On-the-Fly Tuning
Use MySQL’s SET syntax to change
parameters on the fly (new in 4.0)
max_connections
wait_timeout
thread_cache
key_buffer_size
table_cache
Don’t change too much at once
Persistent connections aren’t always fast!
Changes may take time to notice
Copyright 2003, Jeremy Zawodny