Personal schedule for John Russell
subscribe to John Russell's
This tutorial focuses on the diagnostic tools you can turn to when confronted with an unexplained performance problem. Tools explained include iostat, vmstat, and mk-query-digest. The emphasis is on practical usage under pressure, and less on performance theory.
Command line skills for administering and using MySQL are still one of the main requirements for professionals in the Unix world. This tutorial
provides the basics and several advanced techniques.
InnoDB Hot Backup is the ideal solution for online backups of InnoDB
tables in MySQL databases, as well as for backups of MyISAM tables. At
this session, you will learn how InnoDB Hot Backup works, and how to
develop a backup strategy using the Hot Backup utility.
There are many exciting performance features in the InnoDB Plugin. But how to best use them? What are the caveats? At this session, we will describe those performance features in depth. We will also present benchmark results that explore the performance of those features.