Linux 2006

About Brighton

Tutorials

Speakers

Talks

Timetable

Introductory Day

Accommodation

Dinner

Registration Information

Event Information (PDF)

Booking Form (PDF)

Call For Papers

Other UKUUG events

Mark Leith - MySQL

TUTORIAL: MySQL Optimisation

This tutorial examines the many aspects involved when optimising a MySQL application, the MySQL server, and its environment.

Contrary to popular expectations (and habits), hardware will be the absolute last item on our list. The reason for this will become apparent as we build an overall picture and take a closer look at various specific issues.

The tutorial will be highly interactive, using discussions, games, and other ways that insure maximum benefit for all participants. This method of teaching, which is the standard format of MySQL AB training courses, has proven to be much more effective than regular lectures.

Optimisation is certainly not a topic of dry knowledge. Instead it is about gaining the skills needed to analyse the big picture, and recognising the often small but important opportunities. As such, this tutorial provides a particularly valuable experience for intermediate-level MySQL users.