What should i do with partitioning in a table require 2 ways of selections for best performance in MYSQL - myisam?
I have a table like bellow:
CREATE TABLE `hosts` (
`ID` int(11) unsigned NOT NULL AUTO_INCREMENT,
`Name` varchar(60) NOT NULL,
PRIMARY KEY (`ID`,`Name`),
UNIQUE KEY `UniqueHost` (`Name`),
) ENGINE=MyISAM AUTO_INCREMENT=32527823 DEFAULT CHARSET=utf8
/*!50100 PARTITION BY KEY开发者_高级运维 (`Name`)
PARTITIONS 20 */
What i want to select here are:
select * from hosts where Name = 'blah.com';
and:
select * from hosts where ID = 123123;
What should i do when i have 2 ways of selection like above for best performance ? other tables requires the ID of this table. However, i also need to select the Name of hosts frequently.
Another question is How many partitions i should create for 32 millions of rows?
精彩评论