Loading...

Easy MySQL server performance tuning for everyone [linux.conf.au 2014]

18,078 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on Jan 13, 2014

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.

by Trent Lloyd

http://lca2014.linux.org.au/staticsch...

Loading...

When autoplay is enabled, a suggested video will automatically play next.

Up next


to add this to Watch Later

Add to

Loading playlists...