One day I noticed that my wordpress site mafia started responding slowly and at times it was giving database connecting problem. In many instances it was giving me the following error “Connection lost. Saving is disabled until you reconnect. We are backing up this post in your browser, just in case. “While writing a blog post.
This was an unusual occurrence for me, as my traffic was consistent and there was no change in the server configuration. The first time I just ignored the issue
With this I was sure that there is something wrong with the database and I thought about repairing my database. Instead of using the WP DB-manager plugin or the WP-optimize plugin, I directly used PHPMyAdmin to repair and optimize my database.
The first time I found something very unusual because I noticed that some of my WordPress database tables could not be repaired.
Convert InnoDB MySQL Engine to MyISAM – SQL Query
I researched about this issue and understood that InnoDB and MyISAM are two popular MySQL engines. MyISAM is the one that supports the repair feature of mysqlcheck. The InnoDB engine is recommended for busy databases, but in this case I was facing issues with excessive database overhead, so I decided to move my tables back to the MyISAM engine.
If you are also facing similar problem, the solution is to convert InnoDB to MyISAM engine. Here I am sharing the SQL query that you need to run to convert the tables one by one.
Note: Take a complete backup of your database before running this SQL query. If something goes wrong, you should be in a position to restore your database.
Replace the table name with your database table name that you want to convert to MyISAM. After repeating this for all tables, repair and optimize your database.
ALTER TABLE tablename ENGINE=MyISAM;
To fix this problem with my site WordPress database. If you ever come across a similar situation, this will help you.