mysql - Simple table partitioning? -
i'm trying learn partitioning - have large mysql database following structure:
name (varchar), id (int), dob (int), height (int)
around 70% of rows in table not have value dob (this value null), wish separate these rest of table speed queries remaining 30% of table.
example queries:
select name mytable id = ' ' limit 1; insert mytable (height) values (180) id = '1234';
this large table, , therefore query take while execute - therefore using partition may make sense speed up.
is there simple partition can create separate these?
i'm aware there different types of partitioning (hash, key, list, column) , i'm bit uncertain how best table?
Comments
Post a Comment