Divide and Be Conquered

Brooks Johnson (Verdiem)
Performance Tuning and Benchmarks
Location: Ballroom D
Average rating: ****.
(4.00, 1 rating)

I’m going to demonstrate cases where partitioning can slow and improve performance. I’ll extend this article:

http://dbscience.blogspot.com/2008_01_01_archive.html

I’ll cover a few more scenarios that aren’t covered by the article, such as a standard primary key of only orderId with InnoDB and I’ll add a few MyISAM test cases.

I’ll tackle some of the partitioning myths, such as partitioning is a good way to distribute data over multiple disks. Instead I’ll state it is better to use raid to consistently distribute the data over all disks. This avoids data hots spots where one partition is being used at a time and the others are not active.

After having shown some of the performance hits of partitioning, I’m going to show where partitioning does improve performance. Two examples of this are altering tables and only having to optimize one partition of a table, rather than the entire table. Then, for the table optimization case, I’ll come up with a rule to optimize, er, table optimization, which is to keep the partitions the size of the machine memory. I’ll show a case of how following this rule improves optimization performance.

Brooks Johnson

Verdiem

A database guy

Co-presented By:

O'Reilly Media MySQL/Sun Microsystems
  • Kickfire
  • Virident
  • Infobright, Inc
  • JasperSoft
  • Intel
  • Advanced Micro Devices
  • BIRT Exchange by Actuate
  • Calpont
  • Canonical
  • Continuent
  • Dolphin Interconnect Solutions
  • Facebook
  • HiT Software, Inc.
  • IBM
  • iDashboards
  • Oracle
  • Pentaho
  • R1Soft
  • Schooner Information Technology
  • SQLstream
  • Ticketmaster
  • Zmanda, Inc.
  • Linux Journal

Sponsorship Opportunities

For information on exhibition and sponsorship opportunities at the conference, contact Sharon Cordesse at scordesse@oreilly.com

Download the MySQL 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@ oreilly.com

Press and Media

For media-related inquiries, contact Maureen Jennings at maureen@oreilly.com

MySQL Conference Newsletter

To stay abreast of conference news and to receive email notification when registration opens, please sign up for the MySQL Conference newsletter.

Contact Us

View a complete list of MySQL contacts.