The opposite day I observed that my WordPress website (WPSaviour) began responding gradual and at occasions it was giving error connecting database difficulty. At many occasion it was giving me following error “Connection misplaced. Saving has been disabled till you’re reconnected.
It was uncommon, as my site visitors was constant and there was n change in server configuration. For the primary few time I merely ignored this difficulty and in the present day I bumped into one other difficulty with remark moderation. Even after accepting or trashing the feedback, it was re-appearing.
With that I used to be certain one thing is incorrect with the database and I considered repairing my database. As an alternative of utilizing WP DB-manager plugin or WP-optimize plugin, I right away used PHPMyAdmin to restore and optimise my database.
- Learn: How To Optimize WordPress Database Dimension To Enhance Efficiency
For the primary time I encountered one thing very uncommon as I observed few of my WordPress database tables couldn’t be repaired. Here’s what error message appeared like:
wp_se_blc_instances: The storage engine for the desk doesn’t help restore
wp_se_blc_links: The storage engine for the desk doesn’t help restore
Discover the “The storage engine for the desk doesn’t help restore” and after I checked my WordPress database overhead, I used to be surprised as overhead dimension was about 5320GiB.
I right away Pinged my internet hosting help crew however they couldn’t any assist as this was a difficulty with database and never the internet hosting. So I began looking for an answer to this difficulty and eventually I discovered what might be accomplished to repair error “The storage engine for the desk doesn’t help restore“.
Convert InnoDB MySQL Engine to MyISAM – SQL Question
I researched in regards to the difficulty and understood that InnoDB and MyISAM are two fashionable MySQL Engine. MyISAM is the one which helps mysqlcheck’s restore characteristic. InnoDB engine is really helpful for busy database however on this case I used to be dealing with points with extreme database overhead, so I made a decision to maneuver my tables again to MyISAM engine.
In case you are additionally dealing with the same difficulty, the answer is to transform the InnoDB to MyISAM engine. Right here I’m sharing the SQL question which it is advisable to run to transform the tables one after the other.
Be aware: Do take a whole backup of your database earlier than working this SQL question. If one thing goes incorrect, try to be in a situation to revive your database.
ALTER TABLE tablename ENGINE=MyISAM;
Exchange desk identify along with your database desk identify which you wish to be transformed into MyISAM. After repeating that for all of the tables, do restore and optimise your database.
- Learn: Learn how to delete customized subject worth from WordPress database
For me, this mounted my drawback of WordPress database. If you happen to ever run into related form of scenario, this may aid you. Don’t neglect to take your database backup earlier than working any SQL question.