aaP_slewrate Hi, aaPanel mysql backups lock the databases and make websites unresponsive. I would like to add --single-transaction to the mysqldump command. How can I do that? Thanks Alex
aaPanel_Kern aaP_slewrate Hello, the database backup in our cron does not support adding, you can create a shell backup database to add this parameter, and the backup database should be backed up when few people access it.
aaP_slewrate Ok. But why not use --single-transaction by default so that the website are not going offline when backing up?
aaPanel_Kern aaP_slewrate Hello, --single-transaction backup needs to open the general_log of the database. After opening, all database operation logs will be recorded and the volume will be very large.
