/home/elenst/git/10.1/sql/mysqld, Version: 10.1.5-MariaDB-wsrep-debug-log (Source distribution, wsrep_25.10.r4144). started with: Tcp port: 19300 Unix socket: /home/elenst/test_results/analyze5/mysql.sock Time Id Command Argument 150505 15:34:03 3 Connect root@localhost as anonymous on mysql 150505 15:34:05 3 Query SHOW VARIABLES LIKE 'version' 3 Query SET GLOBAL BINLOG_FORMAT = 'statement' 4 Connect root@localhost as anonymous on 4 Query SELECT UNIX_TIMESTAMP() 4 Query SHOW VARIABLES LIKE 'SERVER_ID' 4 Query SET @master_heartbeat_period= 1799999979520 4 Query SET @master_binlog_checksum= @@global.binlog_checksum 4 Query SELECT @master_binlog_checksum 4 Query SET @mariadb_slave_capability=4 4 Query SELECT @@GLOBAL.gtid_domain_id 4 Query SET @slave_connect_state='' 4 Query SET @slave_gtid_strict_mode=0 4 Query SET @slave_gtid_ignore_duplicates=0 4 Binlog Dump Log: '' Pos: 4 5 Connect root@localhost as anonymous on test 5 Query SELECT VERSION() 5 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 5 Query SELECT DATABASE() 5 Query SELECT CONNECTION_ID() 5 Query SET SQL_MODE= 'NO_ENGINE_SUBSTITUTION' 5 Query SET STORAGE_ENGINE='InnoDB' 5 Query CREATE SCHEMA /*!IF NOT EXISTS*/ test 5 Query SHOW WARNINGS 5 Query USE test 5 Query SELECT DATABASE() 5 Query DROP TABLE /*! IF EXISTS*/ table0_innodb_int_autoinc 5 Query SHOW WARNINGS 5 Query CREATE TABLE `table0_innodb_int_autoinc` ( `col_int` int, `col_char_12` char(12), `col_char_12_key` char(12), pk integer auto_increment, `col_int_key` int, /*Indices*/ key (`col_char_12_key` ), primary key (pk), key (`col_int_key` )) ENGINE=innodb 150505 15:34:07 5 Query CREATE OR REPLACE VIEW `view_table0_innodb_int_autoinc` AS SELECT * FROM `table0_innodb_int_autoinc` 5 Query ALTER TABLE `table0_innodb_int_autoinc` DISABLE KEYS 5 Query SHOW WARNINGS 5 Query COMMIT 5 Query ALTER TABLE `table0_innodb_int_autoinc` ENABLE KEYS 5 Query SHOW WARNINGS 5 Query DROP TABLE /*! IF EXISTS*/ table1_innodb_int_autoinc 5 Query SHOW WARNINGS 5 Query CREATE TABLE `table1_innodb_int_autoinc` ( `col_int` int, pk integer auto_increment, `col_int_key` int, `col_char_12` char(12), `col_char_12_key` char(12), /*Indices*/ primary key (pk), key (`col_int_key` ), key (`col_char_12_key` )) ENGINE=innodb 150505 15:34:08 5 Query CREATE OR REPLACE VIEW `view_table1_innodb_int_autoinc` AS SELECT * FROM `table1_innodb_int_autoinc` 5 Query ALTER TABLE `table1_innodb_int_autoinc` DISABLE KEYS 5 Query SHOW WARNINGS 5 Query INSERT /*! IGNORE */ INTO table1_innodb_int_autoinc VALUES (NULL, NULL, NULL, 'du', 'b') 150505 15:34:10 5 Query COMMIT 5 Query ALTER TABLE `table1_innodb_int_autoinc` ENABLE KEYS 5 Query SHOW WARNINGS 5 Query DROP TABLE /*! IF EXISTS*/ table2_innodb_int_autoinc 5 Query SHOW WARNINGS 5 Query CREATE TABLE `table2_innodb_int_autoinc` ( `col_int_key` int, `col_char_12_key` char(12), pk integer auto_increment, `col_int` int, `col_char_12` char(12), /*Indices*/ key (`col_int_key` ), key (`col_char_12_key` ), primary key (pk)) ENGINE=innodb 150505 15:34:11 5 Query CREATE OR REPLACE VIEW `view_table2_innodb_int_autoinc` AS SELECT * FROM `table2_innodb_int_autoinc` 5 Query ALTER TABLE `table2_innodb_int_autoinc` DISABLE KEYS 5 Query SHOW WARNINGS 5 Query INSERT /*! IGNORE */ INTO table2_innodb_int_autoinc VALUES (9, 'utwnznrrizp', NULL, 3, 'twnznr') , (NULL, 'wnznrr', NULL, -2114322432, 'mean') 150505 15:34:12 5 Query COMMIT 5 Query ALTER TABLE `table2_innodb_int_autoinc` ENABLE KEYS 5 Query SHOW WARNINGS 5 Query DROP TABLE /*! IF EXISTS*/ table3_innodb_int_autoinc 5 Query SHOW WARNINGS 5 Query CREATE TABLE `table3_innodb_int_autoinc` ( `col_int` int, pk integer auto_increment, `col_char_12` char(12), `col_char_12_key` char(12), `col_int_key` int, /*Indices*/ primary key (pk), key (`col_char_12_key` ), key (`col_int_key` )) ENGINE=innodb 150505 15:34:14 5 Query CREATE OR REPLACE VIEW `view_table3_innodb_int_autoinc` AS SELECT * FROM `table3_innodb_int_autoinc` 5 Query ALTER TABLE `table3_innodb_int_autoinc` DISABLE KEYS 5 Query SHOW WARNINGS 5 Query INSERT /*! IGNORE */ INTO table3_innodb_int_autoinc VALUES (7, NULL, 'n', 'o', NULL) , (-1583284224, NULL, 'did', 'the', 183173120) , (-850395136, NULL, 'l', 'i', NULL) 150505 15:34:16 5 Query COMMIT 5 Query ALTER TABLE `table3_innodb_int_autoinc` ENABLE KEYS 5 Query SHOW WARNINGS 5 Query COMMIT 5 Query USE test 5 Query SELECT DATABASE() 5 Quit 6 Connect root@localhost as anonymous on test 6 Query SHOW VARIABLES 6 Query SHOW SLAVE HOSTS 6 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 6 Quit 150505 15:34:17 7 Connect root@localhost as anonymous on test 7 Query SHOW VARIABLES 7 Query SHOW SLAVE HOSTS 7 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 7 Quit 8 Connect root@localhost as anonymous on test 8 Query SHOW VARIABLES 8 Query SHOW SLAVE HOSTS 8 Query SELECT PLUGIN_NAME, PLUGIN_LIBRARY FROM INFORMATION_SCHEMA.PLUGINS WHERE PLUGIN_LIBRARY IS NOT NULL 8 Quit 9 Connect root@localhost as anonymous on test 9 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 9 Query SELECT DATABASE() 9 Query SELECT CONNECTION_ID() 9 Query SELECT CASE WHEN table_schema = 'information_schema' THEN 'INFORMATION_SCHEMA' ELSE table_schema END, table_name, CASE WHEN table_type = 'BASE TABLE' THEN 'table' WHEN table_type = 'VIEW' THEN 'view' WHEN table_type = 'SYSTEM VIEW' then 'view' ELSE 'misc' END, column_name, CASE WHEN column_key = 'PRI' THEN 'primary' WHEN column_key = 'MUL' THEN 'indexed' WHEN column_key = 'UNI' THEN 'indexed' ELSE 'ordinary' END, CASE WHEN data_type IN ('bit','tinyint','smallint','mediumint','int','bigint') THEN 'int' WHEN data_type IN ('float','double') THEN 'float' WHEN data_type IN ('datetime','timestamp') THEN 'timestamp' WHEN data_type IN ('char','varchar') THEN 'char' WHEN data_type IN ('binary','varbinary') THEN 'binary' WHEN data_type IN ('tinyblob','blob','mediumblob','longblob') THEN 'blob' WHEN data_type IN ('tinytext','text','mediumtext','longtext') THEN 'text' ELSE data_type END FROM information_schema.tables INNER JOIN information_schema.columns USING(table_schema, table_name) WHERE table_name <> 'DUMMY' 9 Query SELECT collation_name,character_set_name FROM information_schema.collations 9 Query SHOW VARIABLES LIKE 'datadir' 9 Quit 10 Connect root@localhost as anonymous on test 10 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 10 Query SELECT DATABASE() 10 Query SELECT CONNECTION_ID() 10 Query SELECT collation_name,character_set_name FROM information_schema.collations 10 Query SHOW SLAVE HOSTS 10 Query /* thread_id=10 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 11 Connect root@localhost as anonymous on test 11 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 11 Query SELECT DATABASE() 11 Query SELECT CONNECTION_ID() 11 Query SELECT collation_name,character_set_name FROM information_schema.collations 11 Query SHOW SLAVE HOSTS 11 Query /* thread_id=11 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 12 Connect root@localhost as anonymous on test 12 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 12 Query SELECT DATABASE() 12 Query SELECT CONNECTION_ID() 12 Query SELECT collation_name,character_set_name FROM information_schema.collations 12 Query SHOW SLAVE HOSTS 12 Query /* thread_id=12 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 13 Connect root@localhost as anonymous on test 13 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 13 Query SELECT DATABASE() 13 Query SELECT CONNECTION_ID() 13 Query SELECT collation_name,character_set_name FROM information_schema.collations 13 Query SHOW SLAVE HOSTS 13 Query /* thread_id=13 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 14 Connect root@localhost as anonymous on test 14 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 14 Query SELECT DATABASE() 14 Query SELECT CONNECTION_ID() 14 Query SELECT collation_name,character_set_name FROM information_schema.collations 14 Query SHOW SLAVE HOSTS 150505 15:34:18 14 Query /* thread_id=14 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Connect root@localhost as anonymous on test 15 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 15 Query SELECT DATABASE() 15 Query SELECT CONNECTION_ID() 15 Query SELECT collation_name,character_set_name FROM information_schema.collations 15 Query SHOW SLAVE HOSTS 15 Query /* thread_id=15 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 16 Connect root@localhost as anonymous on test 16 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 16 Query SELECT DATABASE() 16 Query SELECT CONNECTION_ID() 16 Query SELECT collation_name,character_set_name FROM information_schema.collations 16 Query SHOW SLAVE HOSTS 16 Query /* thread_id=16 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 17 Connect root@localhost as anonymous on test 17 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 17 Query SELECT DATABASE() 17 Query SELECT CONNECTION_ID() 17 Query SELECT collation_name,character_set_name FROM information_schema.collations 17 Query SHOW SLAVE HOSTS 17 Query /* thread_id=17 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Connect root@localhost as anonymous on test 18 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 18 Query SELECT DATABASE() 18 Query SELECT CONNECTION_ID() 18 Query SELECT collation_name,character_set_name FROM information_schema.collations 18 Query SHOW SLAVE HOSTS 18 Query /* thread_id=18 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 19 Connect root@localhost as anonymous on test 19 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 19 Query SELECT DATABASE() 19 Query SELECT CONNECTION_ID() 19 Query SELECT collation_name,character_set_name FROM information_schema.collations 19 Query SHOW SLAVE HOSTS 19 Query /* thread_id=19 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 20 Connect root@localhost as anonymous on test 20 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 20 Query SELECT DATABASE() 20 Query SELECT CONNECTION_ID() 20 Query SELECT collation_name,character_set_name FROM information_schema.collations 20 Query SHOW SLAVE HOSTS 20 Query /* thread_id=20 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 21 Connect root@localhost as anonymous on test 21 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 21 Query SELECT DATABASE() 21 Query SELECT CONNECTION_ID() 21 Query SELECT collation_name,character_set_name FROM information_schema.collations 21 Query SHOW SLAVE HOSTS 21 Query /* thread_id=21 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 22 Connect root@localhost as anonymous on test 22 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 22 Query SELECT DATABASE() 22 Query SELECT CONNECTION_ID() 22 Query SELECT collation_name,character_set_name FROM information_schema.collations 22 Query SHOW SLAVE HOSTS 22 Query /* thread_id=22 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 23 Connect root@localhost as anonymous on test 23 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 23 Query SELECT DATABASE() 23 Query SELECT CONNECTION_ID() 23 Query SELECT collation_name,character_set_name FROM information_schema.collations 23 Query SHOW SLAVE HOSTS 23 Query /* thread_id=23 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:34:19 24 Connect root@localhost as anonymous on test 24 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 24 Query SELECT DATABASE() 24 Query SELECT CONNECTION_ID() 24 Query SELECT collation_name,character_set_name FROM information_schema.collations 24 Query SHOW SLAVE HOSTS 24 Query /* thread_id=24 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 25 Connect root@localhost as anonymous on test 25 Query SET optimizer_switch=(SELECT variable_value FROM INFORMATION_SCHEMA.GLOBAL_VARIABLES WHERE VARIABLE_NAME='optimizer_switch') 25 Query SELECT DATABASE() 25 Query SELECT CONNECTION_ID() 25 Query SELECT collation_name,character_set_name FROM information_schema.collations 25 Query SHOW SLAVE HOSTS 25 Query /* thread_id=25 cnt=1 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:34:20 13 Query /* thread_id=13 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:34:22 22 Query /* thread_id=22 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:34:27 14 Query /* thread_id=14 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:34:28 17 Query /* thread_id=17 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:34:30 12 Query /* thread_id=12 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:34:31 19 Query /* thread_id=19 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:34:34 17 Query /* thread_id=17 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:34:35 25 Query /* thread_id=25 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:34:36 13 Query /* thread_id=13 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=2 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:34:39 11 Query /* thread_id=11 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:34:40 23 Query /* thread_id=23 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:34:41 16 Query /* thread_id=16 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:34:43 20 Query /* thread_id=20 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:34:47 10 Query /* thread_id=10 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:34:55 19 Query /* thread_id=19 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:34:57 10 Query /* thread_id=10 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:35:02 15 Query /* thread_id=15 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=3 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:35:05 21 Query /* thread_id=21 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:35:06 13 Query /* thread_id=13 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:35:11 24 Query /* thread_id=24 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:14 10 Query /* thread_id=10 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:16 16 Query /* thread_id=16 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:35:19 17 Query /* thread_id=17 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:22 25 Query /* thread_id=25 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:35:23 20 Query /* thread_id=20 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=4 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:24 14 Query /* thread_id=14 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:35:27 19 Query /* thread_id=19 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:28 17 Query /* thread_id=17 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:35:29 25 Query /* thread_id=25 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:35:30 10 Query /* thread_id=10 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:35:31 21 Query /* thread_id=21 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:35:35 15 Query /* thread_id=15 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:36 16 Query /* thread_id=16 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:37 18 Query /* thread_id=18 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:41 23 Query /* thread_id=23 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:35:45 12 Query /* thread_id=12 cnt=5 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:35:47 15 Query /* thread_id=15 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:35:50 23 Query /* thread_id=23 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:35:52 14 Query /* thread_id=14 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:35:54 10 Query /* thread_id=10 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:35:58 15 Query /* thread_id=15 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:05 20 Query /* thread_id=20 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:36:07 23 Query /* thread_id=23 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=6 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:36:09 21 Query /* thread_id=21 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:36:11 11 Query /* thread_id=11 cnt=7 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:13 20 Query /* thread_id=20 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:14 19 Query /* thread_id=19 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:36:16 18 Query /* thread_id=18 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:36:21 25 Query /* thread_id=25 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:22 18 Query /* thread_id=18 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:36:24 24 Query /* thread_id=24 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:36:25 20 Query /* thread_id=20 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:36:26 24 Query /* thread_id=24 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:36:28 23 Query /* thread_id=23 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:36:30 19 Query /* thread_id=19 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:31 13 Query /* thread_id=13 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=16 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:36:32 15 Query /* thread_id=15 cnt=17 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `col_char_12` FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 1959657472 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 24 Query /* thread_id=24 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:36:33 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=18 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_char_12_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 101 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:36:34 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=19 */ DELETE FROM `view_table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:36:35 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=20 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:36:36 14 Query /* thread_id=14 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:37 15 Query /* thread_id=15 cnt=21 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:38 25 Query /* thread_id=25 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:36:39 11 Query /* thread_id=11 cnt=8 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:42 17 Query /* thread_id=17 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:36:43 22 Query /* thread_id=22 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:36:46 13 Query /* thread_id=13 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:36:49 25 Query /* thread_id=25 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=22 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:36:54 19 Query /* thread_id=19 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:36:55 13 Query /* thread_id=13 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:36:56 18 Query /* thread_id=18 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:36:57 16 Query /* thread_id=16 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=16 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 22 Query /* thread_id=22 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:36:58 25 Query /* thread_id=25 cnt=17 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12_key` = 'b' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:36:59 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=18 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:37:00 17 Query /* thread_id=17 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=19 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:01 10 Query /* thread_id=10 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:37:02 25 Query /* thread_id=25 cnt=20 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=23 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 232 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:03 14 Query /* thread_id=14 cnt=9 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=24 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 3 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:37:04 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=25 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `pk` = 31 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:37:05 11 Query /* thread_id=11 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=26 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12` FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 1987379200 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:06 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=27 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:07 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=28 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` = 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:37:08 13 Query /* thread_id=13 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=29 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:09 15 Query /* thread_id=15 cnt=30 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` = 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:37:10 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=31 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:37:11 17 Query /* thread_id=17 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=21 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:12 24 Query /* thread_id=24 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=16 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=16 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 25 Query /* thread_id=25 cnt=22 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:37:13 14 Query /* thread_id=14 cnt=10 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=16 */ REPLACE INTO `view_table2_innodb_int_autoinc` ( `pk`, `col_char_12_key` ) VALUES ( 'a', 's' ), ( 1, 122 ) 14 Query /* thread_id=14 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=17 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 2 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query /* thread_id=19 cnt=17 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12_key` = 'y' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:14 23 Query SHOW WARNINGS 19 Query SHOW WARNINGS 24 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=18 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=18 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 23 Query /* thread_id=23 cnt=17 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 'j', 2317352960, 's', 109, 1 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:37:15 23 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=18 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:37:16 24 Query /* thread_id=24 cnt=19 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `pk` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 23 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:37:17 24 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=20 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:37:20 20 Query /* thread_id=20 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:37:22 14 Query /* thread_id=14 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=16 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 2 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 22 Query /* thread_id=22 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:37:23 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=17 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:24 18 Query /* thread_id=18 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=32 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `pk` BETWEEN 4 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=33 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12` ) VALUES ( 'w', 239 ), ( 7, 'j' ) 150505 15:37:25 10 Query /* thread_id=10 cnt=18 */ INSERT INTO `view_table2_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 102, 187 ), ( 1001914368, 'z' ) 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=19 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:26 15 Query /* thread_id=15 cnt=34 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 2894987264, 171 ), ( 3088580608, 3945594880 ) 15 Query /* thread_id=15 cnt=35 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_int_key`, `pk` ) VALUES ( 'e', 'j' ), ( 4, 2169569280 ) 12 Query /* thread_id=12 cnt=11 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=16 */ DELETE FROM `table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:37:27 15 Query SHOW WARNINGS 20 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=20 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=17 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_int` BETWEEN 2 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query /* thread_id=15 cnt=36 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 'c', 7, 27, 762970112, 'd' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:37:28 20 Query SHOW WARNINGS 20 Query /* thread_id=20 cnt=18 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=37 */ DELETE FROM `table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:37:29 15 Query SHOW WARNINGS 20 Query /* thread_id=20 cnt=19 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 2 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query /* thread_id=15 cnt=38 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=39 */ INSERT INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 7, 120 ), ( 90, 54 ) 150505 15:37:30 14 Query /* thread_id=14 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=21 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12` = 220 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 23 Query /* thread_id=23 cnt=19 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=20 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 20 Query SHOW WARNINGS 10 Query SHOW WARNINGS 23 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=21 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=22 */ DELETE FROM `table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 20 Query /* thread_id=20 cnt=20 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `pk` IN ( 229048320, 709230592, 238, 34, 3791847424 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query /* thread_id=15 cnt=40 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_int_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 3810328576 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 10 Query SHOW WARNINGS 20 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=23 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query SHOW WARNINGS 20 Query /* thread_id=20 cnt=21 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 4 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query /* thread_id=15 cnt=41 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=42 */ ROLLBACK 15 Query /* thread_id=15 cnt=43 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 8 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 23 Query /* thread_id=23 cnt=22 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:37:31 20 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=24 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=22 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int` IN ( 'g', 7, 92, 55, 'g' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:32 15 Query SHOW WARNINGS 20 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=44 */ SET AUTOCOMMIT=OFF 20 Query /* thread_id=20 cnt=23 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 250, 141 ), ( 'g', 'z' ) 15 Query /* thread_id=15 cnt=45 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=46 */ INSERT IGNORE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=47 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=48 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_char_12_key` FROM `table1_innodb_int_autoinc` WHERE `pk` = 7 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=49 */ INSERT INTO `view_table0_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 231, 9 ), ( 23, 'a' ) 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=50 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` IN ( 38, 4, 1, 'l', 2 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=51 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 7, 0, 'o', 4, 967901184 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=52 */ SET TRANSACTION ISOLATION LEVEL READ COMMITTED 15 Query /* thread_id=15 cnt=53 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=54 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=55 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:37:33 20 Query /* thread_id=20 cnt=24 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:34 20 Query SHOW WARNINGS 20 Query /* thread_id=20 cnt=25 */ INSERT INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 20 Query /* thread_id=20 cnt=26 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_int_key` FROM `table1_innodb_int_autoinc` WHERE `pk` = 66 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 24 Query /* thread_id=24 cnt=21 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:35 11 Query /* thread_id=11 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=23 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` = 'l' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 11 Query /* thread_id=11 cnt=16 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` ( `col_int`, `col_int_key` ) VALUES ( 'q', 1264517120 ), ( 'd', 1 ) 25 Query SHOW WARNINGS 20 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=24 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 20 Query /* thread_id=20 cnt=27 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=22 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 2 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:36 24 Query SHOW WARNINGS 11 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=23 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=17 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 1537933312, 3592290304 ), ( 'b', 165 ) 11 Query /* thread_id=11 cnt=18 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_int_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 5 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 25 Query /* thread_id=25 cnt=25 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 119, 2019557376, 8, 2412969984, 21 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:37 25 Query SHOW WARNINGS 11 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=26 */ DELETE FROM `view_table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 11 Query /* thread_id=11 cnt=19 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:38 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=27 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=20 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=21 */ INSERT INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:39 25 Query /* thread_id=25 cnt=28 */ INSERT INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=22 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:41 18 Query /* thread_id=18 cnt=16 */ SET TRANSACTION ISOLATION LEVEL REPEATABLE READ 18 Query /* thread_id=18 cnt=17 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=18 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` = 'r' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=23 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=19 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:37:42 13 Query /* thread_id=13 cnt=16 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:43 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=17 */ START TRANSACTION 13 Query /* thread_id=13 cnt=18 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_char_12_key`, `col_int_key` ) VALUES ( 31, 44 ), ( 28, 'l' ) 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=19 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` IN ( 2277048320, 31, 231, 4, 0 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=20 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 'i', 1 ), ( 'e', 'l' ) 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=21 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:37:44 10 Query /* thread_id=10 cnt=25 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `pk` BETWEEN 1 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 14 Query /* thread_id=14 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:37:45 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=26 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=24 */ INSERT INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:46 11 Query /* thread_id=11 cnt=25 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `pk` FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 'd' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:37:47 15 Query /* thread_id=15 cnt=56 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 0, 4 ), ( 7, 4 ) 15 Query /* thread_id=15 cnt=57 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `pk` IN ( 8, 106692608, 'e', 89, 235 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=58 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=26 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 2 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:37:48 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=27 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `pk` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 'r' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:37:49 12 Query /* thread_id=12 cnt=12 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=19 */ DELETE FROM `table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 22 Query /* thread_id=22 cnt=16 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` = 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 11 Query SHOW WARNINGS 19 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=28 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=20 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 229, 132 ), ( 'r', 216 ) 19 Query /* thread_id=19 cnt=21 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12` ) VALUES ( 4, 92 ), ( 2, 175 ) 150505 15:37:51 19 Query /* thread_id=19 cnt=22 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 'y' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:37:52 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=23 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=28 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:37:53 20 Query /* thread_id=20 cnt=29 */ INSERT IGNORE INTO `view_table1_innodb_int_autoinc` ( `pk`, `col_char_12_key` ) VALUES ( 'y', 's' ), ( 'z', 8 ) 150505 15:37:58 12 Query /* thread_id=12 cnt=13 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=16 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 2690646016 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 16 Query /* thread_id=16 cnt=16 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 185, 4, 1, 191, 5 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 10 Query /* thread_id=10 cnt=27 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:37:59 16 Query SHOW WARNINGS 14 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=17 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=17 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` IN ( SELECT `pk` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 7 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:38:00 24 Query /* thread_id=24 cnt=24 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `pk` FROM `table2_innodb_int_autoinc` WHERE `pk` = 'j' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 24 Query /* thread_id=24 cnt=25 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `table3_innodb_int_autoinc` WHERE `pk` = 1019346944 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:38:01 24 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=26 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:38:04 17 Query /* thread_id=17 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=14 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=23 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 13, 6, 1, 2866544640, 191 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query /* thread_id=18 cnt=20 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:38:05 23 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=24 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:38:06 11 Query /* thread_id=11 cnt=29 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `pk` IN ( SELECT `pk` FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 25165824 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query /* thread_id=15 cnt=59 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=60 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `pk` FROM `table1_innodb_int_autoinc` WHERE `pk` = 4264034304 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=61 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_int_key` IN ( 13, 242, 67, 221, 5 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:38:07 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=30 */ DELETE FROM `view_table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query /* thread_id=19 cnt=24 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 5, 9, 5, 5, 246 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:38:08 13 Query /* thread_id=13 cnt=22 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=16 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_int_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 'w' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=25 */ INSERT IGNORE INTO `table0_innodb_int_autoinc` ( `col_char_12_key`, `col_int` ) VALUES ( 7, 't' ), ( 1, 'o' ) 150505 15:38:09 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=26 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:38:10 18 Query /* thread_id=18 cnt=21 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:38:11 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=22 */ SET AUTOCOMMIT=ON 18 Query /* thread_id=18 cnt=23 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int` IN ( 'u', 'k', 's', 1, 'y' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:38:12 23 Query /* thread_id=23 cnt=25 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 10 Query /* thread_id=10 cnt=28 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `col_int_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 3 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:38:13 16 Query /* thread_id=16 cnt=18 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 23 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=26 */ REPLACE INTO `view_table2_innodb_int_autoinc` ( `pk`, `col_char_12` ) VALUES ( 847249408, 839516160 ), ( 186, 1688141824 ) 24 Query /* thread_id=24 cnt=27 */ DELETE FROM `table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:38:14 24 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=27 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=28 */ INSERT IGNORE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 23 Query /* thread_id=23 cnt=28 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=27 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `pk` BETWEEN 1 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 17 Query /* thread_id=17 cnt=16 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 30212096, 205 ), ( 'y', 'l' ) 17 Query /* thread_id=17 cnt=17 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:38:15 24 Query /* thread_id=24 cnt=29 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `pk` = 3731357696 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=29 */ SAVEPOINT C 19 Query /* thread_id=19 cnt=28 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `pk` = 'n' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 23 Query /* thread_id=23 cnt=30 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` = 9 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:38:16 12 Query /* thread_id=12 cnt=15 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 19 Query SHOW WARNINGS 23 Query SHOW WARNINGS 24 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=29 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` = 75 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 23 Query /* thread_id=23 cnt=31 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=30 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:38:17 13 Query /* thread_id=13 cnt=23 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 3980394496, 174 ), ( 2, 8 ) 13 Query /* thread_id=13 cnt=24 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_int_key` = 2111569920 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=25 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=30 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:38:18 19 Query /* thread_id=19 cnt=31 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:38:19 17 Query /* thread_id=17 cnt=18 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:38:22 12 Query /* thread_id=12 cnt=16 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 16 Query /* thread_id=16 cnt=19 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 69, 173, 'q', 0, 1366818816 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 24 Query /* thread_id=24 cnt=31 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `pk` IN ( 'u', 4176478208, 215, 175, 'v' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:38:23 16 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=20 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=26 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 23 Query /* thread_id=23 cnt=32 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `pk` FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 215 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 13 Query /* thread_id=13 cnt=27 */ DELETE FROM `view_table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=28 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` = 4 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=29 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:38:25 17 Query /* thread_id=17 cnt=19 */ DELETE FROM `table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:38:26 17 Query SHOW WARNINGS 23 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=20 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=33 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( 'e', 57, 'g', 3, 5 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 16 Query /* thread_id=16 cnt=21 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=22 */ INSERT INTO `table3_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 126, 1284243456 ), ( 4036231168, 3260350464 ) 16 Query /* thread_id=16 cnt=23 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=24 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `pk` FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 452198400 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:38:27 23 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=34 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `table2_innodb_int_autoinc` WHERE `pk` = 9 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query /* thread_id=13 cnt=30 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` IN ( 'm', 9, 3, 111, 74 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:38:28 17 Query /* thread_id=17 cnt=21 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:38:29 15 Query SHOW WARNINGS 19 Query SHOW WARNINGS 14 Query SHOW WARNINGS 16 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=62 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 14 Query /* thread_id=14 cnt=18 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=32 */ INSERT INTO `view_table0_innodb_int_autoinc` ( `col_char_12_key`, `col_int` ) VALUES ( 'j', 76 ), ( 5, 'n' ) 15 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=25 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=63 */ SET AUTOCOMMIT=OFF 15 Query /* thread_id=15 cnt=64 */ REPLACE INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=65 */ SET TRANSACTION ISOLATION LEVEL REPEATABLE READ 15 Query /* thread_id=15 cnt=66 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `col_char_12` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 152633344 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 23 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=35 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( 'w', 's', 129, 8, 202 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 13 Query /* thread_id=13 cnt=31 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `table3_innodb_int_autoinc` WHERE `pk` = 'l' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=67 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=68 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `pk` = 3 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=69 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `pk` = 178 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=70 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=71 */ DELETE FROM `table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=72 */ SAVEPOINT A 15 Query /* thread_id=15 cnt=73 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 2, 1 ), ( 3228762112, 'u' ) 15 Query /* thread_id=15 cnt=74 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:38:30 23 Query SHOW WARNINGS 19 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=36 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=33 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `pk` IN ( 422051840, 76, 3, 'w', 0 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 23 Query /* thread_id=23 cnt=37 */ DELETE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 25 Query /* thread_id=25 cnt=29 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 1, 'e' ), ( 'e', 2586771456 ) 150505 15:38:31 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=34 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=30 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 25 Query /* thread_id=25 cnt=31 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 2 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:38:32 14 Query /* thread_id=14 cnt=19 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `pk` IN ( 2483486720, 3553427456, 174456832, 9, 0 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 25 Query SHOW WARNINGS 14 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=32 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 14 Query /* thread_id=14 cnt=20 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 'l' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 16 Query /* thread_id=16 cnt=26 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` ( `col_int`, `col_char_12_key` ) VALUES ( 'o', 'k' ), ( 188, 2512453632 ) 150505 15:38:33 14 Query SHOW WARNINGS 14 Query /* thread_id=14 cnt=21 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=33 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 0, 4130275328 ), ( 3, 175 ) 150505 15:38:34 16 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=27 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=75 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` = 1084030976 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=76 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 197, 0 ), ( 1, 1510604800 ) 15 Query /* thread_id=15 cnt=77 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` ( `pk`, `col_int_key` ) VALUES ( 4171431936, 2653814784 ), ( 3356426240, 0 ) 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=78 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 'a' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=79 */ SET AUTOCOMMIT=OFF 15 Query /* thread_id=15 cnt=80 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:38:35 25 Query /* thread_id=25 cnt=34 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:38:36 25 Query /* thread_id=25 cnt=35 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:38:37 25 Query /* thread_id=25 cnt=36 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 2 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:38:39 19 Query /* thread_id=19 cnt=35 */ INSERT IGNORE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=28 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12` IN ( SELECT `col_char_12` FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 'd' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query /* thread_id=15 cnt=81 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=22 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_int` BETWEEN 2 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:38:40 19 Query /* thread_id=19 cnt=36 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=17 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:38:41 15 Query /* thread_id=15 cnt=82 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `table3_innodb_int_autoinc` WHERE `pk` = 2 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=83 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `table2_innodb_int_autoinc` WHERE `pk` = 1867841536 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=38 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=84 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:38:43 22 Query /* thread_id=22 cnt=18 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=19 */ INSERT IGNORE INTO `table2_innodb_int_autoinc` ( `col_int_key`, `col_char_12_key` ) VALUES ( 'i', 106 ), ( 'p', 182 ) 19 Query /* thread_id=19 cnt=37 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` IN ( 125, 'r', 4076142592, 103, 1494614016 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:38:44 22 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=20 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 3436838912, 6 ), ( 2535653376, 3710058496 ) 20 Query /* thread_id=20 cnt=30 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=85 */ INSERT IGNORE INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 2, 2226520064 ), ( 'i', 1452146688 ) 23 Query /* thread_id=23 cnt=39 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 3, 'q' ), ( 's', 180 ) 15 Query /* thread_id=15 cnt=86 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 6, 'c' ), ( 3456565248, 1653473280 ) 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=87 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `pk` FROM `table0_innodb_int_autoinc` WHERE `pk` = 'z' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query /* thread_id=15 cnt=88 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=89 */ INSERT IGNORE INTO `view_table0_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 'u', 1147863040 ), ( 4, 25 ) 150505 15:38:45 22 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=21 */ INSERT INTO `table3_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 1971322880, 36 ), ( 1277755392, 255 ) 150505 15:38:46 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=90 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_int_key`, `col_int` ) VALUES ( 'u', 88 ), ( 8, 1929576448 ) 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=91 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 23 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=40 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 's' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 20 Query /* thread_id=20 cnt=31 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 4 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 20 Query SHOW WARNINGS 20 Query /* thread_id=20 cnt=32 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:38:47 22 Query /* thread_id=22 cnt=22 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 4054581248, 5 ), ( 'o', 'b' ) 15 Query /* thread_id=15 cnt=92 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_int` = 1712390144 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=93 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 4 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=94 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 5, 'b', 660275200, 'e', 181 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=95 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 106 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=96 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=97 */ SET AUTOCOMMIT=OFF 15 Query /* thread_id=15 cnt=98 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 56, 5 ), ( 27, 9 ) 15 Query /* thread_id=15 cnt=99 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=100 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 8, 5 ), ( 2857041920, 'h' ) 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=101 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=102 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=103 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=104 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=105 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 82 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=106 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` = 'm' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=107 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=108 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=109 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `pk` IN ( 'b', 209, 'f', 158, 'o' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=110 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `pk` BETWEEN 1 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 21 Query /* thread_id=21 cnt=17 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=31 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 149 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 16 Query /* thread_id=16 cnt=29 */ INSERT INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 24 Query /* thread_id=24 cnt=32 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 119, 'p' ), ( 'y', 214 ) 14 Query /* thread_id=14 cnt=23 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 12 Query /* thread_id=12 cnt=17 */ DELETE FROM `table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=111 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:38:48 12 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=18 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 8, 8, 2223570944, 'j', 38 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 22 Query SHOW WARNINGS 21 Query /* thread_id=21 cnt=18 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_int`, `col_int_key` ) VALUES ( 616890368, 0 ), ( 0, 990773248 ) 22 Query /* thread_id=22 cnt=23 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `pk` IN ( 'a', 3049652224, 1944715264, 1, 56 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 21 Query /* thread_id=21 cnt=19 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 1 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 24 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=33 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:38:49 15 Query /* thread_id=15 cnt=112 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 12 Query SHOW WARNINGS 21 Query SHOW WARNINGS 21 Query /* thread_id=21 cnt=20 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 12 Query /* thread_id=12 cnt=19 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=34 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 'd', 0 ), ( 2251685888, 231 ) 12 Query /* thread_id=12 cnt=20 */ INSERT INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 24 Query /* thread_id=24 cnt=35 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_char_12_key`, `col_int` ) VALUES ( 94, 193 ), ( 873463808, 248 ) 22 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=24 */ REPLACE INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:38:50 21 Query /* thread_id=21 cnt=21 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 22 Query /* thread_id=22 cnt=25 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=36 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=113 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `pk` = 'h' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=114 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 'z' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=115 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:38:51 24 Query /* thread_id=24 cnt=37 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:38:52 24 Query /* thread_id=24 cnt=38 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=39 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 1381433344 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 21 Query /* thread_id=21 cnt=22 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=23 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` = 'j' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:38:53 24 Query SHOW WARNINGS 21 Query SHOW WARNINGS 21 Query /* thread_id=21 cnt=24 */ REPLACE INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 24 Query /* thread_id=24 cnt=40 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `pk`, `col_char_12_key` ) VALUES ( 62, 2757820416 ), ( 0, 875757568 ) 150505 15:38:54 21 Query /* thread_id=21 cnt=25 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 179 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:38:55 15 Query /* thread_id=15 cnt=116 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 22 Query /* thread_id=22 cnt=26 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 21 Query /* thread_id=21 cnt=26 */ INSERT INTO `table1_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 1638203392, 3151626240 ), ( 'r', 1621360640 ) 15 Query /* thread_id=15 cnt=117 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 58, 'p', 1907032064, 1, 8 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 21 Query /* thread_id=21 cnt=27 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` = 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=118 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:38:56 15 Query /* thread_id=15 cnt=119 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:38:57 15 Query /* thread_id=15 cnt=120 */ INSERT INTO `view_table3_innodb_int_autoinc` ( `pk`, `col_int` ) VALUES ( 1574305792, 4 ), ( 1181417472, 100 ) 15 Query /* thread_id=15 cnt=121 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `pk` BETWEEN 4 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=122 */ INSERT IGNORE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=123 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=32 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query /* thread_id=15 cnt=124 */ SET AUTOCOMMIT=ON 150505 15:38:58 19 Query SHOW WARNINGS 18 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=125 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `pk` = 0 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query /* thread_id=19 cnt=38 */ SET AUTOCOMMIT=OFF 18 Query /* thread_id=18 cnt=24 */ DELETE FROM `table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query /* thread_id=19 cnt=39 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 0, 'b' ), ( 2309554176, 151 ) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=40 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` = 'o' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=41 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 'd', 48 ), ( 'k', 214 ) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=42 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=43 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_char_12_key`, `col_int_key` ) VALUES ( 1175126016, 180420608 ), ( 1617166336, 3453747200 ) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=44 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 'g', 249 ), ( 2051211264, 0 ) 19 Query /* thread_id=19 cnt=45 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 3975020544, 3 ), ( 52, 5 ) 19 Query /* thread_id=19 cnt=46 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=47 */ DELETE FROM `table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=48 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=49 */ COMMIT 18 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=30 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=22 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 169, 1426194432 ), ( 5, 507641856 ) 18 Query /* thread_id=18 cnt=25 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 15 Query SHOW WARNINGS 14 Query /* thread_id=14 cnt=24 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 11 Query SHOW WARNINGS 20 Query /* thread_id=20 cnt=33 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_int`, `col_char_12_key` ) VALUES ( 5, 'k' ), ( 'q', 9 ) 12 Query /* thread_id=12 cnt=21 */ DELETE FROM `table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 17 Query /* thread_id=17 cnt=23 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 221, 2710765568 ), ( 966000640, 2 ) 11 Query /* thread_id=11 cnt=33 */ INSERT INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 22 Query /* thread_id=22 cnt=27 */ ROLLBACK 24 Query /* thread_id=24 cnt=41 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 'r', 84, 's', 2, 'l' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 22 Query /* thread_id=22 cnt=28 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `pk` BETWEEN 3 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 16 Query /* thread_id=16 cnt=31 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 'g', 889061376, 'l', 'h', 7 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 12 Query SHOW WARNINGS 13 Query SHOW WARNINGS 10 Query SHOW WARNINGS 23 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=22 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 4 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 10 Query /* thread_id=10 cnt=29 */ INSERT INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 22 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=126 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `col_char_12_key` FROM `table1_innodb_int_autoinc` WHERE `pk` = 4205641728 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 21 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=32 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 22 Query /* thread_id=22 cnt=29 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `pk` IN ( SELECT `pk` FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 134 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 21 Query /* thread_id=21 cnt=28 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12` ) VALUES ( 8, 199 ), ( 128843776, 'q' ) 13 Query /* thread_id=13 cnt=33 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=41 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 232, 7, 0, 3875602432, 'l' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 12 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=32 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=23 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 23 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=34 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` IN ( 523239424, 2649096192, 51, 'v', 's' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 23 Query /* thread_id=23 cnt=42 */ REPLACE INTO `view_table2_innodb_int_autoinc` ( `col_int_key`, `col_char_12_key` ) VALUES ( 439812096, 0 ), ( 200, 0 ) 16 Query /* thread_id=16 cnt=33 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 22 Query SHOW WARNINGS 13 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=50 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 22 Query /* thread_id=22 cnt=30 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=35 */ DELETE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query /* thread_id=19 cnt=51 */ DELETE FROM `table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 19 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=127 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=52 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 102236160 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=53 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=54 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 20 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=34 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 'l', 408748032 ), ( 'n', 169 ) 20 Query /* thread_id=20 cnt=34 */ INSERT INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=24 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=36 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `pk` IN ( 1884028928, 3818061824, 4, 1768292352, 2470838272 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 10 Query /* thread_id=10 cnt=30 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_int` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 3846176768 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 13 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=43 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 'c', 93, 'x', 3016359936, 160 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 11 Query SHOW WARNINGS 10 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=37 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 1 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 11 Query /* thread_id=11 cnt=35 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 2798845952, 'i' ), ( 'd', 8 ) 10 Query /* thread_id=10 cnt=31 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_int`, `col_char_12_key` ) VALUES ( 90, 'e' ), ( 'u', 1632763904 ) 150505 15:38:59 15 Query /* thread_id=15 cnt=128 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 17 Query /* thread_id=17 cnt=25 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `table3_innodb_int_autoinc` WHERE `pk` = 'h' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 21 Query /* thread_id=21 cnt=29 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `pk`, `col_int` ) VALUES ( 7, 9 ), ( 37, 110 ) 16 Query /* thread_id=16 cnt=34 */ DELETE FROM `view_table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 11 Query SHOW WARNINGS 23 Query SHOW WARNINGS 13 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=36 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=44 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 98 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 13 Query /* thread_id=13 cnt=38 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 'o', 3 ), ( 1034682368, 22 ) 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=39 */ INSERT INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=40 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 'u', 113 ), ( 1, 8 ) 13 Query /* thread_id=13 cnt=41 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=32 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:00 17 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=26 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_char_12_key`, `col_int` ) VALUES ( 416153600, 152 ), ( 2175860736, 'n' ) 17 Query /* thread_id=17 cnt=27 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `pk` = 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 10 Query /* thread_id=10 cnt=33 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 201, 227 ), ( 3438477312, 164 ) 150505 15:39:01 17 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=28 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:39:02 10 Query /* thread_id=10 cnt=34 */ SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED 10 Query /* thread_id=10 cnt=35 */ DELETE FROM `table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 10 Query /* thread_id=10 cnt=36 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 'r', 3 ), ( 482410496, 'l' ) 10 Query /* thread_id=10 cnt=37 */ REPLACE INTO `view_table2_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 496304128, 9 ), ( 5, 4 ) 10 Query /* thread_id=10 cnt=38 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 'p', 'i' ), ( 245, 4104257536 ) 10 Query /* thread_id=10 cnt=39 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:39:04 22 Query /* thread_id=22 cnt=31 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:39:05 14 Query /* thread_id=14 cnt=25 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` BETWEEN 2 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 11 Query /* thread_id=11 cnt=37 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 64, 156, 1, 63, 9 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:39:06 14 Query SHOW WARNINGS 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=38 */ REPLACE INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 14 Query /* thread_id=14 cnt=26 */ DELETE FROM `view_table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:39:07 11 Query /* thread_id=11 cnt=39 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_int_key` FROM `table2_innodb_int_autoinc` WHERE `pk` = 251 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 13 Query /* thread_id=13 cnt=42 */ INSERT INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=55 */ REPLACE INTO `view_table2_innodb_int_autoinc` ( `pk`, `pk` ) VALUES ( 0, 2 ), ( 662896640, 'j' ) 12 Query /* thread_id=12 cnt=24 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=43 */ INSERT INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=44 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 3072655360, 'z' ), ( 237, 'z' ) 13 Query /* thread_id=13 cnt=45 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12` = 2293235712 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=46 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 'd', 5 ), ( 9, 1560936448 ) 13 Query /* thread_id=13 cnt=47 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 98, 244 ), ( 1922105344, 'r' ) 13 Query /* thread_id=13 cnt=48 */ SET AUTOCOMMIT=OFF 13 Query /* thread_id=13 cnt=49 */ SET TRANSACTION ISOLATION LEVEL REPEATABLE READ 13 Query /* thread_id=13 cnt=50 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 3 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=51 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 7, 206, 61, 't', 194 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=52 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` BETWEEN 4 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=53 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `pk` IN ( 64, 4208197632, 2963079168, 78, 6 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=54 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=55 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `pk` IN ( 1013710848, 'v', 150, 'u', 'g' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=56 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:39:08 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=40 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 8 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 11 Query /* thread_id=11 cnt=41 */ DELETE FROM `table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 17 Query /* thread_id=17 cnt=29 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:39:09 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=42 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:39:10 18 Query /* thread_id=18 cnt=26 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` IN ( 'b', 8, 212, 't', 6 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:39:11 13 Query /* thread_id=13 cnt=57 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=27 */ COMMIT 18 Query /* thread_id=18 cnt=28 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:14 22 Query /* thread_id=22 cnt=32 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=40 */ INSERT INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=41 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:39:17 13 Query /* thread_id=13 cnt=58 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_int_key` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 1 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=59 */ INSERT IGNORE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:19 22 Query /* thread_id=22 cnt=33 */ INSERT INTO `table3_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 98, 'w' ), ( 596246528, 9961472 ) 13 Query /* thread_id=13 cnt=60 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 22 Query /* thread_id=22 cnt=34 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( 'q', 2606891008, 'l', 'r', 73 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 13 Query /* thread_id=13 cnt=61 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=62 */ INSERT INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=63 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 41 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=64 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=65 */ INSERT INTO `table1_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 204, 5 ), ( 1281228800, 105 ) 13 Query /* thread_id=13 cnt=66 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 22 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=56 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12` ) VALUES ( 3, 80 ), ( 1747910656, 'f' ) 22 Query /* thread_id=22 cnt=35 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` = 126 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:39:20 10 Query /* thread_id=10 cnt=42 */ DELETE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 10 Query /* thread_id=10 cnt=43 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 22 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=36 */ INSERT INTO `table1_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 7, 6 ), ( 41, 668729344 ) 150505 15:39:21 17 Query /* thread_id=17 cnt=30 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `pk` BETWEEN 1 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 11 Query /* thread_id=11 cnt=43 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=44 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` = 'g' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 17 Query SHOW WARNINGS 11 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=31 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` = 208 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 11 Query /* thread_id=11 cnt=45 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` IN ( 89, 7, 237, 3303407616, 8 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:39:22 22 Query /* thread_id=22 cnt=37 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_int_key` ) VALUES ( 7, 1224933376 ), ( 323878912, 3497852928 ) 17 Query SHOW WARNINGS 11 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=32 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 2720202752, 2242314240 ), ( 6, 6 ) 11 Query /* thread_id=11 cnt=46 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `col_int` FROM `table0_innodb_int_autoinc` WHERE `pk` = 'v' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 10 Query /* thread_id=10 cnt=44 */ INSERT INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=45 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=46 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:39:23 22 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=38 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 1559756800, 4 ), ( 7, 2290221056 ) 22 Query /* thread_id=22 cnt=39 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:24 10 Query /* thread_id=10 cnt=47 */ COMMIT 13 Query /* thread_id=13 cnt=67 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=48 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `pk`, `col_char_12` ) VALUES ( 1522073600, 0 ), ( 3031236608, 0 ) 13 Query /* thread_id=13 cnt=68 */ ROLLBACK TO SAVEPOINT B 13 Query /* thread_id=13 cnt=69 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:39:26 13 Query /* thread_id=13 cnt=70 */ COMMIT 13 Query /* thread_id=13 cnt=71 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 11 Query SHOW WARNINGS 25 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=47 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=37 */ INSERT INTO `table1_innodb_int_autoinc` ( `col_int`, `col_char_12_key` ) VALUES ( 10, 'p' ), ( 3086548992, 'n' ) 19 Query /* thread_id=19 cnt=57 */ SET AUTOCOMMIT=OFF 19 Query /* thread_id=19 cnt=58 */ INSERT IGNORE INTO `view_table1_innodb_int_autoinc` ( `pk`, `pk` ) VALUES ( 7, 9 ), ( 157, 'o' ) 20 Query /* thread_id=20 cnt=35 */ INSERT INTO `table1_innodb_int_autoinc` ( `col_char_12`, `col_char_12` ) VALUES ( 5, 'q' ), ( 85, 9 ) 20 Query /* thread_id=20 cnt=36 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` = 4 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 16 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=35 */ INSERT INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 20 Query SHOW WARNINGS 17 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=29 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_char_12_key`, `col_int_key` ) VALUES ( 3487498240, 155 ), ( 'n', 183 ) 10 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=25 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12` IN ( SELECT `pk` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 58 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=49 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_char_12_key` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 'x' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 19 Query /* thread_id=19 cnt=59 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 24 Query /* thread_id=24 cnt=42 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 'e', 151 ), ( 185, 0 ) 17 Query /* thread_id=17 cnt=33 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12` ) VALUES ( 192, 9 ), ( 255, 118 ) 22 Query /* thread_id=22 cnt=40 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 10 Query SHOW WARNINGS 23 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=50 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=129 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 23 Query /* thread_id=23 cnt=45 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=51 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `pk` BETWEEN 1 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 19 Query /* thread_id=19 cnt=60 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 1 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 24 Query /* thread_id=24 cnt=43 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 19 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=46 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 13, 3023896576 ), ( 's', 74 ) 17 Query /* thread_id=17 cnt=34 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 'm', 499122176 ), ( 'e', 3572170752 ) 23 Query /* thread_id=23 cnt=47 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_int` BETWEEN 1 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query /* thread_id=19 cnt=61 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=37 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=38 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 18 Query /* thread_id=18 cnt=30 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=36 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 21 Query /* thread_id=21 cnt=30 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12` BETWEEN 3 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query /* thread_id=15 cnt=130 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 133, 120 ), ( 239, 1349517312 ) 10 Query /* thread_id=10 cnt=52 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=131 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=35 */ INSERT IGNORE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:27 25 Query SHOW WARNINGS 16 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=39 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=37 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 'v', 7 ), ( 'p', 2920087552 ) 14 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=38 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=27 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 1469186048, 6 ), ( 1151860736, 'p' ) 10 Query /* thread_id=10 cnt=53 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query /* thread_id=18 cnt=31 */ SET AUTOCOMMIT=OFF 17 Query /* thread_id=17 cnt=36 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=32 */ INSERT INTO `view_table2_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 3155034112, 'o' ), ( 'm', 64487424 ) 17 Query /* thread_id=17 cnt=37 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=33 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 24, 'a' ), ( 4289069056, 164691968 ) 12 Query SHOW WARNINGS 10 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=26 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `pk` = 83 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 10 Query /* thread_id=10 cnt=54 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 'k', 'u' ), ( 56, 1817313280 ) 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=34 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 8, 1665531904 ), ( 2620522496, 2146369536 ) 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=35 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int_key` = 2925985792 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=36 */ INSERT INTO `view_table3_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 1828192256, 166 ), ( 4031512576, 224 ) 18 Query /* thread_id=18 cnt=37 */ INSERT INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query /* thread_id=18 cnt=38 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` ( `col_char_12_key`, `col_int_key` ) VALUES ( 'z', 210 ), ( 97, 3768254464 ) 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=39 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `table1_innodb_int_autoinc` WHERE `pk` = 2647064576 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=40 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` ( `col_int`, `col_int_key` ) VALUES ( 3072524288, 'j' ), ( 9, 102432768 ) 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=41 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=42 */ REPLACE INTO `view_table2_innodb_int_autoinc` ( `pk`, `col_int_key` ) VALUES ( 809369600, 0 ), ( 9, 3829989376 ) 25 Query /* thread_id=25 cnt=40 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_int` IN ( 'f', 1540227072, 58, 13, 117 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 14 Query /* thread_id=14 cnt=28 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:39:28 12 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=27 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=55 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_int` ) VALUES ( 1509621760, 3732865024 ), ( 5, 1617625088 ) 150505 15:39:29 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=56 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:30 13 Query /* thread_id=13 cnt=72 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=57 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:39:31 19 Query /* thread_id=19 cnt=62 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` IN ( 'a', 4, 28, 92, 5 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=63 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=64 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:39:32 16 Query /* thread_id=16 cnt=39 */ INSERT INTO `table3_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 'o', 53 ), ( 1507000320, 163 ) 16 Query /* thread_id=16 cnt=40 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:33 16 Query /* thread_id=16 cnt=41 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=42 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:35 16 Query /* thread_id=16 cnt=43 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` IN ( 21889024, 'd', 3996057600, 6, 5 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query /* thread_id=15 cnt=132 */ INSERT INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=48 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` = 37 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:39:36 16 Query SHOW WARNINGS 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=49 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=44 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 3942318080, 3514040320, 6, 89, 'n' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query /* thread_id=15 cnt=133 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 24 Query /* thread_id=24 cnt=44 */ SET TRANSACTION ISOLATION LEVEL SERIALIZABLE 13 Query /* thread_id=13 cnt=73 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=29 */ INSERT INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 24 Query /* thread_id=24 cnt=45 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=74 */ INSERT INTO `view_table2_innodb_int_autoinc` ( `col_int`, `col_int_key` ) VALUES ( 2, 1278083072 ), ( 'z', 2574254080 ) 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=75 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` = 696713216 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=76 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=77 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=78 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 4 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:39:37 16 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=50 */ INSERT IGNORE INTO `table3_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 6, 7 ), ( 216924160, 8 ) 16 Query /* thread_id=16 cnt=45 */ START TRANSACTION 14 Query /* thread_id=14 cnt=30 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12` IN ( 'o', 'e', 739180544, 243, 178 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 16 Query /* thread_id=16 cnt=46 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=51 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_char_12_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 'a' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 11 Query /* thread_id=11 cnt=52 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `col_int` FROM `table0_innodb_int_autoinc` WHERE `pk` = 'k' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 24 Query /* thread_id=24 cnt=46 */ DELETE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:39:41 16 Query /* thread_id=16 cnt=47 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `col_int_key` FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 234 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query /* thread_id=15 cnt=134 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=48 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=49 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 91, 160, 323158016, 4, 218 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 16 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=50 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_int_key` FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 94 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:39:42 15 Query /* thread_id=15 cnt=135 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `pk` = 'l' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query /* thread_id=19 cnt=65 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=66 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:39:43 10 Query /* thread_id=10 cnt=58 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 9 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=136 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 7, 8 ), ( 1, 8 ) 15 Query /* thread_id=15 cnt=137 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 815661056, 3028877312 ), ( 3466067968, 5 ) 150505 15:39:45 15 Query /* thread_id=15 cnt=138 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=139 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 12 Query /* thread_id=12 cnt=28 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `pk`, `col_char_12` ) VALUES ( 238, 1 ), ( 4, 159 ) 19 Query /* thread_id=19 cnt=67 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( 148, 614006784, 4241948672, 'y', 126 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=38 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 162, 736034816 ), ( 324796416, 3502440448 ) 19 Query /* thread_id=19 cnt=68 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 4 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 19 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=41 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=69 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 't' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 22 Query /* thread_id=22 cnt=42 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=70 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 14 Query /* thread_id=14 cnt=31 */ INSERT INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=53 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int` BETWEEN 1 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 19 Query /* thread_id=19 cnt=71 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=72 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_int`, `col_int_key` ) VALUES ( 880672768, 'o' ), ( 3935305728, 177 ) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=73 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:39:46 16 Query /* thread_id=16 cnt=51 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `table1_innodb_int_autoinc` WHERE `pk` = 'p' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 16 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=52 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 17 Query SHOW WARNINGS 14 Query /* thread_id=14 cnt=32 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 17 Query /* thread_id=17 cnt=39 */ INSERT IGNORE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=140 */ INSERT IGNORE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:47 22 Query /* thread_id=22 cnt=43 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=141 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12` FROM `table1_innodb_int_autoinc` WHERE `pk` = 7 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 14 Query /* thread_id=14 cnt=33 */ INSERT IGNORE INTO `view_table1_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 'p', 7 ), ( 5, 'g' ) 17 Query /* thread_id=17 cnt=40 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=74 */ INSERT INTO `view_table2_innodb_int_autoinc` ( `col_char_12`, `col_char_12` ) VALUES ( 1077805056, 2 ), ( 987824128, 'b' ) 150505 15:39:48 14 Query SHOW WARNINGS 14 Query /* thread_id=14 cnt=34 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 16 Query /* thread_id=16 cnt=53 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `pk` BETWEEN 4 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 19 Query /* thread_id=19 cnt=75 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 16 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=76 */ INSERT INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=54 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=77 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=78 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12` BETWEEN 2 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 11 Query /* thread_id=11 cnt=54 */ COMMIT 19 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=142 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=55 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=79 */ DELETE FROM `table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 11 Query /* thread_id=11 cnt=56 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` = 551419904 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=80 */ INSERT INTO `view_table0_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12` ) VALUES ( 3343319040, 8 ), ( 2863529984, 31 ) 19 Query /* thread_id=19 cnt=81 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:39:49 11 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=143 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=57 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:39:50 15 Query /* thread_id=15 cnt=144 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12_key` = 'x' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:39:51 22 Query /* thread_id=22 cnt=44 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 1, 7, 5, 425787392, 8 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 22 Query SHOW WARNINGS 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=145 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 22 Query /* thread_id=22 cnt=45 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:39:52 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=146 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:39:53 16 Query /* thread_id=16 cnt=55 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 3704750080 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:39:54 15 Query /* thread_id=15 cnt=147 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `table3_innodb_int_autoinc` WHERE `pk` = 61 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query /* thread_id=19 cnt=82 */ SET AUTOCOMMIT=OFF 19 Query /* thread_id=19 cnt=83 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=84 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `pk` = 67 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=85 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` = 's' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=86 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=87 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12` IN ( SELECT `pk` FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 94 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 10 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=48 */ SET AUTOCOMMIT=OFF 18 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=49 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=59 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` IN ( 4, 4, 18, 'c', 3654549504 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 18 Query /* thread_id=18 cnt=43 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=44 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` = 'q' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=45 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` = 230 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=46 */ START TRANSACTION 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=60 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=41 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` = 'g' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 18 Query /* thread_id=18 cnt=47 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_int_key` FROM `view_table1_innodb_int_autoinc` WHERE `pk` = 3959095296 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:39:55 25 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=29 */ INSERT INTO `view_table2_innodb_int_autoinc` ( `col_char_12`, `col_char_12` ) VALUES ( 17, 0 ), ( 1196949504, 7 ) 25 Query /* thread_id=25 cnt=42 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 25 Query /* thread_id=25 cnt=43 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 2565865472, 4276092928, 9, 83, 102 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:39:56 25 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=30 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=44 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 17 Query /* thread_id=17 cnt=41 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 196, 'r' ), ( 3049848832, 85 ) 14 Query /* thread_id=14 cnt=35 */ DELETE FROM `view_table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:39:57 11 Query /* thread_id=11 cnt=58 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=88 */ DELETE FROM `table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=89 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_int`, `col_char_12_key` ) VALUES ( 9, 'd' ), ( 'a', 1 ) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=90 */ REPLACE INTO `view_table2_innodb_int_autoinc` ( `col_int`, `col_char_12_key` ) VALUES ( 'f', 4 ), ( 0, 171 ) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=91 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=92 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` = 253 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=93 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=59 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` IN ( 'g', 3, 'x', 2311651328, 241 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=60 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=79 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 2 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 13 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=61 */ START TRANSACTION 13 Query /* thread_id=13 cnt=80 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` = 124 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 11 Query /* thread_id=11 cnt=62 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=63 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 17 Query SHOW WARNINGS 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=45 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=42 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 7, 1 ), ( 2975596544, 2 ) 25 Query /* thread_id=25 cnt=46 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` IN ( 'j', 8, 3196715008, 'f', 74317824 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 17 Query /* thread_id=17 cnt=43 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `col_char_12` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 5 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:39:58 22 Query /* thread_id=22 cnt=46 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 22 Query SHOW WARNINGS 25 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=47 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` = 887095296 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 25 Query /* thread_id=25 cnt=47 */ INSERT INTO `view_table2_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 1, 'f' ), ( 2096562176, 8 ) 150505 15:39:59 25 Query SHOW WARNINGS 22 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=48 */ ROLLBACK 22 Query /* thread_id=22 cnt=48 */ INSERT INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 29, 227 ), ( 3853385728, 'p' ) 25 Query /* thread_id=25 cnt=49 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=50 */ REPLACE INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=61 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 't', 9 ), ( 3, 119 ) 10 Query /* thread_id=10 cnt=62 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12` BETWEEN 1 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:00 22 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=49 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 0, 'f', 'f', 6, 3 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 25 Query /* thread_id=25 cnt=51 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `pk` IN ( 1593180160, 'd', 'h', 'i', 6 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 12 Query /* thread_id=12 cnt=31 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:40:01 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=52 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:40:02 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=53 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 42, 1203634176 ), ( 6, 4237950976 ) 25 Query /* thread_id=25 cnt=54 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=55 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 's', 229, 's', 19, 25 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:40:03 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=56 */ INSERT INTO `table1_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 6, 'a' ), ( 'w', 1708523520 ) 23 Query /* thread_id=23 cnt=50 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=94 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 143, 8 ), ( 'b', 50 ) 19 Query /* thread_id=19 cnt=95 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `col_int_key`, `col_int` ) VALUES ( 3, 'w' ), ( 'j', 1525874688 ) 19 Query /* thread_id=19 cnt=96 */ INSERT IGNORE INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=97 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 1 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=98 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 656277504, 188 ), ( 'h', 1 ) 150505 15:40:04 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=99 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=100 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12` IN ( 3, 1063059456, 'a', 3038642176, 1016070144 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 20 Query /* thread_id=20 cnt=38 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=63 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `pk` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 'p' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 21 Query /* thread_id=21 cnt=31 */ DELETE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query /* thread_id=15 cnt=148 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12` ) VALUES ( 2101411840, 'v' ), ( 885522432, 2794258432 ) 22 Query /* thread_id=22 cnt=50 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `pk` IN ( SELECT `pk` FROM `table2_innodb_int_autoinc` WHERE `pk` = 'a' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 24 Query /* thread_id=24 cnt=47 */ ROLLBACK TO SAVEPOINT A 10 Query /* thread_id=10 cnt=64 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `pk` IN ( 2273640448, 8, 4, 'q', 31 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 24 Query /* thread_id=24 cnt=48 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_int_key` = 61 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 17 Query /* thread_id=17 cnt=44 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 3 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=101 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int_key` IN ( 4153016320, 3472359424, 225, 'f', 59 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=102 */ REPLACE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 19 Query /* thread_id=19 cnt=103 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `pk` BETWEEN 4 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=104 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 24 Query SHOW WARNINGS 22 Query SHOW WARNINGS 17 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=49 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( 9, 16, 't', 8, 192 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 22 Query /* thread_id=22 cnt=51 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_char_12`, `pk` ) VALUES ( 123, 0 ), ( 2829516800, 'y' ) 17 Query /* thread_id=17 cnt=45 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 1 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 25 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=149 */ INSERT INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 25 Query /* thread_id=25 cnt=57 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:40:05 17 Query SHOW WARNINGS 24 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=50 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `pk` BETWEEN 2 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 17 Query /* thread_id=17 cnt=46 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_char_12_key`, `col_int` ) VALUES ( 'i', 4 ), ( 1921646592, 2417885184 ) 17 Query /* thread_id=17 cnt=47 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 3 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:06 25 Query /* thread_id=25 cnt=58 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 24 Query SHOW WARNINGS 17 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=51 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 17 Query /* thread_id=17 cnt=48 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:40:07 17 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=49 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:40:08 23 Query /* thread_id=23 cnt=51 */ SET AUTOCOMMIT=OFF 23 Query /* thread_id=23 cnt=52 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12` = 62 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:13 19 Query /* thread_id=19 cnt=105 */ DELETE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 20 Query /* thread_id=20 cnt=39 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 7, 9 ), ( 6, 3787849728 ) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=106 */ COMMIT 24 Query /* thread_id=24 cnt=52 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=40 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 20 Query /* thread_id=20 cnt=41 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int` BETWEEN 3 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 10 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=64 */ INSERT INTO `table1_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 'w', 197 ), ( 2940862464, 31 ) 18 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=65 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=48 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=66 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=65 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=107 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query /* thread_id=18 cnt=49 */ REPLACE INTO `view_table2_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 17, 20 ), ( 'k', 0 ) 19 Query /* thread_id=19 cnt=108 */ DELETE FROM `table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 18 Query SHOW WARNINGS 19 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=50 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=109 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=110 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_int_key` FROM `table1_innodb_int_autoinc` WHERE `pk` = 't' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 19 Query /* thread_id=19 cnt=111 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 102 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=112 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `pk` IN ( 2470182912, 'u', 5, 'l', 'm' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=113 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 'r', 3, 4, 6, 0 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query /* thread_id=15 cnt=150 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_char_12_key`, `col_int` ) VALUES ( 7, 'd' ), ( 1842413568, 0 ) 22 Query SHOW WARNINGS 150505 15:40:14 20 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=32 */ DELETE FROM `view_table2_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 4 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 25 Query /* thread_id=25 cnt=59 */ DELETE FROM `view_table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 22 Query /* thread_id=22 cnt=52 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_int`, `col_char_12_key` ) VALUES ( 4082761728, 1527775232 ), ( 2639069184, 'f' ) 20 Query /* thread_id=20 cnt=42 */ DELETE FROM `table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=151 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:40:15 22 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=53 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `pk` IN ( SELECT `pk` FROM `table0_innodb_int_autoinc` WHERE `pk` = 2566979584 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 20 Query SHOW WARNINGS 20 Query /* thread_id=20 cnt=43 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:40:16 22 Query SHOW WARNINGS 22 Query /* thread_id=22 cnt=54 */ DELETE FROM `view_table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 17 Query /* thread_id=17 cnt=50 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `pk` IN ( 3233742848, 'g', 'd', 145, 'l' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:18 11 Query /* thread_id=11 cnt=66 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 1, 0, 3608150016, 5, 230 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 11 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=53 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=67 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=68 */ DELETE FROM `table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=69 */ ROLLBACK 150505 15:40:19 18 Query /* thread_id=18 cnt=51 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 2 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=52 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` = 'f' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=53 */ INSERT IGNORE INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query /* thread_id=18 cnt=54 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:40:21 10 Query /* thread_id=10 cnt=67 */ INSERT INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 10 Query /* thread_id=10 cnt=68 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 5, 768212992, 220, 3597271040, 1525415936 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 15 Query /* thread_id=15 cnt=152 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 15 Query /* thread_id=15 cnt=153 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `pk` IN ( SELECT `pk` FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 4 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:22 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=69 */ INSERT INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=55 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 'c' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 13 Query /* thread_id=13 cnt=81 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=56 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `pk` IN ( 5, 91, 8, 4, 6 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=57 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `pk` IN ( 6, 'x', 0, 'c', 'z' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 11 Query /* thread_id=11 cnt=70 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_int` IN ( SELECT `pk` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 96 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:23 10 Query /* thread_id=10 cnt=70 */ INSERT INTO `view_table2_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 3823042560, 1 ), ( 'y', 206 ) 24 Query /* thread_id=24 cnt=54 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 2 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:24 24 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=71 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `pk` BETWEEN 3 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 24 Query /* thread_id=24 cnt=55 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 'b', 2, 'm', 2, 'r' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 13 Query /* thread_id=13 cnt=82 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:40:25 24 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=56 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 'w', 98 ), ( 1063190528, 'd' ) 150505 15:40:26 24 Query SHOW WARNINGS 24 Query /* thread_id=24 cnt=57 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 1534263296, 67, 0, 2, 0 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:40:27 13 Query /* thread_id=13 cnt=83 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=84 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:40:28 13 Query /* thread_id=13 cnt=85 */ INSERT INTO `view_table0_innodb_int_autoinc` ( `col_int`, `col_char_12_key` ) VALUES ( 232, 2 ), ( 425918464, 653328384 ) 13 Query /* thread_id=13 cnt=86 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `col_char_12` = 9 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 16 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=154 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 2 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 16 Query /* thread_id=16 cnt=56 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 'k' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 16 Query SHOW WARNINGS 16 Query /* thread_id=16 cnt=57 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `pk` BETWEEN 4 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=155 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=156 */ INSERT INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=58 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 16 Query /* thread_id=16 cnt=59 */ ROLLBACK TO SAVEPOINT A 16 Query /* thread_id=16 cnt=60 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12` IN ( 2463039488, 'e', 3, 'a', 4096327680 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 13 Query /* thread_id=13 cnt=87 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_char_12_key` = 3784245248 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=88 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=89 */ START TRANSACTION 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=60 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` = 4 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 17 Query SHOW WARNINGS 17 Query /* thread_id=17 cnt=51 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12` BETWEEN 3 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=58 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `table3_innodb_int_autoinc` WHERE `pk` = 238 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=59 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 'u', 3 ), ( 'o', 251 ) 18 Query /* thread_id=18 cnt=60 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=157 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` = 194 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:29 25 Query SHOW WARNINGS 15 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=90 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 'q', 2342715392 ), ( 1126694912, 77 ) 25 Query /* thread_id=25 cnt=61 */ INSERT IGNORE INTO `view_table1_innodb_int_autoinc` ( `pk`, `col_int_key` ) VALUES ( 8, 's' ), ( 's', 121 ) 15 Query /* thread_id=15 cnt=158 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 971177984, 1982595072 ), ( 5, 'q' ) 15 Query /* thread_id=15 cnt=159 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_int` BETWEEN 1 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 13 Query /* thread_id=13 cnt=91 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `pk` IN ( SELECT `col_int_key` FROM `table2_innodb_int_autoinc` WHERE `pk` = 'y' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=92 */ INSERT IGNORE INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 3626172416, 157 ), ( 7, 1 ) 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=93 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 5, 372572160 ), ( 'd', 551223296 ) 13 Query /* thread_id=13 cnt=94 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_char_12`, `pk` ) VALUES ( 3504668672, 'g' ), ( 7, 'o' ) 18 Query /* thread_id=18 cnt=61 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=62 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12` ) VALUES ( 8, 1102708736 ), ( 28, 379387904 ) 18 Query /* thread_id=18 cnt=63 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:40:30 18 Query /* thread_id=18 cnt=64 */ DELETE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 1 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=65 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 195, 'n' ), ( 'e', 81 ) 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=66 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:40:31 18 Query /* thread_id=18 cnt=67 */ DELETE IGNORE FROM `table1_innodb_int_autoinc` WHERE `col_int_key` = 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=68 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=69 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 4221173760, 1217200128, 3084255232, 135, 216 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=70 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:40:33 18 Query /* thread_id=18 cnt=71 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `view_table0_innodb_int_autoinc` WHERE `pk` = 0 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=72 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` IN ( 1, 119, 'r', 1, 6 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=73 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=74 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=75 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:40:36 18 Query /* thread_id=18 cnt=76 */ INSERT IGNORE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=77 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `col_int_key` = 'v' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 18 Query SHOW WARNINGS 21 Query /* thread_id=21 cnt=32 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 8, 120 ), ( 3670540288, 6 ) 18 Query /* thread_id=18 cnt=78 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 0, 6 ), ( 0, 19 ) 21 Query /* thread_id=21 cnt=33 */ DELETE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `pk` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 2 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query /* thread_id=18 cnt=79 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 150505 15:40:37 12 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=33 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 2 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:40:38 18 Query /* thread_id=18 cnt=80 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=81 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 254, 'a', 'e', 6, 'r' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=82 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=83 */ INSERT IGNORE INTO `view_table0_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 3852337152, 0 ), ( 250, 1295777792 ) 150505 15:40:39 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=84 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 150505 15:40:41 18 Query /* thread_id=18 cnt=85 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 25 Query SHOW WARNINGS 14 Query /* thread_id=14 cnt=36 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 25 Query /* thread_id=25 cnt=62 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` ( `col_int`, `pk` ) VALUES ( 3, 1222836224 ), ( 153, 1818558464 ) 21 Query /* thread_id=21 cnt=34 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=53 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 21 Query /* thread_id=21 cnt=35 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:40:42 14 Query /* thread_id=14 cnt=37 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_char_12_key` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 2589851648 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=86 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query /* thread_id=18 cnt=87 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` WHERE `col_int_key` IN ( SELECT `col_int_key` FROM `table2_innodb_int_autoinc` WHERE `pk` = 134 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=88 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `col_int_key` IN ( 3654746112, 'd', 47, 4, 'o' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=89 */ DELETE IGNORE FROM `table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=90 */ DELETE FROM `view_table0_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 18 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=91 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query /* thread_id=18 cnt=92 */ SET AUTOCOMMIT=ON 14 Query SHOW WARNINGS 14 Query /* thread_id=14 cnt=38 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 14 Query /* thread_id=14 cnt=39 */ DELETE IGNORE FROM `table2_innodb_int_autoinc` WHERE `pk` = 2 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 14 Query SHOW WARNINGS 19 Query SHOW WARNINGS 13 Query SHOW WARNINGS 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=71 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 13 Query /* thread_id=13 cnt=95 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_int_key`, `col_char_12` ) VALUES ( 8, 104 ), ( 1, 1882456064 ) 19 Query /* thread_id=19 cnt=114 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `view_table2_innodb_int_autoinc` WHERE `pk` = 'g' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 14 Query /* thread_id=14 cnt=40 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( 824705024, 164, 3283550208, 'x', 'l' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 15 Query SHOW WARNINGS 19 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=160 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=115 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `pk`, `pk` ) VALUES ( 12, 3477995520 ), ( 167, 4 ) 13 Query /* thread_id=13 cnt=96 */ DELETE FROM `table1_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 12 Query SHOW WARNINGS 19 Query SHOW WARNINGS 13 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=34 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 3 AND 5 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query /* thread_id=19 cnt=116 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_char_12`, `col_char_12` ) VALUES ( 3, 1424031744 ), ( 737411072, 628817920 ) 15 Query /* thread_id=15 cnt=161 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=97 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 14 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=117 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_int_key` FROM `table1_innodb_int_autoinc` WHERE `pk` = 3499360256 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 13 Query /* thread_id=13 cnt=98 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 18 Query /* thread_id=18 cnt=93 */ INSERT IGNORE INTO `view_table0_innodb_int_autoinc` ( `col_int`, `col_char_12` ) VALUES ( 8, 2820276224 ), ( 1750335488, 9 ) 19 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=99 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 14 Query /* thread_id=14 cnt=41 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=118 */ INSERT INTO `view_table0_innodb_int_autoinc` ( `pk`, `col_char_12_key` ) VALUES ( 120, 277282816 ), ( 414908416, 86 ) 19 Query /* thread_id=19 cnt=119 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 150505 15:40:43 25 Query /* thread_id=25 cnt=63 */ DELETE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 21 Query /* thread_id=21 cnt=36 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_char_12_key`, `col_int` ) VALUES ( 3753443328, 3093102592 ), ( 1, 4 ) 12 Query SHOW WARNINGS 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=72 */ REPLACE INTO `view_table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 12 Query /* thread_id=12 cnt=35 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( 'p', 'q', 'i', 9, 231 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 10 Query /* thread_id=10 cnt=73 */ DELETE FROM `view_table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 21 Query SHOW WARNINGS 21 Query /* thread_id=21 cnt=37 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:40:44 25 Query SHOW WARNINGS 12 Query SHOW WARNINGS 18 Query /* thread_id=18 cnt=94 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=162 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 1403846656, 6 ), ( 4274782208, 'o' ) 12 Query /* thread_id=12 cnt=36 */ DELETE IGNORE FROM `table3_innodb_int_autoinc` WHERE `pk` IN ( 3760848896, 6, 1, 'r', 'd' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 25 Query /* thread_id=25 cnt=64 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` IN ( SELECT `pk` FROM `table2_innodb_int_autoinc` WHERE `pk` = 1486880768 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 21 Query /* thread_id=21 cnt=38 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 21 Query /* thread_id=21 cnt=39 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 150505 15:40:45 12 Query SHOW WARNINGS 12 Query /* thread_id=12 cnt=37 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 23 Query /* thread_id=23 cnt=54 */ INSERT INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 23 Query /* thread_id=23 cnt=55 */ INSERT INTO `table2_innodb_int_autoinc` ( `col_int_key`, `col_int` ) VALUES ( 2594308096, 3172401152 ), ( 'r', 3798663168 ) 23 Query SHOW WARNINGS 23 Query /* thread_id=23 cnt=56 */ INSERT IGNORE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 23 Query /* thread_id=23 cnt=57 */ REPLACE INTO `view_table1_innodb_int_autoinc` ( `pk`, `col_char_12` ) VALUES ( 5, 202 ), ( 8, 5 ) 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=163 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=164 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `pk` IN ( 'b', 'c', 5, 'f', 'k' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 150505 15:40:46 15 Query SHOW WARNINGS 15 Query /* thread_id=15 cnt=165 */ REPLACE INTO `table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:40:47 12 Query /* thread_id=12 cnt=38 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 15 Query /* thread_id=15 cnt=166 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:40:48 11 Query /* thread_id=11 cnt=72 */ REPLACE INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 150505 15:40:49 15 Query /* thread_id=15 cnt=167 */ DELETE IGNORE FROM `view_table0_innodb_int_autoinc` WHERE `col_char_12_key` = 236 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 11 Query /* thread_id=11 cnt=73 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `col_int_key` = 'r' ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:40:50 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=74 */ REPLACE INTO `view_table0_innodb_int_autoinc` ( `col_char_12`, `pk` ) VALUES ( 1, 'n' ), ( 5, 0 ) 19 Query /* thread_id=19 cnt=120 */ ROLLBACK 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=75 */ REPLACE INTO `view_table3_innodb_int_autoinc` ( `col_int_key`, `col_int_key` ) VALUES ( 'y', 149 ), ( 'w', 'w' ) 11 Query /* thread_id=11 cnt=76 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:40:52 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=77 */ INSERT INTO `view_table3_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 'h', 88 ), ( 'k', 1223884800 ) 11 Query /* thread_id=11 cnt=78 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `pk` = 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 150505 15:40:53 11 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=79 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 11 Query /* thread_id=11 cnt=80 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_char_12_key` = 12 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 12 Query /* thread_id=12 cnt=39 */ INSERT INTO `table3_innodb_int_autoinc` (`pk`) VALUES (NULL) 23 Query /* thread_id=23 cnt=58 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 19 Query /* thread_id=19 cnt=121 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_char_12`, `col_char_12_key` ) VALUES ( 12, 7 ), ( 'i', 211 ) 19 Query /* thread_id=19 cnt=122 */ REPLACE INTO `table3_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 367329280, 555548672 ), ( 85, 9 ) 19 Query /* thread_id=19 cnt=123 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12_key` BETWEEN 1 AND 7 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 11 Query SHOW WARNINGS 19 Query SHOW WARNINGS 25 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=124 */ INSERT INTO `table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 11 Query /* thread_id=11 cnt=81 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 'p', 'p' ), ( 'j', 8 ) 10 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=65 */ CREATE OR REPLACE TEMPORARY TABLE `table2_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 10 Query /* thread_id=10 cnt=74 */ INSERT IGNORE INTO `table2_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 29, 127 ), ( 7, 4011065344 ) 25 Query /* thread_id=25 cnt=66 */ COMMIT 19 Query /* thread_id=19 cnt=125 */ REPLACE INTO `table0_innodb_int_autoinc` ( `col_char_12_key`, `col_int_key` ) VALUES ( 'f', 104 ), ( 0, 2906980352 ) 25 Query /* thread_id=25 cnt=67 */ COMMIT 19 Query SHOW WARNINGS 11 Query /* thread_id=11 cnt=82 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 25 Query /* thread_id=25 cnt=68 */ DELETE FROM `table1_innodb_int_autoinc` WHERE `col_char_12_key` IN ( SELECT `col_char_12_key` FROM `table0_innodb_int_autoinc` WHERE `pk` = 85 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query /* thread_id=19 cnt=126 */ REPLACE INTO `table2_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 3872391168, 211 ), ( 'q', 472449024 ) 19 Query /* thread_id=19 cnt=127 */ REPLACE INTO `table1_innodb_int_autoinc` ( `col_int_key`, `col_char_12_key` ) VALUES ( 'n', 6 ), ( 'u', 1 ) 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=128 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` WHERE `col_char_12` BETWEEN 4 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 19 Query SHOW WARNINGS 19 Query /* thread_id=19 cnt=129 */ INSERT INTO `view_table3_innodb_int_autoinc` ( `col_int`, `col_int` ) VALUES ( 115, 0 ), ( 61, 4 ) 19 Query /* thread_id=19 cnt=130 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table2_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=40 */ INSERT INTO `table0_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 2654666752, 8 ), ( 409600000, 477495296 ) 150505 15:40:54 13 Query /* thread_id=13 cnt=100 */ REPLACE INTO `table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 21 Query /* thread_id=21 cnt=40 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_int_key` IN ( 5, 5, 8, 7, 'b' ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 13 Query /* thread_id=13 cnt=101 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 13 Query /* thread_id=13 cnt=102 */ INSERT INTO `view_table0_innodb_int_autoinc` ( `col_char_12`, `col_int_key` ) VALUES ( 47, 2394095616 ), ( 1, 'y' ) 13 Query SHOW WARNINGS 13 Query /* thread_id=13 cnt=103 */ ROLLBACK TO SAVEPOINT A 13 Query /* thread_id=13 cnt=104 */ DELETE IGNORE FROM `view_table1_innodb_int_autoinc` WHERE `col_char_12` IN ( 8, 0, 67, 5, 3338665984 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 14 Query /* thread_id=14 cnt=42 */ DELETE FROM `table2_innodb_int_autoinc` WHERE `col_int_key` IN ( 'j', 'i', 2966880256, 2876768256, 216 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 25 Query SHOW WARNINGS 14 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=69 */ DELETE FROM `table3_innodb_int_autoinc` WHERE `pk` IN ( 4, 'k', 9, 152, 3 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 14 Query /* thread_id=14 cnt=43 */ INSERT IGNORE INTO `table3_innodb_int_autoinc` ( `col_char_12`, `col_int` ) VALUES ( 's', 'b' ), ( 5, 567738368 ) 18 Query /* thread_id=18 cnt=95 */ CREATE OR REPLACE TEMPORARY TABLE `table0_innodb_int_autoinc` LIKE `table0_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=96 */ CREATE OR REPLACE TEMPORARY TABLE `table1_innodb_int_autoinc` LIKE `table1_innodb_int_autoinc` 18 Query /* thread_id=18 cnt=97 */ DELETE FROM `view_table3_innodb_int_autoinc` WHERE `pk` BETWEEN 1 AND 6 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:40:55 10 Query SHOW WARNINGS 10 Query /* thread_id=10 cnt=75 */ DELETE IGNORE FROM `view_table3_innodb_int_autoinc` ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 2 12 Query /* thread_id=12 cnt=41 */ CREATE OR REPLACE TEMPORARY TABLE `table3_innodb_int_autoinc` LIKE `table3_innodb_int_autoinc` 12 Query /* thread_id=12 cnt=42 */ REPLACE INTO `view_table0_innodb_int_autoinc` (`pk`) VALUES (NULL) 12 Query /* thread_id=12 cnt=43 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_int_key` BETWEEN 2 AND 8 ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 3 14 Query SHOW WARNINGS 14 Query /* thread_id=14 cnt=44 */ REPLACE INTO `view_table1_innodb_int_autoinc` (`pk`) VALUES (NULL) 14 Query /* thread_id=14 cnt=45 */ DELETE FROM `view_table0_innodb_int_autoinc` WHERE `col_int` IN ( 9, 248, 3332308992, 7, 2 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 4 150505 15:40:56 25 Query SHOW WARNINGS 25 Query /* thread_id=25 cnt=70 */ DELETE IGNORE FROM `view_table2_innodb_int_autoinc` WHERE `col_int_key` IN ( 5, 3093168128, 'a', 100, 2 ) ORDER BY `col_char_12`,`col_char_12_key`,`col_int`,`col_int_key`,`pk` LIMIT 1 150505 15:40:57 11 Query /* thread_id=11 cnt=83 */ INSERT INTO `table3_innodb_int_autoinc` ( `col_char_12_key`, `col_char_12_key` ) VALUES ( 'd', 'j' ), ( 'q', 6 ) 11 Query /* thread_id=11 cnt=84 */ INSERT IGNORE INTO `view_table2_innodb_int_autoinc` (`pk`) VALUES (NULL) 25 Query SHOW WARNINGS 25 Quit 150505 15:40:58 11 Quit 150505 15:40:59 19 Quit 23 Quit 150505 15:41:02 18 Query SHOW WARNINGS 20 Query SHOW WARNINGS 18 Quit 20 Quit 22 Query SHOW WARNINGS 10 Query SHOW WARNINGS 16 Query SHOW WARNINGS 10 Quit 16 Quit 22 Quit 150505 15:41:07 24 Query SHOW WARNINGS 21 Query SHOW WARNINGS 24 Quit 21 Quit 13 Query SHOW WARNINGS 13 Quit 150505 15:41:09 12 Quit 17 Query SHOW WARNINGS 17 Quit 15 Query SHOW WARNINGS 15 Quit 150505 15:41:10 14 Query SHOW WARNINGS 14 Quit 150505 15:41:11 26 Connect root@localhost as anonymous on test 26 Query SHOW SLAVE HOSTS 26 Query SHOW BINARY LOGS 150505 15:41:51 26 Quit 150505 15:41:52 3 Shutdown