Register Now & Save!
Sponsors

Diamond Sponsors

  • Dell Inc.
  • Hewlett Packard
  • Red Hat
  • Solid Information Technology
  • Zmanda, Inc.

Platinum Sponsor

  • JasperSoft

Gold Sponsors

  • Actuate Corporation
  • Bakbone Software
  • CodeGear
  • Continuent
  • Dolphin Interconnect Solutions
  • Google
  • Infobright, Inc
  • NitroSecurity
  • Oracle
  • Pentaho
  • Port 25 - Microsoft
  • Rackspace Managed Hosting
  • Sun Microsystems
  • Talend
  • The Pythian Group
  • Ticketmaster
  • Unisys

Sponsorship Opportunities

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

Download the MySQL Conference & Expo Sponsor/Exhibitor Prospectus (PDF).

Conference News

To stay abreast of Conference news and to receive email notification when registration opens, please sign up here.

Program Ideas

Drop us a line at and tell us who and/or what would make this year's MySQL Users Conference a must-attend event.

Press and Media

For media-related inquiries, contact Sharon Cordesse at

User Groups

For user group related inquiries, contact Marsee Henon at

Session

The innotop Workshop

Baron Schwartz, Software Engineer, Rimm-Kaufmann Group

Track: General
Date: Thursday, April 26
Time: 10:45am - 11:45am
Location: Ballroom C

innotop is an advanced monitor for InnoDB internals and MySQL in general. It is a MySQL developer's and administrator's Swiss Army Knife. This session will demonstrate how to use innotop for monitoring and controlling one or many MySQL servers.

  • I'll demonstrate innotop's classic "top"-like query monitoring mode, and show you how to sort, filter and colorize the queries to your heart's content.
  • I'll show you how to monitor InnoDB transactions, and thin-slice the wealth of information available about them. For example, did you know you can find out how close to finishing an InnoDB query is?
  • You can use innotop to view transactions or queries that are locked or waiting for locks, see when your server starts resorting to spinlocks, and more. I'll show you how to view which part of your server's workload is jammed up and what to do about it.
  • You can use innotop to monitor replication in real-time across multiple servers simultaneously. I'll show you how.
  • Innotop has features to help you control many servers with only a few keystrokes, such as stopping replication or killing queries on many machines at once. I'll demonstrate these abilities.
  • You can use innotop to monitor arbitrary status and variable information, such as the number of queries per second, with intuitive expressions like "Questions/Uptime". I'll show you how to define custom views of MySQL's internal status.
  • You will learn how to use innotop's unattended monitoring modes to pipe data into other programs for further processing.