MySQL Performance Tips
• Application Design
– Use the right column types
– Use the right table types
• Concurrency/Locking
• Features: full-text, foreign keys, etc.
– Cache infrequently changed data
• Or use HEAP (in-memory) tables
– Don’t over-use sessions
– Plan for growth, possibly using replication
– Use transactions where they make sense
Copyright 2003, Jeremy Zawodny