… I know it will run for days? Here’s my train of thought: It’s performing index lookups into the fact… that this equates to about 18790 * 606 = 11386740 I/O operations, assuming that the indexes are fully in memory. When you… second dimension table. That’s 300 million random I/O operations. In contrast, the optimizer chose a plan that it thought…
Post: The MySQL optimizer, the OS cache, and sequential versus random I/O
April 28, 2008 By 17 Comments
Post: Upcoming Webinar on Index Design
October 1, 2012 By 2 Comments
… for you to build index design into your development and operations work. Please register for this free webinar and join me… are in part a preview of our new Live Virtual Training for Analyzing SQL Queries with Percona Toolkit. I’ve been developing this training this summer, and we’re going to present it October…
Post: Off to California!
September 10, 2009 By 5 Comments
… day I fly to Los Angeles to teach a private training class, en route to Santa Clara/San Francisco for our public training workshops next week. Our Montreal practice teach at Station-C… slides and our official classes will have much better information. Operational issues are one of the most important things people want…
Post: MySQL Consulting - Being on your own
February 20, 2007 By 7 Comments
… etc. I’m not the great person for such routine operations so it was not always done well. Good enough we… draw application structure on the whiteboard or to have mini training done about efficient MySQL usage, or simply when security is… and efficiency. We need to find a great people and train them and this is not something you can do in…
Post: Percona XtraBackup 1.6.3
September 23, 2011 By 5 Comments
…been removed. Bug Fixed: #677279 (Alexey Kopytov). Executing DDL operations, TRUNCATE TABLE, DROP/CREATE the_same_table or …links: Downloads: Binary distributions, Percona Software Repositories Consulting, support, training, and custom development Release notes Documentation Developer Discussion …
Post: Percona Server 5.1.57-12.8 Stable Release
June 8, 2011 By 10 Comments
…32 (maximum number of parallel threads in a parallelized operation). The innodb_purge_thread patch accepted a value …: Binary distributions, Percona Software Repositories Installation instructions Consulting, support, training, and custom development Release notes Documentation Developer discussion …
Post: When should you store serialized objects in the database?
January 21, 2010 By 47 Comments
… commands are no longer required. Until 5.1-plugin simple operations like adding a secondary index on an InnoDB table require… larger amounts of data at once. We’ve all been trained to know that SELECT * is bad. This creates a pattern…
Post: Onsite and Remote - getting best of both worlds
July 2, 2009 By 1 Comment
… in for question. I believe Onsite visits also offer unmatched training experience for the team – one of the team members can… millions of other things. Second – waiting on database (or other) operations to complete – backup, restore, ALTER TABLE, load testing – all of…
Post: Silicon Valley Onsite consulting anyone ?
July 10, 2007 By 2 Comments
… time could be well spent to have mini-training on MySQL high performance design operations or development practices, to look into your…
