## Env [umshastr@hod03]~/bugs: uname -an Linux hod03 3.8.13-98.2.2.el7uek.x86_64 #2 SMP Tue Sep 15 16:23:09 PDT 2015 x86_64 x86_64 x86_64 GNU/Linux [umshastr@hod03]~/bugs: uname -r 3.8.13-98.2.2.el7uek.x86_64 [umshastr@hod03]~/bugs: cat /etc/*release Oracle Linux Server release 7.1 NAME="Oracle Linux Server" VERSION="7.1" ID="ol" VERSION_ID="7.1" PRETTY_NAME="Oracle Linux Server 7.1" ANSI_COLOR="0;31" CPE_NAME="cpe:/o:oracle:linux:7:1" HOME_URL="https://linux.oracle.com/" BUG_REPORT_URL="https://bugzilla.oracle.com/" ORACLE_BUGZILLA_PRODUCT="Oracle Linux 7" ORACLE_BUGZILLA_PRODUCT_VERSION=7.1 ORACLE_SUPPORT_PRODUCT="Oracle Linux" ORACLE_SUPPORT_PRODUCT_VERSION=7.1 Red Hat Enterprise Linux Server release 7.1 (Maipo) Oracle Linux Server release 7.1 [umshastr@hod03]~/bugs: [umshastr@hod03]~/bugs: grep -c processor /proc/cpuinfo 32 [umshastr@hod03]~/bugs: free -g total used free shared buff/cache available Mem: 251 4 51 0 196 246 Swap: 7 0 7 [umshastr@hod03]~/bugs: ### Start up (initialized instance before every attempts) rm -rf 87827 bin/mysqld --defaults-file=./87827.cnf --initialize-insecure --basedir=$PWD --datadir=$PWD/87827 -v bin/mysqld --defaults-file=./87827.cnf --basedir=$PWD --datadir=$PWD/87827 --core-file --socket=/tmp/mysql_ushastry.sock --port=3306 --log-error=$PWD/87827/log.err 2>&1 & == 87827.cnf [mysqld] innodb_buffer_pool_size = 100G innodb_io_capacity=20000 innodb_flush_log_at_trx_commit = 0 innodb_log_file_size = 2G innodb_flush_method=O_DIRECT_NO_FSYNC skip-log-bin == 5.7.19 == 8.0.0 [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.0: cat docs/INFO_SRC commit: f6b5010bafd3f8d25091258e606353bdded22ff4 date: 2016-08-25 14:05:26 +0200 build-date: 2016-08-25 14:32:40 +0200 short: f6b5010 branch: mysql-8.0.0-dmr-release MySQL source 8.0.0 ----- Single (1) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.0: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.01 sec) Bye real 0m45.367s user 0m8.258s sys 0m13.952s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.0: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 10063 | +--------------------+-------+ (2) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.0: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.02 sec) Bye real 0m47.219s user 0m7.880s sys 0m14.483s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.0: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 10073 | +--------------------+-------+ ----- parallel (1) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.0: time ./install_on_mysql_8_0_parallel.sh . . real 26m45.229s user 13m12.583s sys 27m25.466s (2) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.0: time real 0m0.000s user 0m0.000s sys 0m0.000s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.0: time ./install_on_mysql_8_0_parallel.sh . Bye real 27m14.986s user 13m1.081s sys 27m44.835s == 8.0.1 [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: cat docs/INFO_SRC commit: 69ffe6a6a2083eff81307ddc3651a1b0c51fb92c date: 2017-03-23 05:26:01 +0100 build-date: 2017-03-23 05:52:29 +0100 short: 69ffe6a branch: mysql-8.0.1-dmr-release MySQL source 8.0.1 ----- Single (1) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.01 sec) Bye real 0m44.536s user 0m8.288s sys 0m13.844s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 10069 | +--------------------+-------+ (2) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.00 sec) Bye real 0m47.808s user 0m7.643s sys 0m14.474s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 10069 | +--------------------+-------+ ----- parallel (1) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: time ./install_on_mysql_8_0_parallel.sh . . Bye real 22m54.841s user 15m41.469s sys 36m1.278s (2) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.1: time ./install_on_mysql_8_0_parallel.sh . . Bye real 22m31.339s user 15m36.418s sys 35m43.708s == 8.0.2 cat docs/INFO_SRC commit: 88d44cf92038947d40b7af4dc27295ccb611d0fc date: 2017-06-27 13:00:43 +0200 build-date: 2017-06-27 13:44:43 +0200 short: 88d44cf branch: mysql-8.0.2-dmr-release MySQL source 8.0.2 ----- Single (1) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.2: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.00 sec) Bye real 0m53.190s user 0m8.045s sys 0m14.088s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.2: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 10080 | +--------------------+-------+ (2) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.2: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.00 sec) Bye real 0m52.128s user 0m8.164s sys 0m13.947s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.2: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 10080 | +--------------------+-------+ ----- parallel (1) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.2: time ./install_on_mysql_8_0_parallel.sh . Bye real 22m14.186s user 14m52.408s sys 32m57.203s (2) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.2: time ./install_on_mysql_8_0_parallel.sh . . Bye real 22m41.475s user 15m56.255s sys 35m30.541s == 8.0.3 [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: cat docs/INFO_SRC commit: a9da615e9ff5b0cfa096e7694e423c103f230394 date: 2017-09-19 12:22:09 +0200 build-date: 2017-09-19 13:34:04 +0200 short: a9da615 branch: mysql-8.0.3-rc-release MySQL source 8.0.3 ----- Single (1) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.01 sec) Bye real 1m6.944s user 0m7.823s sys 0m14.454s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 30101 | +--------------------+-------+ (2) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.01 sec) Bye real 1m6.363s user 0m7.738s sys 0m14.459s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 30101 | +--------------------+-------+ ----- parallel (1) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: time ./install_on_mysql_8_0_parallel.sh . . Bye real 30m51.849s user 14m50.727s sys 30m19.727s (2) [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: time ./install_on_mysql_8_0_parallel.sh . . Bye real 31m14.437s user 14m51.015s sys 30m5.974s ## 8.0.3 [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-8.0.3: bin/mysql -uroot -S /tmp/mysql_ushastry.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 258304 Server version: 8.0.3-rc MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. root@localhost [(none)]> show engine innodb status\G root@localhost [(none)]> show engine innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2017-09-22 12:29:18 0x7eff342c2700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 13 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 444 srv_active, 0 srv_shutdown, 16 srv_idle srv_master_thread log flush and writes: 460 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 43041263 --Thread 139639926392576 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637243750144 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639928137472 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634555033344 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637240260352 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639924647680 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645157795584 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631873586944 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639929300736 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634558523136 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639927555840 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637244622592 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634558813952 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645159249664 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639927846656 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639925229312 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637239097088 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639924938496 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637244040960 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631875622656 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634556487424 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645158958848 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645158377216 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631871551232 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637244331776 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645161723648 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637239969536 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639927265024 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639928719104 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631872423680 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634555905792 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634557941504 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645162886912 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139642474043136 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631875913472 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637242005248 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139642473752320 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631874750208 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637243168512 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645162305280 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639929009920 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637241714432 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637239678720 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637241132800 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634559395584 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631872132864 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639928428288 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645162596096 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637241423616 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631870678784 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631875041024 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639924066048 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631870387968 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634556778240 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634559686400 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637240841984 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631870969600 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631872714496 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639923193600 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637242877696 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645158086400 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639925520128 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634559104768 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139642474624768 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637242586880 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639924356864 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631874459392 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634555324160 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631874168576 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139642473461504 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631873005312 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634556196608 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139642474333952 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631873877760 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645158668032 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139634559977216 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139642474915584 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631873296128 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639923484416 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139645162014464 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139531244963584 has waited at dict0dict.cc line 535 for 0.00 seconds the semaphore: Mutex at 0x7ee80d022218, Mutex DICT_SYS created dict0dict.cc:1090, lock var 0 --Thread 139639923775232 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637239387904 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631875331840 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631871260416 has waited at dict0stats.cc line 2268 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637242296064 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139637240551168 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139631871842048 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 number of readers 0, waiters flag 0, lock_word: 20000000 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/handler/ha_innodb.cc line 13259 --Thread 139639926683392 has waited at ha_innodb.cc line 13259 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x7ee80d023538 created in file dict0dict.cc line 1101 a writer (thread id 139637243459328) has reserved it in mode exclusive number of readers 0, waiters flag 0, lock_word: 0 Last time read locked in file not yet reserved line 0 Last time write locked in file ../../../mysql-8.0.3-rc/storage/innobase/dict/dict0stats.cc line 2268 OS WAIT ARRAY INFO: signal count 1625685 RW-shared spins 616388, rounds 788242, OS waits 175575 RW-excl spins 1040672, rounds 1247830331, OS waits 41372838 RW-sx spins 40400, rounds 1102099, OS waits 30706 Spin rounds per wait: 1.28 RW-shared, 1199.06 RW-excl, 27.28 RW-sx ------------ TRANSACTIONS ------------ Trx id counter 2049503 Purge done for trx's n:o < 2049493 undo n:o < 17 state: running History list length 18 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 421122859503840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 421122859490960, not started flushing log 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 2049502, ACTIVE 0 sec 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 2049499, ACTIVE 0 sec inserting mysql tables in use 12, locked 12 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 5 MySQL thread id 259938, OS thread handle 139634557359872, query id 779697 localhost root creating table CREATE TABLE sbtest43 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2562 ---TRANSACTION 2049497, ACTIVE 0 sec inserting mysql tables in use 12, locked 12 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 9 MySQL thread id 259937, OS thread handle 139639926101760, query id 779695 localhost root creating table CREATE TABLE sbtest39 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2509 ---TRANSACTION 2049494, ACTIVE 0 sec inserting mysql tables in use 12, locked 12 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 15 MySQL thread id 259936, OS thread handle 139639925810944, query id 779693 localhost root creating table CREATE TABLE sbtest48 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2533 ---TRANSACTION 2049483, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259935, OS thread handle 139631874459392, query id 779690 localhost root creating table CREATE TABLE sbtest52 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2527 ---TRANSACTION 2049480, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259934, OS thread handle 139634559977216, query id 779688 localhost root creating table CREATE TABLE sbtest47 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2507 ---TRANSACTION 2049477, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259933, OS thread handle 139631875913472, query id 779685 localhost root creating table CREATE TABLE sbtest39 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2598 ---TRANSACTION 2049475, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259932, OS thread handle 139639927555840, query id 779683 localhost root creating table CREATE TABLE sbtest45 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2587 ---TRANSACTION 2049472, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259931, OS thread handle 139631872132864, query id 779680 localhost root creating table CREATE TABLE sbtest51 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2560 ---TRANSACTION 2049457, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259930, OS thread handle 139637239097088, query id 779676 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2558 ---TRANSACTION 2049449, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259929, OS thread handle 139631873586944, query id 779672 localhost root creating table CREATE TABLE sbtest45 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2519 ---TRANSACTION 2049443, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259928, OS thread handle 139634558813952, query id 779668 localhost root creating table CREATE TABLE sbtest37 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2583 ---TRANSACTION 2049438, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259927, OS thread handle 139639924938496, query id 779666 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2592 ---TRANSACTION 2049434, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259926, OS thread handle 139631875041024, query id 779664 localhost root creating table CREATE TABLE sbtest55 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2586 ---TRANSACTION 2049426, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259925, OS thread handle 139634555324160, query id 779661 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2516 ---TRANSACTION 2049425, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259924, OS thread handle 139645157795584, query id 779660 localhost root creating table CREATE TABLE sbtest38 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2518 ---TRANSACTION 2049416, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259923, OS thread handle 139639923775232, query id 779655 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2569 ---TRANSACTION 2049403, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259922, OS thread handle 139631875331840, query id 779651 localhost root creating table CREATE TABLE sbtest45 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2577 ---TRANSACTION 2049381, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259921, OS thread handle 139645161723648, query id 779646 localhost root creating table CREATE TABLE sbtest51 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2544 ---TRANSACTION 2049368, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259920, OS thread handle 139637240841984, query id 779643 localhost root creating table CREATE TABLE sbtest54 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2517 ---TRANSACTION 2049366, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259919, OS thread handle 139634557941504, query id 779641 localhost root creating table CREATE TABLE sbtest51 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2559 ---TRANSACTION 2049361, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259918, OS thread handle 139645158377216, query id 779638 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2534 ---TRANSACTION 2049349, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259916, OS thread handle 139631874168576, query id 779635 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2506 ---TRANSACTION 2049336, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259915, OS thread handle 139639924356864, query id 779629 localhost root creating table CREATE TABLE sbtest50 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2548 ---TRANSACTION 2049329, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259914, OS thread handle 139637243750144, query id 779626 localhost root creating table CREATE TABLE sbtest50 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2580 ---TRANSACTION 2049328, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259913, OS thread handle 139634558523136, query id 779625 localhost root creating table CREATE TABLE sbtest47 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2579 ---TRANSACTION 2049314, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259912, OS thread handle 139637244040960, query id 779621 localhost root creating table CREATE TABLE sbtest43 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2574 ---TRANSACTION 2049311, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259911, OS thread handle 139631872423680, query id 779618 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2585 ---TRANSACTION 2049309, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259910, OS thread handle 139645158086400, query id 779617 localhost root creating table CREATE TABLE sbtest44 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2531 ---TRANSACTION 2049308, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259909, OS thread handle 139639928137472, query id 779614 localhost root creating table CREATE TABLE sbtest48 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2554 ---TRANSACTION 2049300, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259908, OS thread handle 139631873296128, query id 779610 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2553 ---TRANSACTION 2049291, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259907, OS thread handle 139639927846656, query id 779608 localhost root creating table CREATE TABLE sbtest54 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2551 ---TRANSACTION 2049289, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259906, OS thread handle 139642474333952, query id 779607 localhost root creating table CREATE TABLE sbtest50 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2521 ---TRANSACTION 2049287, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259905, OS thread handle 139637243168512, query id 779603 localhost root creating table CREATE TABLE sbtest55 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2515 ---TRANSACTION 2049255, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259904, OS thread handle 139639926683392, query id 779594 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2549 ---TRANSACTION 2049250, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259903, OS thread handle 139631871842048, query id 779592 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2525 ---TRANSACTION 2049237, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259902, OS thread handle 139637244622592, query id 779589 localhost root creating table CREATE TABLE sbtest44 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2575 ---TRANSACTION 2049235, ACTIVE 0 sec 9 lock struct(s), heap size 1136, 17 row lock(s), undo log entries 38 MySQL thread id 259901, OS thread handle 139629191268096, query id 779586 localhost root After create CREATE TABLE sbtest45 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2590 Trx read view will not see trx with id >= 2049497, sees < 2047178 ---TRANSACTION 2049231, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259899, OS thread handle 139631873877760, query id 779583 localhost root creating table CREATE TABLE sbtest48 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2564 ---TRANSACTION 2049230, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259900, OS thread handle 139637243459328, query id 779584 localhost root creating table CREATE TABLE sbtest42 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2513 ---TRANSACTION 2049219, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259898, OS thread handle 139639929009920, query id 779580 localhost root creating table CREATE TABLE sbtest48 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2561 ---TRANSACTION 2049215, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259897, OS thread handle 139634559686400, query id 779577 localhost root creating table CREATE TABLE sbtest53 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2529 ---TRANSACTION 2049211, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259895, OS thread handle 139639928719104, query id 779572 localhost root creating table CREATE TABLE sbtest53 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2541 ---TRANSACTION 2049206, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259894, OS thread handle 139637241714432, query id 779569 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2545 ---TRANSACTION 2049185, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259891, OS thread handle 139645158668032, query id 779561 localhost root creating table CREATE TABLE sbtest52 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2572 ---TRANSACTION 2049167, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259889, OS thread handle 139637242296064, query id 779552 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2597 ---TRANSACTION 2049149, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259888, OS thread handle 139642473461504, query id 779548 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2576 ---TRANSACTION 2049143, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259887, OS thread handle 139634555033344, query id 779545 localhost root creating table CREATE TABLE sbtest35 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2520 ---TRANSACTION 2049117, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259886, OS thread handle 139645159249664, query id 779540 localhost root creating table CREATE TABLE sbtest53 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2581 ---TRANSACTION 2049112, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259885, OS thread handle 139637242005248, query id 779538 localhost root creating table CREATE TABLE sbtest41 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2596 ---TRANSACTION 2049102, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259884, OS thread handle 139639924647680, query id 779536 localhost root creating table CREATE TABLE sbtest42 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2563 ---TRANSACTION 2049096, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259883, OS thread handle 139645162014464, query id 779533 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2530 ---TRANSACTION 2049090, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259882, OS thread handle 139634556778240, query id 779530 localhost root creating table CREATE TABLE sbtest50 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2526 ---TRANSACTION 2049086, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259881, OS thread handle 139637242586880, query id 779528 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2546 ---TRANSACTION 2049072, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259879, OS thread handle 139645162886912, query id 779522 localhost root creating table CREATE TABLE sbtest51 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2539 ---TRANSACTION 2049051, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259877, OS thread handle 139645162305280, query id 779515 localhost root creating table CREATE TABLE sbtest47 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2550 ---TRANSACTION 2049030, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259874, OS thread handle 139634556487424, query id 779506 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2547 ---TRANSACTION 2049021, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259872, OS thread handle 139631871551232, query id 779500 localhost root creating table CREATE TABLE sbtest51 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2566 ---TRANSACTION 2048998, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259870, OS thread handle 139637239969536, query id 779494 localhost root creating table CREATE TABLE sbtest41 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2589 ---TRANSACTION 2048985, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259869, OS thread handle 139645158958848, query id 779491 localhost root creating table CREATE TABLE sbtest51 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2591 ---TRANSACTION 2048944, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259864, OS thread handle 139639926392576, query id 779478 localhost root creating table CREATE TABLE sbtest58 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2573 ---TRANSACTION 2048928, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259863, OS thread handle 139637239678720, query id 779472 localhost root creating table CREATE TABLE sbtest55 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2552 ---TRANSACTION 2048917, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259861, OS thread handle 139642474624768, query id 779467 localhost root creating table CREATE TABLE sbtest50 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2535 ---TRANSACTION 2048887, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259859, OS thread handle 139642474043136, query id 779460 localhost root creating table CREATE TABLE sbtest50 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2528 ---TRANSACTION 2048880, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259857, OS thread handle 139639924066048, query id 779455 localhost root creating table CREATE TABLE sbtest54 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2512 ---TRANSACTION 2048871, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259855, OS thread handle 139642473752320, query id 779451 localhost root creating table CREATE TABLE sbtest50 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2594 ---TRANSACTION 2048866, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259854, OS thread handle 139639928428288, query id 779449 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2578 ---TRANSACTION 2048849, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259852, OS thread handle 139637241132800, query id 779440 localhost root creating table CREATE TABLE sbtest42 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2599 ---TRANSACTION 2048846, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259851, OS thread handle 139639927265024, query id 779438 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2532 ---TRANSACTION 2048812, ACTIVE 0 sec mysql tables in use 13, locked 12 8 lock struct(s), heap size 1136, 17 row lock(s), undo log entries 37 MySQL thread id 259849, OS thread handle 139634554742528, query id 779430 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2588 ---TRANSACTION 2048811, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259848, OS thread handle 139637241423616, query id 779428 localhost root creating table CREATE TABLE sbtest48 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2555 ---TRANSACTION 2048809, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259846, OS thread handle 139634555905792, query id 779423 localhost root creating table CREATE TABLE sbtest48 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2510 ---TRANSACTION 2048792, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259844, OS thread handle 139631873005312, query id 779417 localhost root creating table CREATE TABLE sbtest45 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2503 ---TRANSACTION 2048765, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259842, OS thread handle 139631875622656, query id 779409 localhost root creating table CREATE TABLE sbtest58 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2540 ---TRANSACTION 2048748, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259840, OS thread handle 139634556196608, query id 779405 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2570 ---TRANSACTION 2048744, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259839, OS thread handle 139637242877696, query id 779401 localhost root creating table CREATE TABLE sbtest53 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2505 ---TRANSACTION 2048731, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259837, OS thread handle 139631870678784, query id 779395 localhost root creating table CREATE TABLE sbtest44 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2537 ---TRANSACTION 2048721, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259836, OS thread handle 139639923484416, query id 779392 localhost root creating table CREATE TABLE sbtest38 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2501 ---TRANSACTION 2048690, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259833, OS thread handle 139639923193600, query id 779382 localhost root creating table CREATE TABLE sbtest52 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2523 ---TRANSACTION 2048640, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259828, OS thread handle 139634559395584, query id 779367 localhost root creating table CREATE TABLE sbtest41 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2556 ---TRANSACTION 2048609, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259825, OS thread handle 139634559104768, query id 779359 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2538 ---TRANSACTION 2048592, ACTIVE 0 sec starting index read mysql tables in use 12, locked 12 7 lock struct(s), heap size 1136, 8 row lock(s), undo log entries 28 MySQL thread id 259823, OS thread handle 139629191558912, query id 779356 localhost root creating table CREATE TABLE sbtest47 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2543 ---TRANSACTION 2048562, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259817, OS thread handle 139637244331776, query id 779337 localhost root creating table CREATE TABLE sbtest51 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2593 ---TRANSACTION 2048507, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259812, OS thread handle 139631871260416, query id 779321 localhost root creating table CREATE TABLE sbtest44 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2504 ---TRANSACTION 2048396, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259801, OS thread handle 139634555614976, query id 779286 localhost root creating table CREATE TABLE sbtest43 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2502 ---TRANSACTION 2048366, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259796, OS thread handle 139631872714496, query id 779273 localhost root creating table CREATE TABLE sbtest41 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2600 ---TRANSACTION 2048295, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259786, OS thread handle 139631870969600, query id 779240 localhost root creating table CREATE TABLE sbtest49 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2557 ---TRANSACTION 2048256, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259782, OS thread handle 139639925520128, query id 779228 localhost root creating table CREATE TABLE sbtest44 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2584 ---TRANSACTION 2048245, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259779, OS thread handle 139645162596096, query id 779219 localhost root creating table CREATE TABLE sbtest50 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2508 ---TRANSACTION 2048215, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259772, OS thread handle 139639925229312, query id 779202 localhost root creating table CREATE TABLE sbtest42 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2568 ---TRANSACTION 2048126, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259763, OS thread handle 139639929300736, query id 779172 localhost root creating table CREATE TABLE sbtest44 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2571 ---TRANSACTION 2048062, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259757, OS thread handle 139631874750208, query id 779153 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2536 ---TRANSACTION 2047873, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259734, OS thread handle 139634558232320, query id 779085 localhost root creating table CREATE TABLE sbtest52 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2511 ---TRANSACTION 2047593, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259699, OS thread handle 139637240551168, query id 778981 localhost root creating table CREATE TABLE sbtest45 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2542 ---TRANSACTION 2047565, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259695, OS thread handle 139631870387968, query id 778970 localhost root creating table CREATE TABLE sbtest46 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2595 ---TRANSACTION 2047460, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 20 MySQL thread id 259684, OS thread handle 139637239387904, query id 778937 localhost root creating table CREATE TABLE sbtest45 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2582 ---TRANSACTION 2047415, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259676, OS thread handle 139637240260352, query id 778914 localhost root creating table CREATE TABLE sbtest45 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2567 ---TRANSACTION 2047178, ACTIVE 0 sec 4 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 17 MySQL thread id 259646, OS thread handle 139642474915584, query id 778823 localhost root creating table CREATE TABLE sbtest37 ( id int(10) unsigned NOT NULL AUTO_INCREMENT, k int(10) unsigned NOT NULL DEFAULT '0', c varchar(120) NOT NULL DEFAULT '', pad varchar(60) NOT NULL DEFAULT '', PRIMARY KEY (id), KEY k_1 (k) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 tablespace test_sbtest_2514 -------- FILE I/O -------- I/O thread 0 state: waiting for completed aio requests (insert buffer thread) I/O thread 1 state: waiting for completed aio requests (log thread) I/O thread 2 state: waiting for completed aio requests (read thread) I/O thread 3 state: waiting for completed aio requests (read thread) I/O thread 4 state: waiting for completed aio requests (read thread) I/O thread 5 state: waiting for completed aio requests (read thread) I/O thread 6 state: waiting for completed aio requests (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 1016 OS file reads, 1817276 OS file writes, 1005991 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 4084.76 writes/s, 2058.61 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 0, seg size 2, 0 merges merged operations: insert 0, delete mark 0, delete 0 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 26562343, node heap has 4 buffer(s) Hash table size 26562343, node heap has 1 buffer(s) Hash table size 26562343, node heap has 5 buffer(s) Hash table size 26562343, node heap has 5 buffer(s) Hash table size 26562343, node heap has 5 buffer(s) Hash table size 26562343, node heap has 31 buffer(s) Hash table size 26562343, node heap has 5 buffer(s) Hash table size 26562343, node heap has 3 buffer(s) 14246.13 hash searches/s, 70367.43 non-hash searches/s --- LOG --- Log sequence number 4926850988 Log flushed up to 4926848285 Pages flushed up to 4534106812 Last checkpoint at 4467481432 0 pending log flushes, 0 pending chkp writes 1000771 log i/o's done, 2043.23 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 109943193600 Dictionary memory allocated 288516891 Buffer pool size 6553580 Free buffers 5903995 Database pages 649525 Old database pages 239601 Modified db pages 49742 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 10, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 997, created 648528, written 620581 0.00 reads/s, 1329.51 creates/s, 1479.89 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 649525, unzip_LRU len: 0 I/O sum[0]:cur[11968], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 819200 Free buffers 737626 Database pages 81567 Old database pages 30089 Modified db pages 6775 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 224, created 81343, written 77556 0.00 reads/s, 179.22 creates/s, 184.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81567, unzip_LRU len: 0 I/O sum[0]:cur[1496], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 819200 Free buffers 738055 Database pages 81134 Old database pages 29929 Modified db pages 6350 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 185, created 80949, written 77560 0.00 reads/s, 172.60 creates/s, 184.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81134, unzip_LRU len: 0 I/O sum[0]:cur[1496], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 819192 Free buffers 738092 Database pages 81090 Old database pages 29913 Modified db pages 6333 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 104, created 80986, written 77553 0.00 reads/s, 159.22 creates/s, 184.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81090, unzip_LRU len: 0 I/O sum[0]:cur[1496], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 819200 Free buffers 737975 Database pages 81221 Old database pages 29961 Modified db pages 6249 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 16, created 81205, written 77554 0.00 reads/s, 165.37 creates/s, 184.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81221, unzip_LRU len: 0 I/O sum[0]:cur[1496], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 819200 Free buffers 738089 Database pages 81103 Old database pages 29918 Modified db pages 5986 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 17, created 81086, written 77553 0.00 reads/s, 154.60 creates/s, 184.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81103, unzip_LRU len: 0 I/O sum[0]:cur[1496], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 819189 Free buffers 737950 Database pages 81232 Old database pages 29966 Modified db pages 5501 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 2, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 31, created 81201, written 77614 0.00 reads/s, 165.60 creates/s, 184.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81232, unzip_LRU len: 0 I/O sum[0]:cur[1496], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 819200 Free buffers 738083 Database pages 81112 Old database pages 29921 Modified db pages 5977 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 4, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 184, created 80928, written 77628 0.00 reads/s, 169.14 creates/s, 184.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81112, unzip_LRU len: 0 I/O sum[0]:cur[1496], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 819199 Free buffers 738125 Database pages 81066 Old database pages 29904 Modified db pages 6571 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 236, created 80830, written 77563 0.00 reads/s, 163.76 creates/s, 184.99 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 81066, unzip_LRU len: 0 I/O sum[0]:cur[1496], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 2 read views open inside InnoDB Process ID=8775, Main thread ID=139531276433152 , state=sleeping Number of rows inserted 4598276, updated 4334316, deleted 0, read 8165592 9364.90 inserts/s, 8827.01 updates/s, 0.00 deletes/s, 16622.64 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) root@localhost [(none)]> ## 5.7.19 [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-5.7.19: cat docs/INFO_SRC commit: 432d360adedd7d8976fd6254eb3f5bee0b1ac3d6 date: 2017-06-22 16:12:22 +0200 build-date: 2017-06-22 16:13:32 +0200 short: 432d360 branch: mysql-5.7.19-release MySQL source 5.7.19 [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-5.7.19: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.00 sec) Bye real 0m40.742s user 0m7.846s sys 0m14.293s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-5.7.19: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 10055 | +--------------------+-------+ [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-5.7.19: [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-5.7.19: time ./install_on_mysql_8_0_single.sh -------------- create database if not exists test -------------- Query OK, 1 row affected (0.00 sec) Bye real 0m40.734s user 0m7.939s sys 0m14.302s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-5.7.19: bin/mysql -uroot -S /tmp/mysql_ushastry.sock -e "show status like 'Innodb_data_fsyncs'" +--------------------+-------+ | Variable_name | Value | +--------------------+-------+ | Innodb_data_fsyncs | 10063 | +--------------------+-------+ -- parallel [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-5.7.19: time ./install_on_mysql_8_0_parallel.sh real 22m24.097s user 12m49.629s sys 29m36.289s [umshastr@hod03]/export/umesh/server/binaries/Trunk/87827/mysql-5.7.19: time ./install_on_mysql_8_0_parallel.sh . . Bye real 22m4.389s user 12m46.055s sys 29m48.036s