Not the answer you need?
Register and ask your own question!

all mysql query thread ACTIVE waiting in InnoDB queue ,how to resulte it !!!

zjh_ffzjh_ff EntrantCurrent User Role Beginner
I have deleted 20000 rows and repeat 60 , then all mysql query thread ACTIVE 43 sec waiting in InnoDB queue display :Mutex at 0x98b69da8 '&log_sys->log_flush_order_mutex', lock var 1 --Thread 139688494044928 has waited at btr0sea.c line 1123 for 0.0000 seconds the semaphore, how to resulte it ?

---TRANSACTION 25C337CA23, ACTIVE 27 sec waiting in InnoDB queue
mysql tables in use 2, locked 0
MySQL thread id 24790014, OS thread handle 0x7f0ae8be3700, query id 7657691194 172.162.11.122 txxx Sending data
SELECT "*"
FROM book_pas bp
where bp.bk_id = 412122



and bp.part_num >= 111


and bp.is_charge= 1
AND NOT EXISTS(
SELECT s.id
FROM sub785 s
WHERE bp.id = s.chapter_id
AND bp.book_id = s.book_id
AND s.user_id = 221221)
Trx read view will not see trx with id >= 25C337CA24, sees < 25C3355CA5
---TRANSACTION 25C337C9F5, ACTIVE 27 sec waiting in InnoDB queue

Comments

Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.