A
A
Alena2015-10-20 11:25:28
MySQL
Alena, 2015-10-20 11:25:28

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

2 answer(s)
D
Dmitry Entelis, 2015-10-20
@DmitriyEntelis

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

V
Vlad Zhivotnev, 2015-10-20
@inkvizitor68sl

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 question

Ask a Question

731 491 924 answers to any question