Web lists-archives.com

mysql dump global read lock


Hereis my mysqldump command line

mysqldump -u root --events --complete-insert --skip-opt --single-transaction --add-drop-table --add-locks --create-options --disable-keys -- extended-insert --quick --set-charset --routines --triggers --hex-blob DB_NAME

But i see tons of Waiting for global read lock
in show processlist for many tables in many different databases for all modification queries and locks

Why? As i understood --skip-opt --single-transaction must disable global read lock

mysql version
Server version: 5.6.27-log Source distribution


MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql