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