0

when I run a MySQL dump I noticed that the webserver does not deliver any requests. The CPU is not fully occupied.

Is this normal behavior?

2
  • 1
    You might also notice that it is pretty common that a dump locks tables readonly, and that might cause a problem with running queries other than selects. you can try --lock-tables=false switch and see if it changes anything – bocian85 Jun 16 at 12:38
  • Also, using MyISAM is more problematic than InnoDB. – Rick James Jun 16 at 21:14
3

Depending on the size and the configuration of your database this might be normal.

To prevent this you can set up a replication slave and make your dump on the slave.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy