I run a busy website and perform daily mysql backups. Every day on cue my database locks up due to SELECT /*!40001 SQL_NO_CACHE */ * FROM table queries. Is there any way i can prevent this lock up?
I have the following my.cnf settings for mysqldump:
Would increasing max_allowed_packet improve the backup speed?
[EDIT] Sorry i think i have found a solution to this - i use cpanel, which performs automatic backups - i believe the command being used by cpanel contains the --lock-tables or --lock-all-tables options which should be removed for my purposes – the problem is i just can’t find where the backup script is.