2016-11-16 6:20:34 70366877476688 [Note] build/sql/mysqld (mysqld 10.2.3-MariaDB-log) starting as process 76284 ... 2016-11-16 6:20:34 70366877476688 [Note] Plugin 'SEQUENCE' is disabled. 2016-11-16 6:20:34 70366877476688 [Note] Plugin 'partition' is disabled. 2016-11-16 6:20:34 70366877476688 [Note] InnoDB: PUNCH HOLE support available 2016-11-16 6:20:34 70366877476688 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2016-11-16 6:20:34 70366877476688 [Note] InnoDB: Uses event mutexes 2016-11-16 6:20:34 70366877476688 [Note] InnoDB: Compressed tables use zlib 1.2.3 2016-11-16 6:20:34 70366877476688 [Note] InnoDB: Using Linux native AIO 2016-11-16 6:20:34 70366877476688 [Note] InnoDB: Number of pools: 1 2016-11-16 6:20:34 70366877476688 [Note] InnoDB: Using POWER8 crc32 instructions 2016-11-16 6:20:34 70366877476688 [Note] InnoDB: Initializing buffer pool, total size = 28G, instances = 32, chunk size = 128M 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: Completed initialization of buffer pool 2016-11-16 6:20:35 70334279250272 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2016-11-16 6:20:35 70366877476688 [Warning] InnoDB: Failed to set O_DIRECT on file./ibdata1;OPEN: Invalid argument, ccontinuing anyway. O_DIRECT is known to result in 'Invalid argument' on Linux on tmpfs, see MySQL Bug#26662. 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: Tablespace ID 0 name innodb_system:Default tablespace encryption mode scheme unencrypted 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: Highest supported file format is Barracuda. 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: Creating shared tablespace for temporary tables 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: Tablespace ID 7 name innodb_temporary:Default tablespace encryption mode scheme unencrypted 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: 32 non-redo rollback segment(s) are active. 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: Waiting for purge to start 2016-11-16 6:20:35 70366877476688 [Note] InnoDB: 5.7.14 started; log sequence number 6984717729 2016-11-16 6:20:35 70334904529248 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_auto_dQFW/mysqld.1/data/ib_buffer_pool 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_LOCKS' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_CMP' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_TRX' is disabled. 2016-11-16 6:20:35 70334904529248 [Note] InnoDB: Buffer pool(s) load completed at 161116 6:20:35 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'FEEDBACK' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_TEMP_TABLE_INFO' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_TABLES' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_METRICS' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_CMPMEM' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled. 2016-11-16 6:20:35 70366877476688 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled. 2016-11-16 6:20:35 70366877476688 [Warning] build/sql/mysqld: unknown variable 'loose-feedback-debug-startup-interval=20' 2016-11-16 6:20:35 70366877476688 [Warning] build/sql/mysqld: unknown variable 'loose-feedback-debug-first-interval=60' 2016-11-16 6:20:35 70366877476688 [Warning] build/sql/mysqld: unknown variable 'loose-feedback-debug-interval=60' 2016-11-16 6:20:35 70366877476688 [Warning] build/sql/mysqld: unknown option '--loose-pam-debug' 2016-11-16 6:20:35 70366877476688 [Warning] build/sql/mysqld: unknown variable 'loose-debug-sync-timeout=300' 2016-11-16 6:20:35 70366877476688 [Note] Server socket created on IP: '127.0.0.1'. 2016-11-16 6:20:35 70366877476688 [Note] build/sql/mysqld: ready for connections. Version: '10.2.3-MariaDB-log' socket: '/home/mariadb/svoj/build/mysql-test/var/tmp/mysqld.1.sock' port: 16000 MariaDB Server 2016-11-16 6:20:36 70334652448096 [Note] InnoDB: Online DDL : Start 2016-11-16 6:20:36 70334652448096 [Note] InnoDB: Online DDL : Start reading clustered index of the table and create temporary files 2016-11-16 6:20:36 70334652448096 [Note] InnoDB: Online DDL : End of reading clustered index of the table and create temporary files 2016-11-16 6:20:36 70334652448096 [Note] InnoDB: Online DDL : Start applying row log 2016-11-16 6:20:36 70334652448096 [Note] InnoDB: Online DDL : End of applying row log 2016-11-16 6:20:36 70334652448096 [Note] InnoDB: Online DDL : Completed 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334649302368 has waited at trx0undo.ic line 191 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x3ffde1a37148 created in file buf0buf.cc line 1504 number of readers 0, waiters flag 1, lock_word: 20000000 Last time read locked in file trx0undo.ic line 191 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/include/trx0undo.ic line 171 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334649695584 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334652448096 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334651268448 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334648909152 has waited at row0upd.cc line 3120 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3ffd345d4bc8 created in file buf0buf.cc line 1504 a writer (thread id 70334648909152) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0sel.cc line 3659 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334650875232 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334652054880 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334650482016 has waited at row0sel.cc line 4995 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x3ffd345d4bc8 created in file buf0buf.cc line 1504 a writer (thread id 70334648909152) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0sel.cc line 3659 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334651661664 has waited at row0upd.cc line 3120 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3ffd6e1f2828 created in file buf0buf.cc line 1504 a writer (thread id 70334651661664) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1029 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334912917856 has waited at srv0srv.cc line 2953 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334128255328 has waited at buf0flu.cc line 1220 for 241.00 seconds the semaphore: SX-lock on RW-latch at 0x3ffd6e1f2828 created in file buf0buf.cc line 1504 a writer (thread id 70334651661664) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1029 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 2016-11-16 6:29:19 70335005978976 [Warning] InnoDB: A long semaphore wait: --Thread 70334650088800 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334649302368 has waited at trx0undo.ic line 191 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x3ffde1a37148 created in file buf0buf.cc line 1504 number of readers 0, waiters flag 1, lock_word: 20000000 Last time read locked in file trx0undo.ic line 191 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/include/trx0undo.ic line 171 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334649695584 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334652448096 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334651268448 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334648909152 has waited at row0upd.cc line 3120 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3ffd345d4bc8 created in file buf0buf.cc line 1504 a writer (thread id 70334648909152) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0sel.cc line 3659 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334650875232 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334652054880 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334650482016 has waited at row0sel.cc line 4995 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x3ffd345d4bc8 created in file buf0buf.cc line 1504 a writer (thread id 70334648909152) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0sel.cc line 3659 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334651661664 has waited at row0upd.cc line 3120 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3ffd6e1f2828 created in file buf0buf.cc line 1504 a writer (thread id 70334651661664) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1029 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334912917856 has waited at srv0srv.cc line 2953 for 241.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334128255328 has waited at buf0flu.cc line 1220 for 241.00 seconds the semaphore: SX-lock on RW-latch at 0x3ffd6e1f2828 created in file buf0buf.cc line 1504 a writer (thread id 70334651661664) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1029 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 2016-11-16 6:29:19 70335005978976 [Note] InnoDB: A semaphore wait: --Thread 70334650088800 has waited at trx0rec.cc line 2172 for 241.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info: InnoDB: Pending preads 0, pwrites 0 ===================================== 2016-11-16 06:29:31 0x3ff8248bf160 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 48 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 281 srv_active, 0 srv_shutdown, 241 srv_idle srv_master_thread log flush and writes: 522 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 535116 --Thread 70334649302368 has waited at trx0undo.ic line 191 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x3ffde1a37148 created in file buf0buf.cc line 1504 number of readers 0, waiters flag 1, lock_word: 20000000 Last time read locked in file trx0undo.ic line 191 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/include/trx0undo.ic line 171 --Thread 70334649695584 has waited at trx0rec.cc line 2172 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 --Thread 70334652448096 has waited at trx0rec.cc line 2172 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 --Thread 70334651268448 has waited at trx0rec.cc line 2172 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 --Thread 70334648909152 has waited at row0upd.cc line 3120 for 253.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3ffd345d4bc8 created in file buf0buf.cc line 1504 a writer (thread id 70334648909152) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0sel.cc line 3659 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 --Thread 70334650875232 has waited at trx0rec.cc line 2172 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 --Thread 70334652054880 has waited at trx0rec.cc line 2172 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 --Thread 70334650482016 has waited at row0sel.cc line 4995 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x3ffd345d4bc8 created in file buf0buf.cc line 1504 a writer (thread id 70334648909152) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file row0sel.cc line 3659 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 --Thread 70334651661664 has waited at row0upd.cc line 3120 for 253.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3ffd6e1f2828 created in file buf0buf.cc line 1504 a writer (thread id 70334651661664) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1029 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 --Thread 70334912917856 has waited at srv0srv.cc line 2953 for 253.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 --Thread 70334128255328 has waited at buf0flu.cc line 1220 for 253.00 seconds the semaphore: SX-lock on RW-latch at 0x3ffd6e1f2828 created in file buf0buf.cc line 1504 a writer (thread id 70334651661664) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.cc line 1029 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/row/row0upd.cc line 3120 --Thread 70334650088800 has waited at trx0rec.cc line 2172 for 253.00 seconds the semaphore: S-lock on RW-latch at 0x1004bdc9f70 created in file trx0purge.cc line 238 a writer (thread id 70334912917856) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file trx0rec.cc line 2172 Last time write locked in file /home/mariadb/svoj/mariadb/storage/innobase/srv/srv0srv.cc line 2916 OS WAIT ARRAY INFO: signal count 1496491 RW-shared spins 0, rounds 484113, OS waits 20221 RW-excl spins 0, rounds 14984465, OS waits 578069 RW-sx spins 1000, rounds 12976, OS waits 283 Spin rounds per wait: 484113.00 RW-shared, 14984465.00 RW-excl, 12.98 RW-sx ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2016-11-16 06:25:18 0x3ff80fc37d60 *** (1) TRANSACTION: TRANSACTION 2498229, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 31 lock struct(s), heap size 3520, 30 row lock(s), undo log entries 29 MySQL thread id 13, OS thread handle 0x3ff80fc97d60, query id 19403000 localhost root updating UPDATE sbtest1 SET c='14648256138-90486540048-51367278919-22737296823-19587054906-44650736773-69331452680-27684997755-52786173117-05703735911' WHERE id=8743 *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 8 page no 152 n bits 144 index PRIMARY of table `test`.`sbtest1` trx id 2498229 lock_mode X locks rec but not gap waiting Record lock, heap no 21 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 00002227; asc "';; 1: len 6; hex 000000261ebd; asc & ;; 2: len 7; hex 35000001350110; asc 5 5 ;; 3: len 4; hex 000023fa; asc # ;; 4: len 30; hex 39353532363037353535322d31363632323637373938342d313136393330; asc 95526075552-16622677984-116930; (total 120 bytes); 5: len 30; hex 32323530323535383031312d35363637333830343732302d313135373531; asc 22502558011-56673804720-115751; (total 60 bytes); *** (2) TRANSACTION: TRANSACTION 2498237, ACTIVE 0 sec starting index read mysql tables in use 1, locked 1 20 lock struct(s), heap size 3520, 21 row lock(s), undo log entries 20 MySQL thread id 14, OS thread handle 0x3ff80fc37d60, query id 19403118 localhost root updating UPDATE sbtest1 SET c='21777274702-45958191030-08380337731-30731739168-40936905471-42808132464-35160560456-31417979740-14513536731-02251711288' WHERE id=4492 *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 8 page no 152 n bits 144 index PRIMARY of table `test`.`sbtest1` trx id 2498237 lock_mode X locks rec but not gap Record lock, heap no 21 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 00002227; asc "';; 1: len 6; hex 000000261ebd; asc & ;; 2: len 7; hex 35000001350110; asc 5 5 ;; 3: len 4; hex 000023fa; asc # ;; 4: len 30; hex 39353532363037353535322d31363632323637373938342d313136393330; asc 95526075552-16622677984-116930; (total 120 bytes); 5: len 30; hex 32323530323535383031312d35363637333830343732302d313135373531; asc 22502558011-56673804720-115751; (total 60 bytes); *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 8 page no 94 n bits 144 index PRIMARY of table `test`.`sbtest1` trx id 2498237 lock_mode X locks rec but not gap waiting Record lock, heap no 4 PHYSICAL RECORD: n_fields 6; compact format; info bits 0 0: len 4; hex 0000118c; asc ;; 1: len 6; hex 000000261eae; asc & ;; 2: len 7; hex 2d00000118106a; asc - j;; 3: len 4; hex 00001f02; asc ;; 4: len 30; hex 32393137393839323739342d34353935363430393938382d393831303736; asc 29179892794-45956409988-981076; (total 120 bytes); 5: len 30; hex 35323936373930383631372d32383434393733343633302d343932353931; asc 52967908617-28449734630-492591; (total 60 bytes); *** WE ROLL BACK TRANSACTION (2) ------------ TRANSACTIONS ------------ Trx id counter 2498344 Purge done for trx's n:o < 2498308 undo n:o < 0 state: running but idle History list length 178 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 2498336, ACTIVE 253 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1136, 2 row lock(s), undo log entries 1 MySQL thread id 14, OS thread handle 0x3ff80fc37d60, query id 19405135 localhost root updating UPDATE sbtest1 SET k=k+1 WHERE id=9909 Trx read view will not see trx with id >= 2498334, sees < 2498313 ---TRANSACTION 2498332, ACTIVE 253 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 1136, 12 row lock(s), undo log entries 11 MySQL thread id 7, OS thread handle 0x3ff80fed7d60, query id 19405243 localhost root updating UPDATE sbtest1 SET k=k+1 WHERE id=3833 Trx read view will not see trx with id >= 2498331, sees < 2498313 ---TRANSACTION 2498331, ACTIVE 253 sec starting index read mysql tables in use 1, locked 1 32 lock struct(s), heap size 3520, 33 row lock(s), undo log entries 33 MySQL thread id 10, OS thread handle 0x3ff80fdb7d60, query id 19405232 localhost root updating UPDATE sbtest1 SET c='37275156844-08289605527-27566576513-09012921038-84650308769-30211936952-96140839866-48437103911-96854945337-44304176159' WHERE id=9939 Trx read view will not see trx with id >= 2498327, sees < 2498313 -------- 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 (write thread) Pending normal aio reads:, aio writes:, ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 0; buffer pool: 0 291 OS file reads, 443089 OS file writes, 701 OS fsyncs 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 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 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 1 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 16 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) Hash table size 1859467, node heap has 0 buffer(s) 0.00 hash searches/s, 0.00 non-hash searches/s --- LOG --- Log sequence number 10956940650 Log flushed up to 10956940650 Pages flushed up to 10091574742 Last checkpoint at 10091574742 0 pending log flushes, 0 pending chkp writes 436325 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 30945574912 Dictionary memory allocated 170562 Buffer pool size 1835008 Free buffers 1834369 Database pages 622 Old database pages 0 Modified db pages 383 Percent of dirty pages(LRU & free pages): 0.021 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 274, created 348, written 5500 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 622, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 57344 Free buffers 57311 Database pages 32 Old database pages 0 Modified db pages 10 Percent of dirty pages(LRU & free pages): 0.017 Max dirty pages percent: 75.000 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 32, created 0, written 484 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 32, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 57344 Free buffers 57343 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 57344 Free buffers 57342 Database pages 1 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 1, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 57344 Free buffers 57275 Database pages 68 Old database pages 0 Modified db pages 51 Percent of dirty pages(LRU & free pages): 0.089 Max dirty pages percent: 75.000 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 68, created 0, written 645 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 68, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 57344 Free buffers 57282 Database pages 61 Old database pages 0 Modified db pages 36 Percent of dirty pages(LRU & free pages): 0.063 Max dirty pages percent: 75.000 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 46, created 15, written 585 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 61, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 57344 Free buffers 57279 Database pages 64 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 64, created 0, written 492 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 57344 Free buffers 57279 Database pages 64 Old database pages 0 Modified db pages 51 Percent of dirty pages(LRU & free pages): 0.089 Max dirty pages percent: 75.000 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 5, created 59, written 562 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 57344 Free buffers 57245 Database pages 98 Old database pages 0 Modified db pages 51 Percent of dirty pages(LRU & free pages): 0.089 Max dirty pages percent: 75.000 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 32, created 66, written 680 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 98, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 8 Buffer pool size 57344 Free buffers 57215 Database pages 128 Old database pages 0 Modified db pages 99 Percent of dirty pages(LRU & free pages): 0.173 Max dirty pages percent: 75.000 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 26, created 102, written 849 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 128, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 9 Buffer pool size 57344 Free buffers 57279 Database pages 64 Old database pages 0 Modified db pages 56 Percent of dirty pages(LRU & free pages): 0.098 Max dirty pages percent: 75.000 Pending reads 0 Pending writes: LRU 0, flush list 2, single page 0 Pages made young 0, not young 0 0.00 youngs/s, 0.00 non-youngs/s Pages read 0, created 64, written 643 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 64, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 10 Buffer pool size 57344 Free buffers 57301 Database pages 42 Old database pages 0 Modified db pages 29 Percent of dirty pages(LRU & free pages): 0.051 Max dirty pages percent: 75.000 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 0, created 42, written 560 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 42, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 11 Buffer pool size 57344 Free buffers 57343 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 12 Buffer pool size 57344 Free buffers 57343 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 13 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 14 Buffer pool size 57344 Free buffers 57343 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 15 Buffer pool size 57344 Free buffers 57343 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 16 Buffer pool size 57344 Free buffers 57343 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 17 Buffer pool size 57344 Free buffers 57343 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 18 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 19 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 20 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 21 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 22 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 23 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 24 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 25 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 26 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 27 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 28 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 29 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 30 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] ---BUFFER POOL 31 Buffer pool size 57344 Free buffers 57344 Database pages 0 Old database pages 0 Modified db pages 0 Percent of dirty pages(LRU & free pages): 0.000 Max dirty pages percent: 75.000 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 0, created 0, written 0 0.00 reads/s, 0.00 creates/s, 0.00 writes/s No buffer pool page gets since the last printout Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 0, unzip_LRU len: 0 I/O sum[0]:cur[0], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 10 read views open inside InnoDB Process ID=76284, Main thread ID=70334921306464, state: sleeping Number of rows inserted 458529, updated 15332849, deleted 448522, read 198342685 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s Number of system rows inserted 0, updated 0, deleted 0, read 0 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================