MySQL Benchmarking and Monitoring Tools

Tom Hanlon (Cloudera)
Average rating: **...
(2.60, 10 ratings)

MySQL Benchmarking and Monitoring :

An overview of currently available tools with an introduction to the features of each and a demonstration of using each tool against a running Database.

Intended Audience:

DBA’s , Developers, managers assessing MySQL performance, System Admins.

So you want to know how many requests your database can handle before performance begins to degrade? What is the cost/benefit of various indexing strategies. What is the cost of foreign keys, triggers and stored procedures. What is faster in your situation MyISAM or INNODB ? Perhaps your boss wants to know what sort of machine he should purchase for the migration to MySQL. Or perhaps your website traffic is growing exponentially, how do you make the big decisions about capacity, hardware utilization, budgeting and future planning? The answer is benchmarks. This session will show you the tools you need to gather relevant useful benchmarks.

In addition you might want to know, how much disk is left after your online subscriptions grow by %100. Or how much CPU or network traffic is your MySQL server generating. What you need in this case is good Monitoring tools. There is a wide variety of monitoring tools available, from the text based, to the graphical, from the email alert to the phone call, the pager, the alarms and the red lights. Learn how each tool works and find the one that works best for you.

Benchmarks:

Obtaining realistic and relevant benchmarks of the performance of your MySQL servers is invaluable. So where does a weary DBA turn to when he needs to get this data ? Fortunately there are many tools available for you. However deciding what tool is right and understanding the features and details of each can be a lengthy process of its own. In this session you will get working examples of most flexible , easy to use, and configurable tools available to day. Every DataBase is different and every use case is different, you need accurate benchmarks that reflect the performance of YOUR database. In this session we will cover the following tools.

mysqlslap sql-bench supersmack Apache Bench (combined with some sample PHP scripts) MySQL’s benchmark() function WAST JMeter

Benchmarking your servers performance is just half the picture however. What about Monitoring a running server ? Well Monitoring your server is at least as important as Benchmarking and there are a wide array of tools available for the job. In the next 45 minutes of the session we will demonstrate and review the features of the available MySQL monitoring tools.

Enterprise Monitor Cacti Xenoss Innotop MyTop Munin Nagios MyTOP and/or MTstat Selenium (test framework)

Tom Hanlon

Cloudera

Tom Hanlon is currently a senior instructor at MySQL and has been teaching MySQL and assorted FOSS topics such as Apache, PHP , and Linux for since 2001. In addition I have been building and maintaining MySQL based applications since the MySQL 3.2 era. I am experienced in presenting technical topics to diverse audiences.

Comments on this page are now closed.

Comments

Picture of Michael McFadden
04/22/2009 8:40am PDT

A good introduction for those who have never explored monitoring tools. Great use of audience knowledge

04/21/2009 5:54am PDT

Could have learned as much from using internet search tools.

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.