auto integrity/optimize on daily trigger
Suggestions
right, but what im suggesting is there could be a 'auto run integrity check" option built into the integrity check that enables it to run in that maintenance cycle
or how would i go about getting the integrity check to fire at that time when thatlistener goes off and, have it enable all or some of the options selectively
id want to use all options, but i found when i have mod_pagespeed enabled the verify modules locks up; on jrforums so i had to disable pagespeed (wich drasticky reduced server load but increased load times significantly ( but still in the acceptable range)
i might instead see if i can run mysqlcheck as a cron job to repair all tables nightly and optimize all tables every 6 hours or something
that might be a better idea since it will optimize akll databases on all sites