| 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
2002, Jeremy Zawodny (Jeremy@Zawodny.com) |