Description:
I'm using DELAYED INSERT thread in my application, and I'd to limit the max number of DELAYED thread created.
Thus I've set max_delayed_thread to 20 :
mysql> show variables like "%max_delayed_thread%";
+---------------------+-------+
| Variable_name | Value |
+---------------------+-------+
| max_delayed_threads | 20 |
+---------------------+-------+
1 row in set (0.00 sec)
Then I was expecting to not have more than 20 delayed_thread created, but that's not the case according to show processlist :
mysql> show processlist;
+--------+---------+-----------+-------------------------------+----------------+-------+--------------------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+--------+---------+-----------+-------------------------------+----------------+-------+--------------------+------------------+
| 9799 | DELAYED | | forum_overclex | Delayed_insert | 2644 | Waiting for INSERT | |
| 9800 | DELAYED | :28769 | forum_overclex | Delayed_insert | 2644 | Waiting for INSERT | |
| 9868 | DELAYED | | forum_presencepc | Delayed_insert | 121 | Waiting for INSERT | |
| 9869 | DELAYED | | forum_presencepc | Delayed_insert | 121 | Waiting for INSERT | |
| 9918 | DELAYED | | forum_overclex | Delayed_insert | 40 | Waiting for INSERT | |
| 9919 | DELAYED | | forum_overclex | Delayed_insert | 40 | Waiting for INSERT | |
| 10180 | DELAYED | | forum_presencepc | Delayed_insert | 162 | Waiting for INSERT | |
| 10181 | DELAYED | | forum_presencepc | Delayed_insert | 162 | Waiting for INSERT | |
| 10240 | DELAYED | :26739 | forum_xboxhacks | Delayed_insert | 1539 | Waiting for INSERT | |
| 10241 | DELAYED | | forum_xboxhacks | Delayed_insert | 1539 | Waiting for INSERT | |
| 10298 | DELAYED | :60127 | forum_xboxhacks | Delayed_insert | 52358 | Waiting for INSERT | |
| 10299 | DELAYED | | forum_xboxhacks | Delayed_insert | 52358 | Waiting for INSERT | |
| 10300 | DELAYED | :65535 | forum_xboxhacks | Delayed_insert | 56254 | Waiting for INSERT | |
| 10820 | DELAYED | | forum_vossey | Delayed_insert | 117 | Waiting for INSERT | |
| 10821 | DELAYED | :26128 | forum_vossey | Delayed_insert | 117 | Waiting for INSERT | |
| 10967 | DELAYED | :17407 | forum_xboxhacks | Delayed_insert | 4988 | Waiting for INSERT | |
| 10968 | DELAYED | :65535 | forum_xboxhacks | Delayed_insert | 4988 | Waiting for INSERT | |
| 10969 | DELAYED | :65535 | forum_xboxhacks | Delayed_insert | 7271 | Waiting for INSERT | |
| 11010 | DELAYED | :996 | forum_crazycity | Delayed_insert | 36214 | Waiting for INSERT | |
| 11011 | DELAYED | :16419 | forum_crazycity | Delayed_insert | 36214 | Waiting for INSERT | |
| 11199 | DELAYED | :65535 | forum_crazycity | Delayed_insert | 510 | Waiting for INSERT | |
| 11200 | DELAYED | :2 | forum_crazycity | Delayed_insert | 510 | Waiting for INSERT | |
| 11223 | DELAYED | :12592 | forum_crazycity | Delayed_insert | 6179 | Waiting for INSERT | |
| 11224 | DELAYED | :65535 | forum_crazycity | Delayed_insert | 6179 | Waiting for INSERT | |
| 11225 | DELAYED | :64520 | forum_crazycity | Delayed_insert | 62134 | Waiting for INSERT | |
| 11472 | DELAYED | | forum_overclex | Delayed_insert | 18 | Waiting for INSERT | |
| 11473 | DELAYED | :2 | forum_overclex | Delayed_insert | 18 | Waiting for INSERT | |
| 11479 | DELAYED | | forum_ussportsmag | Delayed_insert | 43757 | Waiting for INSERT | |
| 11480 | DELAYED | | forum_ussportsmag | Delayed_insert | 43757 | Waiting for INSERT | |
| 11739 | DELAYED | :26656 | forum_powerattitude | Delayed_insert | 1579 | Waiting for INSERT | |
| 11740 | DELAYED | | forum_powerattitude | Delayed_insert | 1579 | Waiting for INSERT | |
| 12056 | DELAYED | :2061 | forum_overclex | Delayed_insert | 314 | Waiting for INSERT | |
| 12057 | DELAYED | | forum_overclex | Delayed_insert | 314 | Waiting for INSERT | |
| 12121 | DELAYED | | forum_xboxhacks | Delayed_insert | 390 | Waiting for INSERT | |
| 12122 | DELAYED | :2304 | forum_xboxhacks | Delayed_insert | 390 | Waiting for INSERT | |
| 12123 | DELAYED | :64992 | forum_xboxhacks | Delayed_insert | 814 | Waiting for INSERT | |
| 12260 | DELAYED | :12078 | forum_ussportsmag | Delayed_insert | 3538 | Waiting for INSERT | |
| 12261 | DELAYED | :18243 | forum_ussportsmag | Delayed_insert | 3538 | Waiting for INSERT | |
| 12309 | DELAYED | :30632 | forum_powerattitude | Delayed_insert | 40564 | Waiting for INSERT | |
| 12310 | DELAYED | :56208 | forum_powerattitude | Delayed_insert | 40564 | Waiting for INSERT | |
| 12315 | DELAYED | :2048 | forum_root42 | Delayed_insert | 249 | Waiting for INSERT | |
| 12316 | DELAYED | | forum_root42 | Delayed_insert | 249 | Waiting for INSERT | |
| 12349 | DELAYED | | forum_gamefrance | Delayed_insert | 56809 | Waiting for INSERT | |
| 12350 | DELAYED | | forum_gamefrance | Delayed_insert | 56809 | Waiting for INSERT | |
| 12498 | DELAYED | :20096 | forum_powerattitude | Delayed_insert | 638 | Waiting for INSERT | |
| 12500 | DELAYED | | forum_powerattitude | Delayed_insert | 638 | Waiting for INSERT | |
| 12742 | DELAYED | :14098 | forum_vossey | Delayed_insert | 447 | Waiting for INSERT | |
| 12743 | DELAYED | :57040 | forum_vossey | Delayed_insert | 447 | Waiting for INSERT | |
| 12928 | DELAYED | :2560 | forum_xboxhacks | Delayed_insert | 1747 | Waiting for INSERT | |
| 12929 | DELAYED | :24949 | forum_xboxhacks | Delayed_insert | 1747 | Waiting for INSERT | |
| 12930 | DELAYED | | forum_xboxhacks | Delayed_insert | 5548 | Waiting for INSERT | |
| 13145 | DELAYED | | forum_rezo | Delayed_insert | 788 | Waiting for INSERT | |
| 13146 | DELAYED | | forum_rezo | Delayed_insert | 788 | Waiting for INSERT | |
| 13218 | DELAYED | | forum_foldinghome | Delayed_insert | 3201 | Waiting for INSERT | |
| 13219 | DELAYED | :16 | forum_foldinghome | Delayed_insert | 3201 | Waiting for INSERT | |
| 13486 | DELAYED | :2226 | forum_xboxhacks | Delayed_insert | 39193 | Waiting for INSERT | |
| 13654 | DELAYED | :65535 | forum_foldinghome | Delayed_insert | 3271 | Waiting for INSERT | |
| 13655 | DELAYED | | forum_foldinghome | Delayed_insert | 3271 | Waiting for INSERT | |
| 14066 | DELAYED | :28257 | forum_presencepc | Delayed_insert | 8296 | Waiting for INSERT | |
| 14067 | DELAYED | :65535 | forum_presencepc | Delayed_insert | 8296 | Waiting for INSERT | |
| 14184 | DELAYED | :26984 | forum_xboxhacks | Delayed_insert | 5965 | Waiting for INSERT | |
| 14186 | DELAYED | :27746 | forum_xboxhacks | Delayed_insert | 5965 | Waiting for INSERT | |
| 14187 | DELAYED | :26465 | forum_xboxhacks | Delayed_insert | 5965 | Waiting for INSERT | |
| 14476 | DELAYED | :28912 | forum_presencepc | Delayed_insert | 201 | Waiting for INSERT | |
| 14477 | DELAYED | :29152 | forum_presencepc | Delayed_insert | 201 | Waiting for INSERT | |
| 14749 | DELAYED | :17759 | forum_xboxhacks | Delayed_insert | 1294 | Waiting for INSERT | |
| 14750 | DELAYED | :26746 | forum_xboxhacks | Delayed_insert | 1294 | Waiting for INSERT | |
| 14751 | DELAYED | :8293 | forum_xboxhacks | Delayed_insert | 4594 | Waiting for INSERT | |
| 15089 | DELAYED | :30632 | forum_xboxhacks | Delayed_insert | 27460 | Waiting for INSERT | |
| 15090 | DELAYED | :6568 | forum_xboxhacks | Delayed_insert | 27460 | Waiting for INSERT | |
| 15091 | DELAYED | :32 | forum_xboxhacks | Delayed_insert | 27599 | Waiting for INSERT | |
| 15558 | DELAYED | :8624 | forum_crazycity | Delayed_insert | 6315 | Waiting for INSERT | |
| 15559 | DELAYED | :8224 | forum_crazycity | Delayed_insert | 6315 | Waiting for INSERT | |
| 15903 | DELAYED | :65535 | forum_rtp | Delayed_insert | 46009 | Waiting for INSERT | |
| 16085 | DELAYED | :58708 | forum_xboxhacks | Delayed_insert | 6179 | Waiting for INSERT | |
| 16086 | DELAYED | :20640 | forum_xboxhacks | Delayed_insert | 6179 | Waiting for INSERT | |
| 16398 | DELAYED | :3112 | forum_rtp | Delayed_insert | 42090 | Waiting for INSERT | |
| 16399 | DELAYED | :35280 | forum_rtp | Delayed_insert | 42090 | Waiting for INSERT | |
| 16666 | DELAYED | | forum_overclex | Delayed_insert | 1322 | Waiting for INSERT | |
| 16667 | DELAYED | :29801 | forum_overclex | Delayed_insert | 1322 | Waiting for INSERT | |
| 16668 | DELAYED | :1792 | forum_overclex | Delayed_insert | 11477 | Waiting for INSERT | |
| 16682 | DELAYED | :21384 | forum_lho | Delayed_insert | 11008 | Waiting for INSERT | |
| 16683 | DELAYED | :65288 | forum_lho | Delayed_insert | 11008 | Waiting for INSERT | |
| 16856 | DELAYED | :29797 | forum_overclex | Delayed_insert | 1417 | Waiting for INSERT | |
| 16857 | DELAYED | :25964 | forum_overclex | Delayed_insert | 1417 | Waiting for INSERT | |
| 17316 | DELAYED | :33372 | forum_vossey | Delayed_insert | 950 | Waiting for INSERT | |
| 17318 | DELAYED | :16750 | forum_vossey | Delayed_insert | 950 | Waiting for INSERT | |
| 17428 | DELAYED | | forum_rtp | Delayed_insert | 2166 | Waiting for INSERT | |
| 17429 | DELAYED | :27264 | forum_rtp | Delayed_insert | 2166 | Waiting for INSERT | |
| 17844 | DELAYED | | forum_overclex | Delayed_insert | 104 | Waiting for INSERT | |
| 17845 | DELAYED | | forum_overclex | Delayed_insert | 104 | Waiting for INSERT | |
| 17846 | DELAYED | | forum_overclex | Delayed_insert | 4154 | Waiting for INSERT | |
| 18241 | DELAYED | :2304 | forum_presencepc | Delayed_insert | 1603 | Waiting for INSERT | |
| 18242 | DELAYED | | forum_presencepc | Delayed_insert | 1603 | Waiting for INSERT | |
| 18561 | DELAYED | :65535 | forum_vossey | Delayed_insert | 1166 | Waiting for INSERT | |
| 18562 | DELAYED | :14385 | forum_vossey | Delayed_insert | 1166 | Waiting for INSERT | |
| 18978 | DELAYED | :65535 | forum_lameute | Delayed_insert | 7550 | Waiting for INSERT | |
| 18979 | DELAYED | | forum_lameute | Delayed_insert | 7550 | Waiting for INSERT | |
| 20674 | DELAYED | :44848 | pubs | Delayed_insert | 2907 | Waiting for INSERT | |
| 21308 | DELAYED | :30313 | forum_lho | Delayed_insert | 54144 | Waiting for INSERT | |
| 21309 | DELAYED | :29537 | forum_lho | Delayed_insert | 54144 | Waiting for INSERT | |
| 22596 | DELAYED | :45240 | forum_lameute | Delayed_insert | 63847 | Waiting for INSERT | |
| 22597 | DELAYED | :1024 | forum_lameute | Delayed_insert | 63847 | Waiting for INSERT | |
| 22741 | DELAYED | :27978 | forum_lameute | Delayed_insert | 63824 | Waiting for INSERT | |
| 22742 | DELAYED | :29810 | forum_lameute | Delayed_insert | 63824 | Waiting for INSERT | |
| 22893 | DELAYED | :8306 | forum_crazycity | Delayed_insert | 2863 | Waiting for INSERT | |
| 22894 | DELAYED | :30060 | forum_crazycity | Delayed_insert | 2863 | Waiting for INSERT | |
| 23408 | DELAYED | :30309 | forum_presencepc | Delayed_insert | 234 | Waiting for INSERT | |
| 24077 | DELAYED | | forum_smpfr | Delayed_insert | 34889 | Waiting for INSERT | |
| 24078 | DELAYED | :256 | forum_smpfr | Delayed_insert | 34889 | Waiting for INSERT | |
| 24331 | DELAYED | :19800 | forum_xboxhacks | Delayed_insert | 63617 | Waiting for INSERT | |
| 24332 | DELAYED | :37804 | forum_xboxhacks | Delayed_insert | 63617 | Waiting for INSERT | |
| 24791 | DELAYED | | forum_ussportsfan | Delayed_insert | 40 | Waiting for INSERT | |
| 24792 | DELAYED | :84 | forum_ussportsfan | Delayed_insert | 40 | Waiting for INSERT | |
| 25402 | DELAYED | :65535 | forum_overclex | Delayed_insert | 493 | Waiting for INSERT | |
| 25403 | DELAYED | | forum_overclex | Delayed_insert | 493 | Waiting for INSERT | |
| 26561 | DELAYED | :65535 | forum_rezo | Delayed_insert | 1896 | Waiting for INSERT | |
| 26562 | DELAYED | :1160 | forum_rezo | Delayed_insert | 1896 | Waiting for INSERT | |
| 27472 | DELAYED | :55692 | forum_xboxhacks | Delayed_insert | 8151 | Waiting for INSERT | |
| 27473 | DELAYED | :14385 | forum_xboxhacks | Delayed_insert | 8151 | Waiting for INSERT | |
| 27474 | DELAYED | :30285 | forum_xboxhacks | Delayed_insert | 57819 | Waiting for INSERT | |
| 28921 | DELAYED | :2 | forum_forumrservauxwebmasters | Delayed_insert | 6543 | Waiting for INSERT | |
| 28922 | DELAYED | | forum_forumrservauxwebmasters | Delayed_insert | 6543 | Waiting for INSERT | |
| 28973 | DELAYED | :8224 | forum_presencepc | Delayed_insert | 3846 | Waiting for INSERT | |
| 29776 | DELAYED | :2194 | forum_overclex | Delayed_insert | 20986 | Waiting for INSERT | |
| 32414 | DELAYED | :30325 | forum_foldinghome | Delayed_insert | 1108 | Waiting for INSERT | |
| 32416 | DELAYED | :55122 | forum_foldinghome | Delayed_insert | 1108 | Waiting for INSERT | |
| 32417 | DELAYED | | forum_foldinghome | Delayed_insert | 62514 | Waiting for INSERT | |
| 33494 | DELAYED | :54512 | forum_root42 | Delayed_insert | 1058 | Waiting for INSERT | |
| 33495 | DELAYED | :768 | forum_root42 | Delayed_insert | 1058 | Waiting for INSERT | |
| 33507 | DELAYED | :42172 | forum_root42 | Delayed_insert | 1107 | Waiting for INSERT | |
| 33508 | DELAYED | :8306 | forum_root42 | Delayed_insert | 1107 | Waiting for INSERT | |
| 36240 | DELAYED | :20784 | forum_root42 | Delayed_insert | 38470 | Waiting for INSERT | |
| 36241 | DELAYED | :65023 | forum_root42 | Delayed_insert | 38470 | Waiting for INSERT | |
| 36572 | DELAYED | :12857 | forum_rezo | Delayed_insert | 355 | Waiting for INSERT | |
| 36573 | DELAYED | :65535 | forum_rezo | Delayed_insert | 355 | Waiting for INSERT | |
| 37805 | DELAYED | :65535 | forum_presencepc | Delayed_insert | 61613 | Waiting for INSERT | |
| 37806 | DELAYED | :26465 | forum_presencepc | Delayed_insert | 61613 | Waiting for INSERT | |
| 38619 | DELAYED | :57343 | forum_overclex | Delayed_insert | 12 | Waiting for INSERT | |
| 38620 | DELAYED | :1 | forum_overclex | Delayed_insert | 12 | Waiting for INSERT | |
| 38779 | DELAYED | :65535 | forum_overclex | Delayed_insert | 143 | Waiting for INSERT | |
| 38780 | DELAYED | :25964 | forum_overclex | Delayed_insert | 143 | Waiting for INSERT | |
| 40057 | DELAYED | :8250 | forum_crazycity | Delayed_insert | 8909 | Waiting for INSERT | |
| 40058 | DELAYED | :4188 | forum_crazycity | Delayed_insert | 8909 | Waiting for INSERT | |
| 42505 | DELAYED | :15956 | forum_overclex | Delayed_insert | 9326 | Waiting for INSERT | |
| 43371 | DELAYED | | forum_vossey | Delayed_insert | 61211 | Waiting for INSERT | |
| 43372 | DELAYED | :56780 | forum_vossey | Delayed_insert | 61211 | Waiting for INSERT | |
| 43878 | DELAYED | | forum_supinfocom | Delayed_insert | 61144 | Waiting for INSERT | |
| 43879 | DELAYED | :1128 | forum_supinfocom | Delayed_insert | 61144 | Waiting for INSERT | |
| 46027 | DELAYED | | forum_overclex | Delayed_insert | 9660 | Waiting for INSERT | |
| 47277 | DELAYED | :60876 | forum_presencepc | Delayed_insert | 37724 | Waiting for INSERT | |
| 47657 | DELAYED | :30063 | forum_presencepc | Delayed_insert | 1113 | Waiting for INSERT | |
| 47658 | DELAYED | :43176 | forum_presencepc | Delayed_insert | 1113 | Waiting for INSERT | |
| 47659 | DELAYED | :65535 | forum_presencepc | Delayed_insert | 60611 | Waiting for INSERT | |
| 50485 | DELAYED | :8224 | forum_smpfr | Delayed_insert | 60170 | Waiting for INSERT | |
| 50486 | DELAYED | :12650 | forum_smpfr | Delayed_insert | 60170 | Waiting for INSERT | |
| 50647 | DELAYED | | forum_smpfr | Delayed_insert | 2668 | Waiting for INSERT | |
| 50648 | DELAYED | :50400 | forum_smpfr | Delayed_insert | 2668 | Waiting for INSERT | |
| 50649 | DELAYED | :1024 | forum_smpfr | Delayed_insert | 60150 | Waiting for INSERT | |
| 52664 | DELAYED | :44544 | forum_foldinghome | Delayed_insert | 3640 | Waiting for INSERT | |
| 53475 | DELAYED | :12064 | forum_hokutoteam | Delayed_insert | 33311 | Waiting for INSERT | |
| 53476 | DELAYED | :29811 | forum_hokutoteam | Delayed_insert | 33311 | Waiting for INSERT | |
| 53982 | DELAYED | :32816 | forum_vossey | Delayed_insert | 2330 | Waiting for INSERT | |
| 54041 | DELAYED | :1792 | forum_lameute | Delayed_insert | 3208 | Waiting for INSERT | |
| 54042 | DELAYED | :65535 | forum_lameute | Delayed_insert | 3208 | Waiting for INSERT | |
| 55039 | DELAYED | :53800 | forum_presencepc | Delayed_insert | 2485 | Waiting for INSERT | |
| 55330 | DELAYED | | forum_projetinge4 | Delayed_insert | 39975 | Waiting for INSERT | |
| 55331 | DELAYED | :26994 | forum_projetinge4 | Delayed_insert | 39975 | Waiting for INSERT | |
| 55332 | DELAYED | :27476 | forum_projetinge4 | Delayed_insert | 43919 | Waiting for INSERT | |
| 55696 | DELAYED | :24228 | forum_lho | Delayed_insert | 33730 | Waiting for INSERT | |
| 55697 | DELAYED | :16750 | forum_lho | Delayed_insert | 33730 | Waiting for INSERT | |
| 56454 | DELAYED | :29537 | forum_unlocker93 | Delayed_insert | 59324 | Waiting for INSERT | |
| 56455 | DELAYED | :16672 | forum_unlocker93 | Delayed_insert | 59324 | Waiting for INSERT | |
| 56685 | DELAYED | | forum_pubstv | Delayed_insert | 2192 | Waiting for INSERT | |
| 57604 | DELAYED | :11640 | forum_root42 | Delayed_insert | 10946 | Waiting for INSERT | |
| 57605 | DELAYED | | forum_root42 | Delayed_insert | 10946 | Waiting for INSERT | |
| 58792 | DELAYED | :792 | forum_overclex | Delayed_insert | 4674 | Waiting for INSERT | |
| 58847 | DELAYED | :26465 | forum_powerattitude | Delayed_insert | 58950 | Waiting for INSERT | |
| 58848 | DELAYED | | forum_powerattitude | Delayed_insert | 58950 | Waiting for INSERT | |
| 61428 | DELAYED | :41284 | forum_lho | Delayed_insert | 58569 | Waiting for INSERT | |
| 62118 | DELAYED | | forum_gamefrance | Delayed_insert | 36959 | Waiting for INSERT | |
| 62119 | DELAYED | :65535 | forum_gamefrance | Delayed_insert | 36959 | Waiting for INSERT | |
| 62767 | DELAYED | | forum_hokutoteam | Delayed_insert | 4388 | Waiting for INSERT | |
| 62768 | DELAYED | :65535 | forum_hokutoteam | Delayed_insert | 4388 | Waiting for INSERT | |
| 66425 | DELAYED | :1280 | forum_powerattitude | Delayed_insert | 56523 | Waiting for INSERT | |
| 66427 | DELAYED | :28483 | forum_powerattitude | Delayed_insert | 56523 | Waiting for INSERT | |
| 71120 | DELAYED | :26144 | forum_vossey | Delayed_insert | 41430 | Waiting for INSERT | |
| 71121 | DELAYED | | forum_vossey | Delayed_insert | 41430 | Waiting for INSERT | |
| 71591 | DELAYED | | prix | Delayed_insert | 2704 | Waiting for INSERT | |
| 72139 | DELAYED | :41044 | forum_root42 | Delayed_insert | 3593 | Waiting for INSERT | |
| 72288 | DELAYED | :25961 | forum_lho | Delayed_insert | 3569 | Waiting for INSERT | |
| 72289 | DELAYED | | forum_lho | Delayed_insert | 3569 | Waiting for INSERT | |
| 72480 | DELAYED | :8632 | forum_foldinghome | Delayed_insert | 6868 | Waiting for INSERT | |
| 72481 | DELAYED | :25962 | forum_foldinghome | Delayed_insert | 6868 | Waiting for INSERT | |
| 72482 | DELAYED | | forum_foldinghome | Delayed_insert | 56789 | Waiting for INSERT | |
| 78345 | DELAYED | | forum_rtp | Delayed_insert | 31960 | Waiting for INSERT | |
| 78346 | DELAYED | | forum_rtp | Delayed_insert | 31960 | Waiting for INSERT | |
| 79202 | DELAYED | :65288 | forum_crazycity | Delayed_insert | 55840 | Waiting for INSERT | |
| 79240 | DELAYED | :65535 | forum_presencepc | Delayed_insert | 705 | Waiting for INSERT | |
| 79241 | DELAYED | :29289 | forum_presencepc | Delayed_insert | 705 | Waiting for INSERT | |
| 79924 | DELAYED | :14392 | forum_rtp | Delayed_insert | 41990 | Waiting for INSERT | |
| 79925 | DELAYED | :36942 | forum_rtp | Delayed_insert | 41990 | Waiting for INSERT | |
| 82407 | DELAYED | | forum_pubstv | Delayed_insert | 1929 | Waiting for INSERT | |
| 82408 | DELAYED | | forum_pubstv | Delayed_insert | 1929 | Waiting for INSERT | |
| 83853 | DELAYED | :3628 | forum_pubstv | Delayed_insert | 39394 | Waiting for INSERT | |
| 83854 | DELAYED | | forum_pubstv | Delayed_insert | 39394 | Waiting for INSERT | |
| 85230 | DELAYED | :8976 | forum_vossey | Delayed_insert | 18 | Waiting for INSERT | |
| 85231 | DELAYED | :8224 | forum_vossey | Delayed_insert | 18 | Waiting for INSERT | |
| 86053 | DELAYED | :12323 | forum_ussportsfan | Delayed_insert | 54792 | Waiting for INSERT | |
| 86054 | DELAYED | :14385 | forum_ussportsfan | Delayed_insert | 54792 | Waiting for INSERT | |
| 86761 | DELAYED | :8224 | forum_stmicro | Delayed_insert | 54683 | Waiting for INSERT | |
| 86762 | DELAYED | | forum_stmicro | Delayed_insert | 54683 | Waiting for INSERT | |
| 86763 | DELAYED | :8293 | forum_stmicro | Delayed_insert | 54683 | Waiting for INSERT | |
| 87748 | DELAYED | :8481 | forum_overclex | Delayed_insert | 53146 | Waiting for INSERT | |
| 91364 | DELAYED | :2208 | forum_ussportsfan | Delayed_insert | 35822 | Waiting for INSERT | |
| 91365 | DELAYED | :26465 | forum_ussportsfan | Delayed_insert | 35822 | Waiting for INSERT | |
| 94485 | DELAYED | :8224 | forum_pubstv | Delayed_insert | 40978 | Waiting for INSERT | |
| 94486 | DELAYED | | forum_pubstv | Delayed_insert | 40978 | Waiting for INSERT | |
| 94584 | DELAYED | :25965 | forum_vossey | Delayed_insert | 2048 | Waiting for INSERT | |
| 94585 | DELAYED | | forum_vossey | Delayed_insert | 2048 | Waiting for INSERT | |
| 95274 | DELAYED | :48660 | forum_powerattitude | Delayed_insert | 52154 | Waiting for INSERT | |
| 95275 | DELAYED | | forum_powerattitude | Delayed_insert | 52154 | Waiting for INSERT | |
| 102476 | DELAYED | :25956 | forum_presencepc | Delayed_insert | 1603 | Waiting for INSERT | |
| 106185 | DELAYED | :26994 | forum_presencepc | Delayed_insert | 3015 | Waiting for INSERT | |
| 106186 | DELAYED | :1764 | forum_presencepc | Delayed_insert | 3015 | Waiting for INSERT | |
| 106187 | DELAYED | :1536 | forum_presencepc | Delayed_insert | 9885 | Waiting for INSERT | |
| 113765 | DELAYED | :28448 | forum_ussportsmag | Delayed_insert | 50349 | Waiting for INSERT | |
| 118496 | DELAYED | :8306 | forum_lameute | Delayed_insert | 1802 | Waiting for INSERT | |
| 118497 | DELAYED | | forum_lameute | Delayed_insert | 1802 | Waiting for INSERT | |
| 121937 | DELAYED | :20221 | forum_foldinghome | Delayed_insert | 3701 | Waiting for INSERT | |
| 121938 | DELAYED | :47496 | forum_foldinghome | Delayed_insert | 3701 | Waiting for INSERT | |
| 128831 | DELAYED | :65535 | forum_ussportsfan | Delayed_insert | 48441 | Waiting for INSERT | |
| 133588 | DELAYED | :26994 | forum_lameute | Delayed_insert | 2948 | Waiting for INSERT | |
| 133589 | DELAYED | :7624 | forum_lameute | Delayed_insert | 2948 | Waiting for INSERT | |
| 135076 | DELAYED | :34884 | forum_pubstv | Delayed_insert | 1748 | Waiting for INSERT | |
| 135077 | DELAYED | :65535 | forum_pubstv | Delayed_insert | 1748 | Waiting for INSERT | |
| 136500 | DELAYED | :13059 | forum_vossey | Delayed_insert | 4754 | Waiting for INSERT | |
| 137768 | DELAYED | :10273 | forum_vossey | Delayed_insert | 218 | Waiting for INSERT | |
| 137769 | DELAYED | :26994 | forum_vossey | Delayed_insert | 218 | Waiting for INSERT | |
| 138644 | DELAYED | | forum_vossey | Delayed_insert | 47108 | Waiting for INSERT | |
| 138645 | DELAYED | :16750 | forum_vossey | Delayed_insert | 47108 | Waiting for INSERT | |
| 140757 | DELAYED | :25961 | forum_foldinghome | Delayed_insert | 21036 | Waiting for INSERT | |
| 140758 | DELAYED | :28946 | forum_foldinghome | Delayed_insert | 21036 | Waiting for INSERT | |
| 140759 | DELAYED | :36192 | forum_foldinghome | Delayed_insert | 33350 | Waiting for INSERT | |
| 142707 | DELAYED | :65535 | forum_vossey | Delayed_insert | 46474 | Waiting for INSERT | |
| 142708 | DELAYED | :29285 | forum_vossey | Delayed_insert | 46474 | Waiting for INSERT | |
| 147772 | DELAYED | | forum_lho | Delayed_insert | 4769 | Waiting for INSERT | |
| 152699 | DELAYED | :2189 | forum_interne | Delayed_insert | 28773 | Waiting for INSERT | |
| 152700 | DELAYED | :8224 | forum_interne | Delayed_insert | 28773 | Waiting for INSERT | |
| 156724 | DELAYED | | forum_gamefrance | Delayed_insert | 44370 | Waiting for INSERT | |
| 156725 | DELAYED | | forum_gamefrance | Delayed_insert | 44370 | Waiting for INSERT | |
| 158953 | DELAYED | :65535 | forum_rtp | Delayed_insert | 5404 | Waiting for INSERT | |
| 158955 | DELAYED | :12857 | forum_rtp | Delayed_insert | 5404 | Waiting for INSERT | |
| 185031 | DELAYED | :37404 | forum_hokutoteam | Delayed_insert | 39858 | Waiting for INSERT | |
| 185032 | DELAYED | :65535 | forum_hokutoteam | Delayed_insert | 39858 | Waiting for INSERT | |
| 195470 | DELAYED | :26994 | forum_root42 | Delayed_insert | 1196 | Waiting for INSERT | |
| 195471 | DELAYED | :28261 | forum_root42 | Delayed_insert | 1196 | Waiting for INSERT | |
| 197259 | DELAYED | :29018 | forum_overclex | Delayed_insert | 12608 | Waiting for INSERT | |
| 200474 | DELAYED | :109 | forum_foldinghome | Delayed_insert | 3478 | Waiting for INSERT | |
| 200475 | DELAYED | | forum_foldinghome | Delayed_insert | 3478 | Waiting for INSERT | |
| 200476 | DELAYED | :12336 | forum_foldinghome | Delayed_insert | 36844 | Waiting for INSERT | |
| 202715 | DELAYED | :26994 | forum_crazycity | Delayed_insert | 36157 | Waiting for INSERT | |
| 202716 | DELAYED | :44848 | forum_crazycity | Delayed_insert | 36157 | Waiting for INSERT | |
| 202717 | DELAYED | | forum_crazycity | Delayed_insert | 36157 | Waiting for INSERT | |
| 206039 | DELAYED | :31244 | forum_rtp | Delayed_insert | 35109 | Waiting for INSERT | |
| 206600 | DELAYED | :29766 | forum_rtp | Delayed_insert | 1875 | Waiting for INSERT | |
| 206601 | DELAYED | :25376 | forum_rtp | Delayed_insert | 1875 | Waiting for INSERT | |
| 206602 | DELAYED | :40352 | forum_rtp | Delayed_insert | 5008 | Waiting for INSERT | |
| 207100 | DELAYED | :37412 | forum_rezo | Delayed_insert | 34761 | Waiting for INSERT | |
| 207226 | DELAYED | :43528 | forum_crazycity | Delayed_insert | 32503 | Waiting for INSERT | |
| 208083 | DELAYED | :12857 | forum_overclex | Delayed_insert | 34342 | Waiting for INSERT | |
| 208352 | DELAYED | :11350 | forum_interne | Delayed_insert | 2454 | Waiting for INSERT | |
| 208353 | DELAYED | :32960 | forum_interne | Delayed_insert | 2454 | Waiting for INSERT | |
| 210207 | DELAYED | :58964 | forum_rtp | Delayed_insert | 33567 | Waiting for INSERT | |
| 210208 | DELAYED | | forum_rtp | Delayed_insert | 33567 | Waiting for INSERT | |
| 210209 | DELAYED | | forum_rtp | Delayed_insert | 33567 | Waiting for INSERT | |
| 217646 | DELAYED | :56063 | forum_rezo | Delayed_insert | 853 | Waiting for INSERT | |
| 217647 | DELAYED | :44848 | forum_rezo | Delayed_insert | 853 | Waiting for INSERT | |
| 219923 | DELAYED | :25965 | forum_interne | Delayed_insert | 28773 | Waiting for INSERT | |
| 247500 | DELAYED | :26704 | forum_smpfr | Delayed_insert | 1324 | Waiting for INSERT | |
| 247501 | DELAYED | :13107 | forum_smpfr | Delayed_insert | 1324 | Waiting for INSERT | |
| 249405 | DELAYED | :13020 | forum_vossey | Delayed_insert | 7530 | Waiting for INSERT | |
| 254060 | DELAYED | :2048 | forum_gamefrance | Delayed_insert | 6601 | Waiting for INSERT | |
| 254061 | DELAYED | :11890 | forum_gamefrance | Delayed_insert | 6601 | Waiting for INSERT | |
| 256264 | DELAYED | | forum_xboxhacks | Delayed_insert | 6179 | Waiting for INSERT | |
| 262036 | DELAYED | :26994 | forum_powerattitude | Delayed_insert | 1805 | Waiting for INSERT | |
| 262037 | DELAYED | | forum_powerattitude | Delayed_insert | 1805 | Waiting for INSERT | |
| 265012 | DELAYED | :39023 | forum_pubstv | Delayed_insert | 2861 | Waiting for INSERT | |
| 265637 | DELAYED | :29800 | forum_hokutoteam | Delayed_insert | 4388 | Waiting for INSERT | |
| 267218 | DELAYED | :65288 | forum_hokutoteam | Delayed_insert | 4098 | Waiting for INSERT | |
| 267219 | DELAYED | :29541 | forum_hokutoteam | Delayed_insert | 4098 | Waiting for INSERT | |
| 274792 | DELAYED | | forum_ussportsmag | Delayed_insert | 2223 | Waiting for INSERT | |
| 274793 | DELAYED | | forum_ussportsmag | Delayed_insert | 2223 | Waiting for INSERT | |
| 274794 | DELAYED | | forum_ussportsmag | Delayed_insert | 2957 | Waiting for INSERT | |
| 277010 | DELAYED | :44820 | forum_vossey | Delayed_insert | 2639 | Waiting for INSERT | |
| 277627 | DELAYED | :26994 | forum_powerattitude | Delayed_insert | 2523 | Waiting for INSERT | |
| 279258 | root | localhost | NULL | Query | 0 | NULL | show processlist |
| 286491 | DELAYED | :58152 | forum_vossey | Delayed_insert | 1166 | Waiting for INSERT | |
| 290122 | DELAYED | :14385 | forum_rezo | Delayed_insert | 600 | Waiting for INSERT | |
| 290123 | DELAYED | :29295 | forum_rezo | Delayed_insert | 600 | Waiting for INSERT | |
| 290124 | DELAYED | :8226 | forum_rezo | Delayed_insert | 600 | Waiting for INSERT | |
| 291398 | DELAYED | :26232 | forum_vossey | Delayed_insert | 403 | Waiting for INSERT | |
| 292432 | DELAYED | :40480 | forum_root42 | Delayed_insert | 249 | Waiting for INSERT | |
| 293427 | DELAYED | | forum_rezo | Delayed_insert | 97 | Waiting for INSERT | |
| 293428 | DELAYED | :65535 | forum_rezo | Delayed_insert | 97 | Waiting for INSERT | |
| 293967 | mysql | localhost | presence | Sleep | 2 | | NULL |
| 294005 | mysql | localhost | presence | Sleep | 5 | | NULL |
+--------+---------+-----------+-------------------------------+----------------+-------+--------------------+------------------+
307 rows in set (0.01 sec)
Delayed_insert_timeout seems to not work properly too :
mysql> show variables like "%delayed_insert_timeout%";
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| delayed_insert_timeout | 150 |
+------------------------+-------+
1 row in set (0.00 sec)
As you can see above, I've a lot of DELAYED process waiting for more than 150s .
How to repeat:
Set delayed_insert_timeout and max_delayed_threads and try to create delayed threads.
