Bottom-up Database Benchmarking

Greg Smith (2ndQuadrant US)
Average rating: *****
(5.00, 6 ratings)

The increasing use of virtual hardware and multi-node clusters makes the performance of individual nodes seem less relevant than it used to be. But databases have unique consistency and workload requirements that still make hardware performance and choice critical. And particularly with the complexity of today’s hardware, running your own bottom-up benchmarks is vital for defending against the very common hardware vendor errors you should expect to happen to you eventually, not be surprised by. Deploy a production server without making sure the hardware itself performs as expected, and troubleshooting the resulting problems is vastly more difficult.

And don’t forget one more thing—the information you need to know to make informed hardware changes changes constantly. There are two parts of this session that come out of the speaker’s latest, unique research into database performance tuning. The stream-scaling project provides a new way to visualize how memory performance scales with the number of active cores involved in the workload, a vital component to quantify on today’s many core designs when running a database server. And recently developed improvements to the sysbench program make it more fair than ever to use as a way to compare MySQL and PostgreSQL on the same hardware.

Topics covered in this session include:

  • Benchmarking memory speed at various concurrently levels
  • The four dimensions of disk performance: read, write, seek, and commit rate
  • The most important disk benchmarking tools to use
  • What SSD vendors are not telling you
  • Common sources of slow hardware performance
  • Managing hardware vendor relations when performance is poor
  • How to configure PostgreSQL for fair benchmarking results in only seconds
  • Using sysbench to compare basic MySQL and PostgreSQL performance
Photo of Greg Smith

Greg Smith

2ndQuadrant US

Greg Smith leads the US-based work for international PostgreSQL services firm 2ndQuadrant. He’s the author of PostgreSQL 9.0 High Performance from Packt Publishing. His past work on PostgreSQL includes rewriting the database’s background writer, releasing its first open-source tuning configuration tool, and introducing the earliest tools featuring transaction latency graphing as a technique for analyzing performance over time.

  • 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 yromaine@oreilly.com

Media Partners Opportunities

For media partnerships, contact mediapartners@ oreilly.com

Press & Media

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

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