===================================== 040706 0:49:35 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 16 seconds ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 916734, signal count 692041 --Thread 3884030 has waited at btr0cur.c line 347 for 0.00 seconds the semaphore: S-lock on RW-latch at 0x4318e2bc created in file dict0dict.c line 3494 a writer (thread id 114696) has reserved it in mode exclusive number of readers 0, waiters flag 1 Last time read locked in file btr0cur.c line 347 Last time write locked in file btr0cur.c line 340 Mutex spin waits 9650571, rounds 54443929, OS waits 582401 RW-shared spins 272557, OS waits 145923; RW-excl spins 154790, OS waits 72254 ------------ TRANSACTIONS ------------ Trx id counter 0 1053397777 Purge done for trx's n:o < 0 1053397151 undo n:o < 0 0 Total number of lock structs in row lock hash table 2 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0 1053243245, not started, process no 24391, OS thread id 1704041 MySQL thread id 2871, query id 1465906 scripts.neopets.com 207.218.164.31 neopets ---TRANSACTION 0 1053334258, not started, process no 24944, OS thread id 3916800 MySQL thread id 2749, query id 1562955 www175.neopets.com 207.218.164.175 neopets ---TRANSACTION 0 1053394967, not started, process no 25142, OS thread id 3965973 MySQL thread id 2736, query id 1628221 www115.neopets.com 207.218.164.115 neopets ---TRANSACTION 0 1053395341, not started, process no 25112, OS thread id 3949588 MySQL thread id 2561, query id 1628632 www148.neopets.com 207.218.164.148 neopets ---TRANSACTION 0 1053394766, not started, process no 24483, OS thread id 3212290 MySQL thread id 1940, query id 1627976 www223.neopets.com 207.218.164.223 neopets ---TRANSACTION 0 1053394892, not started, process no 24396, OS thread id 1785966 MySQL thread id 2288, query id 1628131 www158.sjo.neopets.com 206.132.214.158 neopets ---TRANSACTION 0 1053394948, not started, process no 24452, OS thread id 2703526 MySQL thread id 2330, query id 1628194 www144.neopets.com 207.218.164.144 neopets ---TRANSACTION 0 1052610161, not started, process no 24467, OS thread id 2949301 MySQL thread id 2223, query id 741975 neo6.neopets.com 207.218.164.45 neopets ---TRANSACTION 0 1053337313, not started, process no 24431, OS thread id 2359441 MySQL thread id 1949, query id 1566350 www139.neopets.com 207.218.164.139 neopets ---TRANSACTION 0 1053395052, not started, process no 24417, OS thread id 2130051 MySQL thread id 1809, query id 1628323 www196.neopets.com 207.218.164.196 neopets ---TRANSACTION 0 1053367435, not started, process no 24446, OS thread id 2605216 MySQL thread id 1822, query id 1598586 www118.neopets.com 207.218.164.118 neopets ---TRANSACTION 0 1053396794, not started, process no 24349, OS thread id 1015871 MySQL thread id 1084, query id 1630196 www159.sjo.neopets.com 206.132.214.159 neopets ---TRANSACTION 0 1053396553, not started, process no 24384, OS thread id 1589346 MySQL thread id 933, query id 1629903 www176.sjo.neopets.com 206.132.214.176 neopets ---TRANSACTION 0 1053394009, not started, process no 24378, OS thread id 1491036 MySQL thread id 1250, query id 1627102 www200.sjo.neopets.com 206.132.214.200 neopets ---TRANSACTION 0 1053385742, not started, process no 24525, OS thread id 3408910 MySQL thread id 1211, query id 1618186 www210.sjo.neopets.com 206.132.214.210 neopets ---TRANSACTION 0 1053395003, not started, process no 24347, OS thread id 983101 MySQL thread id 1087, query id 1628267 www186.sjo.neopets.com 206.132.214.186 neopets ---TRANSACTION 0 1053390092, not started, process no 24364, OS thread id 1261646 MySQL thread id 1065, query id 1622857 www198.sjo.neopets.com 206.132.214.198 neopets ---TRANSACTION 0 1053396550, not started, process no 24379, OS thread id 1507421 MySQL thread id 929, query id 1629899 www219.sjo.neopets.com 206.132.214.219 neopets ---TRANSACTION 0 1053392601, not started, process no 24352, OS thread id 1065026 MySQL thread id 1053, query id 1625613 www153.sjo.neopets.com 206.132.214.153 neopets ---TRANSACTION 0 1053387910, not started, process no 24297, OS thread id 180236 MySQL thread id 1080, query id 1620586 www174.sjo.neopets.com 206.132.214.174 neopets ---TRANSACTION 0 1053392017, not started, process no 24432, OS thread id 2375826 MySQL thread id 1063, query id 1624882 www212.sjo.neopets.com 206.132.214.212 neopets ---TRANSACTION 0 1053396202, not started, process no 24311, OS thread id 409626 MySQL thread id 1221, query id 1629529 www166.neopets.com 207.218.164.166 neopets ---TRANSACTION 0 1053394839, not started, process no 24342, OS thread id 901176 MySQL thread id 1048, query id 1628062 www222.sjo.neopets.com 206.132.214.222 neopets ---TRANSACTION 0 1053364131, not started, process no 24477, OS thread id 3113386 MySQL thread id 1244, query id 1594952 www190.neopets.com 207.218.164.190 neopets ---TRANSACTION 0 1053394526, not started, process no 24300, OS thread id 229391 MySQL thread id 1236, query id 1627680 www217.sjo.neopets.com 206.132.214.217 neopets ---TRANSACTION 0 1053368212, not started, process no 24326, OS thread id 655401 MySQL thread id 1226, query id 1599473 www165.neopets.com 207.218.164.165 neopets ---TRANSACTION 0 1053369315, not started, process no 24356, OS thread id 1130566 MySQL thread id 1241, query id 1600901 www111.neopets.com 207.218.164.111 neopets ---TRANSACTION 0 1053396619, not started, process no 24363, OS thread id 1245261 MySQL thread id 1239, query id 1629975 www213.sjo.neopets.com 206.132.214.213 neopets ---TRANSACTION 0 1053389185, not started, process no 24361, OS thread id 1212491 MySQL thread id 1256, query id 1621934 www172.neopets.com 207.218.164.172 neopets ---TRANSACTION 0 1053394234, not started, process no 24330, OS thread id 720941 MySQL thread id 1283, query id 1627363 www169.neopets.com 207.218.164.169 neopets ---TRANSACTION 0 1053396080, not started, process no 24448, OS thread id 2637986 MySQL thread id 1280, query id 1629386 www188.sjo.neopets.com 206.132.214.188 neopets ---TRANSACTION 0 1053396475, not started, process no 24377, OS thread id 1474651 MySQL thread id 1281, query id 1629819 www235.neopets.com 207.218.164.235 neopets ---TRANSACTION 0 1053394975, not started, process no 24367, OS thread id 1310801 MySQL thread id 1233, query id 1628234 www175.sjo.neopets.com 206.132.214.175 neopets ---TRANSACTION 0 1053387890, not started, process no 24586, OS thread id 3850372 MySQL thread id 1278, query id 1620556 www164.neopets.com 207.218.164.164 neopets ---TRANSACTION 0 1053335638, not started, process no 24575, OS thread id 3670170 MySQL thread id 1260, query id 1564526 www140.neopets.com 207.218.164.140 neopets ---TRANSACTION 0 1053389837, not started, process no 24529, OS thread id 3474450 MySQL thread id 1266, query id 1622591 www192.neopets.com 207.218.164.192 neopets ---TRANSACTION 0 1053387852, not started, process no 24428, OS thread id 2310286 MySQL thread id 1268, query id 1620507 www133.neopets.com 207.218.164.133 neopets ---TRANSACTION 0 1053384343, not started, process no 24571, OS thread id 3604576 MySQL thread id 1270, query id 1616658 www230.neopets.com 207.218.164.230 neopets ---TRANSACTION 0 1053394150, not started, process no 24406, OS thread id 1949816 MySQL thread id 1261, query id 1627265 www157.sjo.neopets.com 206.132.214.157 neopets ---TRANSACTION 0 1053397190, not started, process no 24572, OS thread id 3620989 MySQL thread id 1267, query id 1630605 www151.neopets.com 207.218.164.151 neopets ---TRANSACTION 0 1053382548, not started, process no 24527, OS thread id 3441680 MySQL thread id 1238, query id 1614776 www177.neopets.com 207.218.164.177 neopets ---TRANSACTION 0 1053389697, not started, process no 24309, OS thread id 376856 MySQL thread id 1255, query id 1622449 www183.sjo.neopets.com 206.132.214.183 neopets ---TRANSACTION 0 1053387456, not started, process no 24298, OS thread id 196621 MySQL thread id 1269, query id 1620090 www134.neopets.com 207.218.164.134 neopets ---TRANSACTION 0 1053389638, not started, process no 24381, OS thread id 1540191 MySQL thread id 1247, query id 1622390 www189.sjo.neopets.com 206.132.214.189 neopets ---TRANSACTION 0 1053394237, not started, process no 24371, OS thread id 1376341 MySQL thread id 1245, query id 1627369 www162.sjo.neopets.com 206.132.214.162 neopets ---TRANSACTION 0 1053384328, not started, process no 24320, OS thread id 557091 MySQL thread id 1248, query id 1616635 www181.sjo.neopets.com 206.132.214.181 neopets ---TRANSACTION 0 1053389248, not started, process no 24338, OS thread id 835636 MySQL thread id 1259, query id 1621999 www213.neopets.com 207.218.164.213 neopets ---TRANSACTION 0 1053390997, not started, process no 24482, OS thread id 3195905 MySQL thread id 1252, query id 1623823 www232.neopets.com 207.218.164.232 neopets ---TRANSACTION 0 1053392327, not started, process no 24392, OS thread id 1720426 MySQL thread id 1258, query id 1625301 www168.neopets.com 207.218.164.168 neopets ---TRANSACTION 0 1053392355, not started, process no 24474, OS thread id 3063996 MySQL thread id 1254, query id 1625337 www224.neopets.com 207.218.164.224 neopets ---TRANSACTION 0 1053394134, not started, process no 24535, OS thread id 3489831 MySQL thread id 1249, query id 1627241 www123.neopets.com 207.218.164.123 neopets ---TRANSACTION 0 1053372075, not started, process no 24373, OS thread id 1409111 MySQL thread id 1246, query id 1603930 www179.neopets.com 207.218.164.179 neopets ---TRANSACTION 0 1053368291, not started, process no 24335, OS thread id 802866 MySQL thread id 1231, query id 1599577 www191.neopets.com 207.218.164.191 neopets ---TRANSACTION 0 1053396764, not started, process no 24343, OS thread id 917561 MySQL thread id 1213, query id 1630160 www154.sjo.neopets.com 206.132.214.154 neopets ---TRANSACTION 0 1053396828, not started, process no 24341, OS thread id 884791 MySQL thread id 1230, query id 1630234 www157.neopets.com 207.218.164.157 neopets ---TRANSACTION 0 1053375932, not started, process no 24393, OS thread id 1736811 MySQL thread id 1215, query id 1607967 www187.neopets.com 207.218.164.187 neopets ---TRANSACTION 0 1053396826, not started, process no 24585, OS thread id 3833977 MySQL thread id 1235, query id 1630231 www208.neopets.com 207.218.164.208 neopets ---TRANSACTION 0 1053386200, not started, process no 24574, OS thread id 3653781 MySQL thread id 1225, query id 1618701 www127.neopets.com 207.218.164.127 neopets ---TRANSACTION 0 1053394590, not started, process no 24423, OS thread id 2228361 MySQL thread id 1234, query id 1627768 www203.neopets.com 207.218.164.203 neopets ---TRANSACTION 0 1053378376, not started, process no 24333, OS thread id 770096 MySQL thread id 1224, query id 1610471 www176.neopets.com 207.218.164.176 neopets ---TRANSACTION 0 1053369337, not started, process no 24458, OS thread id 2801836 MySQL thread id 1229, query id 1600935 www143.neopets.com 207.218.164.143 neopets ---TRANSACTION 0 1053384604, not started, process no 24323, OS thread id 606246 MySQL thread id 1220, query id 1616954 www132.neopets.com 207.218.164.132 neopets ---TRANSACTION 0 1053369410, not started, process no 24490, OS thread id 3326985 MySQL thread id 1227, query id 1601023 www158.neopets.com 207.218.164.158 neopets ---TRANSACTION 0 1053392275, not started, process no 24421, OS thread id 2195591 MySQL thread id 1219, query id 1625220 www233.neopets.com 207.218.164.233 neopets ---TRANSACTION 0 1053394274, not started, process no 24410, OS thread id 2015356 MySQL thread id 1218, query id 1627416 www147.neopets.com 207.218.164.147 neopets ---TRANSACTION 0 1053394845, not started, process no 24385, OS thread id 1605731 MySQL thread id 1212, query id 1628073 www145.neopets.com 207.218.164.145 neopets ---TRANSACTION 0 1053233516, not started, process no 24374, OS thread id 1425496 MySQL thread id 1209, query id 1455432 www184.neopets.com 207.218.164.184 neopets ---TRANSACTION 0 1053396775, not started, process no 24438, OS thread id 2474136 MySQL thread id 1114, query id 1630177 www112.neopets.com 207.218.164.112 neopets ---TRANSACTION 0 1053365727, not started, process no 24587, OS thread id 3866791 MySQL thread id 1123, query id 1596744 www182.neopets.com 207.218.164.182 neopets ---TRANSACTION 0 1053382860, not started, process no 24570, OS thread id 3588169 MySQL thread id 940, query id 1615099 www154.neopets.com 207.218.164.154 neopets ---TRANSACTION 0 1053367952, not started, process no 24475, OS thread id 3080381 MySQL thread id 1032, query id 1599163 www171.neopets.com 207.218.164.171 neopets ---TRANSACTION 0 1053394559, not started, process no 24345, OS thread id 950331 MySQL thread id 1057, query id 1627732 www208.sjo.neopets.com 206.132.214.208 neopets ---TRANSACTION 0 1053392226, not started, process no 24327, OS thread id 671786 MySQL thread id 926, query id 1625169 www210.neopets.com 207.218.164.210 neopets ---TRANSACTION 0 1053391878, not started, process no 24476, OS thread id 3096766 MySQL thread id 1020, query id 1624736 www202.sjo.neopets.com 206.132.214.202 neopets ---TRANSACTION 0 1053367491, not started, process no 24573, OS thread id 3637376 MySQL thread id 944, query id 1598662 www104.neopets.com 207.218.164.104 neopets ---TRANSACTION 0 1053396681, not started, process no 24354, OS thread id 1097796 MySQL thread id 1064, query id 1630044 www194.sjo.neopets.com 206.132.214.194 neopets ---TRANSACTION 0 1053395335, not started, process no 24567, OS thread id 3538988 MySQL thread id 937, query id 1628627 www221.sjo.neopets.com 206.132.214.221 neopets ---TRANSACTION 0 1053196700, not started, process no 24413, OS thread id 2064511 MySQL thread id 1119, query id 1415940 www113.neopets.com 207.218.164.113 neopets ---TRANSACTION 0 1053392147, not started, process no 24455, OS thread id 2752681 MySQL thread id 534, query id 1625052 www147.sjo.neopets.com 206.132.214.147 neopets ---TRANSACTION 0 1053368507, not started, process no 24380, OS thread id 1523806 MySQL thread id 1090, query id 1599863 www160.neopets.com 207.218.164.160 neopets ---TRANSACTION 0 1053368311, not started, process no 24437, OS thread id 2457751 MySQL thread id 1069, query id 1599603 www186.neopets.com 207.218.164.186 neopets ---TRANSACTION 0 1053396695, not started, process no 24353, OS thread id 1081411 MySQL thread id 1099, query id 1630061 www203.sjo.neopets.com 206.132.214.203 neopets ---TRANSACTION 0 1053386662, not started, process no 24317, OS thread id 507936 MySQL thread id 930, query id 1619190 www171.sjo.neopets.com 206.132.214.171 neopets ---TRANSACTION 0 1053396225, not started, process no 24322, OS thread id 589861 MySQL thread id 924, query id 1629551 www211.sjo.neopets.com 206.132.214.211 neopets ---TRANSACTION 0 1053383949, not started, process no 24415, OS thread id 2097281 MySQL thread id 1081, query id 1616236 www183.neopets.com 207.218.164.183 neopets ---TRANSACTION 0 1053386771, not started, process no 24425, OS thread id 2261131 MySQL thread id 1086, query id 1619319 www182.sjo.neopets.com 206.132.214.182 neopets ---TRANSACTION 0 1053294307, not started, process no 24295, OS thread id 147466 MySQL thread id 1008, query id 1520652 www181.neopets.com 207.218.164.181 neopets ---TRANSACTION 0 1053379136, not started, process no 24344, OS thread id 933946 MySQL thread id 1109, query id 1611247 www142.sjo.neopets.com 206.132.214.142 neopets ---TRANSACTION 0 1053392188, not started, process no 24350, OS thread id 1032256 MySQL thread id 1108, query id 1625111 www179.sjo.neopets.com 206.132.214.179 neopets ---TRANSACTION 0 1053394659, not started, process no 24400, OS thread id 1851506 MySQL thread id 1083, query id 1627848 www185.sjo.neopets.com 206.132.214.185 neopets ---TRANSACTION 0 1053393719, not started, process no 24375, OS thread id 1441881 MySQL thread id 1101, query id 1626799 www193.neopets.com 207.218.164.193 neopets ---TRANSACTION 0 1053378196, not started, process no 24395, OS thread id 1769581 MySQL thread id 1110, query id 1610280 www225.neopets.com 207.218.164.225 neopets ---TRANSACTION 0 1053396187, not started, process no 24389, OS thread id 1671271 MySQL thread id 1113, query id 1629503 www116.neopets.com 207.218.164.116 neopets ---TRANSACTION 0 1053394676, not started, process no 24304, OS thread id 294931 MySQL thread id 1085, query id 1627881 www164.sjo.neopets.com 206.132.214.164 neopets ---TRANSACTION 0 1053396191, not started, process no 24372, OS thread id 1392726 MySQL thread id 1112, query id 1629511 www167.neopets.com 207.218.164.167 neopets ---TRANSACTION 0 1053397765, not started, process no 24450, OS thread id 2670756 MySQL thread id 1106, query id 1631194 www170.sjo.neopets.com 206.132.214.170 neopets ---TRANSACTION 0 1053394963, not started, process no 24403, OS thread id 1900661 MySQL thread id 1094, query id 1628213 www216.sjo.neopets.com 206.132.214.216 neopets ---TRANSACTION 0 1053394961, not started, process no 24370, OS thread id 1359956 MySQL thread id 1104, query id 1628208 www129.neopets.com 207.218.164.129 neopets ---TRANSACTION 0 1053396842, not started, process no 24402, OS thread id 1884276 MySQL thread id 1117, query id 1630247 www177.sjo.neopets.com 206.132.214.177 neopets ---TRANSACTION 0 1053392507, not started, process no 24408, OS thread id 1982586 MySQL thread id 1093, query id 1625510 www149.sjo.neopets.com 206.132.214.149 neopets ---TRANSACTION 0 1053369878, not started, process no 24491, OS thread id 3343370 MySQL thread id 991, query id 1601542 www162.neopets.com 207.218.164.162 neopets ---TRANSACTION 0 1053098481, not started, process no 24398, OS thread id 1818736 MySQL thread id 1105, query id 1310728 www188.neopets.com 207.218.164.188 neopets ---TRANSACTION 0 1053393844, not started, process no 24312, OS thread id 426011 MySQL thread id 1111, query id 1626931 www204.neopets.com 207.218.164.204 neopets ---TRANSACTION 0 1053311346, not started, process no 24339, OS thread id 852021 MySQL thread id 1098, query id 1538630 www117.neopets.com 207.218.164.117 neopets ---TRANSACTION 0 1053392201, not started, process no 24301, OS thread id 245776 MySQL thread id 1115, query id 1625138 www141.neopets.com 207.218.164.141 neopets ---TRANSACTION 0 1053394194, not started, process no 24472, OS thread id 3031226 MySQL thread id 1078, query id 1627317 www197.neopets.com 207.218.164.197 neopets ---TRANSACTION 0 1053383954, not started, process no 24404, OS thread id 1917046 MySQL thread id 1100, query id 1616241 www153.neopets.com 207.218.164.153 neopets ---TRANSACTION 0 1053394704, not started, process no 24399, OS thread id 1835121 MySQL thread id 1055, query id 1627912 www192.sjo.neopets.com 206.132.214.192 neopets ---TRANSACTION 0 1053395354, not started, process no 24366, OS thread id 1294416 MySQL thread id 1097, query id 1628644 www197.sjo.neopets.com 206.132.214.197 neopets ---TRANSACTION 0 1053394191, not started, process no 24340, OS thread id 868406 MySQL thread id 1095, query id 1627315 www190.sjo.neopets.com 206.132.214.190 neopets ---TRANSACTION 0 1053394730, not started, process no 24584, OS thread id 3817635 MySQL thread id 1079, query id 1627939 www217.neopets.com 207.218.164.217 neopets ---TRANSACTION 0 1053390333, not started, process no 24456, OS thread id 2769066 MySQL thread id 925, query id 1623125 www218.neopets.com 207.218.164.218 neopets ---TRANSACTION 0 1053393665, not started, process no 24397, OS thread id 1802351 MySQL thread id 1082, query id 1626740 www130.neopets.com 207.218.164.130 neopets ---TRANSACTION 0 1053324481, not started, process no 24358, OS thread id 1163336 MySQL thread id 1031, query id 1552602 www189.neopets.com 207.218.164.189 neopets ---TRANSACTION 0 1053366726, not started, process no 24296, OS thread id 163851 MySQL thread id 947, query id 1597838 www149.neopets.com 207.218.164.149 neopets ---TRANSACTION 0 1053396770, not started, process no 24310, OS thread id 393241 MySQL thread id 928, query id 1630172 www226.neopets.com 207.218.164.226 neopets ---TRANSACTION 0 1053392386, not started, process no 24346, OS thread id 966716 MySQL thread id 1072, query id 1625369 www102.neopets.com 207.218.164.102 neopets ---TRANSACTION 0 1053391871, not started, process no 24569, OS thread id 3571781 MySQL thread id 939, query id 1624723 www155.neopets.com 207.218.164.155 neopets ---TRANSACTION 0 1053392290, not started, process no 24486, OS thread id 3261445 MySQL thread id 1068, query id 1625237 www100.neopets.com 207.218.164.100 neopets ---TRANSACTION 0 1053387900, not started, process no 24303, OS thread id 278546 MySQL thread id 1002, query id 1620571 www236.neopets.com 207.218.164.236 neopets ---TRANSACTION 0 1053392146, not started, process no 24307, OS thread id 344086 MySQL thread id 1058, query id 1625050 www195.neopets.com 207.218.164.195 neopets ---TRANSACTION 0 1053396791, not started, process no 24420, OS thread id 2179206 MySQL thread id 1050, query id 1630193 www106.neopets.com 207.218.164.106 neopets ---TRANSACTION 0 1053396812, not started, process no 24409, OS thread id 1998971 MySQL thread id 931, query id 1630215 www221.neopets.com 207.218.164.221 neopets ---TRANSACTION 0 1053392088, not started, process no 24473, OS thread id 3047611 MySQL thread id 1051, query id 1624978 www128.neopets.com 207.218.164.128 neopets ---TRANSACTION 0 1053389024, not started, process no 24465, OS thread id 2916531 MySQL thread id 1026, query id 1621751 www214.sjo.neopets.com 206.132.214.214 neopets ---TRANSACTION 0 1053396315, not started, process no 24388, OS thread id 1654886 MySQL thread id 954, query id 1629651 www225.sjo.neopets.com 206.132.214.225 neopets ---TRANSACTION 0 1053396142, not started, process no 24362, OS thread id 1228876 MySQL thread id 1070, query id 1629452 www228.neopets.com 207.218.164.228 neopets ---TRANSACTION 0 1053373519, not started, process no 24348, OS thread id 999486 MySQL thread id 982, query id 1605442 www178.neopets.com 207.218.164.178 neopets ---TRANSACTION 0 1053395029, not started, process no 24581, OS thread id 3768399 MySQL thread id 1038, query id 1628298 www231.neopets.com 207.218.164.231 neopets ---TRANSACTION 0 1053392362, not started, process no 24390, OS thread id 1687656 MySQL thread id 1054, query id 1625344 www101.neopets.com 207.218.164.101 neopets ---TRANSACTION 0 1053394437, not started, process no 24469, OS thread id 2982071 MySQL thread id 1060, query id 1627586 www207.neopets.com 207.218.164.207 neopets ---TRANSACTION 0 1053393582, not started, process no 24536, OS thread id 3506241 MySQL thread id 1061, query id 1626638 www108.neopets.com 207.218.164.108 neopets ---TRANSACTION 0 1053374075, not started, process no 24316, OS thread id 491551 MySQL thread id 1044, query id 1606033 www215.neopets.com 207.218.164.215 neopets ---TRANSACTION 0 1053392321, not started, process no 24566, OS thread id 3522583 MySQL thread id 936, query id 1625285 www146.sjo.neopets.com 206.132.214.146 neopets ---TRANSACTION 0 1053394729, not started, process no 24441, OS thread id 2523291 MySQL thread id 1043, query id 1627937 www167.sjo.neopets.com 206.132.214.167 neopets ---TRANSACTION 0 1053385035, not started, process no 24315, OS thread id 475166 MySQL thread id 994, query id 1617431 www207.sjo.neopets.com 206.132.214.207 neopets ---TRANSACTION 0 1053397302, not started, process no 24466, OS thread id 2932916 MySQL thread id 412, query id 1630720 www173.sjo.neopets.com 206.132.214.173 neopets ---TRANSACTION 0 1053394824, not started, process no 24422, OS thread id 2211976 MySQL thread id 1034, query id 1628038 www170.neopets.com 207.218.164.170 neopets ---TRANSACTION 0 1053392211, not started, process no 24459, OS thread id 2818221 MySQL thread id 1029, query id 1625154 www168.sjo.neopets.com 206.132.214.168 neopets ---TRANSACTION 0 1053396641, not started, process no 24488, OS thread id 3294215 MySQL thread id 1021, query id 1629998 www169.sjo.neopets.com 206.132.214.169 neopets ---TRANSACTION 0 1053392319, not started, process no 24430, OS thread id 2343056 MySQL thread id 1049, query id 1625281 www199.sjo.neopets.com 206.132.214.199 neopets ---TRANSACTION 0 1053388296, not started, process no 24464, OS thread id 2900146 MySQL thread id 1045, query id 1620986 www222.neopets.com 207.218.164.222 neopets ---TRANSACTION 0 1053394581, not started, process no 24524, OS thread id 3392525 MySQL thread id 1016, query id 1627757 www159.neopets.com 207.218.164.159 neopets ---TRANSACTION 0 1053387853, not started, process no 24360, OS thread id 1196106 MySQL thread id 958, query id 1620509 www161.sjo.neopets.com 206.132.214.161 neopets ---TRANSACTION 0 1053390793, not started, process no 24445, OS thread id 2588831 MySQL thread id 1027, query id 1623614 www184.sjo.neopets.com 206.132.214.184 neopets ---TRANSACTION 0 1053388323, not started, process no 24328, OS thread id 688171 MySQL thread id 999, query id 1621028 www144.sjo.neopets.com 206.132.214.144 neopets ---TRANSACTION 0 1053382911, not started, process no 24583, OS thread id 3801214 MySQL thread id 1040, query id 1615152 www185.neopets.com 207.218.164.185 neopets ---TRANSACTION 0 1053384588, not started, process no 24577, OS thread id 3702945 MySQL thread id 1028, query id 1616923 www148.sjo.neopets.com 206.132.214.148 neopets ---TRANSACTION 0 1053393609, not started, process no 24578, OS thread id 3719196 MySQL thread id 1035, query id 1626669 www173.neopets.com 207.218.164.173 neopets ---TRANSACTION 0 1053392314, not started, process no 24470, OS thread id 2998456 MySQL thread id 1024, query id 1625271 www166.sjo.neopets.com 206.132.214.166 neopets ---TRANSACTION 0 1053390595, not started, process no 24314, OS thread id 458781 MySQL thread id 1000, query id 1623413 www178.sjo.neopets.com 206.132.214.178 neopets ---TRANSACTION 0 1053393669, not started, process no 24582, OS thread id 3784786 MySQL thread id 1039, query id 1626743 www211.neopets.com 207.218.164.211 neopets ---TRANSACTION 0 1053394841, not started, process no 24454, OS thread id 2736296 MySQL thread id 1030, query id 1628065 www214.neopets.com 207.218.164.214 neopets ---TRANSACTION 0 1053345116, not started, process no 24444, OS thread id 2572446 MySQL thread id 1015, query id 1574974 www180.neopets.com 207.218.164.180 neopets ---TRANSACTION 0 1053392415, not started, process no 24357, OS thread id 1146951 MySQL thread id 1019, query id 1625408 www114.neopets.com 207.218.164.114 neopets ---TRANSACTION 0 1053396739, not started, process no 24331, OS thread id 737326 MySQL thread id 1025, query id 1630124 www180.sjo.neopets.com 206.132.214.180 neopets ---TRANSACTION 0 1053395205, not started, process no 24376, OS thread id 1458266 MySQL thread id 1010, query id 1628483 www103.neopets.com 207.218.164.103 neopets ---TRANSACTION 0 1053396767, not started, process no 24580, OS thread id 3751985 MySQL thread id 1037, query id 1630168 www156.sjo.neopets.com 206.132.214.156 neopets ---TRANSACTION 0 1053392298, not started, process no 24579, OS thread id 3735592 MySQL thread id 1036, query id 1625245 www131.neopets.com 207.218.164.131 neopets ---TRANSACTION 0 1053392323, not started, process no 24394, OS thread id 1753196 MySQL thread id 1003, query id 1625292 www209.neopets.com 207.218.164.209 neopets ---TRANSACTION 0 1053394852, not started, process no 24401, OS thread id 1867891 MySQL thread id 1009, query id 1628085 www107.neopets.com 207.218.164.107 neopets ---TRANSACTION 0 1053394853, not started, process no 24332, OS thread id 753711 MySQL thread id 1006, query id 1628087 www212.neopets.com 207.218.164.212 neopets ---TRANSACTION 0 1053392344, not started, process no 24434, OS thread id 2408596 MySQL thread id 974, query id 1625323 www160.sjo.neopets.com 206.132.214.160 neopets ---TRANSACTION 0 1053394842, not started, process no 24426, OS thread id 2277516 MySQL thread id 984, query id 1628069 www109.neopets.com 207.218.164.109 neopets ---TRANSACTION 0 1053384608, not started, process no 24436, OS thread id 2441366 MySQL thread id 992, query id 1616959 www126.neopets.com 207.218.164.126 neopets ---TRANSACTION 0 1053396762, not started, process no 24318, OS thread id 524321 MySQL thread id 932, query id 1630159 www215.sjo.neopets.com 206.132.214.215 neopets ---TRANSACTION 0 1053387410, not started, process no 24468, OS thread id 2965686 MySQL thread id 993, query id 1620015 www195.sjo.neopets.com 206.132.214.195 neopets ---TRANSACTION 0 1053396188, not started, process no 24443, OS thread id 2556061 MySQL thread id 493, query id 1629505 www191.sjo.neopets.com 206.132.214.191 neopets ---TRANSACTION 0 1053394797, not started, process no 24568, OS thread id 3555379 MySQL thread id 938, query id 1628009 www194.neopets.com 207.218.164.194 neopets ---TRANSACTION 0 1053394239, not started, process no 24457, OS thread id 2785451 MySQL thread id 953, query id 1627373 www163.sjo.neopets.com 206.132.214.163 neopets ---TRANSACTION 0 1053391870, not started, process no 24489, OS thread id 3310600 MySQL thread id 986, query id 1624721 www200.neopets.com 207.218.164.200 neopets ---TRANSACTION 0 1053396254, not started, process no 24478, OS thread id 3129773 MySQL thread id 962, query id 1629584 www196.sjo.neopets.com 206.132.214.196 neopets ---TRANSACTION 0 1053394586, not started, process no 24305, OS thread id 311316 MySQL thread id 983, query id 1627765 www229.neopets.com 207.218.164.229 neopets ---TRANSACTION 0 1053396732, not started, process no 24319, OS thread id 540706 MySQL thread id 973, query id 1630106 www143.sjo.neopets.com 206.132.214.143 neopets ---TRANSACTION 0 1053394445, not started, process no 24321, OS thread id 573476 MySQL thread id 935, query id 1627596 www151.sjo.neopets.com 206.132.214.151 neopets ---TRANSACTION 0 1053392067, not started, process no 24416, OS thread id 2113666 MySQL thread id 955, query id 1624957 www204.sjo.neopets.com 206.132.214.204 neopets ---TRANSACTION 0 1053380756, not started, process no 24302, OS thread id 262161 MySQL thread id 927, query id 1612909 www165.sjo.neopets.com 206.132.214.165 neopets ---TRANSACTION 0 1053396200, not started, process no 24576, OS thread id 3686556 MySQL thread id 949, query id 1629525 www193.sjo.neopets.com 206.132.214.193 neopets ---TRANSACTION 0 1053395008, not started, process no 24439, OS thread id 2490521 MySQL thread id 964, query id 1628274 www227.neopets.com 207.218.164.227 neopets ---TRANSACTION 0 1053392514, not started, process no 24383, OS thread id 1572961 MySQL thread id 956, query id 1625518 www172.sjo.neopets.com 206.132.214.172 neopets ---TRANSACTION 0 1053333704, not started, process no 24419, OS thread id 2162821 MySQL thread id 959, query id 1562311 www110.neopets.com 207.218.164.110 neopets ---TRANSACTION 0 1053369327, not started, process no 24451, OS thread id 2687141 MySQL thread id 963, query id 1600917 www142.neopets.com 207.218.164.142 neopets ---TRANSACTION 0 1053396735, not started, process no 24461, OS thread id 2850991 MySQL thread id 934, query id 1630114 www198.neopets.com 207.218.164.198 neopets ---TRANSACTION 0 1053391483, not started, process no 24306, OS thread id 327701 MySQL thread id 921, query id 1624313 www155.sjo.neopets.com 206.132.214.155 neopets ---TRANSACTION 0 1053390242, not started, process no 24427, OS thread id 2293901 MySQL thread id 952, query id 1623023 www201.sjo.neopets.com 206.132.214.201 neopets ---TRANSACTION 0 1053397163, not started, process no 24471, OS thread id 3014841 MySQL thread id 960, query id 1630577 www145.sjo.neopets.com 206.132.214.145 neopets ---TRANSACTION 0 1053376989, not started, process no 24405, OS thread id 1933431 MySQL thread id 922, query id 1609035 petpages.sjo.neopets.com 206.132.214.128 neopets ---TRANSACTION 0 1053375263, not started, process no 24369, OS thread id 1343571 MySQL thread id 942, query id 1607273 www174.neopets.com 207.218.164.174 neopets ---TRANSACTION 0 1053396981, not started, process no 24386, OS thread id 1622116 MySQL thread id 957, query id 1630390 www216.neopets.com 207.218.164.216 neopets ---TRANSACTION 0 1053388055, not started, process no 24433, OS thread id 2392211 MySQL thread id 923, query id 1620742 www150.sjo.neopets.com 206.132.214.150 neopets ---TRANSACTION 0 1053387309, not started, process no 24424, OS thread id 2244746 MySQL thread id 912, query id 1619893 www161.neopets.com 207.218.164.161 neopets ---TRANSACTION 0 1052488458, not started, process no 24528, OS thread id 3458065 MySQL thread id 269, query id 543883 www139.neopets.com 207.218.164.139 neopets ---TRANSACTION 0 1052179279, not started, process no 24526, OS thread id 3425295 MySQL thread id 268, query id 36670 www139.neopets.com 207.218.164.139 neopets ---TRANSACTION 0 1053394133, not started, process no 24485, OS thread id 3245060 MySQL thread id 193, query id 1627240 neoadmin.neopets.com 207.218.164.61 neopets ---TRANSACTION 0 1052156963, not started, process no 24484, OS thread id 3228675 MySQL thread id 192, query id 697 neoadmin.neopets.com 207.218.164.61 neopets ---TRANSACTION 0 1053397776, ACTIVE 0 sec, process no 24588, OS thread id 3884030 updating or deleting, thread declared inside InnoD B 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 1279, query id 1631205 www234.neopets.com 207.218.164.234 neopets updating DELETE FROM neomessages WHERE message_id='614275769' AND (save = 0 OR save IS NULL) ---TRANSACTION 0 1053397775, ACTIVE 0 sec, process no 24943, OS thread id 3899568 updating or deleting, thread declared inside InnoD B 499 mysql tables in use 1, locked 1 2 lock struct(s), heap size 320, undo log entries 1 MySQL thread id 2154, query id 1631204 db04.neopets.com 206.132.214.44 neopets updating delete from neomessages where message_id = '599535943' -------- FILE I/O -------- I/O thread 0 state: waiting for i/o request (insert buffer thread) I/O thread 1 state: waiting for i/o request (log thread) I/O thread 2 state: waiting for i/o request (read thread) I/O thread 3 state: waiting for i/o request (write thread) Pending normal aio reads: 0, aio writes: 0, ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 0; buffer pool: 0 1637269 OS file reads, 264671 OS file writes, 29856 OS fsyncs 382.54 reads/s, 17077 avg bytes/read, 179.43 writes/s, 13.00 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf for space 0: size 17, free list len 18245, seg size 18263, is not empty Ibuf for space 0: size 17, free list len 18245, seg size 18263, 36139 inserts, 78654 merged recs, 23989 merges Hash table size 4425293, used cells 1251775, node heap has 1444 buffer(s) 3223.30 hash searches/s, 5223.05 non-hash searches/s --- LOG --- Log sequence number 50 4193895871 Log flushed up to 50 4193179980 Last checkpoint at 50 4041525739 0 pending log writes, 0 pending chkp writes 6459 log i/o's done, 0.81 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1158312296; in additional pool allocated 1395328 Buffer pool size 65536 Free buffers 0 Database pages 64092 Modified db pages 29762 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages read 1723303, created 1674, written 293344 399.73 reads/s, 0.06 creates/s, 214.05 writes/s Buffer pool hit rate 990 / 1000 -------------- ROW OPERATIONS -------------- 1 queries inside InnoDB, 0 queries in queue Main thread process no. 24293, id 114696, state: purging Number of rows inserted 33666, updated 93291, deleted 334703, read 21865699 3.31 inserts/s, 12.12 updates/s, 319.54 deletes/s, 1706.21 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================