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

**URL:** <https://forums.percona.com/t/all-mysql-query-thread-active-waiting-in-innodb-queue-how-to-resulte-it/6366>\
**Category:** Other MySQL® Questions\
**Created:** [May 19, 2018, 4:33am UTC](https://forums.percona.com/t/all-mysql-query-thread-active-waiting-in-innodb-queue-how-to-resulte-it/6366 "2018-05-19T04:33:46Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![zjh\_ff](https://avatars.discourse-cdn.com/v4/letter/z/4af34b/32.png) [@zjh\_ff](https://forums.percona.com/u/zjh_ff)\
**Post date:** [May 19, 2018, 4:33am UTC](https://forums.percona.com/t/all-mysql-query-thread-active-waiting-in-innodb-queue-how-to-resulte-it/6366/1 "2018-05-19T04:33:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![leonardowalsh](https://avatars.discourse-cdn.com/v4/letter/l/e0b2c6/32.png) [@leonardowalsh](https://forums.percona.com/u/leonardowalsh)\
**Post date:** [November 26, 2018, 2:48am UTC](https://forums.percona.com/t/all-mysql-query-thread-active-waiting-in-innodb-queue-how-to-resulte-it/6366/2 "2018-11-26T02:48:20Z")

</div>

help:)…

---

<div class="post-metadata">

**Author:** ![lorraine.pocklington](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/lorraine.pocklington/32/37_2.png) [@lorraine.pocklington](https://forums.percona.com/u/lorraine.pocklington)\
**Post date:** [November 26, 2018, 4:48am UTC](https://forums.percona.com/t/all-mysql-query-thread-active-waiting-in-innodb-queue-how-to-resulte-it/6366/3 "2018-11-26T04:48:20Z")

</div>

Hello [leonardowalsh](https://www.percona.com/forums/member/42491-leonardowalsh) we need a bit more to go on before we can give help.The first post is really old. For guidelines on how to help other forum users to help you then you can check out this posthttps://www.percona.com/forums/questions-discussions/mysql-and-percona-server/percona-server-5-7/50708-troubleshooting-percona-server-for-mysql-and-how-to-report-a-bug

As a minimum really we need to know what version of software you are working on, error logs, situation leading to any problem you are seeing, OS info, impact on your application etc.

Also please start a new thread - as this one wasn’t active when it was raised there’s almost zero chance of a Forum user picking up on it now.

Thanks! And welcome to the Forum. FYI, new users are moderated to help to avoid spam.