…will not be sequential, yet same is true for MyISAM which over time will get fragmented rows. Freshly …in primary index scan vs other index scan. The data is at least “clustered” in primary key so …page will contain 500 pointers causing up to 500 different pages to be fetched. For row size of 100 you…
Percona's MySQL & InnoDB performance and scalability blog
Percona Webinars
- June 26, 2013 - Percona XtraDB Cluster Operations
- July 17, 2013 - 5 Proactive Measures to Minimize MySQL Downtime
- July 24, 2013 - Advanced MySQL Query Tuning
- July 31, 2013 - Percona Server 5.6: Enterprise Grade MySQL
Percona MySQL Training
- Moving to MySQL 5.6 - Utrecht, Netherlands on Monday, 01 July 2013
- London, United Kingdom on Monday, 15 July 2013
- Moving to MySQL 5.6 - Orlando, FL on Monday, 15 July 2013
- Moving to MySQL 5.6 - Salt Lake City, UT on Thursday, 18 July 2013
- Boston, Massachusetts, USA on Monday, 22 July 2013
Percona Careers
- Administrative Aide [Uruguay]
- Consultant: Linux and Web System Administration
- Director of Open Source Development
- Perl Programmer [Americas timezone]
- MySQL Instructor [Any Location - US]
Copyright © Percona LLC • Contact Us • MySQL and InnoDB are trademarks of Oracle Corp.