on a fresh datadir: --------------------- drop database if exists a; drop database if exists b; drop database if exists x; drop database if exists y; create database a; create database b; create database x; create database y; create table a.a(a int,primary key(a),key(a))engine=innodb; create table b.b(b int,primary key(b),key(b))engine=innodb; create table x.x(x int,primary key(x),key(x))engine=innodb; create table y.y(y int,primary key(y),key(y))engine=innodb; insert a.a values(1),(2); insert b.b values(1),(2); insert x.x values(1),(2); insert y.y values(1),(2); create view a.ax as select * from x.x; create view x.xa as select * from a.a; ---------------------- mysqldump --all-databases -uroot > db.sql then, continuously read from the tables, in my case i just put into a loop: n|1|flush tables with read lock n|1|unlock tables n|1|select * from a.a n|1|select * from b.b n|1|select * from x.x n|1|select * from y.y n|1|select * from a.ax n|1|select * from x.xa Then, C:\mysql-5.6.19-winx64\bin>mysql -uroot -h127.0.0.1 < db.sql C:\mysql-5.6.19-winx64\bin>mysql -uroot -h127.0.0.1 < db.sql ERROR 1062 (23000) at line 373: Duplicate entry 'a-a-PRIMARY-n_diff_pfx01' for key 'PRIMARY' C:\mysql-5.6.19-winx64\bin>mysql -uroot -h127.0.0.1 < db.sql C:\mysql-5.6.19-winx64\bin>mysql -uroot -h127.0.0.1 < db.sql ERROR 1062 (23000) at line 373: Duplicate entry 'a-a-PRIMARY-n_diff_pfx01' for key 'PRIMARY' C:\mysql-5.6.19-winx64\bin>mysql -uroot -h127.0.0.1 < db.sql ERROR 1062 (23000) at line 373: Duplicate entry 'a-a-PRIMARY-n_diff_pfx01' for key 'PRIMARY' select * from mysql.innodb_index_stats;select * from mysql.innodb_table_stats;show processlist;