How to make sure WordPress database doesn’t have any problems?
I’m transferring a WordPress site to a new server. On the new server, getting things ready, I was using the “Optimize Database after Deleting Revisions” plugin to maintain the database before making the switch to the new server. When I checked the option to “Clear orphans” the analysis showed that I had 58,000 orphans, when I clicked the option to delete them, the operation was taking a very long time, so I left it overnight, and I just checked this morning within the WordPress, in the plugin dashboard page, I received a “There has been a critical error on your website. Please check your site admin email inbox for instructions.” message.
However, I don’t see any email with instructions, the website seems to be working fine, when I try to clear orphans again, it looks like that the previous process completed the clearing, because the plugin shows 0 orphans. I optimized the (InnoDB) database again through phpmyadmin, and everything seems to be working.
The only thing I found is in the apache logs this message:
[Sun Jul 26 06:45:06.600134 2020] [php7:error] [pid 1078] [client 555.555.555.555:51234] PHP Fatal error: Maximum execution time of 14400 seconds exceeded in /var/www/html/wp-includes/wp-db.php on line 2024, referer: https://domain.com/wp-admin/tools.php?page=rvg-optimize-database&action=analyze_summary which I think is the reason of the dashboard error.
The mysql logs only shows a few “notes” during, but no errors.
I have also restarted the server, things looks like are working.
My questions are :
- Is it safe to deploy the WordPress site after this happened?
- should I be worried about the error message?
- Is there anything else should I do to make sure everything is OK and nothing got corrupted?