Forums

MySQL database optimization

Permalink
Hey.. created my first package for the market place...

The package provides a job script for optimizing MySQL tables

try it:
http://www.concrete5.org/marketplace/addons/mysql-optimize...

Happy to hear your thoughts...
scalait
 
elyon replied on at Permalink Reply
elyon
Looks good!

Is there any chance of data loss when using this script? Are you using a well known or built-in optimization command, or is there a way to know what kinds of changes are being made to optimize the tables?

Thanks
scalait replied on at Permalink Reply
scalait
if there is a overhang on a MySQL table, the script executes a "OPTIMIZE TABLE" query.

So it uses the internal MySQL table optimization.
adeang replied on at Permalink Reply
After installing this my image slideshow no longer appears in public only in the edit mode. Any suggestions?