N
N
Nikita Shelkovnikov2018-09-26 07:49:18
MySQL
Nikita Shelkovnikov, 2018-09-26 07:49:18

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

2 answer(s)
S
Swartalf, 2018-09-26
@Swartalf

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.

P
pfg21, 2018-09-26
@pfg21

for the time of a backup I hope work the database stops?? write cache is reset??
Online database backup is more complicated than just copying files :)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question