Hi, I'm using MySQL 4.0.0-alpha, and I'm wondering why sometimes I have so many lock in my processlist (I don't see any non-locked INSERT which could cause all the lock). mysql> show processlist; +-------+-------+-----------+------------+---------+------+--------------+-- ---------------------------------------------------------------------------- ------------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-------+-----------+------------+---------+------+--------------+-- ---------------------------------------------------------------------------- ------------------------+ | 39767 | mysql | localhost | Hardwarefr | Sleep | 94 | | NULL | | 40364 | mysql | localhost | Hardwarefr | Sleep | 44 | | NULL | | 40479 | mysql | localhost | Hardwarefr | Sleep | 13 | | NULL | | 40586 | mysql | localhost | Hardwarefr | Sleep | 15 | | NULL | | 40709 | mysql | localhost | Hardwarefr | Query | 14 | Locked | INSERT INTO threadhardwarefr7 (numeropost,icone,contenu,pseudo,date,signature,ip) VALUES (48128,16,' | | 40723 | mysql | localhost | Hardwarefr | Sleep | 123 | | NULL | | 40757 | mysql | localhost | Hardwarefr | Query | 7 | Locked | SELECT COUNT(*) FROM threadhardwarefr7 | | 40773 | mysql | localhost | Hardwarefr | Sleep | 70 | | NULL | | 40805 | mysql | localhost | Hardwarefr | Sleep | 27 | | NULL | | 40851 | mysql | localhost | Hardwarefr | Sleep | 13 | | NULL | | 40874 | mysql | localhost | Hardwarefr | Sleep | 122 | | NULL | | 40878 | mysql | localhost | Hardwarefr | Sleep | 36 | | NULL | | 40881 | mysql | localhost | Hardwarefr | Sleep | 9 | | NULL | | 40893 | mysql | localhost | Hardwarefr | Sleep | 120 | | NULL | | 40966 | mysql | localhost | Hardwarefr | Sleep | 12 | | NULL | | 40970 | mysql | localhost | Hardwarefr | Sleep | 2 | | NULL | | 40979 | mysql | localhost | Hardwarefr | Sleep | 9 | | NULL | | 40995 | mysql | localhost | Hardwarefr | Sleep | 14 | | NULL | | 40997 | mysql | localhost | Hardwarefr | Sleep | 109 | | NULL | | 41009 | mysql | localhost | Hardwarefr | Sleep | 195 | | NULL | | 41014 | mysql | localhost | Hardwarefr | Query | 11 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48069 AND pseudo='OTH' LIMIT 1 | | 41034 | mysql | localhost | Hardwarefr | Sleep | 17 | | NULL | | 41052 | mysql | localhost | Hardwarefr | Sleep | 51 | | NULL | | 41063 | mysql | localhost | Hardwarefr | Sleep | 8 | | NULL | | 41064 | mysql | localhost | Hardwarefr | Query | 9 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48124 AND pseudo='Tchou' LIMIT 1 | | 41069 | mysql | localhost | Hardwarefr | Sleep | 6 | | NULL | | 41109 | mysql | localhost | Hardwarefr | Sleep | 69 | | NULL | | 41123 | mysql | localhost | Hardwarefr | Sleep | 33 | | NULL | | 41128 | mysql | localhost | Hardwarefr | Sleep | 49 | | NULL | | 41131 | mysql | localhost | Hardwarefr | Sleep | 31 | | NULL | | 41135 | mysql | localhost | Hardwarefr | Query | 12 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 41136 | mysql | localhost | Hardwarefr | Sleep | 55 | | NULL | | 41204 | mysql | localhost | Hardwarefr | Sleep | 11 | | NULL | | 41205 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48128 AND pseudo='LYLO' LIMIT 1 | | 41207 | mysql | localhost | Hardwarefr | Sleep | 66 | | NULL | | 41214 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 41215 | mysql | localhost | Hardwarefr | Query | 13 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 41216 | mysql | localhost | Hardwarefr | Sleep | 111 | | NULL | | 41221 | mysql | localhost | Hardwarefr | Sleep | 15 | | NULL | | 41257 | mysql | localhost | Hardwarefr | Sleep | 10 | | NULL | | 41326 | mysql | localhost | Hardwarefr | Sleep | 75 | | NULL | | 41329 | mysql | localhost | Hardwarefr | Sleep | 87 | | NULL | | 41331 | mysql | localhost | Hardwarefr | Sleep | 74 | | NULL | | 41352 | mysql | localhost | Hardwarefr | Sleep | 71 | | NULL | | 41366 | mysql | localhost | Hardwarefr | Query | 11 | Locked | SELECT COUNT(*) FROM threadhardwarefr7 | | 41367 | mysql | localhost | Hardwarefr | Sleep | 76 | | NULL | | 41373 | mysql | localhost | Hardwarefr | Sleep | 1 | | NULL | | 41381 | mysql | localhost | Hardwarefr | Sleep | 7 | | NULL | | 41383 | mysql | localhost | Hardwarefr | Sleep | 12 | | NULL | | 41384 | mysql | localhost | Hardwarefr | Sleep | 27 | | NULL | | 41385 | mysql | localhost | Hardwarefr | Sleep | 26 | | NULL | | 41386 | mysql | localhost | Hardwarefr | Query | 7 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48124 AND pseudo='Tchou' LIMIT 1 | | 41420 | mysql | localhost | Hardwarefr | Sleep | 94 | | NULL | | 41424 | mysql | localhost | Hardwarefr | Sleep | 74 | | NULL | | 41433 | mysql | localhost | Hardwarefr | Sleep | 34 | | NULL | | 41438 | mysql | localhost | Hardwarefr | Sleep | 11 | | NULL | | 41439 | mysql | localhost | Hardwarefr | Sleep | 14 | | NULL | | 41464 | mysql | localhost | Hardwarefr | Sleep | 42 | | NULL | | 41469 | mysql | localhost | Hardwarefr | Sleep | 129 | | NULL | | 41470 | mysql | localhost | Hardwarefr | Sleep | 50 | | NULL | | 41479 | mysql | localhost | Hardwarefr | Sleep | 163 | | NULL | | 41498 | mysql | localhost | Hardwarefr | Sleep | 69 | | NULL | | 41548 | mysql | localhost | Hardwarefr | Sleep | 42 | | NULL | | 41579 | mysql | localhost | Hardwarefr | Sleep | 13 | | NULL | | 41580 | mysql | localhost | Hardwarefr | Sleep | 48 | | NULL | | 41597 | mysql | localhost | Hardwarefr | Sleep | 50 | | NULL | | 41602 | mysql | localhost | Hardwarefr | Sleep | 31 | | NULL | | 41610 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 41613 | mysql | localhost | Hardwarefr | Sleep | 1 | | NULL | | 41615 | mysql | localhost | Hardwarefr | Sleep | 2 | | NULL | | 41670 | mysql | localhost | Hardwarefr | Sleep | 63 | | NULL | | 41677 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48076 AND pseudo='Dion' LIMIT 1 | | 41678 | mysql | localhost | Hardwarefr | Sleep | 68 | | NULL | | 41681 | mysql | localhost | Hardwarefr | Sleep | 33 | | NULL | | 41682 | mysql | localhost | Hardwarefr | Sleep | 56 | | NULL | | 41683 | mysql | localhost | Hardwarefr | Sleep | 77 | | NULL | | 41693 | mysql | localhost | Hardwarefr | Sleep | 45 | | NULL | | 41694 | mysql | localhost | Hardwarefr | Query | 6 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=43783 AND pseudo='seb31' LIMIT 1 | | 41698 | mysql | localhost | Hardwarefr | Sleep | 14 | | NULL | | 41720 | mysql | localhost | Hardwarefr | Sleep | 14 | | NULL | | 41790 | mysql | localhost | Hardwarefr | Sleep | 90 | | NULL | | 41791 | mysql | localhost | Hardwarefr | Sleep | 71 | | NULL | | 41792 | mysql | localhost | Hardwarefr | Sleep | 17 | | NULL | | 41794 | mysql | localhost | Hardwarefr | Sleep | 12 | | NULL | | 41795 | mysql | localhost | Hardwarefr | Sleep | 6 | | NULL | | 41799 | mysql | localhost | Hardwarefr | Sleep | 10 | | NULL | | 41801 | mysql | localhost | Hardwarefr | Sleep | 15 | | NULL | | 41804 | mysql | localhost | Hardwarefr | Sleep | 4 | | NULL | | 41812 | mysql | localhost | Hardwarefr | Query | 11 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 41813 | mysql | localhost | Hardwarefr | Sleep | 14 | | NULL | | 41815 | mysql | localhost | Hardwarefr | Sleep | 198 | | NULL | | 41816 | mysql | localhost | Hardwarefr | Sleep | 34 | | NULL | | 41825 | mysql | localhost | Hardwarefr | Query | 14 | Sending data | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 41834 | mysql | localhost | Hardwarefr | Sleep | 3 | | NULL | | 41837 | mysql | localhost | Hardwarefr | Sleep | 22 | | NULL | | 41839 | mysql | localhost | Hardwarefr | Sleep | 14 | | NULL | | 41850 | mysql | localhost | Hardwarefr | Sleep | 190 | | NULL | | 41857 | mysql | localhost | Hardwarefr | Query | 5 | Locked | SELECT COUNT(*) FROM threadhardwarefr7 | | 41891 | mysql | localhost | Hardwarefr | Sleep | 17 | | NULL | | 41893 | mysql | localhost | Hardwarefr | Sleep | 61 | | NULL | | 41894 | mysql | localhost | Hardwarefr | Sleep | 10 | | NULL | | 41903 | mysql | localhost | Hardwarefr | Sleep | 50 | | NULL | | 41950 | mysql | localhost | Hardwarefr | Query | 10 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 41953 | mysql | localhost | Hardwarefr | Sleep | 15 | | NULL | | 41954 | mysql | localhost | Hardwarefr | Sleep | 41 | | NULL | | 41963 | mysql | localhost | Hardwarefr | Sleep | 3 | | NULL | | 41969 | mysql | localhost | Hardwarefr | Sleep | 7 | | NULL | | 41974 | mysql | localhost | Hardwarefr | Sleep | 79 | | NULL | | 41984 | mysql | localhost | Hardwarefr | Sleep | 19 | | NULL | | 41985 | mysql | localhost | Hardwarefr | Sleep | 60 | | NULL | | 41986 | mysql | localhost | Hardwarefr | Sleep | 21 | | NULL | | 41992 | mysql | localhost | Hardwarefr | Query | 7 | Sending data | SELECT contenu,pseudo FROM threadhardwarefr9 WHERE numeropost=4416 ORDER BY numreponse ASC LIMIT 204 | | 42015 | mysql | localhost | Hardwarefr | Sleep | 90 | | NULL | | 42018 | mysql | localhost | Hardwarefr | Sleep | 47 | | NULL | | 42019 | mysql | localhost | Hardwarefr | Sleep | 23 | | NULL | | 42025 | mysql | localhost | Hardwarefr | Query | 4 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=47609 AND pseudo='GilouJeTenculeSalePD' LIMIT 1 | | 42058 | mysql | localhost | Hardwarefr | Sleep | 120 | | NULL | | 42071 | mysql | localhost | Hardwarefr | Sleep | 15 | | NULL | | 42073 | mysql | localhost | Hardwarefr | Sleep | 4 | | NULL | | 42074 | mysql | localhost | Hardwarefr | Sleep | 67 | | NULL | | 42086 | mysql | localhost | Hardwarefr | Sleep | 13 | | NULL | | 42087 | mysql | localhost | Hardwarefr | Sleep | 7 | | NULL | | 42088 | mysql | localhost | Hardwarefr | Sleep | 115 | | NULL | | 42089 | mysql | localhost | Hardwarefr | Sleep | 12 | | NULL | | 42090 | mysql | localhost | Hardwarefr | Sleep | 62 | | NULL | | 42091 | mysql | localhost | Hardwarefr | Query | 9 | Locked | SELECT COUNT(*) FROM threadhardwarefr7 | | 42092 | mysql | localhost | Hardwarefr | Sleep | 144 | | NULL | | 42093 | mysql | localhost | Hardwarefr | Sleep | 11 | | NULL | | 42096 | mysql | localhost | Hardwarefr | Sleep | 13 | | NULL | | 42097 | mysql | localhost | Hardwarefr | Query | 0 | Sending data | SELECT COUNT(*) FROM prive WHERE ((dest='cpulloverclock' AND ludest=0) OR (auteur='cpulloverclock' A | | 42098 | mysql | localhost | Hardwarefr | Sleep | 40 | | NULL | | 42100 | mysql | localhost | Hardwarefr | Query | 40 | Sending data | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42101 | mysql | localhost | Hardwarefr | Sleep | 60 | | NULL | | 42103 | mysql | localhost | Hardwarefr | Query | 9 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42104 | mysql | localhost | Hardwarefr | Sleep | 14 | | NULL | | 42105 | mysql | localhost | Hardwarefr | Sleep | 11 | | NULL | | 42106 | mysql | localhost | Hardwarefr | Sleep | 0 | | NULL | | 42114 | mysql | localhost | Hardwarefr | Sleep | 164 | | NULL | | 42116 | mysql | localhost | Hardwarefr | Sleep | 89 | | NULL | | 42121 | mysql | localhost | Hardwarefr | Sleep | 129 | | NULL | | 42126 | mysql | localhost | Hardwarefr | Sleep | 30 | | NULL | | 42131 | mysql | localhost | Hardwarefr | Sleep | 5 | | NULL | | 42151 | mysql | localhost | Hardwarefr | Query | 1 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48130 AND pseudo='yoyo3d' LIMIT 1 | | 42158 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42187 | mysql | localhost | Hardwarefr | Sleep | 96 | | NULL | | 42189 | mysql | localhost | Hardwarefr | Query | 14 | Locked | INSERT INTO threadhardwarefr7 (numeropost,icone,contenu,pseudo,date,signature,ip) VALUES (48131,1,'n | | 42190 | mysql | localhost | Hardwarefr | Query | 1 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48124 AND pseudo='Dion' LIMIT 1 | | 42204 | mysql | localhost | Hardwarefr | Sleep | 15 | | NULL | | 42205 | mysql | localhost | Hardwarefr | Query | 13 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42207 | mysql | localhost | Hardwarefr | Sleep | 0 | | NULL | | 42208 | mysql | localhost | Hardwarefr | Sleep | 39 | | NULL | | 42227 | mysql | localhost | Hardwarefr | Sleep | 13 | | NULL | | 42229 | mysql | localhost | Hardwarefr | Sleep | 4 | | NULL | | 42232 | mysql | localhost | Hardwarefr | Sleep | 18 | | NULL | | 42233 | mysql | localhost | Hardwarefr | Sleep | 3 | | NULL | | 42235 | mysql | localhost | Hardwarefr | Query | 4 | Locked | SELECT 1 FROM threadhardwarefr7 WHERE numeropost=48124 AND pseudo='Tchou' LIMIT 1 | | 42236 | mysql | localhost | Hardwarefr | Sleep | 78 | | NULL | | 42237 | mysql | localhost | Hardwarefr | Sleep | 22 | | NULL | | 42238 | mysql | localhost | Hardwarefr | Sleep | 12 | | NULL | | 42239 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT COUNT(*) FROM threadhardwarefr7 | | 42240 | mysql | localhost | Hardwarefr | Sleep | 20 | | NULL | | 42241 | mysql | localhost | Hardwarefr | Sleep | 171 | | NULL | | 42242 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42243 | mysql | localhost | Hardwarefr | Sleep | 14 | | NULL | | 42244 | mysql | localhost | Hardwarefr | Sleep | 76 | | NULL | | 42245 | mysql | localhost | Hardwarefr | Sleep | 7 | | NULL | | 42246 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT contenu,pseudo FROM threadhardwarefr7 WHERE numeropost=48028 ORDER BY numreponse ASC LIMIT 0, | | 42247 | mysql | localhost | Hardwarefr | Query | 5 | Locked | SELECT MAX(numreponse) FROM threadhardwarefr7 WHERE numeropost=48088 | | 42248 | mysql | localhost | Hardwarefr | Sleep | 126 | | NULL | | 42249 | mysql | localhost | Hardwarefr | Sleep | 28 | | NULL | | 42250 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42251 | mysql | localhost | Hardwarefr | Query | 13 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42252 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42253 | mysql | localhost | Hardwarefr | Sleep | 31 | | NULL | | 42254 | mysql | localhost | Hardwarefr | Sleep | 67 | | NULL | | 42255 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42256 | mysql | localhost | Hardwarefr | Sleep | 19 | | NULL | | 42257 | mysql | localhost | Hardwarefr | Sleep | 65 | | NULL | | 42258 | mysql | localhost | Hardwarefr | Sleep | 16 | | NULL | | 42259 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42260 | mysql | localhost | Hardwarefr | Sleep | 2 | | NULL | | 42261 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT contenu,pseudo FROM threadhardwarefr7 WHERE numeropost=48019 ORDER BY numreponse ASC LIMIT 0, | | 42262 | mysql | localhost | Hardwarefr | Sleep | 22 | | NULL | | 42263 | mysql | localhost | Hardwarefr | Sleep | 30 | | NULL | | 42264 | mysql | localhost | Hardwarefr | Sleep | 10 | | NULL | | 42265 | mysql | localhost | Hardwarefr | Sleep | 66 | | NULL | | 42266 | mysql | localhost | Hardwarefr | Sleep | 155 | | NULL | | 42269 | mysql | localhost | Hardwarefr | Sleep | 23 | | NULL | | 42272 | mysql | localhost | Hardwarefr | Sleep | 13 | | NULL | | 42273 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42274 | mysql | localhost | Hardwarefr | Query | 14 | Locked | SELECT contenu,pseudo FROM threadhardwarefr7 WHERE numeropost=38534 ORDER BY numreponse ASC LIMIT 0, | | 42275 | mysql | localhost | Hardwarefr | Sleep | 51 | | NULL | | 42279 | mysql | localhost | Hardwarefr | Sleep | 22 | | NULL | | 42282 | mysql | localhost | Hardwarefr | Sleep | 5 | | NULL | | 42283 | mysql | localhost | Hardwarefr | Sleep | 17 | | NULL | | 42284 | root | localhost | NULL | Query | 0 | NULL | show processlist | | 42286 | mysql | localhost | Hardwarefr | Sleep | 49 | | NULL | | 42291 | mysql | localhost | Hardwarefr | Sleep | 5 | | NULL | | 42292 | mysql | localhost | Hardwarefr | Query | 35 | Sending data | SELECT icone,contenu,pseudo,date,numreponse,signature,INET_NTOA(ip) FROM threadhardwarefr7 WHERE num | | 42294 | mysql | localhost | Hardwarefr | Sleep | 97 | | NULL | | 42295 | mysql | localhost | Hardwarefr | Query | 9 | Locked | SELECT COUNT(*) FROM threadhardwarefr7 | | 42296 | mysql | localhost | Hardwarefr | Sleep | 15 | | NULL | | 42297 | mysql | localhost | Hardwarefr | Sleep | 15 | | NULL | | 42298 | mysql | localhost | Hardwarefr | Sleep | 2 | | NULL | +-------+-------+-----------+------------+---------+------+--------------+-- ---------------------------------------------------------------------------- ------------------------+ 204 rows in set (0.00 sec) Any idea ?? Thank you :) Jocelyn Fournier Presence-PC --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php