check care fullly in the gdb.txt I can find that: (please pay attention to the three "evidence") Thread 673 #13 0x00000000019bb6e5 in MYSQL_BIN_LOG::rotate (this=, force_rotate=, check_purge=0x7f5b3c0ba970) at in sql/binlog.cc:8929 mysql_mutex_lock(&LOCK_log); /* If rotate fails then depends on binlog_error_action variable appropriate action will be taken inside rotate call. */ int error = rotate(false, &check_purge); mysql_mutex_unlock(&LOCK_log); and during the rotate process: #5 ha_innobase::write_row(unsigned char*) () at ../../../mysql-8.0.16/storage/innobase/handler/ha_innodb.cc:8374 in mysql-8.0.16/storage/innobase/handler/ha_innodb.cc:8374 innobase_srv_conc_enter_innodb(m_prebuilt); which reuqire go inside innodb so thread 673 holds LOCK_log and require innodb_thread_conncurrency or innodb_commit_concurrency that is the first evidence Thread 683 (Thread 0x7f5b5d626700 (LWP 8563)): 0x7f5b5d626700 is 140030385481472 and in the show engine innodb status: ---TRANSACTION 937840546, ACTIVE 468 sec, thread declared inside InnoDB 1024 mysql tables in use 1, locked 1 2 lock struct(s), heap size 1136, 1 row lock(s) MySQL thread id 571, OS thread handle 140030385481472, query id 40008453 10.10.0.201 ztm waiting for handler commit update customer_auto_1 set name=left(name,2),telephone=telephone+1,address=left(address,8) where id=4062388 if you search "inside" in the show engine innodb , there is 67 result and subtract that the 3 "inside" in LATEST FOREIGN KEY ERROR and ROW OPERATIONS it is 64 which means that no more innodb_thread_conncurrency is available for thread 673. thread 673 will never finish its job, except got innodb_thread_conncurrency. that is the second evidence check all 64 threads inside innodb: convert the OS thread handle xxx in show engine innodb status to hex, and find it in gdb.txt: 140017003460352,0x7f583fc0f700 Thread 539 (Thread 0x7f583fc0f700 (LWP 9514)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022928144128,0x7f59a0e47700 Thread 603 (Thread 0x7f59a0e47700 (LWP 9359)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017004345088,0x7f583fce7700 Thread 542 (Thread 0x7f583fce7700 (LWP 9511)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022915757824,0x7f59a0277700 Thread 561 (Thread 0x7f59a0277700 (LWP 9492)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022922245888,0x7f59a08a7700 Thread 583 (Thread 0x7f59a08a7700 (LWP 9379)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022918412032,0x7f59a04ff700 Thread 570 (Thread 0x7f59a04ff700 (LWP 9483)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022914578176,0x7f59a0157700 Thread 557 (Thread 0x7f59a0157700 (LWP 9496)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017001985792,0x7f583faa7700 Thread 534 (Thread 0x7f583faa7700 (LWP 9519)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022917822208,0x7f59a046f700 Thread 568 (Thread 0x7f59a046f700 (LWP 9485)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017002280704,0x7f583faef700 Thread 535 (Thread 0x7f583faef700 (LWP 9518)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022925784832,0x7f59a0c07700 Thread 595 (Thread 0x7f59a0c07700 (LWP 9367)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022918706944,0x7f59a0547700 Thread 571 (Thread 0x7f59a0547700 (LWP 9482)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022927849216,0x7f59a0dff700 Thread 602 (Thread 0x7f59a0dff700 (LWP 9360)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022934632192,0x7f59a1477700 Thread 625 (Thread 0x7f59a1477700 (LWP 9317)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140016996087552,0x7f583f507700 Thread 514 (Thread 0x7f583f507700 (LWP 9539)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022931093248,0x7f59a1117700 Thread 613 (Thread 0x7f59a1117700 (LWP 9329)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140026692908800,0x7f5a814a3700 Thread 654 (Thread 0x7f5a814a3700 (LWP 8935)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022933157632,0x7f59a130f700 Thread 620 (Thread 0x7f59a130f700 (LWP 9322)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022926374656,0x7f59a0c97700 Thread 597 (Thread 0x7f59a0c97700 (LWP 9365)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022931388160,0x7f59a115f700 Thread 614 (Thread 0x7f59a115f700 (LWP 9328)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022925489920,0x7f59a0bbf700 Thread 594 (Thread 0x7f59a0bbf700 (LWP 9368)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022924605184,0x7f59a0ae7700 Thread 591 (Thread 0x7f59a0ae7700 (LWP 9371)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022934042368,0x7f59a13e7700 Thread 623 (Thread 0x7f59a13e7700 (LWP 9319)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017000216320,0x7f583f8f7700 Thread 528 (Thread 0x7f583f8f7700 (LWP 9525)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140030384891648,0x7f5b5d596700 Thread 681 (Thread 0x7f5b5d596700 (LWP 8571)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140029691565824,0x7f5b34061700 Thread 661 (Thread 0x7f5b34061700 (LWP 8921)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022929323776,0x7f59a0f67700 Thread 607 (Thread 0x7f59a0f67700 (LWP 9355)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022921361152,0x7f59a07cf700 Thread 580 (Thread 0x7f59a07cf700 (LWP 9382)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022928439040,0x7f59a0e8f700 Thread 604 (Thread 0x7f59a0e8f700 (LWP 9358)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022920771328,0x7f59a073f700 Thread 578 (Thread 0x7f59a073f700 (LWP 9384)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017006999296,0x7f583ff6f700 Thread 551 (Thread 0x7f583ff6f700 (LWP 9502)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140030385481472,0x7f5b5d626700 Thread 683 (Thread 0x7f5b5d626700 (LWP 8563)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140026671576832,0x7f5a8004b700 Thread 635 (Thread 0x7f5a8004b700 (LWP 9138)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140016995792640,0x7f583f4bf700 Thread 513 (Thread 0x7f583f4bf700 (LWP 9540)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022927259392,0x7f59a0d6f700 Thread 600 (Thread 0x7f59a0d6f700 (LWP 9362)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022933747456,0x7f59a139f700 Thread 622 (Thread 0x7f59a139f700 (LWP 9320)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022934337280,0x7f59a142f700 Thread 624 (Thread 0x7f59a142f700 (LWP 9318)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017005524736,0x7f583fe07700 Thread 546 (Thread 0x7f583fe07700 (LWP 9507)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140026673641216,0x7f5a80243700 Thread 642 (Thread 0x7f5a80243700 (LWP 9113)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017006114560,0x7f583fe97700 Thread 548 (Thread 0x7f583fe97700 (LWP 9505)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022932567808,0x7f59a127f700 Thread 618 (Thread 0x7f59a127f700 (LWP 9324)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140016995497728,0x7f583f477700 Thread 512 (Thread 0x7f583f477700 (LWP 9541)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017005229824,0x7f583fdbf700 Thread 545 (Thread 0x7f583fdbf700 (LWP 9508)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022921066240,0x7f59a0787700 Thread 579 (Thread 0x7f59a0787700 (LWP 9383)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022931977984,0x7f59a11ef700 Thread 616 (Thread 0x7f59a11ef700 (LWP 9326)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022929618688,0x7f59a0faf700 Thread 608 (Thread 0x7f59a0faf700 (LWP 9354)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022918117120,0x7f59a04b7700 Thread 569 (Thread 0x7f59a04b7700 (LWP 9484)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140016997267200,0x7f583f627700 Thread 518 (Thread 0x7f583f627700 (LWP 9535)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022926964480,0x7f59a0d27700 Thread 599 (Thread 0x7f59a0d27700 (LWP 9363)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140016999626496,0x7f583f867700 Thread 526 (Thread 0x7f583f867700 (LWP 9527)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017003165440,0x7f583fbc7700 Thread 538 (Thread 0x7f583fbc7700 (LWP 9515)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022916642560,0x7f59a034f700 Thread 564 (Thread 0x7f59a034f700 (LWP 9489)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022956619520,0x7f59a296f700 Thread 632 (Thread 0x7f59a296f700 (LWP 9148)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022915168000,0x7f59a01e7700 Thread 559 (Thread 0x7f59a01e7700 (LWP 9494)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140016998446848,0x7f583f747700 Thread 522 (Thread 0x7f583f747700 (LWP 9531)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022913693440,0x7f59a007f700 Thread 554 (Thread 0x7f59a007f700 (LWP 9499)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140017002870528,0x7f583fb7f700 Thread 537 (Thread 0x7f583fb7f700 (LWP 9516)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140026694678272,0x7f5a81653700 Thread 660 (Thread 0x7f5a81653700 (LWP 8923)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140016995202816,0x7f583f42f700 Thread 511 (Thread 0x7f583f42f700 (LWP 9542)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022924015360,0x7f59a0a57700 Thread 589 (Thread 0x7f59a0a57700 (LWP 9373)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022923130624,0x7f59a097f700 Thread 586 (Thread 0x7f59a097f700 (LWP 9376)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022925195008,0x7f59a0b77700 Thread 593 (Thread 0x7f59a0b77700 (LWP 9369)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140029691860736,0x7f5b340a9700 Thread 662 (Thread 0x7f5b340a9700 (LWP 8919)): #0 0x00007f5b722d1965 in pthread_cond_wait@@GLIBC_2.3.2 () from /lib64/libpthread.so.0 #1 0x00000000019b3c64 in native_cond_wait (mutex=0x3807608 , cond=0x38075d0 ) at ../../mysql-8.0.16/include/thr_cond.h:162 140022934927104,0x7f59a14bf700 Thread 626 (Thread 0x7f59a14bf700 (LWP 9316)): #0 0x00007f5b722d44ed in __lll_lock_wait () from /lib64/libpthread.so.0 #1 0x00007f5b722cfdcb in _L_lock_883 () from /lib64/libpthread.so.0 #2 0x00007f5b722cfc98 in pthread_mutex_lock () from /lib64/libpthread.so.0 #3 0x00000000019b8b8f in native_mutex_lock (mutex=0x38066c8 ) at ../../mysql-8.0.16/include/thr_mutex.h:186 #4 my_mutex_lock (mp=0x38066c8 ) at ../../mysql-8.0.16/include/thr_mutex.h:186 #5 inline_mysql_mutex_lock (src_line=8373, src_file=0x2ae0410 "../../mysql-8.0.16/sql/binlog.cc", that=0x38066c8 ) at ../../mysql-8.0.16/include/mysql/psi/mysql_mutex.h:250 #6 MYSQL_BIN_LOG::change_stage (this=, thd=, stage=, queue=, leave_mutex=, enter_mutex=0x38066c8 ) at ../../mysql-8.0.16/sql/binlog.cc:8373 please verify this section carfully. 63 of them is waiting for mysql_bin_log+3912 1 of them is waiting for mysql_bin_log+8 so all of the 64 thread is waiting for some lock of binlog that is the third part evidence. so ,1 vs 63 + 1, a large dead lock between binlog and innodb-thread-concurrency\innodb-commit-concurrency. I think this is enough to draw atttion from a devloper, and start some work. I suggest you find some developer help you to analyze this by review the code, maybe Thread 626 worth more attention than others, it is the special one. or find some developer help you to add debug sync point, or something like that. If you insist that you have to reproduce this problem with out any change in code, maybe a lower value of innodb-thread-concurrency\innodb-commit-concurrency and lower max-binlog-size will help you, just don't set it too low, wish you have the luck.