Large database need --single-transaction --quick options to DB backup mysql
We have a large database with InnoDB. Wen the backup runs it brings my site down for 9 min. need option to not bring our DB down.
This is a valid request, so we'll look into it. There is no ETA at the moment, but we would really appreciate you voting for this request so that we can accurately assess its popularity relative to other features.
Thanks in advance!
I have merged the request by creoline into this existing one. Actually, adding a parameter like --single-transaction requires careful consideration of many side effects that this can have. It is explained well in https://stackoverflow.com/questions/41683158/mysqldump-single-transaction-option and comments. But like IG I also think it is a valid request.
We will consider this functionality in upcoming releases if it will be popular.
Everyone, please continue voting for this feature if you consider it important.
creoline GmbH commented
Actually, all database backups are exported with a "LOCK TABLES" operation which seems to be outdated for InnoDB.
I would suggest allowing users to choose the locking strategy on exporting database dumps in the Plesk GUI.
There should be options like:
- Single Transaction (Not supported for MyISAM)
- Lock Tables
The export button is very useless for InnoDB users with traffic on their websites because a global READ lock applied also if no MyISAM tables are available.