Forums

mySQL optimize tables?

Permalink
Hey everyone!

I'm doing a bunch of custom mySQL tables and etc on my C9 and I'm seeing talk about optimizing tables. Just curious if anyone has had issues with not optimizing.

Thanks!
rainmaker
 
mhawke replied on at Permalink Reply
mhawke
None of my sites are big enough to make optimization an issue but I run this just in case:

http://www.concrete5.org/marketplace/addons/mysql-optimize/...
rainmaker replied on at Permalink Reply
rainmaker
Hey mhawke!

I did run into that addon. Just wasn't sure how to really access it. I installed it, but that was it. Was there something in the dashboard that I just couldn't find?

THANKS!
mhawke replied on at Permalink Best Answer Reply
mhawke
On my system, it installed a new job called "MindNet Optimize MySQL database" under "Dashboard->System and Settings->Automated Jobs"

I have also installed a free add-on called "Nontab Scheduler" to run all my jobs each day.

http://www.concrete5.org/marketplace/addons/nontab-scheduler/...
JohntheFish replied on at Permalink Reply
JohntheFish
If you don't want to be stuck with running all the jobs at the same time, and don't want to get involved with cron, you can use FlexJob Scheduler:

http://www.concrete5.org/marketplace/addons/flexjob-scheduler/...
rainmaker replied on at Permalink Reply
rainmaker
Oh geez. I totally didn't think about working there. I kept searching and just got noooo where. THANK YOU!