Faster Than Alter - Less Downtime

Business and Case Studies, Performance Tuning and Benchmarking
Location: Ballroom E Level: Intermediate
Average rating: ***..
(3.50, 4 ratings)

Although ALTER will always have its place in MySQL, there are faster ways to change schema which cause little to no customer facing downtime! This presentation will cover the following topics:

1. Alter table vs Load Data INFILE
2. De-fragmentation of data sets
3. Using Slave servers to help minimize downtime
4. Real world situations from three companies
*Schema change on large 70+GB MyISAM table
*De-fragmentation of Innodb data sets (Golden Gate)
*Throwing in Fusion I/O to make it even faster

This will be a informative talk about real world problem solving and the powerful yet sometimes overlooked LOAD DATA INFILE command. This talk is for MySQL DBAs who want to expand their knowledge, improve performance and decrease customer facing downtime.

Photo of Chris Schneider

Chris Schneider

Certified MySQL professional with over 6 years in the MySQL community and open source. I have designed, implemented and maintained small to large scale MySQL installations. This includes building architectures from the ground up and improving on those that are currently in place while emphasizing scalability, performance and ease operations. A few of the companies I have contributed to are,, VMware, Virident, and I also run a community site,, that promotes collaboration within the open source community.

  • Oracle
  • Monty Program
  • Calpont
  • Facebook
  • Gear6
  • Infobright, Inc
  • JasperSoft
  • Joyent
  • Kickfire
  • NorthScale, Inc.
  • Percona
  • Schooner Information Technology
  • Solid Quality Mentors (SolidQ)
  • Intel
  • Pentaho
  • Linux Pro Magazine

Sponsorship Opportunities

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

Download the O'Reilly MySQL Conference & Expo Sponsor/ Exhibitor Prospectus

Media Partner Opportunities

Download the Media & Promotional Partner Brochure (PDF) for information on trade opportunities with O'Reilly conferences or contact mediapartners@

Press and Media

For media-related inquiries, contact Maureen Jennings at

O'Reilly MySQL Conference Newsletter

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

Contact Us

View a complete list of O'Reilly MySQL Conference contacts.