| MySQL
Server Tuning |
|
|
|
|
|
|
|
|
|
|
|
|
|
| | Upgrade once in a while |
|||||||||||
| | New versions are often faster |
|||||||||||
| | Better optimizations in query parser |
|||||||||||
| | New and enhanced caching |
|||||||||||
| | Convert older tables to newer format |
|||||||||||
| | ISAM to MyISAM |
|||||||||||
| | BDB to InnoDB (or not) |
|||||||||||
| | ALTER TABLE my_table TYPE=InnoDB |
|||||||||||
| | Dont flush the transaction logs on commit |
|||||||||||
| Copyright 2003, Jeremy Zawodny |