O'Reilly Open Source Software Convention 2002

	Home
	Registration
	Speakers
	Keynotes
	Tutorials
	Sessions
	At-a-Glance
	BOFs
	Events
	Exhibitors
	Sponsors
	Hotel/Travel
	Venue Map
	See & Do
	Press
	Mail List

From the Frontiers of Research to the Heart of the Enterprise
O'Reilly Open Source Convention
Sheraton San Diego Hotel and Marina
July 22-26, 2002 -- San Diego, CA

Apache
Tutorial
MySQL Optimization
Jeremy D. Zawodny, Yahoo! Inc.

Track: Databases
Date: Monday, July 22
Time: 1:45pm - 5:15pm
Location: Marina VI
As the load on a MySQL server increases, its performance often degrades if it has not been properly tuned to handle the load. A standard installation of MySQL performs well for many applications, but it generally will not perform efficiently under stress.
In this tutorial we'll discuss many of the tunable parameters in MySQL's configuration file (my.cnf) and cover various optimizations which can be used to improve the performance and efficiency of MySQL servers--often with dramatic results. We'll also examine MySQL's various table types as well as hardware solutions to performance problems.