Description:
I have run a test backing up and restoring a database with a total of about 42M rows (database size around 4.2GB.
The backup took about 4 minutes and the restore about eight hours (the system was idle during both operations).
During both operations there was no way to tell if and how the backup and restore actions are actually progressing or the backup/restore processes are hanging (the server itself was responding and there was no issue with preforming other tasks.
How to repeat:
Set a mysql server
load a large database (such that backup and restore will take more then a few seconds)
Start backup and restore actions
observe that there is no progress so me seen during he operations:
- processlist shows the thread executing
- backup_progress table has no changes to it
- no entries in the error file (only the start and completion of the
backup/restore
Suggested fix:
Include some form of a progress indication either by writing a 'note' to the error file or updating the backup_progress table with new / updated records.
