Answer the question
In order to leave comments, you need to log in
Why do indexes in tables break when backing up a database?
We have a dedik from 1dedic.ru Backup
(boxed in ispmgr) starts at 7 am. Sometimes at the start of a backup, errors about broken indexes in tables immediately begin to fall.
Every time the problem occurs with the same tables.
The base weighs about 300mb.
Backups were transferred to different times (night, morning, evening) - the indexes beat clearly during backup.
Where to dig? The hoster says that everything is in order with the disk and memory.
Answer the question
In order to leave comments, you need to log in
How is a backup made? table lock and rsync/snapshot, binary dump like xtrabackup, mysqldump or alternative method? Yes, I would like to see errors.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question