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: 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 :

  1. Is it safe to deploy the WordPress site after this happened?
  2. should I be worried about the error message?
  3. Is there anything else should I do to make sure everything is OK and nothing got corrupted?
, , mhweb 1 year 2020-07-26T08:10:27-05:00 0 Answers 54 views 0

Leave an answer