mysql> show engine innodb status\G *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2017-01-05 19:17:57 2ac17de60700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 10 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1906253 srv_active, 0 srv_shutdown, 954 srv_idle srv_master_thread log flush and writes: 1907206 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 5515493297 --Thread 47001021011712 has waited at btr0cur.cc line 536 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009418831616 has waited at btr0cur.cc line 536 for 106.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009412175616 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 46982042851072 has waited at btr0cur.cc line 536 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47010229790464 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009419097856 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009415104256 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009417234176 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 46963063891712 has waited at row0ins.cc line 2655 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 46994696800000 has waited at row0ins.cc line 2655 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47008416290560 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009419364096 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47008415491840 has waited at row0ins.cc line 2655 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009418299136 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009418032896 has waited at row0ins.cc line 2655 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 46975713912576 has waited at row0ins.cc line 2655 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47008415758080 has waited at row0ins.cc line 2655 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009415370496 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 46982043117312 has waited at row0ins.cc line 2655 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009416169216 has waited at row0row.cc line 815 for 14.00 seconds the semaphore: X-lock on RW-latch at 0x2abaeb14bc40 created in file buf0buf.cc line 1016 a writer (thread id 47009411110656) has reserved it in mode exclusive number of readers 0, waiters flag 1, lock_word: 0 Last time read locked in file buf0flu.cc line 1066 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/row/row0row.cc line 815 --Thread 47009410578176 has waited at btr0cur.cc line 545 for 106.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46988367595264 has waited at btr0cur.cc line 545 for 105.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47010545256192 has waited at btr0cur.cc line 545 for 104.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46975712581376 has waited at btr0cur.cc line 545 for 103.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46982042584832 has waited at btr0cur.cc line 545 for 106.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47010310469376 has waited at btr0cur.cc line 545 for 103.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009414838016 has waited at btr0cur.cc line 545 for 103.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47010316326656 has waited at btr0cur.cc line 545 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47010495735552 has waited at btr0cur.cc line 545 for 105.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46994696533760 has waited at btr0cur.cc line 545 for 103.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47001021277952 has waited at btr0cur.cc line 545 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009408448256 has waited at btr0cur.cc line 545 for 101.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46994697066240 has waited at btr0cur.cc line 545 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47001021544192 has waited at btr0cur.cc line 545 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009411909376 has waited at btr0cur.cc line 545 for 101.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47001022076672 has waited at btr0cur.cc line 545 for 101.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009409779456 has waited at btr0cur.cc line 545 for 100.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009417766656 has waited at btr0cur.cc line 545 for 102.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46975713113856 has waited at btr0cur.cc line 545 for 106.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009416701696 has waited at btr0cur.cc line 545 for 100.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47007350482688 has waited at btr0cur.cc line 545 for 98.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009412441856 has waited at btr0cur.cc line 545 for 97.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46969388103424 has waited at btr0cur.cc line 545 for 97.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009409246976 has waited at btr0cur.cc line 545 for 99.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46969387837184 has waited at btr0cur.cc line 545 for 97.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47008416823040 has waited at btr0cur.cc line 545 for 97.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009410844416 has waited at btr0cur.cc line 545 for 96.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47009407383296 has waited at btr0cur.cc line 545 for 96.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46994697332480 has waited at btr0cur.cc line 545 for 96.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 47010299287296 has waited at btr0cur.cc line 545 for 101.00 seconds the semaphore: S-lock on RW-latch at 0x2ac10043d578 created in file dict0dict.cc line 2505 a writer (thread id 47009418831616) has reserved it in mode wait exclusive number of readers 17, waiters flag 1, lock_word: ffffffffffffffef Last time read locked in file btr0cur.cc line 545 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/btr/btr0cur.cc line 536 --Thread 46982042318592 has waited at row0mysql.cc line 1688 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009390147328 has waited at srv0srv.cc line 1998 for 94.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010544191232 has waited at row0mysql.cc line 1688 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46982041786112 has waited at row0mysql.cc line 1688 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010283845376 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009417500416 has waited at row0mysql.cc line 1688 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009418565376 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46994696001280 has waited at row0mysql.cc line 1688 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010466182912 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009412974336 has waited at row0mysql.cc line 1688 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009407915776 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010442221312 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009409513216 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009414039296 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010500261632 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46988367062784 has waited at row0mysql.cc line 1688 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009413506816 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009408980736 has waited at row0mysql.cc line 1688 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010528216832 has waited at row0ins.cc line 1789 for 94.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47007351547648 has waited at row0ins.cc line 1789 for 89.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010300352256 has waited at row0ins.cc line 1789 for 81.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010417727232 has waited at row0mysql.cc line 1688 for 70.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009415902976 has waited at row0ins.cc line 1789 for 68.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010238842624 has waited at row0mysql.cc line 1688 for 62.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010513307392 has waited at row0undo.cc line 298 for 54.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009415636736 has waited at row0undo.cc line 298 for 55.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010540730112 has waited at row0undo.cc line 298 for 54.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46969388369664 has waited at row0undo.cc line 298 for 54.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010311800576 has waited at row0undo.cc line 298 for 54.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46975713646336 has waited at row0undo.cc line 298 for 52.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47008416024320 has waited at row0undo.cc line 298 for 49.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010320852736 has waited at row0mysql.cc line 1688 for 47.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46956809574144 has waited at row0undo.cc line 298 for 47.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009407649536 has waited at row0undo.cc line 298 for 46.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46956771411712 has waited at row0mysql.cc line 1688 for 45.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010263611136 has waited at row0mysql.cc line 1688 for 45.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46969387570944 has waited at row0undo.cc line 298 for 45.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010529814272 has waited at row0mysql.cc line 1688 for 44.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010306742016 has waited at row0ins.cc line 1789 for 44.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010531677952 has waited at row0mysql.cc line 1688 for 44.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46975712847616 has waited at row0mysql.cc line 1688 for 43.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010406811392 has waited at row0mysql.cc line 1688 for 43.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46963063625472 has waited at row0mysql.cc line 1688 for 42.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010455267072 has waited at row0mysql.cc line 1688 for 42.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010493073152 has waited at row0mysql.cc line 1688 for 42.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010242569984 has waited at row0ins.cc line 1789 for 42.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46988367861504 has waited at row0mysql.cc line 1688 for 42.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010387642112 has waited at row0ins.cc line 1789 for 42.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010268935936 has waited at row0ins.cc line 1789 for 42.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010514372352 has waited at row0mysql.cc line 1688 for 41.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010276923136 has waited at row0ins.cc line 1789 for 41.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010319255296 has waited at row0mysql.cc line 1688 for 41.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010395895552 has waited at row0ins.cc line 1789 for 41.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010273994496 has waited at row0ins.cc line 1789 for 41.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010529548032 has waited at row0mysql.cc line 1688 for 40.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010538067712 has waited at row0mysql.cc line 1688 for 40.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010429974272 has waited at row0ins.cc line 1789 for 40.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010244966144 has waited at row0ins.cc line 1789 for 39.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010392168192 has waited at row0ins.cc line 1789 for 39.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009414305536 has waited at row0mysql.cc line 1688 for 39.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010546321152 has waited at row0mysql.cc line 1688 for 39.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 46956771145472 has waited at row0mysql.cc line 1688 for 38.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010547386112 has waited at row0ins.cc line 1789 for 38.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010411603712 has waited at row0ins.cc line 1789 for 37.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47007351281408 has waited at row0ins.cc line 1789 for 37.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010475501312 has waited at row0mysql.cc line 1688 for 37.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010294228736 has waited at row0mysql.cc line 1688 for 37.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009414571776 has waited at row0mysql.cc line 1688 for 37.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010457130752 has waited at row0mysql.cc line 1688 for 36.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009408714496 has waited at row0mysql.cc line 1688 for 36.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010534340352 has waited at row0ins.cc line 1789 for 36.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010275325696 has waited at row0ins.cc line 1789 for 35.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010245498624 has waited at row0mysql.cc line 1688 for 34.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010542061312 has waited at row0ins.cc line 1789 for 34.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010515171072 has waited at row0mysql.cc line 1688 for 34.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010541528832 has waited at row0ins.cc line 1789 for 34.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010326976256 has waited at row0ins.cc line 1789 for 33.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010313131776 has waited at row0mysql.cc line 1688 for 33.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010285975296 has waited at row0ins.cc line 1789 for 33.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010329106176 has waited at row0mysql.cc line 1688 for 33.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010503190272 has waited at row0ins.cc line 1789 for 32.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009410045696 has waited at row0mysql.cc line 1688 for 32.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010241238784 has waited at row0mysql.cc line 1688 for 32.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010470176512 has waited at row0ins.cc line 1789 for 31.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010476033792 has waited at row0mysql.cc line 1688 for 31.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010547119872 has waited at row0mysql.cc line 1688 for 31.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010547918592 has waited at row0mysql.cc line 1688 for 31.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010542860032 has waited at row0ins.cc line 1789 for 31.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010230589184 has waited at row0ins.cc line 1789 for 30.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47007350748928 has waited at row0ins.cc line 1789 for 30.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010408675072 has waited at row0mysql.cc line 1688 for 30.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010537002752 has waited at row0ins.cc line 1789 for 30.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010296358656 has waited at row0mysql.cc line 1688 for 29.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010293430016 has waited at row0mysql.cc line 1688 for 29.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010492540672 has waited at row0mysql.cc line 1688 for 29.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010535139072 has waited at row0mysql.cc line 1688 for 29.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010310735616 has waited at row0ins.cc line 1789 for 29.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010435299072 has waited at row0ins.cc line 1789 for 29.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47001021810432 has waited at row0mysql.cc line 1688 for 29.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47009413773056 has waited at row0ins.cc line 1789 for 28.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47008415225600 has waited at row0ins.cc line 1789 for 13.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 --Thread 47010527684352 has waited at row0mysql.cc line 1688 for 1.00 seconds the semaphore: S-lock on RW-latch at 0x1357420 created in file dict0dict.cc line 972 a writer (thread id 47009390147328) has reserved it in mode wait exclusive number of readers 14, waiters flag 1, lock_word: fffffffffffffff2 Last time read locked in file row0upd.cc line 149 Last time write locked in file /local/mysqlbuild/mysql-5.6.19a.R1/storage/innobase/srv/srv0srv.cc line 1998 OS WAIT ARRAY INFO: signal count 3225530524 Mutex spin waits 3868555700, rounds 6552547127, OS waits 39940357 RW-shared spins 900871155, rounds 93357267600, OS waits 2964510510 RW-excl spins 664081224, rounds 82273979810, OS waits 2456728047 Spin rounds per wait: -15.37 mutex, 103.63 RW-shared, 123.89 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ ***FILTERED*** ------------ TRANSACTIONS ------------ Trx id counter 34932008793 Purge done for trx's n:o < 33138255134 undo n:o < 1 state: running but idle History list length 443301082 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 34932006375, not started MySQL thread id 92614, OS thread handle 0x2ac16c923700, query id 18103045003 10.0.6.238 qharvest cleaning up ---TRANSACTION 34932006907, not started MySQL thread id 92612, OS thread handle 0x2ac13b609700, query id 18103049699 10.0.6.116 qharvest cleaning up ---TRANSACTION 34932008747, not started MySQL thread id 92611, OS thread handle 0x2ac178500700, query id 18103068316 10.0.6.238 qharvest cleaning up ---TRANSACTION 34932008792, not started MySQL thread id 92609, OS thread handle 0x2ac170eb7700, query id 18103068729 10.0.6.238 qharvest cleaning up ---TRANSACTION 34932006873, not started MySQL thread id 92608, OS thread handle 0x2ac171cae700, query id 18103051077 10.0.6.159 qharvest cleaning up ---TRANSACTION 34932008790, not started MySQL thread id 92607, OS thread handle 0x2ac13b33e700, query id 18103068726 10.0.6.238 qharvest cleaning up ---TRANSACTION 34932007337, not started MySQL thread id 92606, OS thread handle 0x2ac179fa9700, query id 18103054097 10.0.6.116 qharvest cleaning up ---TRANSACTION 34932003135, not started MySQL thread id 92604, OS thread handle 0x2ac17b2b4700, query id 18103015342 10.0.6.238 qharvest cleaning up ---TRANSACTION 34932007108, not started MySQL thread id 92602, OS thread handle 0x2ac17b84a700, query id 18103051676 10.0.6.87 qharvest cleaning up ---TRANSACTION 34932007170, not started MySQL thread id 92597, OS thread handle 0x2ac17ecd9700, query id 18103052675 10.0.6.42 qharvest cleaning up ---TRANSACTION 34932006840, not started MySQL thread id 92596, OS thread handle 0x2ac17ed1a700, query id 18103049312 10.0.6.147 qharvest cleaning up ---TRANSACTION 34932007207, not started MySQL thread id 92595, OS thread handle 0x2ac17e5fe700, query id 18103052994 10.0.6.87 qharvest cleaning up ---TRANSACTION 34932007211, not started MySQL thread id 92590, OS thread handle 0x2ac178276700, query id 18103053076 10.0.6.159 qharvest cleaning up ---TRANSACTION 34932008787, not started MySQL thread id 92441, OS thread handle 0x2ab4f9a5e700, query id 18103068733 10.0.6.238 qharvest cleaning up ---TRANSACTION 34929478374, not started MySQL thread id 91992, OS thread handle 0x2ab670b17700, query id 18080331236 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929458124, not started MySQL thread id 91984, OS thread handle 0x2ac17207d700, query id 18080139718 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929457262, not started MySQL thread id 91977, OS thread handle 0x2ac177f29700, query id 18080131094 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456380, not started MySQL thread id 91970, OS thread handle 0x2ab670ad6700, query id 18080122293 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456164, not started MySQL thread id 91968, OS thread handle 0x2ac16c248700, query id 18080120159 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456264, not started MySQL thread id 91965, OS thread handle 0x2ac16ecb1700, query id 18080122484 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456169, not started MySQL thread id 91963, OS thread handle 0x2ac17b601700, query id 18080121183 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456222, not started MySQL thread id 91961, OS thread handle 0x2ac17efe5700, query id 18080121238 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456007, not started MySQL thread id 91958, OS thread handle 0x2ac17643f700, query id 18080118954 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456173, not started MySQL thread id 91955, OS thread handle 0x2ac171286700, query id 18080120220 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456024, not started MySQL thread id 91949, OS thread handle 0x2ac1721c2700, query id 18080118713 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456132, not started MySQL thread id 91944, OS thread handle 0x2ac16c860700, query id 18080119890 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929455334, not started MySQL thread id 91934, OS thread handle 0x2ac17ea4f700, query id 18080112448 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929455712, not started MySQL thread id 91936, OS thread handle 0x2ac17ec16700, query id 18080115705 10.0.6.87 qharvest cleaning up ---TRANSACTION 34929456133, not started MySQL thread id 91933, OS thread handle 0x2ac17dfa5700, query id 18080119924 10.0.6.87 qharvest cleaning up ---TRANSACTION 34931306207, not started MySQL thread id 91246, OS thread handle 0x2ac170697700, query id 18103064148 10.0.6.238 qharvest cleaning up ---TRANSACTION 0, not started MySQL thread id 91076, OS thread handle 0x2ac17de60700, query id 18103068750 10.0.6.238 root init show engine innodb status ---TRANSACTION 34932008661, not started MySQL thread id 1, OS thread handle 0x2ab4f99dc700, query id 18103067210 localhost 127.0.0.1 rdsadmin cleaning up ---TRANSACTION 34932008791, ACTIVE 1 sec MySQL thread id 92793, OS thread handle 0x2ac17a6c5700, query id 18103068748 10.0.6.238 qharvest cleaning up Trx read view will not see trx with id >= 34932008792, sees < 33138255132 ---TRANSACTION 34932008789, ACTIVE 1 sec MySQL thread id 92794, OS thread handle 0x2ac179b58700, query id 18103068749 10.0.6.238 qharvest cleaning up Trx read view will not see trx with id >= 34932008790, sees < 33138255132 ---TRANSACTION 34932008785, ACTIVE 1 sec MySQL thread id 92796, OS thread handle 0x2ac170552700, query id 18103068747 10.0.6.238 qharvest cleaning up Trx read view will not see trx with id >= 34932008786, sees < 33138255132 ---TRANSACTION 34932008773, ACTIVE 1 sec updating or deleting mysql tables in use 1, locked 1 6 lock struct(s), heap size 2936, 67 row lock(s), undo log entries 32 MySQL thread id 92798, OS thread handle 0x2ac17dcda700, query id 18103068525 10.0.6.238 qharvest updating DELETE ***FILTERED*** Trx read view will not see trx with id >= 34932008774, sees < 33138255132 ---TRANSACTION 34932008716, ACTIVE 9 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 1 MySQL thread id 92481, OS thread handle 0x2abc54e95700, query id 18103068026 10.0.6.238 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008717, sees < 33138255132 ------- TRX HAS BEEN WAITING 9 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1568 page no 46244 n bits 512 index `PRIMARY` of table `qharvest`.`qh_rest_deviceextra` trx id 34932008716 lock_mode X locks rec but not gap waiting Record lock, heap no 443 PHYSICAL RECORD: n_fields 8; compact format; info bits 0 0: len 4; hex 808e56f2; asc V ;; 1: len 6; hex 0008221c22c8; asc " " ;; 2: len 7; hex 5d00f866570903; asc ] fW ;; 3: len 4; hex 8140c5c4; asc @ ;; 4: SQL NULL; 5: len 4; hex 7fffffd9; asc ;; 6: len 8; hex 80000000acf2dc26; asc &;; 7: len 4; hex 80000041; asc A;; ------------------ ---TRANSACTION 34932008671, ACTIVE 12 sec starting index read mysql tables in use 1, locked 1 LOCK WAIT 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92487, OS thread handle 0x2abc54fda700, query id 18103067325 10.0.6.238 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008672, sees < 33138255132 ------- TRX HAS BEEN WAITING 12 SEC FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 1459 page no 75090 n bits 176 index `PRIMARY` of table `qharvest`.`qh_rest_qdevice` trx id 34932008671 lock_mode X locks rec but not gap waiting Record lock, heap no 26 PHYSICAL RECORD: n_fields 20; compact format; info bits 0 0: len 4; hex 80872f03; asc / ;; 1: len 6; hex 0008221b4b4c; asc " KL;; 2: len 7; hex 6700f8640e21d5; asc g d ! ;; 3: SQL NULL; 4: SQL NULL; 5: SQL NULL; 6: len 30; hex 36342e37392e3134342e3136362020202020202020202020202020202020; asc 64.79.144.166 ; (total 39 bytes); 7: len 4; hex 80001688; asc ;; 8: len 8; hex 0000000000000000; asc ;; 9: len 8; hex 0000000000000000; asc ;; 10: len 4; hex 8000044b; asc K;; 11: len 4; hex 803e7ad9; asc >z ;; 12: len 19; hex 776c2d362e33372e31342e3132362d312e3330; asc wl-6.37.14.126-1.30;; 13: len 4; hex 80000000; asc ;; 14: SQL NULL; 15: SQL NULL; 16: len 1; hex 80; asc ;; 17: len 4; hex 800000b1; asc ;; 18: len 30; hex 346230643039396565653464346664363963666631383961353265383661; asc 4b0d099eee4d4fd69cff189a52e86a; (total 32 bytes); 19: len 1; hex 81; asc ;; ------------------ ---TRANSACTION 34932008660, ACTIVE 13 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92509, OS thread handle 0x2ac0ffe41700, query id 18103067204 10.0.6.238 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008661, sees < 33138255132 ---TRANSACTION 34932008523, ACTIVE 28 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92551, OS thread handle 0x2ac13b68b700, query id 18103065820 10.0.6.238 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008524, sees < 33138255132 ---TRANSACTION 34932008520, ACTIVE 29 sec updating or deleting mysql tables in use 1, locked 1 21 lock struct(s), heap size 6544, 340 row lock(s), undo log entries 12 MySQL thread id 92777, OS thread handle 0x2abf47358700, query id 18103065767 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008521, sees < 33138255132 ---TRANSACTION 34932008519, ACTIVE 29 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92787, OS thread handle 0x2ac1784bf700, query id 18103065744 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008520, sees < 33138255132 ---TRANSACTION 34932008517, ACTIVE 29 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 280 row lock(s), undo log entries 3 MySQL thread id 92775, OS thread handle 0x2ac17bb56700, query id 18103065714 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008518, sees < 33138255132 ---TRANSACTION 34932008514, ACTIVE 29 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92785, OS thread handle 0x2ac170df4700, query id 18103065690 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008515, sees < 33138255132 ---TRANSACTION 34932008502, ACTIVE 29 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 240 row lock(s), undo log entries 3 MySQL thread id 92781, OS thread handle 0x2ac17e3f6700, query id 18103065608 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008503, sees < 33138255132 ---TRANSACTION 34932008497, ACTIVE 29 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 42 row lock(s), undo log entries 3 MySQL thread id 92765, OS thread handle 0x2ac16fd73700, query id 18103065576 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008498, sees < 33138255132 ---TRANSACTION 34932008492, ACTIVE 30 sec updating or deleting mysql tables in use 1, locked 1 21 lock struct(s), heap size 6544, 300 row lock(s), undo log entries 12 MySQL thread id 92783, OS thread handle 0x2ac17003e700, query id 18103065522 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008493, sees < 33138255132 ---TRANSACTION 34932008488, ACTIVE 30 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92764, OS thread handle 0x2ac17e5bd700, query id 18103065482 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008489, sees < 33138255132 ---TRANSACTION 34932008474, ACTIVE 30 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92769, OS thread handle 0x2ac0c0717700, query id 18103065377 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008475, sees < 33138255132 ---TRANSACTION 34932008473, ACTIVE 30 sec updating or deleting mysql tables in use 1, locked 1 14 lock struct(s), heap size 2936, 276 row lock(s), undo log entries 3 MySQL thread id 92771, OS thread handle 0x2ac176b5b700, query id 18103065386 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008474, sees < 33138255132 ---TRANSACTION 34932008470, ACTIVE 30 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92761, OS thread handle 0x2ac16c185700, query id 18103065347 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008471, sees < 33138255132 ---TRANSACTION 34932008464, ACTIVE 31 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 2 MySQL thread id 92789, OS thread handle 0x2ac17eb53700, query id 18103065304 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008465, sees < 33138255132 ---TRANSACTION 34932008461, ACTIVE 31 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 81 row lock(s), undo log entries 3 MySQL thread id 92791, OS thread handle 0x2ac17f026700, query id 18103065274 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008462, sees < 33138255132 ---TRANSACTION 34932008441, ACTIVE 31 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 56 row lock(s), undo log entries 3 MySQL thread id 92779, OS thread handle 0x2ac17ef63700, query id 18103065151 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008442, sees < 33138255132 ---TRANSACTION 34932008418, ACTIVE 31 sec updating or deleting mysql tables in use 1, locked 1 21 lock struct(s), heap size 6544, 300 row lock(s), undo log entries 12 MySQL thread id 92768, OS thread handle 0x2ac17ab98700, query id 18103065018 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008419, sees < 33138255132 ---TRANSACTION 34932008414, ACTIVE 31 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 92773, OS thread handle 0x2ac17a602700, query id 18103064969 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008415, sees < 33138255132 ---TRANSACTION 34932008368, ACTIVE 32 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 279 row lock(s), undo log entries 3 MySQL thread id 92755, OS thread handle 0x2ac16cbad700, query id 18103064652 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008369, sees < 33138255132 ---TRANSACTION 34932008367, ACTIVE 32 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 80 row lock(s), undo log entries 3 MySQL thread id 92745, OS thread handle 0x2ac13b2fd700, query id 18103064641 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008368, sees < 33138255132 ---TRANSACTION 34932008362, ACTIVE 32 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92747, OS thread handle 0x2ac17c57e700, query id 18103064602 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008363, sees < 33138255132 ---TRANSACTION 34932008352, ACTIVE 33 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 56 row lock(s), undo log entries 3 MySQL thread id 92753, OS thread handle 0x2ac171f79700, query id 18103064508 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008353, sees < 33138255132 ---TRANSACTION 34932008349, ACTIVE 33 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92743, OS thread handle 0x2ac16f657700, query id 18103064486 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008350, sees < 33138255132 ---TRANSACTION 34932008337, ACTIVE 33 sec updating or deleting mysql tables in use 1, locked 1 24 lock struct(s), heap size 6544, 422 row lock(s), undo log entries 12 MySQL thread id 92759, OS thread handle 0x2ac17103d700, query id 18103064429 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008338, sees < 33138255132 ---TRANSACTION 34932008332, ACTIVE 33 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 92757, OS thread handle 0x2ac171d71700, query id 18103064392 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008333, sees < 33138255132 ---TRANSACTION 34932008317, ACTIVE 34 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92739, OS thread handle 0x2ac17ea0e700, query id 18103064311 10.0.6.147 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008318, sees < 33138255132 ---TRANSACTION 34932008315, ACTIVE 34 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92741, OS thread handle 0x2ac17ea90700, query id 18103064292 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008316, sees < 33138255132 ---TRANSACTION 34932008311, ACTIVE 34 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 80 row lock(s), undo log entries 3 MySQL thread id 92751, OS thread handle 0x2ac16cfbd700, query id 18103064274 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008312, sees < 33138255132 ---TRANSACTION 34932008309, ACTIVE 34 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 90 row lock(s), undo log entries 3 MySQL thread id 92749, OS thread handle 0x2ac17d0eb700, query id 18103064294 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008310, sees < 33138255132 ---TRANSACTION 34932008287, ACTIVE 35 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92737, OS thread handle 0x2ac16ec2f700, query id 18103064152 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008288, sees < 33138255132 ---TRANSACTION 34932008275, ACTIVE 36 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92735, OS thread handle 0x2ac17e333700, query id 18103064075 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008276, sees < 33138255132 ---TRANSACTION 34932008272, ACTIVE 36 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 48 row lock(s), undo log entries 3 MySQL thread id 92733, OS thread handle 0x2ac13b1b8700, query id 18103064057 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008273, sees < 33138255132 ---TRANSACTION 34932008271, ACTIVE 36 sec updating or deleting mysql tables in use 1, locked 1 21 lock struct(s), heap size 6544, 268 row lock(s), undo log entries 12 MySQL thread id 92731, OS thread handle 0x2ac179991700, query id 18103064053 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008272, sees < 33138255132 ---TRANSACTION 34932008261, ACTIVE 37 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 56 row lock(s), undo log entries 3 MySQL thread id 92727, OS thread handle 0x2ac13b74e700, query id 18103063971 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008262, sees < 33138255132 ---TRANSACTION 34932008256, ACTIVE 37 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 287 row lock(s), undo log entries 3 MySQL thread id 92729, OS thread handle 0x2ac16fe36700, query id 18103063927 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008257, sees < 33138255132 ---TRANSACTION 34932008254, ACTIVE 37 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 267 row lock(s), undo log entries 3 MySQL thread id 92725, OS thread handle 0x2ac17ab16700, query id 18103063901 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008255, sees < 33138255132 ---TRANSACTION 34932008248, ACTIVE 37 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 92724, OS thread handle 0x2ac0c0799700, query id 18103063835 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008249, sees < 33138255132 ---TRANSACTION 34932008227, ACTIVE 37 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92721, OS thread handle 0x2ac176e26700, query id 18103063659 10.0.6.147 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008228, sees < 33138255132 ---TRANSACTION 34932008208, ACTIVE 38 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92717, OS thread handle 0x2ac17efa4700, query id 18103063526 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008209, sees < 33138255132 ---TRANSACTION 34932008201, ACTIVE 38 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 282 row lock(s), undo log entries 3 MySQL thread id 92719, OS thread handle 0x2ab4f9a9f700, query id 18103063497 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008202, sees < 33138255132 ---TRANSACTION 34932008184, ACTIVE 39 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 282 row lock(s), undo log entries 3 MySQL thread id 92709, OS thread handle 0x2ac17eea0700, query id 18103063393 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008185, sees < 33138255132 ---TRANSACTION 34932008182, ACTIVE 39 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92555, OS thread handle 0x2ac13b70d700, query id 18103063375 10.0.6.238 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008183, sees < 33138255132 ---TRANSACTION 34932008172, ACTIVE 39 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92714, OS thread handle 0x2ac175b9d700, query id 18103063327 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008173, sees < 33138255132 ---TRANSACTION 34932008165, ACTIVE 39 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 92715, OS thread handle 0x2ac16cf3b700, query id 18103063300 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008166, sees < 33138255132 ---TRANSACTION 34932008146, ACTIVE 40 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92711, OS thread handle 0x2ac177fab700, query id 18103063179 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008147, sees < 33138255132 ---TRANSACTION 34932008131, ACTIVE 40 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 78 row lock(s), undo log entries 3 MySQL thread id 92707, OS thread handle 0x2ac17e6c1700, query id 18103063095 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008132, sees < 33138255132 ---TRANSACTION 34932008129, ACTIVE 40 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 88 row lock(s), undo log entries 3 MySQL thread id 92705, OS thread handle 0x2ac17dea1700, query id 18103063072 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008130, sees < 33138255132 ---TRANSACTION 34932008123, ACTIVE 41 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92693, OS thread handle 0x2ac16eaea700, query id 18103063036 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008124, sees < 33138255132 ---TRANSACTION 34932008121, ACTIVE 41 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92691, OS thread handle 0x2ac175f2b700, query id 18103063016 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008122, sees < 33138255132 ---TRANSACTION 34932008118, ACTIVE 41 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 20 row lock(s), undo log entries 3 MySQL thread id 92683, OS thread handle 0x2ac171614700, query id 18103062993 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008119, sees < 33138255132 ---TRANSACTION 34932008117, ACTIVE 41 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92695, OS thread handle 0x2ac16edb5700, query id 18103062984 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008118, sees < 33138255132 ---TRANSACTION 34932008115, ACTIVE 41 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92703, OS thread handle 0x2ac17d028700, query id 18103062971 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008116, sees < 33138255132 ---TRANSACTION 34932008111, ACTIVE 42 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92701, OS thread handle 0x2ac16e617700, query id 18103062952 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008112, sees < 33138255132 ---TRANSACTION 34932008107, ACTIVE 42 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92680, OS thread handle 0x2ac17574c700, query id 18103062920 10.0.6.147 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008108, sees < 33138255132 ---TRANSACTION 34932008100, ACTIVE 42 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92699, OS thread handle 0x2ac16ccf2700, query id 18103062874 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008101, sees < 33138255132 ---TRANSACTION 34932008091, ACTIVE 42 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 254 row lock(s), undo log entries 3 MySQL thread id 92689, OS thread handle 0x2abc54f99700, query id 18103062876 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008092, sees < 33138255132 ---TRANSACTION 34932008089, ACTIVE 42 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 283 row lock(s), undo log entries 3 MySQL thread id 92697, OS thread handle 0x2ac17bbd8700, query id 18103062810 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008090, sees < 33138255132 ---TRANSACTION 34932008079, ACTIVE 42 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92687, OS thread handle 0x2ab670b99700, query id 18103062745 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008080, sees < 33138255132 ---TRANSACTION 34932008078, ACTIVE 42 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 279 row lock(s), undo log entries 3 MySQL thread id 92685, OS thread handle 0x2ac1797ca700, query id 18103062755 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008079, sees < 33138255132 ---TRANSACTION 34932008026, ACTIVE 43 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 56 row lock(s), undo log entries 3 MySQL thread id 92681, OS thread handle 0x2ac176994700, query id 18103062266 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008027, sees < 33138255132 ---TRANSACTION 34932008023, ACTIVE 43 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92677, OS thread handle 0x2ab962ad6700, query id 18103062248 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008024, sees < 33138255132 ---TRANSACTION 34932008015, ACTIVE 44 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 281 row lock(s), undo log entries 3 MySQL thread id 92673, OS thread handle 0x2ac17e0a9700, query id 18103062207 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008016, sees < 33138255132 ---TRANSACTION 34932008013, ACTIVE 44 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92671, OS thread handle 0x2ac170a25700, query id 18103062194 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932008014, sees < 33138255132 ---TRANSACTION 34932008007, ACTIVE 44 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 56 row lock(s), undo log entries 3 MySQL thread id 92675, OS thread handle 0x2ac17dee2700, query id 18103062156 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932008008, sees < 33138255132 ---TRANSACTION 34932007978, ACTIVE 45 sec updating or deleting mysql tables in use 1, locked 1 12 lock struct(s), heap size 2936, 56 row lock(s), undo log entries 3 MySQL thread id 92667, OS thread handle 0x2ac16e103700, query id 18103061943 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007979, sees < 33138255132 ---TRANSACTION 34932007974, ACTIVE 45 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92669, OS thread handle 0x2ab4f9ae0700, query id 18103061910 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007975, sees < 33138255132 ---TRANSACTION 34932007937, ACTIVE 47 sec updating or deleting mysql tables in use 1, locked 1 23 lock struct(s), heap size 6544, 318 row lock(s), undo log entries 12 MySQL thread id 92665, OS thread handle 0x2ac17179a700, query id 18103061561 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007938, sees < 33138255132 ---TRANSACTION 34932007803, ACTIVE 62 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92599, OS thread handle 0x2ac16c964700, query id 18103060097 10.0.6.238 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007804, sees < 33138255132 ---TRANSACTION 34932007762, ACTIVE 68 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92567, OS thread handle 0x2ac13b893700, query id 18103059660 10.0.6.238 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007763, sees < 33138255132 ---TRANSACTION 34932007737, ACTIVE 70 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92649, OS thread handle 0x2ac1773fd700, query id 18103059408 10.0.6.238 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007738, sees < 33138255132 ---TRANSACTION 34932007624, ACTIVE 81 sec updating or deleting mysql tables in use 1, locked 1 3 lock struct(s), heap size 1184, 1 row lock(s), undo log entries 2 MySQL thread id 92663, OS thread handle 0x2ac17040d700, query id 18103058115 10.0.6.238 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007625, sees < 33138255132 ---TRANSACTION 34932007486, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s), undo log entries 1 MySQL thread id 92639, OS thread handle 0x2ac17dd5c700, query id 18103054752 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007487, sees < 33138255132 ---TRANSACTION 34932007485, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92549, OS thread handle 0x2ac13b64a700, query id 18103054698 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007486, sees < 33138255132 ---TRANSACTION 34932007484, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 279 row lock(s), undo log entries 3 MySQL thread id 92529, OS thread handle 0x2ac13b1f9700, query id 18103054705 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007485, sees < 33138255132 ---TRANSACTION 34932007483, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92659, OS thread handle 0x2abc54ed6700, query id 18103054689 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007484, sees < 33138255132 ---TRANSACTION 34932007479, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92653, OS thread handle 0x2ac17c2b3700, query id 18103054663 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007480, sees < 33138255132 ---TRANSACTION 34932007472, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92553, OS thread handle 0x2ac13b6cc700, query id 18103054611 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007473, sees < 33138255132 ---TRANSACTION 34932007470, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92592, OS thread handle 0x2ac13b27b700, query id 18103054596 10.0.6.147 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007471, sees < 33138255132 ---TRANSACTION 34932007464, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92525, OS thread handle 0x2ac13b0f5700, query id 18103054555 10.0.6.147 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007465, sees < 33138255132 ---TRANSACTION 34932007459, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 4 lock struct(s), heap size 1184, 241 row lock(s), undo log entries 17 MySQL thread id 92605, OS thread handle 0x2ac178b59700, query id 18103054587 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007460, sees < 33138255132 ---TRANSACTION 34932007455, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 13 lock struct(s), heap size 2936, 279 row lock(s), undo log entries 3 MySQL thread id 92489, OS thread handle 0x2abdce295700, query id 18103054539 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007456, sees < 33138255132 ---TRANSACTION 34932007454, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 4 lock struct(s), heap size 1184, 225 row lock(s), undo log entries 17 MySQL thread id 92603, OS thread handle 0x2ac17a233700, query id 18103054512 10.0.6.147 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007455, sees < 33138255132 ---TRANSACTION 34932007453, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92583, OS thread handle 0x2ac13bb1d700, query id 18103054457 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007454, sees < 33138255132 ---TRANSACTION 34932007451, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92575, OS thread handle 0x2ac13ba19700, query id 18103054450 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007452, sees < 33138255132 ---TRANSACTION 34932007446, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 24 lock struct(s), heap size 6544, 1142 row lock(s), undo log entries 12 MySQL thread id 92548, OS thread handle 0x2ac13b5c8700, query id 18103054549 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007447, sees < 33138255132 ---TRANSACTION 34932007430, ACTIVE 94 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 360, 0 row lock(s), undo log entries 1 MySQL thread id 92655, OS thread handle 0x2ac16f44f700, query id 18103054355 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932007431, sees < 33138255132 ---TRANSACTION 34932007428, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 2 lock struct(s), heap size 360, 1 row lock(s) MySQL thread id 92641, OS thread handle 0x2abadbe95700, query id 18103054353 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007429, sees < 33138255132 ---TRANSACTION 34932007408, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 14 lock struct(s), heap size 2936, 61 row lock(s), undo log entries 4 MySQL thread id 92645, OS thread handle 0x2ac17ec98700, query id 18103054341 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007409, sees < 33138255132 ---TRANSACTION 34932007405, ACTIVE 94 sec updating or deleting mysql tables in use 1, locked 1 16 lock struct(s), heap size 2936, 18 row lock(s), undo log entries 5 MySQL thread id 92473, OS thread handle 0x2abadbf17700, query id 18103054321 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932007406, sees < 33138255132 ---TRANSACTION 34932006537, ACTIVE 96 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92457, OS thread handle 0x2ab7e9a95700, query id 18103062063 10.0.6.147 qharvest init rollback Trx read view will not see trx with id >= 34932006538, sees < 33138255132 ---TRANSACTION 34932006465, ACTIVE 96 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92523, OS thread handle 0x2ac13b073700, query id 18103045401 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932006466, sees < 33138255132 ---TRANSACTION 34932005894, ACTIVE 96 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92497, OS thread handle 0x2abdce3da700, query id 18103039778 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932005895, sees < 33138255132 ---TRANSACTION 34932005761, ACTIVE 97 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92537, OS thread handle 0x2ac13b3c0700, query id 18103038628 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932005762, sees < 33138255132 ---TRANSACTION 34932005690, ACTIVE 97 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92518, OS thread handle 0x2ac0fffc7700, query id 18103038145 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932005691, sees < 33138255132 ---TRANSACTION 34932005528, ACTIVE 97 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92522, OS thread handle 0x2ac13b0b4700, query id 18103061855 10.0.6.159 qharvest init rollback Trx read view will not see trx with id >= 34932005529, sees < 33138255132 ---TRANSACTION 34932005454, ACTIVE 97 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92459, OS thread handle 0x2ab7e9ad6700, query id 18103035810 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932005455, sees < 33138255132 ---TRANSACTION 34932005257, ACTIVE 97 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92461, OS thread handle 0x2ab7e9b17700, query id 18103034202 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932005258, sees < 33138255132 ---TRANSACTION 34932005133, ACTIVE 97 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92545, OS thread handle 0x2ac13b546700, query id 18103033301 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932005134, sees < 33138255132 ---TRANSACTION 34932004132, ACTIVE 98 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92505, OS thread handle 0x2ac0c06d6700, query id 18103023710 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932004133, sees < 33138255132 ---TRANSACTION 34932004000, ACTIVE 98 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92449, OS thread handle 0x2ab4fbf45700, query id 18103061654 10.0.6.116 qharvest init rollback Trx read view will not see trx with id >= 34932004001, sees < 33138255132 ---TRANSACTION 34932003125, ACTIVE 99 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92531, OS thread handle 0x2ac13b23a700, query id 18103014788 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932003126, sees < 33138255132 ---TRANSACTION 34932002789, ACTIVE 100 sec updating or deleting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1184, 3 row lock(s), undo log entries 4 MySQL thread id 92533, OS thread handle 0x2ac13b2bc700, query id 18103012557 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932002790, sees < 33138255132 ---TRANSACTION 34932002739, ACTIVE 100 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92571, OS thread handle 0x2ac13b956700, query id 18103011483 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932002740, sees < 33138255132 ---TRANSACTION 34932002635, ACTIVE 100 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92515, OS thread handle 0x2ac0fff04700, query id 18103061346 10.0.6.147 qharvest init rollback Trx read view will not see trx with id >= 34932002636, sees < 33138255132 ---TRANSACTION 34932001692, ACTIVE 101 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92527, OS thread handle 0x2ac13b177700, query id 18103002421 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932001693, sees < 33138255132 ---TRANSACTION 34932001666, ACTIVE 101 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92643, OS thread handle 0x2abf47399700, query id 18103001912 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932001667, sees < 33138255132 ---TRANSACTION 34932001591, ACTIVE 101 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92657, OS thread handle 0x2ac170309700, query id 18103001007 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932001592, sees < 33138255132 ---TRANSACTION 34932001105, ACTIVE 101 sec inserting mysql tables in use 1, locked 1 11 lock struct(s), heap size 1184, 4 row lock(s), undo log entries 6 MySQL thread id 92541, OS thread handle 0x2ac13b4c4700, query id 18102996366 10.0.6.42 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34932001106, sees < 33138255132 ---TRANSACTION 34932000581, ACTIVE 102 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92503, OS thread handle 0x2abf47317700, query id 18102991776 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932000582, sees < 33138255132 ---TRANSACTION 34932000447, ACTIVE 102 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92577, OS thread handle 0x2ac13ba5a700, query id 18102990695 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932000448, sees < 33138255132 ---TRANSACTION 34932000371, ACTIVE 102 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92495, OS thread handle 0x2abdce399700, query id 18102990560 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932000372, sees < 33138255132 ---TRANSACTION 34932000152, ACTIVE 102 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92637, OS thread handle 0x2ac171349700, query id 18102988326 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932000153, sees < 33138255132 ---TRANSACTION 34932000097, ACTIVE 102 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92501, OS thread handle 0x2abf472d6700, query id 18102989172 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34932000098, sees < 33138255132 ---TRANSACTION 34931999315, ACTIVE 103 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92559, OS thread handle 0x2ac13b78f700, query id 18102980572 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931999316, sees < 33138255132 ---TRANSACTION 34931999166, ACTIVE 103 sec inserting mysql tables in use 1, locked 1 11 lock struct(s), heap size 1184, 4 row lock(s), undo log entries 6 MySQL thread id 92491, OS thread handle 0x2abdce317700, query id 18102979061 10.0.6.159 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34931999167, sees < 33138255132 ---TRANSACTION 34931998778, ACTIVE 103 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92465, OS thread handle 0x2ab962a95700, query id 18102975853 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931998779, sees < 33138255132 ---TRANSACTION 34931998423, ACTIVE 103 sec updating or deleting mysql tables in use 1, locked 1 6 lock struct(s), heap size 1184, 3 row lock(s), undo log entries 2 MySQL thread id 92594, OS thread handle 0x2ac170db3700, query id 18102972585 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931998424, sees < 33138255132 ---TRANSACTION 34931998310, ACTIVE 104 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92469, OS thread handle 0x2ab962b99700, query id 18103061273 10.0.6.42 qharvest init rollback Trx read view will not see trx with id >= 34931998311, sees < 33138255132 ---TRANSACTION 34931997375, ACTIVE 104 sec inserting mysql tables in use 1, locked 1 11 lock struct(s), heap size 1184, 4 row lock(s), undo log entries 6 MySQL thread id 92661, OS thread handle 0x2ac17ed9c700, query id 18102964570 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34931997376, sees < 33138255132 ---TRANSACTION 34931996582, ACTIVE 105 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92633, OS thread handle 0x2ac17be62700, query id 18102955867 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931996583, sees < 33138255132 ---TRANSACTION 34931996440, ACTIVE 105 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92647, OS thread handle 0x2ac170ef8700, query id 18103061128 10.0.6.42 qharvest init rollback Trx read view will not see trx with id >= 34931996441, sees < 33138255132 ---TRANSACTION 34931996419, ACTIVE 105 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92485, OS thread handle 0x2abc54f58700, query id 18102954427 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931996420, sees < 33138255132 ---TRANSACTION 34931996264, ACTIVE 105 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92635, OS thread handle 0x2ac17cf24700, query id 18103061125 10.0.6.116 qharvest init rollback Trx read view will not see trx with id >= 34931996265, sees < 33138255132 ---TRANSACTION 34931996102, ACTIVE 105 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92463, OS thread handle 0x2ab7e9b58700, query id 18103061127 10.0.6.147 qharvest init rollback Trx read view will not see trx with id >= 34931996103, sees < 33138255132 ---TRANSACTION 34931995880, ACTIVE 105 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92651, OS thread handle 0x2ac17e94b700, query id 18103061126 10.0.6.116 qharvest init rollback Trx read view will not see trx with id >= 34931995881, sees < 33138255132 ---TRANSACTION 34931995748, ACTIVE 106 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92475, OS thread handle 0x2abadbf58700, query id 18102948464 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931995749, sees < 33138255132 ---TRANSACTION 34931995505, ACTIVE 106 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92467, OS thread handle 0x2ab962b17700, query id 18102946401 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931995506, sees < 33138255132 ---TRANSACTION 34931995432, ACTIVE 106 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92535, OS thread handle 0x2ac13b37f700, query id 18102945760 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931995433, sees < 33138255132 ---TRANSACTION 34931994981, ACTIVE 106 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92479, OS thread handle 0x2abadbfda700, query id 18102941548 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931994982, sees < 33138255132 ---TRANSACTION 34931994828, ACTIVE 106 sec rollback ROLLING BACK 4 lock struct(s), heap size 1184, 1 row lock(s) MySQL thread id 92565, OS thread handle 0x2ac13b852700, query id 18103060970 10.0.6.159 qharvest init rollback Trx read view will not see trx with id >= 34931994829, sees < 33138255132 ---TRANSACTION 34931994623, ACTIVE 106 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92513, OS thread handle 0x2ac0ffec3700, query id 18102938809 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931994624, sees < 33138255132 ---TRANSACTION 34931994341, ACTIVE 107 sec inserting mysql tables in use 1, locked 1 8 lock struct(s), heap size 1184, 3 row lock(s), undo log entries 176 MySQL thread id 92507, OS thread handle 0x2ac0c07da700, query id 18103057385 10.0.6.116 qharvest update INSERT ***FILTERED*** Trx read view will not see trx with id >= 34931994342, sees < 33138255132 ---TRANSACTION 34931994128, ACTIVE 107 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92471, OS thread handle 0x2ab962bda700, query id 18102935081 10.0.6.42 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931994129, sees < 33138255132 ---TRANSACTION 34931992904, ACTIVE 108 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92493, OS thread handle 0x2abdce358700, query id 18102923768 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931992905, sees < 33138255132 ---TRANSACTION 34931992848, ACTIVE 108 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92579, OS thread handle 0x2ac13ba9b700, query id 18102923773 10.0.6.116 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931992849, sees < 33138255132 ---TRANSACTION 34931992120, ACTIVE 109 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92511, OS thread handle 0x2ac0ffe82700, query id 18102918457 10.0.6.147 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931992121, sees < 33138255132 ---TRANSACTION 34931989865, ACTIVE 111 sec updating or deleting mysql tables in use 1, locked 1 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 2 MySQL thread id 92455, OS thread handle 0x2ab670bda700, query id 18102898083 10.0.6.159 qharvest updating UPDATE ***FILTERED*** Trx read view will not see trx with id >= 34931989866, sees < 33138255132 ---TRANSACTION 34931971245, ACTIVE 174 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92563, OS thread handle 0x2ac13b811700, query id 18102734486 10.0.6.116 qharvest cleaning up Trx read view will not see trx with id >= 34931971246, sees < 33138255132 ---TRANSACTION 34931971173, ACTIVE 175 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92581, OS thread handle 0x2ac13badc700, query id 18102733818 10.0.6.116 qharvest cleaning up Trx read view will not see trx with id >= 34931971174, sees < 33138255132 ---TRANSACTION 34931971027, ACTIVE 175 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92519, OS thread handle 0x2ac0fff45700, query id 18102732494 10.0.6.42 qharvest cleaning up Trx read view will not see trx with id >= 34931971028, sees < 33138255132 ---TRANSACTION 34931970454, ACTIVE 176 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92539, OS thread handle 0x2ac13b401700, query id 18102727627 10.0.6.42 qharvest cleaning up Trx read view will not see trx with id >= 34931970455, sees < 33138255132 ---TRANSACTION 34931970444, ACTIVE 176 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92543, OS thread handle 0x2ac13b505700, query id 18102727555 10.0.6.42 qharvest cleaning up Trx read view will not see trx with id >= 34931970445, sees < 33138255132 ---TRANSACTION 34931969886, ACTIVE 177 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92587, OS thread handle 0x2ac13bb9f700, query id 18102722808 10.0.6.116 qharvest cleaning up Trx read view will not see trx with id >= 34931969887, sees < 33138255132 ---TRANSACTION 34931969457, ACTIVE 178 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92569, OS thread handle 0x2ac13b8d4700, query id 18102719304 10.0.6.42 qharvest cleaning up Trx read view will not see trx with id >= 34931969458, sees < 33138255132 ---TRANSACTION 34931969229, ACTIVE 178 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92622, OS thread handle 0x2ac16c0c2700, query id 18102717642 10.0.6.238 qharvest cleaning up Trx read view will not see trx with id >= 34931969230, sees < 33138255132 ---TRANSACTION 34931968429, ACTIVE 180 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92561, OS thread handle 0x2ac13b7d0700, query id 18102710871 10.0.6.42 qharvest cleaning up Trx read view will not see trx with id >= 34931968430, sees < 33138255132 ---TRANSACTION 34931967367, ACTIVE 181 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92573, OS thread handle 0x2ac13b9d8700, query id 18102701393 10.0.6.116 qharvest cleaning up Trx read view will not see trx with id >= 34931967368, sees < 33138255132 ---TRANSACTION 34931966212, ACTIVE 184 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92499, OS thread handle 0x2abf47295700, query id 18102691187 10.0.6.42 qharvest cleaning up Trx read view will not see trx with id >= 34931966213, sees < 33138255132 ---TRANSACTION 34931965910, ACTIVE 184 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92477, OS thread handle 0x2abadbf99700, query id 18102688260 10.0.6.147 qharvest cleaning up Trx read view will not see trx with id >= 34931965911, sees < 33138255132 ---TRANSACTION 34931965506, ACTIVE 185 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92589, OS thread handle 0x2ac13bbe0700, query id 18102684980 10.0.6.159 qharvest cleaning up Trx read view will not see trx with id >= 34931965507, sees < 33138255132 ---TRANSACTION 34931964986, ACTIVE 186 sec rollback ROLLING BACK 5 lock struct(s), heap size 1184, 2 row lock(s), undo log entries 1 MySQL thread id 92585, OS thread handle 0x2ac13bb5e700, query id 18102680529 10.0.6.116 qharvest cleaning up Trx read view will not see trx with id >= 34931964987, sees < 33138255132 ---TRANSACTION 33138255132, ACTIVE 1916235 sec MySQL thread id 1543, OS thread handle 0x2ac13be6a700, query id 18103068575 10.0.10.197 root cleaning up Trx read view will not see trx with id >= 33138255133, sees < 33138253913 -------- 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, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 2283134911 OS file reads, 2188224469 OS file writes, 316444657 OS fsyncs 1 pending preads, 0 pending pwrites 1115.09 reads/s, 16384 avg bytes/read, 191.68 writes/s, 52.39 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 356474, free list len 222386, seg size 578861, 127946151 merges merged operations: insert 950609175, delete mark 811173970, delete 2439979 discarded operations: insert 0, delete mark 834, delete 79 Hash table size 95321071, node heap has 403370 buffer(s) 40532.15 hash searches/s, 2938.81 non-hash searches/s --- LOG --- Log sequence number 23381465618658 Log flushed up to 23381465559996 Pages flushed up to 23381365382691 Last checkpoint at 23381323934839 0 pending log writes, 0 pending chkp writes 5807958 log i/o's done, 0.00 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 49294213120; in additional pool allocated 0 Dictionary memory allocated 3338785 Buffer pool size 2939776 Free buffers 7076 Database pages 2526406 Old database pages 932757 Modified db pages 143470 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 7476890016, not young 146593912761 10.90 youngs/s, 2371.46 non-youngs/s Pages read 2283140073, created 34525673, written 2135323632 1115.09 reads/s, 0.10 creates/s, 184.48 writes/s Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 16 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 2526406, unzip_LRU len: 12619 I/O sum[647256]:cur[6368], unzip sum[72]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 367472 Free buffers 886 Database pages 315539 Old database pages 116498 Modified db pages 17894 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 900142002, not young 18362262714 1.70 youngs/s, 308.57 non-youngs/s Pages read 281019397, created 4309034, written 261135677 146.59 reads/s, 0.00 creates/s, 23.60 writes/s Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 16 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 315539, unzip_LRU len: 1920 I/O sum[80907]:cur[796], unzip sum[9]:cur[0] ---BUFFER POOL 1 Buffer pool size 367472 Free buffers 880 Database pages 315934 Old database pages 116644 Modified db pages 17836 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 950348839, not young 18031915090 1.20 youngs/s, 299.87 non-youngs/s Pages read 284433855, created 4315134, written 268240843 141.59 reads/s, 0.00 creates/s, 21.90 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 18 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 315934, unzip_LRU len: 1415 I/O sum[80907]:cur[796], unzip sum[9]:cur[0] ---BUFFER POOL 2 Buffer pool size 367472 Free buffers 892 Database pages 315766 Old database pages 116582 Modified db pages 19015 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 1005302077, not young 18695645410 2.00 youngs/s, 289.17 non-youngs/s Pages read 289696099, created 4304479, written 278345878 134.49 reads/s, 0.10 creates/s, 24.10 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 17 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 315766, unzip_LRU len: 1548 I/O sum[80907]:cur[796], unzip sum[9]:cur[0] ---BUFFER POOL 3 Buffer pool size 367472 Free buffers 876 Database pages 315951 Old database pages 116650 Modified db pages 17549 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 954825824, not young 18570200033 1.10 youngs/s, 294.77 non-youngs/s Pages read 285641942, created 4334415, written 259623128 137.69 reads/s, 0.00 creates/s, 18.50 writes/s Buffer pool hit rate 993 / 1000, young-making rate 0 / 1000 not 15 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 315951, unzip_LRU len: 1537 I/O sum[80907]:cur[796], unzip sum[9]:cur[0] ---BUFFER POOL 4 Buffer pool size 367472 Free buffers 887 Database pages 315823 Old database pages 116603 Modified db pages 17901 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 908173701, not young 18867912383 1.20 youngs/s, 298.07 non-youngs/s Pages read 286074122, created 4321146, written 270499923 138.59 reads/s, 0.00 creates/s, 26.10 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 18 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 315823, unzip_LRU len: 1548 I/O sum[80907]:cur[796], unzip sum[9]:cur[0] ---BUFFER POOL 5 Buffer pool size 367472 Free buffers 884 Database pages 315973 Old database pages 116658 Modified db pages 18004 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 923093173, not young 17879522717 0.80 youngs/s, 301.77 non-youngs/s Pages read 288246157, created 4314771, written 262705365 141.29 reads/s, 0.00 creates/s, 23.00 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 18 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 315973, unzip_LRU len: 1363 I/O sum[80907]:cur[796], unzip sum[9]:cur[0] ---BUFFER POOL 6 Buffer pool size 367472 Free buffers 890 Database pages 315748 Old database pages 116575 Modified db pages 17704 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 844347875, not young 17872449745 1.80 youngs/s, 290.57 non-youngs/s Pages read 280261608, created 4322147, written 269273057 137.49 reads/s, 0.00 creates/s, 24.30 writes/s Buffer pool hit rate 992 / 1000, young-making rate 0 / 1000 not 18 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 315748, unzip_LRU len: 1674 I/O sum[80907]:cur[796], unzip sum[9]:cur[0] ---BUFFER POOL 7 Buffer pool size 367472 Free buffers 881 Database pages 315672 Old database pages 116547 Modified db pages 17567 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 990656525, not young 18314004669 1.10 youngs/s, 288.67 non-youngs/s Pages read 287766893, created 4304547, written 265499761 137.39 reads/s, 0.00 creates/s, 23.00 writes/s Buffer pool hit rate 994 / 1000, young-making rate 0 / 1000 not 13 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 315672, unzip_LRU len: 1614 I/O sum[80907]:cur[796], unzip sum[9]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 158 read views open inside InnoDB Main thread process no. 30209, id 47009390147328, state: enforcing dict cache limit Number of rows inserted 1420658140, updated 2106022970, deleted 210050058, read 2879603316165 0.10 inserts/s, 0.00 updates/s, 3.20 deletes/s, 39832.62 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================ 1 row in set (0.00 sec) mysql> mysql> show global status; +-----------------------------------------------+----------------+ | Variable_name | Value | +-----------------------------------------------+----------------+ | Aborted_clients | 11831 | | Aborted_connects | 6 | | Binlog_cache_disk_use | 53020 | | Binlog_cache_use | 470613315 | | Binlog_stmt_cache_disk_use | 0 | | Binlog_stmt_cache_use | 13 | | Bytes_received | 11298740301455 | | Bytes_sent | 25867148091180 | | Com_admin_commands | 409 | | Com_assign_to_keycache | 0 | | Com_alter_db | 0 | | Com_alter_db_upgrade | 0 | | Com_alter_event | 0 | | Com_alter_function | 0 | | Com_alter_procedure | 0 | | Com_alter_server | 0 | | Com_alter_table | 3 | | Com_alter_tablespace | 0 | | Com_alter_user | 0 | | Com_analyze | 0 | | Com_begin | 0 | | Com_binlog | 0 | | Com_call_procedure | 0 | | Com_change_db | 55 | | Com_change_master | 0 | | Com_check | 0 | | Com_checksum | 0 | | Com_commit | 609336360 | | Com_create_db | 0 | | Com_create_event | 0 | | Com_create_function | 0 | | Com_create_index | 0 | | Com_create_procedure | 0 | | Com_create_server | 0 | | Com_create_table | 1 | | Com_create_trigger | 0 | | Com_create_udf | 0 | | Com_create_user | 0 | | Com_create_view | 0 | | Com_dealloc_sql | 0 | | Com_delete | 82234230 | | Com_delete_multi | 0 | | Com_do | 0 | | Com_drop_db | 0 | | Com_drop_event | 0 | | Com_drop_function | 0 | | Com_drop_index | 0 | | Com_drop_procedure | 0 | | Com_drop_server | 0 | | Com_drop_table | 9 | | Com_drop_trigger | 0 | | Com_drop_user | 0 | | Com_drop_view | 0 | | Com_empty_query | 0 | | Com_execute_sql | 0 | | Com_flush | 6557 | | Com_get_diagnostics | 0 | | Com_grant | 0 | | Com_ha_close | 0 | | Com_ha_open | 0 | | Com_ha_read | 0 | | Com_help | 0 | | Com_insert | 1423560278 | | Com_insert_select | 1 | | Com_install_plugin | 0 | | Com_kill | 11 | | Com_load | 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_preload_keys | 0 | | Com_prepare_sql | 0 | | Com_purge | 6405 | | Com_purge_before_date | 0 | | Com_release_savepoint | 747097 | | Com_rename_table | 0 | | Com_rename_user | 0 | | Com_repair | 0 | | Com_replace | 0 | | Com_replace_select | 0 | | Com_reset | 0 | | Com_resignal | 0 | | Com_revoke | 0 | | Com_revoke_all | 0 | | Com_rollback | 130012715 | | Com_rollback_to_savepoint | 10 | | Com_savepoint | 747113 | | Com_select | 12119187695 | | Com_set_option | 1479001266 | | Com_signal | 0 | | Com_show_binlog_events | 0 | | Com_show_binlogs | 0 | | Com_show_charsets | 0 | | Com_show_collations | 0 | | Com_show_create_db | 0 | | Com_show_create_event | 0 | | Com_show_create_func | 0 | | Com_show_create_proc | 0 | | Com_show_create_table | 23 | | Com_show_create_trigger | 0 | | Com_show_databases | 30 | | Com_show_engine_logs | 0 | | Com_show_engine_mutex | 0 | | Com_show_engine_status | 190402 | | Com_show_events | 0 | | Com_show_errors | 0 | | Com_show_fields | 3473 | | Com_show_function_code | 0 | | Com_show_function_status | 0 | | Com_show_grants | 0 | | Com_show_keys | 0 | | Com_show_master_status | 24 | | Com_show_open_tables | 2 | | Com_show_plugins | 0 | | Com_show_privileges | 0 | | Com_show_procedure_code | 0 | | Com_show_procedure_status | 0 | | Com_show_processlist | 217 | | Com_show_profile | 0 | | Com_show_profiles | 0 | | Com_show_relaylog_events | 0 | | Com_show_slave_hosts | 0 | | Com_show_slave_status | 0 | | Com_show_status | 1909112 | | Com_show_storage_engines | 0 | | Com_show_table_status | 13 | | Com_show_tables | 55 | | Com_show_triggers | 0 | | Com_show_variables | 190411 | | Com_show_warnings | 234514562 | | Com_slave_start | 0 | | Com_slave_stop | 0 | | Com_stmt_close | 0 | | Com_stmt_execute | 0 | | Com_stmt_fetch | 0 | | Com_stmt_prepare | 0 | | Com_stmt_reprepare | 0 | | Com_stmt_reset | 0 | | Com_stmt_send_long_data | 0 | | Com_truncate | 0 | | Com_uninstall_plugin | 0 | | Com_unlock_tables | 24 | | Com_update | 2060266345 | | Com_update_multi | 0 | | Com_xa_commit | 0 | | Com_xa_end | 0 | | Com_xa_prepare | 0 | | Com_xa_recover | 0 | | Com_xa_rollback | 0 | | Com_xa_start | 0 | | Compression | OFF | | Connection_errors_accept | 0 | | Connection_errors_internal | 0 | | Connection_errors_max_connections | 0 | | Connection_errors_peer_address | 0 | | Connection_errors_select | 0 | | Connection_errors_tcpwrap | 0 | | Connections | 95779 | | Created_tmp_disk_tables | 32880 | | Created_tmp_files | 25926 | | Created_tmp_tables | 2657483 | | Delayed_errors | 0 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Flush_commands | 1 | | Handler_commit | 20327757553 | | Handler_delete | 210699487 | | Handler_discover | 0 | | Handler_external_lock | 62355149539 | | Handler_mrr_init | 0 | | Handler_prepare | 8063774774 | | Handler_read_first | 105267326 | | Handler_read_key | 44167021386 | | Handler_read_last | 37953 | | Handler_read_next | 230788000229 | | Handler_read_prev | 3754697634 | | Handler_read_rnd | 225063187 | | Handler_read_rnd_next | 2626302225256 | | Handler_rollback | 132252050 | | Handler_savepoint | 1126061 | | Handler_savepoint_rollback | 10 | | Handler_update | 5403482802 | | Handler_write | 7790258595 | | Innodb_buffer_pool_dump_status | not started | | Innodb_buffer_pool_load_status | not started | | Innodb_buffer_pool_pages_data | 2519936 | | Innodb_buffer_pool_bytes_data | 41329762304 | | Innodb_buffer_pool_pages_dirty | 201228 | | Innodb_buffer_pool_bytes_dirty | 3252944896 | | Innodb_buffer_pool_pages_flushed | 2161870709 | | Innodb_buffer_pool_pages_free | 6610 | | Innodb_buffer_pool_pages_misc | 413230 | | Innodb_buffer_pool_pages_total | 2939776 | | Innodb_buffer_pool_read_ahead_rnd | 0 | | Innodb_buffer_pool_read_ahead | 24563584 | | Innodb_buffer_pool_read_ahead_evicted | 398 | | Innodb_buffer_pool_read_requests | 1563358280523 | | Innodb_buffer_pool_reads | 2231463328 | | Innodb_buffer_pool_wait_free | 158725 | | Innodb_buffer_pool_write_requests | 23820213364 | | Innodb_data_fsyncs | 317284195 | | Innodb_data_pending_fsyncs | 0 | | Innodb_data_pending_reads | 1 | | Innodb_data_pending_writes | 0 | | Innodb_data_read | 36768400191488 | | Innodb_data_reads | 2294107612 | | Innodb_data_writes | 2193401307 | | Innodb_data_written | 71065690330624 | | Innodb_dblwr_pages_written | 2140327248 | | Innodb_dblwr_writes | 30108550 | | Innodb_have_atomic_builtins | ON | | Innodb_log_waits | 0 | | Innodb_log_write_requests | 3012067074 | | Innodb_log_writes | 5545406 | | Innodb_os_log_fsyncs | 5811504 | | Innodb_os_log_pending_fsyncs | 0 | | Innodb_os_log_pending_writes | 0 | | Innodb_os_log_written | 1335517328384 | | Innodb_page_size | 16384 | | Innodb_pages_created | 34596592 | | Innodb_pages_read | 2294112832 | | Innodb_pages_written | 2140327248 | | Innodb_row_lock_current_waits | 5 | | Innodb_row_lock_time | 191178930 | | Innodb_row_lock_time_avg | 299 | | Innodb_row_lock_time_max | 51973 | | Innodb_row_lock_waits | 638566 | | Innodb_rows_deleted | 210699483 | | Innodb_rows_inserted | 1423658430 | | Innodb_rows_read | 2882127905412 | | Innodb_rows_updated | 2110258200 | | Innodb_num_open_files | 308 | | Innodb_truncated_status_writes | 5 | | Innodb_available_undo_logs | 128 | | Key_blocks_not_flushed | 0 | | Key_blocks_unused | 53585 | | Key_blocks_used | 16752 | | Key_read_requests | 167185965 | | Key_reads | 17 | | Key_write_requests | 46182452 | | Key_writes | 0 | | Last_query_cost | 0.000000 | | Last_query_partial_plans | 0 | | Max_used_connections | 1089 | | Not_flushed_delayed_rows | 0 | | Open_files | 236 | | Open_streams | 0 | | Open_table_definitions | 194 | | Open_tables | 3699 | | Opened_files | 399325 | | Opened_table_definitions | 738 | | Opened_tables | 165924 | | Performance_schema_accounts_lost | 0 | | Performance_schema_cond_classes_lost | 0 | | Performance_schema_cond_instances_lost | 0 | | Performance_schema_digest_lost | 0 | | Performance_schema_file_classes_lost | 0 | | Performance_schema_file_handles_lost | 0 | | Performance_schema_file_instances_lost | 0 | | Performance_schema_hosts_lost | 0 | | Performance_schema_locker_lost | 0 | | Performance_schema_mutex_classes_lost | 0 | | Performance_schema_mutex_instances_lost | 0 | | Performance_schema_rwlock_classes_lost | 0 | | Performance_schema_rwlock_instances_lost | 0 | | Performance_schema_session_connect_attrs_lost | 0 | | Performance_schema_socket_classes_lost | 0 | | Performance_schema_socket_instances_lost | 0 | | Performance_schema_stage_classes_lost | 0 | | Performance_schema_statement_classes_lost | 0 | | Performance_schema_table_handles_lost | 0 | | Performance_schema_table_instances_lost | 0 | | Performance_schema_thread_classes_lost | 0 | | Performance_schema_thread_instances_lost | 0 | | Performance_schema_users_lost | 0 | | Prepared_stmt_count | 0 | | Qcache_free_blocks | 1 | | Qcache_free_memory | 1031352 | | Qcache_hits | 0 | | Qcache_inserts | 0 | | Qcache_lowmem_prunes | 0 | | Qcache_not_cached | 12117384444 | | Qcache_queries_in_cache | 0 | | Qcache_total_blocks | 1 | | Queries | 18141998755 | | Questions | 18141992133 | | Select_full_join | 3 | | Select_full_range_join | 384441 | | Select_range | 1220654389 | | Select_range_check | 0 | | Select_scan | 107543409 | | Slave_heartbeat_period | 1800.000 | | Slave_last_heartbeat | | | Slave_open_temp_tables | 0 | | Slave_received_heartbeats | 0 | | Slave_retried_transactions | 0 | | Slave_running | OFF | | Slow_launch_threads | 0 | | Slow_queries | 24955 | | Sort_merge_passes | 34 | | Sort_range | 602398 | | Sort_rows | 229034425 | | Sort_scan | 105304479 | | Ssl_accept_renegotiates | 0 | | Ssl_accepts | 0 | | Ssl_callback_cache_hits | 0 | | Ssl_cipher | | | Ssl_cipher_list | | | Ssl_client_connects | 0 | | Ssl_connect_renegotiates | 0 | | Ssl_ctx_verify_depth | 0 | | Ssl_ctx_verify_mode | 0 | | Ssl_default_timeout | 0 | | Ssl_finished_accepts | 0 | | Ssl_finished_connects | 0 | | Ssl_server_not_after | | | Ssl_server_not_before | | | Ssl_session_cache_hits | 0 | | Ssl_session_cache_misses | 0 | | Ssl_session_cache_mode | Unknown | | Ssl_session_cache_overflows | 0 | | Ssl_session_cache_size | 0 | | Ssl_session_cache_timeouts | 0 | | Ssl_sessions_reused | 0 | | Ssl_used_session_cache_entries | 0 | | Ssl_verify_depth | 0 | | Ssl_verify_mode | 0 | | Ssl_version | | | Table_locks_immediate | 29208574559 | | Table_locks_waited | 13487 | | Table_open_cache_hits | 18293276396 | | Table_open_cache_misses | 28293 | | Table_open_cache_overflows | 24370 | | Tc_log_max_pages_used | 0 | | Tc_log_page_size | 0 | | Tc_log_page_waits | 0 | | Threads_cached | 42 | | Threads_connected | 109 | | Threads_created | 6450 | | Threads_running | 2 | | Uptime | 1952746 | | Uptime_since_flush_status | 1952746 | +-----------------------------------------------+----------------+ 341 rows in set (0.00 sec)