Quote:
|
Originally Posted by cotc2001
Not being one that is all that familiar with mysql (thats what I pay others for), what happens to a database when it's being optimised?? i.e what does it actually do?
|
From the MySQL manual...
"Deleted records are maintained in a linked list and subsequent INSERT operations reuse old record positions. You can use OPTIMIZE TABLE to reclaim the unused space and to defragment the data file."
Basically, optimizing the tables keeps record access as fast as possible. This module also detects and auto-repairs any damaged tables as well.
