mysql数据库latch争用？

2021-01-22 17:33:24 0x7fd59b2a5700 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 32 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 1751153 srv_active, 0 srv_shutdown, 6746 srv_idle srv_master_thread log flush and writes: 1757446 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 55042430 --Thread 140554894399232 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555370465024 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555404543744 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555398952704 has waited at btr0cur.cc line 3874 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555402946304 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555383510784 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554886944512 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554638481152 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555359016704 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555358217984 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554886412032 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555403212544 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554890139392 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555378452224 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555358484224 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555371529984 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554931287808 has waited at btr0sea.cc line 1204 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555773662976 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555410401024 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555380848384 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555366205184 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555363809024 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555408803584 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555409868544 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555380582144 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555361146624 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555365140224 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555355289344 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555347834624 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555402680064 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555392296704 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554639279872 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555377387264 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555357419264 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555405076224 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555369932544 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555385374464 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555404809984 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555406939904 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555371796224 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554895197952 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555353425664 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555393894144 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555399485184 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554636351232 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555395757824 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554888009472 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554893334272 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock (wait_ex) on RW-latch at 0x3a2df128 created in file btr0sea.cc line 195 a writer (thread id 140554893334272) has reserved it in mode exclusive number of readers 0, waiters flag 0, lock_word: 0 Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555356886784 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555408537344 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555408271104 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140555386971904 has waited at btr0sea.ic line 90 for 0.00 seconds the semaphore: X-lock on RW-latch at 0x3a2dfd68 created in file btr0sea.cc line 195 a writer (thread id 140555366205184) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 --Thread 140554637682432 has waited at btr0sea.ic line 128 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x3a2dfba8 created in file btr0sea.cc line 195 a writer (thread id 140555380848384) has reserved it in mode wait exclusive number of readers 1, waiters flag 1, lock_word: ffffffffffffffff Last time read locked in file btr0sea.ic line 128 Last time write locked in file /export/home2/pb2/build/sb_1-33648028-1555165710.26/rpm/BUILD/mysql-5.7.26/mysql-5.7.26/storage/innobase/include/btr0sea.ic line 90 OS WAIT ARRAY INFO: signal count 1180125385 RW-shared spins 0, rounds 316058723, OS waits 16396792 RW-excl spins 0, rounds 872759866, OS waits 18514705 RW-sx spins 11450502, rounds 252510073, OS waits 5103369 Spin rounds per wait: 316058723.00 RW-shared, 872759866.00 RW-excl, 22.05 RW-sx ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2021-01-22 09:46:57 0x7fd59b264700 *** (1) TRANSACTION: TRANSACTION 1752396739, ACTIVE 9 sec fetching rows mysql tables in use 1, locked 1 LOCK WAIT 2439 lock struct(s), heap size 237776, 8 row lock(s), undo log entries 7 MySQL thread id 2638754, OS thread handle 140555368335104, query id 3075688908 172.26.150.183 root Sending data DELETE cm_bs_vehicle_consumption FROM fsl_cm_bs_vehicle_consumption cm_bs_vehicle_consumption WHERE (cm_bs_vehicle_consumption.vehicle_consumption_id = 165137307354546176 ) AND cm_bs_vehicle_consumption.domain_name IN ('FSL') *** (1) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 2174 page no 3833 n bits 112 index PRIMARY of table `tms_prod`.`fsl_cm_bs_vehicle_consumption` trx id 1752396739 lock_mode X locks rec but not gap waiting Record lock, heap no 40 PHYSICAL RECORD: n_fields 16; compact format; info bits 0 0: len 8; hex 82933169ac021000; asc 1i ;; 1: len 6; hex 000068737318; asc hss ;; 2: len 7; hex b800030037031f; asc 7 ;; 3: len 8; hex 82933168f4421000; asc 1h B ;; 4: len 8; hex 818a46885a421000; asc F ZB ;; 5: len 30; hex e6ada6e6b189e58886e5ba932de4bb99e6a183e4b889e78eafe58ab2e980; asc - ; (total 37 bytes); 6: len 9; hex 800000000062000000; asc b ;; 7: len 9; hex 80000000003c000000; asc < ;; 8: len 9; hex 800000000000000000; asc ;; 9: len 9; hex 800000000000000000; asc ;; 10: len 3; hex 46534c; asc FSL;; 11: len 4; hex 80000000; asc ;; 12: len 10; hex 46534c2e373031343535; asc FSL.701455;; 13: len 5; hex 99a8ac9bb1; asc ;; 14: SQL NULL; 15: SQL NULL; *** (2) TRANSACTION: TRANSACTION 1752396568, ACTIVE 11 sec fetching rows mysql tables in use 1, locked 1 35206 lock struct(s), heap size 3416272, 7 row lock(s), undo log entries 92 MySQL thread id 2638995, OS thread handle 140555407738624, query id 3075709667 172.26.150.180 root Sending data DELETE cm_bs_vehicle_consumption FROM fsl_cm_bs_vehicle_consumption cm_bs_vehicle_consumption WHERE (cm_bs_vehicle_consumption.vehicle_consumption_id = 185546374740316160 ) AND cm_bs_vehicle_consumption.domain_name IN ('FSL') *** (2) HOLDS THE LOCK(S): RECORD LOCKS space id 2174 page no 3833 n bits 112 index PRIMARY of table `tms_prod`.`fsl_cm_bs_vehicle_consumption` trx id 1752396568 lock_mode X locks rec but not gap Record lock, heap no 40 PHYSICAL RECORD: n_fields 16; compact format; info bits 0 0: len 8; hex 82933169ac021000; asc 1i ;; 1: len 6; hex 000068737318; asc hss ;; 2: len 7; hex b800030037031f; asc 7 ;; 3: len 8; hex 82933168f4421000; asc 1h B ;; 4: len 8; hex 818a46885a421000; asc F ZB ;; 5: len 30; hex e6ada6e6b189e58886e5ba932de4bb99e6a183e4b889e78eafe58ab2e980; asc - ; (total 37 bytes); 6: len 9; hex 800000000062000000; asc b ;; 7: len 9; hex 80000000003c000000; asc < ;; 8: len 9; hex 800000000000000000; asc ;; 9: len 9; hex 800000000000000000; asc ;; 10: len 3; hex 46534c; asc FSL;; 11: len 4; hex 80000000; asc ;; 12: len 10; hex 46534c2e373031343535; asc FSL.701455;; 13: len 5; hex 99a8ac9bb1; asc ;; 14: SQL NULL; 15: SQL NULL; *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 2174 page no 3114 n bits 176 index PRIMARY of table `tms_prod`.`fsl_cm_bs_vehicle_consumption` trx id 1752396568 lock_mode X locks rec but not gap waiting Record lock, heap no 27 PHYSICAL RECORD: n_fields 16; compact format; info bits 32 0: len 8; hex 82928f5a4a484000; asc ZJH@ ;; 1: len 6; hex 0000687373c3; asc hss ;; 2: len 7; hex 2f000700252046; asc / % F;; 3: len 8; hex 824aaf8190084000; asc J @ ;; 4: len 8; hex 826c8d150a821000; asc l ;; 5: len 30; hex e58d8ee4b8ade68898e795a5e5ba932de98391e5b79ee5a881e4bdb3e5ae; asc - ; (total 34 bytes); 6: len 9; hex 80000000000d000000; asc ;; 7: len 9; hex 800000000000000000; asc ;; 8: len 9; hex 800000000000000000; asc ;; 9: len 9; hex 800000000000000000; asc ;; 10: len 3; hex 46534c; asc FSL;; 11: len 4; hex 80000000; asc ;; 12: len 10; hex 46534c2e636d5461736b; asc FSL.cmTask;; 13: len 5; hex 99a8ab5eae; asc ^ ;; 14: SQL NULL; 15: SQL NULL; *** WE ROLL BACK TRANSACTION (1) ------------ TRANSACTIONS ------------ Trx id counter 1754535171 Purge done for trx's n:o < 1754239914 undo n:o < 0 state: running but idle History list length 23667 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 422066815646896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815759072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815699792, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815682464, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815760896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815898608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815753600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815747216, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815769104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815768192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815758160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815766368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815765456, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815762720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815756336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815740832, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815746304, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815757248, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815752688, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815743568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815739920, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815739008, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815736272, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815733536, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815718032, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815731712, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815730800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815750864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815721680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815708000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815704352, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815703440, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815697968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815896784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815894048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815714384, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815891312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815715296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815889488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815885840, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815883104, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815882192, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815881280, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815712560, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815879456, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815876720, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815880368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815878544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815877632, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815875808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815874896, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815873072, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815870336, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815867600, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815864864, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815862128, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815858480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815859392, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815857568, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815755424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815667872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815851184, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815678816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815849360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815846624, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815645984, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815844800, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815843888, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815802848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815774576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815673344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815842976, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815842064, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815841152, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815840240, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815837504, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815835680, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815833856, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815830208, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815829296, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815825648, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815823824, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815822912, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815822000, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815820176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815821088, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815816528, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815814704, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815811968, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815811056, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815809232, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815808320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815807408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815797376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815789168, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815710736, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815671520, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815665136, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815659664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815792816, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815694320, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815691584, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815693408, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815652368, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815690672, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815687936, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815685200, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815683376, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815670608, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815790992, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815787344, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815783696, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815781872, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815780048, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815780960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815778224, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815777312, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815776400, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815775488, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815773664, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815748128, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815744480, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815735360, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815722592, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815677904, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815705264, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815666960, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815647808, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815650544, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815660576, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815725328, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815724416, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815706176, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815688848, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815681552, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815641424, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815668784, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 422066815644160, not started 0 lock struct(s), heap size 1136, 0 row lock(s) ---TRANSACTION 1754535124, ACTIVE (PREPARED) 0 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2681149, OS thread handle 140555363276544, query id 3117839123 172.26.150.185 root query end INSERT INTO fsl_adapter_protocol_log (id,protocol,protocol_name,status,type,asyn,request_data,request_data2,response_data,error,max_retry_count,retry_count,domain_name,version,insert_user,insert_date) VALUES(185663763952459776,'z_interface_mq',null,'N','rabbitinput',null,'{"key":"hr_dept","sourceSystem":"MDM","sendTime":"2021-01-22 16:15:03","optionType":"ADD","data":{"deptlevel":[{"code":"4","mdm_status":"","mdm_createdby_type":"OuterSystem","mdm_seal":0.0,"mdm_createdon":"2019-05-15 14:27:28","mdm_modifiedon":"","enumeration_code":"hr_org_deptlevel","description":"","mdm_duplicate":0.0,"mdm_ ---TRANSACTION 1754534698, ACTIVE (PREPARED) 0 sec mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s), undo log entries 1 MySQL thread id 2681181, OS thread handle 140554887210752, query id 3117839056 172.26.150.184 root query end UPDATE fsl_task_monitor task_monitor SET status='handling',server_name='172.26.150.184:8040',server_uuid='logwire_b10360a4-fbd4-455e-9333-008235d3ddb5',start_time='2021-01-22 17:33:24.462',version=version+1,update_date='2021-01-22 17:33:24.462',update_user='FSL.ADMIN' WHERE task_monitor.id=185663729600974848 AND task_monitor.version=0 ---TRANSACTION 1754534694, ACTIVE (PREPARED) 0 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2681135, OS thread handle 140555396556544, query id 3117838986 172.26.150.184 root query end INSERT INTO fsl_adapter_protocol_log (id,protocol,protocol_name,status,type,asyn,request_data,request_data2,response_data,error,max_retry_count,retry_count,domain_name,version,insert_user,insert_date) VALUES(185663762333323264,'z_interface_mq',null,'N','rabbitinput',null,'{"key":"hr_dept","sourceSystem":"MDM","sendTime":"2021-01-22 16:15:03","optionType":"ADD","data":{"deptlevel":[{"code":"4","mdm_status":"","mdm_createdby_type":"OuterSystem","mdm_seal":0.0,"mdm_createdon":"2019-05-15 14:27:28","mdm_modifiedon":"","enumeration_code":"hr_org_deptlevel","description":"","mdm_duplicate":0.0,"mdm_ ---TRANSACTION 1754534624, ACTIVE 0 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2682365, OS thread handle 140555406939904, query id 3117838944 172.26.150.184 root update INSERT INTO fsl_order_movement_line (id,shipment,origin,dest,origin_dock,dest_dock,order_movement,order_release,order_line,product,product_code,product_name,box_type,box_type_code,box_type_name,unit_weight,unit_volume,price,ship_qty,ship_weight,ship_volume,load_qty,load_weight,load_volume,unload_qty,unload_weight,unload_volume,ready_qty,ready_weight,ready_volume,domain_name,version,insert_user,insert_date) VALUES(185663760265531392,185662638901579776,185662642177331200,185662642395435008,null,null,185663760164868096,183431172855582720,185203360613031936,32109163555459072,'1100*1100*144','标?? ---TRANSACTION 1754534548, ACTIVE (PREPARED) 1 sec 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2682566, OS thread handle 140554890671872, query id 3117838914 172.26.150.182 root starting commit ---TRANSACTION 1754534542, ACTIVE (PREPARED) 1 sec mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2681476, OS thread handle 140555352094464, query id 3117838851 172.26.150.183 root query end INSERT INTO fsl_cm_task_log (id,voucher_id,cm_voucher_type,cm_task_code,cm_log_type,cm_log_status,info,info_type,domain_name,version,insert_user,insert_date) VALUES(185663760110206976,141582529085325312,'7','updateBmsByvehicleCostTask','error','1','定额数据不完整，未维护或者未审批。','E003','FSL',0,'FSL.cmTask','2021-01-22 17:33:23.876') ---TRANSACTION 1754534485, ACTIVE 1 sec updating or deleting mysql tables in use 1, locked 1 27 lock struct(s), heap size 3520, 1 row lock(s), undo log entries 1 MySQL thread id 2682845, OS thread handle 140555398952704, query id 3117838784 172.26.150.182 root updating UPDATE fsl_order_base order_base SET model1='pack',model2=null,model3=null,input_type='interface',order_no1='DD.OB201216-11340',order_no2='XCSBD78',order_no3=null,order_no4=null,order_no5=null,order_type1='N',order_type2=null,order_type3=null,order_type4=null,order_type5=null,order_status='2',transport_type='road',urgent_level=null,order_date='2020-12-16 03:55:55.0',project=24789418254667776,project_name='调达',truck_type=null,truck_type_name=null,organization=null,organization_name=null,customer=30874729619931136,customer_name='日产中国',consigner=null,consigner_name=null,consignee=null ---TRANSACTION 1754534247, ACTIVE 4 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2681239, OS thread handle 140555377387264, query id 3117838582 172.26.150.185 root update INSERT INTO fsl_order_base (id,model1,model2,model3,input_type,order_no1,order_no2,order_no3,order_no4,order_no5,order_type1,order_type2,order_type3,order_type4,order_type5,order_status,transport_type,urgent_level,order_date,project,project_name,truck_type,truck_type_name,organization,organization_name,customer,customer_name,consigner,consigner_name,consignee,consignee_name,carrier,carrier_name,release_qty,qty,weight,volume,cargo_value,rate_qty,rate_weight,rate_volume,remark,rate1,rate2,rate3,rate4,balance_date,auto_release,plant_supplier_id,plant_supplier_code,project_code,supplier,supplier_c ---TRANSACTION 1754534206, ACTIVE 1 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 1 MySQL thread id 2681133, OS thread handle 140555393894144, query id 3117838571 172.26.150.184 root update INSERT INTO fsl_tm_interface_log (id,interface_name,object_id,interface_type,request,response,domain_name,version,insert_user,insert_date) VALUES(185663759363756032,'飞梭交货信息推送PV','616429829','db','{location_xid= , location_name=赣州东维红金, creator=FSL.ADMIN, domain=FS, modifier=FSL.ADMIN, out_wh_code=616429829, delivery_time=2021-01-22 10:59:05.0, syn_num=20210122173323, whether_arrival=已到达, status=0}','true','FSL',0,'FSL.ADMIN','2021-01-22 17:33:23.697') ---TRANSACTION 1754532223, ACTIVE 4 sec inserting mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 22 MySQL thread id 2680797, OS thread handle 140555395757824, query id 3117839096 172.26.150.181 root update INSERT INTO fsl_tm_in_storage_dtl_trays (id,pid,transport_bill_code,tray_code,scan_time,inserted_date,disabled,message) VALUES(185663762706210816,185663745350180864,'TCP210122R401C10206','LB006A1210126S0005','2021-01-22 17:15:10.0','2021-01-22 17:33:24.494',0,null) ---TRANSACTION 1754497572, ACTIVE 90 sec unlock_row mysql tables in use 1, locked 1 25587 lock struct(s), heap size 2482384, 1 row lock(s) MySQL thread id 2682497, OS thread handle 140555375789824, query id 3117798884 172.26.150.183 root Sending data DELETE cm_bs_apportion_weight FROM fsl_cm_bs_apportion_weight cm_bs_apportion_weight WHERE (((cm_bs_apportion_weight.voucher_id = 170214917088493568 ) AND (cm_bs_apportion_weight.billmodel = 'cm_voucher_vehicle_consumption' )) AND (cm_bs_apportion_weight.cm_voucher_type = '7' )) AND cm_bs_apportion_weight.domain_name IN ('FSL') ---TRANSACTION 1754480994, ACTIVE 131 sec inserting mysql tables in use 1, locked 1 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 2868 MySQL thread id 2681501, OS thread handle 140554894399232, query id 3117838831 172.26.150.184 root update INSERT INTO fsl_indent_factcheck_status (id,consume_id,part_code,part_num,factcheck_time,prepare_code,out_code,send_status,send_date,disabled,insert_user,insert_date) VALUES(185663219581997072,'1810484286116','4140414BB0A-C013',1,'2021-01-22 09:12:22.0','HN2101210747','1000401197','0',null,0,'FSL.ADMIN','2021-01-22 17:31:14.907') ---TRANSACTION 1754414695, ACTIVE 262 sec inserting mysql tables in use 1, locked 1 7 lock struct(s), heap size 1136, 189 row lock(s), undo log entries 428 MySQL thread id 2681146, OS thread handle 140555386971904, query id 3117839048 172.26.150.185 root update INSERT INTO fsl_order_base_line (id,order_base,parent,product,product_code,product_name,box_type,box_type_code,box_type_name,length,width,height,weight,volume,unit_weight,unit_volume,qty,box_qty,release_qty,price,pickup_node,pickup_node_code,pickup_node_name,dispatch_node,dispatch_node_code,dispatch_node_name,plan_arrival_pickup_node,plan_departure_pickup_node,plan_arrival_dispatch_node,plan_departure_dispatch_node,origin,origin_code,origin_name,origin_zone,origin_zone_code,origin_zone_name,origin_country_code,origin_country,origin_province_code,origin_province,origin_city_code,origin_city,ori ---TRANSACTION 1754265102, ACTIVE 875 sec 247 lock struct(s), heap size 24784, 1870 row lock(s), undo log entries 1072 MySQL thread id 2679488, OS thread handle 140555384309504, query id 3117839101 172.26.150.185 root freeing items SELECT line.id as id,line.model1 as model1,line.model2 as model2,line.model3 as model3,line.code as code,line.name as name,line.customer as customer,line.carrier as carrier,line.disabled as disabled,line.apply_date as apply_date,line.effective_date as effective_date,line.expiration_date as expiration_date,line.origin as origin,line.dest as dest,line.distance as distance,line.distance_gps as distance_gps,line.distance_top as distance_top,line.speed as speed,line.total_time as total_time,line.driving_time as driving_time,line.rate_distance as rate_distance,line.lead_hours as lead_hours,line.crit ---TRANSACTION 1754250761, ACTIVE 1314 sec inserting mysql tables in use 3, locked 3 267 lock struct(s), heap size 24784, 2761 row lock(s), undo log entries 2723 MySQL thread id 2679165, OS thread handle 140554636351232, query id 3117838543 172.26.150.184 root closing tables INSERT INTO fsl_order_movement_unit (id,shipment,order_release,origin,dest,origin_dock,dest_dock,order_movement,order_movement_line,order_unit,product,product_code,product_name,box_type,box_type_code,box_type_name,unit_no,unit_weight,unit_volume,ship,ready,`load`,unload,ready_time,load_time,unload_time,`3d_x`,`3d_y`,`3d_z`,status,load_user,unload_user,unload_flag,domain_name,version,insert_user,insert_date) VALUES(185663758126436352,185642205242347520,185608172252573696,185642206488055808,185642206513221632,null,null,185663126262927360,185663126271315968,185660101867753472,null,null,null,null, Trx read view will not see trx with id >= 1754534196, sees < 1754225182 ---TRANSACTION 1754238960, ACTIVE 1618 sec 392 lock struct(s), heap size 41168, 18712 row lock(s), undo log entries 18712 MySQL thread id 2678170, OS thread handle 140554893068032, query id 3117839136 172.26.150.184 root ---TRANSACTION 1754225182, ACTIVE 1963 sec 373 lock struct(s), heap size 41168, 22224 row lock(s), undo log entries 22224 MySQL thread id 2679489, OS thread handle 140555388835584, query id 3117839138 172.26.150.185 root -------- 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 (read thread) I/O thread 7 state: waiting for completed aio requests (read thread) I/O thread 8 state: waiting for completed aio requests (read thread) I/O thread 9 state: waiting for completed aio requests (read thread) I/O thread 10 state: waiting for completed aio requests (read thread) I/O thread 11 state: waiting for completed aio requests (read thread) I/O thread 12 state: waiting for completed aio requests (write thread) I/O thread 13 state: waiting for completed aio requests (write thread) I/O thread 14 state: waiting for completed aio requests (write thread) I/O thread 15 state: waiting for completed aio requests (write thread) I/O thread 16 state: waiting for completed aio requests (write thread) I/O thread 17 state: waiting for completed aio requests (write thread) Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0] , ibuf aio reads:, log i/o's:, sync i/o's: Pending flushes (fsync) log: 1; buffer pool: 1 79247030 OS file reads, 153128641 OS file writes, 83126131 OS fsyncs 56.59 reads/s, 16384 avg bytes/read, 30.81 writes/s, 24.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 246620, seg size 246622, 2460862 merges merged operations: insert 9310141, delete mark 45081865, delete 6488913 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 9461113, node heap has 4196 buffer(s) Hash table size 9461113, node heap has 11663 buffer(s) Hash table size 9461113, node heap has 22245 buffer(s) Hash table size 9461113, node heap has 5258 buffer(s) Hash table size 9461113, node heap has 10480 buffer(s) Hash table size 9461113, node heap has 6694 buffer(s) Hash table size 9461113, node heap has 23329 buffer(s) Hash table size 9461113, node heap has 9520 buffer(s) 141348.08 hash searches/s, 333359.05 non-hash searches/s --- LOG --- Log sequence number 4385332229888 Log flushed up to 4385332229373 Pages flushed up to 4385235645376 Last checkpoint at 4385235451826 0 pending log flushes, 0 pending chkp writes 59073264 log i/o's done, 9.38 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total large memory allocated 35181821952 Dictionary memory allocated 15708010 Buffer pool size 2097024 Free buffers 8184 Database pages 1995298 Old database pages 736382 Modified db pages 10729 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 405881496, not young 4440582670 845.44 youngs/s, 3040.28 non-youngs/s Pages read 79244435, created 19691634, written 84092930 56.53 reads/s, 5.12 creates/s, 16.78 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 30.03/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 1995298, unzip_LRU len: 0 I/O sum[23456]:cur[83], unzip sum[0]:cur[0] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 262112 Free buffers 1025 Database pages 249451 Old database pages 92062 Modified db pages 2663 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 52467375, not young 569779698 137.65 youngs/s, 350.30 non-youngs/s Pages read 10090970, created 2612190, written 11638354 6.69 reads/s, 2.50 creates/s, 2.03 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 4.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 249451, unzip_LRU len: 0 I/O sum[2932]:cur[10], unzip sum[0]:cur[0] ---BUFFER POOL 1 Buffer pool size 262144 Free buffers 1021 Database pages 249465 Old database pages 92067 Modified db pages 218 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 54355404, not young 579914005 123.87 youngs/s, 1124.65 non-youngs/s Pages read 10319935, created 2475326, written 10852719 6.09 reads/s, 1.47 creates/s, 2.91 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 6 / 1000 Pages read ahead 2.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 249465, unzip_LRU len: 0 I/O sum[2932]:cur[10], unzip sum[0]:cur[0] ---BUFFER POOL 2 Buffer pool size 262112 Free buffers 1021 Database pages 249312 Old database pages 92011 Modified db pages 1539 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 44901532, not young 544396109 106.09 youngs/s, 323.33 non-youngs/s Pages read 9577623, created 2413515, written 10521453 7.44 reads/s, 0.16 creates/s, 1.69 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 2 / 1000 Pages read ahead 6.75/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 249312, unzip_LRU len: 0 I/O sum[2932]:cur[10], unzip sum[0]:cur[0] ---BUFFER POOL 3 Buffer pool size 262144 Free buffers 1023 Database pages 249478 Old database pages 92072 Modified db pages 1445 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 48747352, not young 557370025 82.65 youngs/s, 160.15 non-youngs/s Pages read 9864423, created 2429693, written 10291234 3.62 reads/s, 0.12 creates/s, 1.91 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 1 / 1000 Pages read ahead 2.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 249478, unzip_LRU len: 0 I/O sum[2932]:cur[10], unzip sum[0]:cur[0] ---BUFFER POOL 4 Buffer pool size 262112 Free buffers 1021 Database pages 249382 Old database pages 92037 Modified db pages 275 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 54199717, not young 557993436 103.81 youngs/s, 326.33 non-youngs/s Pages read 9893778, created 2452624, written 10286918 9.91 reads/s, 0.06 creates/s, 2.25 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 2 / 1000 Pages read ahead 4.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 249382, unzip_LRU len: 0 I/O sum[2932]:cur[10], unzip sum[0]:cur[0] ---BUFFER POOL 5 Buffer pool size 262144 Free buffers 1025 Database pages 249425 Old database pages 92052 Modified db pages 1327 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 53436964, not young 539021775 97.84 youngs/s, 65.06 non-youngs/s Pages read 9868483, created 2451208, written 10216359 2.44 reads/s, 0.06 creates/s, 2.00 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 249425, unzip_LRU len: 0 I/O sum[2932]:cur[10], unzip sum[0]:cur[0] ---BUFFER POOL 6 Buffer pool size 262112 Free buffers 1024 Database pages 249394 Old database pages 92041 Modified db pages 1623 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 48343347, not young 562002036 96.87 youngs/s, 499.30 non-youngs/s Pages read 9782100, created 2423878, written 10075688 10.66 reads/s, 0.00 creates/s, 1.94 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 3 / 1000 Pages read ahead 5.28/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 249394, unzip_LRU len: 0 I/O sum[2932]:cur[10], unzip sum[0]:cur[0] ---BUFFER POOL 7 Buffer pool size 262144 Free buffers 1024 Database pages 249391 Old database pages 92040 Modified db pages 1639 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 49429805, not young 530105586 96.65 youngs/s, 191.15 non-youngs/s Pages read 9847123, created 2433200, written 10210205 9.69 reads/s, 0.75 creates/s, 2.06 writes/s Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000 Pages read ahead 6.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 249391, unzip_LRU len: 0 I/O sum[2932]:cur[13], unzip sum[0]:cur[0] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 74 read views open inside InnoDB Process ID=13994, Main thread ID=140555936835328, state: sleeping Number of rows inserted 7943033057, updated 505048831, deleted 41643183, read 2434872063260 35.59 inserts/s, 33.19 updates/s, 0.62 deletes/s, 1519402.05 reads/s

复制