linux.conf.au 2014

Perth, Western Australia - 6th to 10th January 2014

Trent Mysql - linux.conf.au


Trent Mysql

Trent Lloyd | Easy MySQL server performance tuning for everyone — why 8MB is not enough and 256KB definitely is

http://www.lathiat.net/

MySQL is the most popular database on the web, many people are running it on applications ranging from single user test servers to sites fielding hundreds of millions of users.

There are many tuning parameters that can be adjusted to suit different workloads and server specifications, the default values are often not optimal and can easily be adjusted for big improvements in performance even on basic systems.

People also often catch wind of tuning MySQL settings and start setting them as big as possible to values that make no sense and absolutely ruin their server performance in the process.

I will take you through a high level overview of MySQL’s configuration parameters, discuss what the settings mean, which ones you should change, why to change them and how to determine the optimum values.

We will also review common traps to avoid and explore why they can ruin your server performance when set incorrectly.

Trent Lloyd (www.lathiat.net)

Trent Lloyd has been a Senior Technical Support Engineer for MySQL in the Customer Support Team for over 6 years at Oracle Australia (previously MySQL AB and Sun Microsystems). He solves problems with MySQL systems day in, day out dealing with issues such as server installation, upgrades, corruption, performance, query tuning and general linux systems administration.

He is an active and enthusiastic member of the free software community, having also been on the development team for Avahi — a mDNS/DNS-SD service discovery stack for Linux and attended/spoken at many past conferences including linux.conf.au and GUADEC.