There have been a few posts on PlanetMySQL
regarding primary keys and the importance of choosing the right
one. This is even more important when the table uses InnoDB.
You've read different posts of why it is so important. Now, I'm
all about benchmarks and showing the details. So I'll take a
table from my previous posts about MySQL 5.1 partitioning and
show what I found.
This table was created under MySQL 5.1.12-beta:
[Read more]
CREATE TABLE `big_table_test1` (
`entity_id` int(11) NOT NULL DEFAULT '0',
`col1` int(11) NOT NULL DEFAULT '0',
`col2` int(11) NOT NULL DEFAULT '0',
`col3` int(11) NOT NULL DEFAULT '0',
`col4` int(11) NOT NULL DEFAULT '0',
`col5` int(11) NOT NULL DEFAULT '0',
`col6` int(11) NOT NULL DEFAULT '0',
`ymdh` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`imps` bigint(20) NOT NULL DEFAULT '0',
`clicks` int(11) …