Answer the question
In order to leave comments, you need to log in
Why do tables break in Wordpress database?
On one of the sites, which was asked to look after, the database crashes with some frequency. That is, when entering, it writes: "Error connecting to the database", etc. I found out the reason - the problem is in the wp_options table.
After the standard procedure "Repair and optimize the database" there is always a message: "wp_options: Table is marked as crashed". I already fix this from phpMyAdmin with the standard REPAIR TABLE `wp_options`.
Everything starts to work. Super. But after a while the problem reappears.
Question: what is the reason for such repetition and how to fix it to the end?
Answer the question
In order to leave comments, you need to log in
Wordpress has nothing to do with it.
I can assume that you have myisam tables - they break quite easily for a bunch of reasons - the disk space could run out, the server could reboot at an unnecessary moment.
Solution a) switch to innodb b) see what is in the iron logs
Either the space on the server (on the partition with mysql) runs out, or someone sometimes kills mysql with a nine.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question