mysql dump global read lock

Artem Kuchin <[email protected]>
Newsgroups gmane.comp.db.mysql.general
Message-ID <[email protected]>
Hello!

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

Artem





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.