Percona's MySQL & InnoDB performance and scalability blog
Why does the mysql client says it’s 5.1.70? Welcome to the MySQL monitor. Commands end with ; or g. Your MySQL connection id is 138 Server version: 5.1.70-rel14.7-log Percona Server (GPL), 14.7, Revision 572
… only have few distinct values (e.g status, gender, group_id with only 10 groups per 10M records), then you don…
…caption id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL …
…caption id=”" align=”alignright” width=”320″] Alexei Rodriguez presenting at PLMCE13[/caption] …
… NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned DEFAULT NULL, PRIMARY KEY (`id`), KEY `parent_id` (`parent_id`), CONSTRAINT `child_B_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id`) ) ENGINE=InnoDB DEFAULT…
…caption id=”attachment_13396″ align=”alignright” width=”247″] Percona Server for MySQL …
… primary key solution for random selection only work when the IDs for movies are distributed uniformly over the range 1..MAX… to count the movies per production year for each kind_id. It was more efficient in this case to force MySQL to scan the `title` table first, grouping by kind_id in index order. This made the first table in the…
… test\G *************************** 1. row *************************** Table: test Create Table: CREATE TABLE `test` ( `id` int(11) NOT NULL AUTO_INCREMENT, `col2` int(11) DEFAULT NULL, `col3` varchar(200) DEFAULT NULL, PRIMARY KEY (`id`), KEY `col2` (`col2`), KEY `col2_2` (`col2`) ) ENGINE=InnoDB DEFAULT…
…) part of the design of MySQL 5.6 global transaction ID. In general, there is no ordering implied between events, because…
… to abort. Query (0): is an invalid pointer Connection ID (thread ID): 3 Status: NOT_KILLED You may download the Percona Server…
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.