jaac Hi Can anyone give me the shell script of cron job to auto optimize database? Is it safe to optimize database oftenly? Thanks.
aaPanel_Jose jaac According to the configuration recommended by aapanel, if the database is not the bottleneck, no frequent optimization is required
jaac aaPanel_Jose The problem is some of my posts are so heavy to load and causing high CPU. But after I repair the database from the aaPanel, those posts back normal.
aapanel_power jaac Do you mean your database has errors that need to be fixed in order to provide normal service?
jaac aapanel_power I dont know its an error or not. But like I mention, sometimes I have to repair my database from aaPanel dashboard or WP Rocket in order to make my site smooth again.