 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
| • |
Server Tuning
|
|
|
|
– |
Read and understand SHOW STATUS output
|
|
|
• |
Bytes in/out per second
|
|
|
|
• |
Queries per second
|
|
|
|
• |
Active vs. idle vs. max connections
|
|
|
|
– |
Understand critical resources
|
|
|
|
• |
Memory
|
|
|
|
• |
CPU
|
|
|
|
• |
Disk I/O
|
|
|
| • |
Customize your configuration file
|
|
|
|
– |
Defaults are very conservative!
|
|