Partitioning Saves Load Data

Average rating: ***..
(3.80, 5 ratings)

Will detail how we migrated from a nfs-backed, sharded, mysqld installation on 5.0.44 to a sas RAID 1+0, 15x resharded, 5.1 partitioned mysqld installation:

  • What caused us to rethink this architecture
  • Immediate tuning to improve short-term performance
  • Testing potential options for long-term re-architecting
  • Implementing new configuration
  • Migrating old data
  • Maintaining partitions and planning for future growth
Photo of Kevin Knapp

Kevin Knapp




Comments on this page are now closed.


Picture of Kevin Knapp
Kevin Knapp
04/13/2011 10:55am PDT

That was quite a surprise! Thanks for attending. I’ll post the slides somewhere soon since no one really had a chance to see them.

Picture of Robert Krzykawski
Robert Krzykawski
04/13/2011 10:01am PDT

You did great without the slides… Also adding the sound effects.. :) Interesting to see how you guys are solving the massive data you have..

  • EnterpriseDB
  • Amazon Web Services
  • Clustrix
  • Continuent
  • Facebook
  • HTI Consultoria e Tecnologia
  • Monty Program
  • Percona
  • Rackspace Hosting
  • Schooner Information Technology
  • SkySQL
  • Xeround

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Yvonne Romaine at

Media Partners Opportunities

For media partnerships, contact mediapartners@

Press & Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Bulletin

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the O'Reilly MySQL Conference Bulletin (login required).

Contact Us

View a complete list of O'Reilly MySQL Conference Contacts