show full processlist; +--------+-------------+--------------------+------+---------+--------+----------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+-------------+--------------------+------+---------+--------+----------------------------------+------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+ | 1 | system user | | NULL | Connect | 116007 | Waiting for master to send event | NULL | | 2 | system user | | esea | Connect | 23283 | Locked | UPDATE servers SET map = 'aim_mp5' WHERE id = 146 | | 871261 | global | 69.93.50.154:44896 | esea | Query | 23150 | preparing | SELECT s.id AS server_id, s.host AS server_host, g.icon AS game_icon, u3.user_id AS is_playing, u.id, u.is_premium, u.alias, u.profile_xfire, c.id AS country_abbr, c.name AS country_name, u4.last_view FROM (users u, countries c, users_buddies u2) LEFT JOIN users_playing u3 ON u3.user_id = u.id LEFT JOIN servers s ON u3.server_id = s.id LEFT JOIN games g ON s.game_id = g.id LEFT JOIN users_online u4 ON u4.user_id = u.id AND u4.site_id = '1' WHERE u2.buddy_id = u.id AND u.country = c.id AND u2.user_id = '' | | 871262 | global | 69.93.50.154:44899 | esea | Query | 23150 | Locked | SELECT g.abbr AS game_abbr, COUNT(*) AS total_players FROM users_playing u, games g, servers s, servers_locations s2 WHERE u.game_id = g.id AND u.server_id = s.id AND s.location = s2.id AND s2.region_id IN(1) GROUP BY g.id | | Status information: Current dir: /usr/local/mysql/var/ Running threads: 81 Stack size: 262144 Current locks: lock: 0x8d05c08: lock: 0x2aaae82bb258: lock: 0x2aaae41023d8: lock: 0x2aaae40b23c8: lock: 0x853a918: read read : 0x8569240 (871263:1); 0x8f66070 (871264:1); 0x8d13ae0 (871265:1); 0x8faa020 (871267:1); 0x91fad50 (871270:1); 0x91de380 (871272:1); 0x91990d0 (871273:1); 0x954dea0 (871274:1); 0x2aaaec036c80 (871275:1); 0x8d85f30 (871277:1); 0x9310250 (871278:1); 0x84ace00 (871280:1); 0x839d030 (871283:1); 0x8396880 (871284:1); 0x946ed60 (871294:1); 0x89ee540 (871295:1); 0x9262e40 (871296:1); 0x921f140 (871300:1); 0x2aaae407db50 (871302:1); 0x921e1f0 (871303:1); 0x93813b0 (871306:1); 0x83e9b20 (871307:1); 0x7c6f640 (871308:1); 0x2aaae4241df0 (871310:1); 0x91eff10 (871312:1); 0x842a410 (871314:1); 0x2aaaec0098c0 (871315:1); 0x854f790 (871316:1); 0x84874b0 (871317:1); 0x7d976d0 (871319:1); 0x8198380 (871320:1); 0x955b520 (871321:1); 0x81a9270 (871322:1); 0x8ad7be0 (871324:1); 0x85922e0 (871325:1); 0x8adc050 (871326:1); 0x822e530 (871327:1); 0x8d8bca0 (871329:1); 0x94a9180 (871331:1); 0x84326b0 (871332:1); 0x92eb690 (871334:1); 0x9245f00 (871335:1); 0x7dc34a0 (871337:1); 0x9441670 (871336:1); 0x7d13b90 (871338:1); 0x80bdc40 (871340:1); 0x94668b0 (871349:1); 0x8aa2fd0 (871356:1); 0x91b0f40 (871360:1); 0x937e4f0 (871363:1); lock: 0x7dab390: lock: 0x939db18: write_wait read read_wait write_wait: 0x9529f70 (2:11); read : 0x2aaae413c2d0 (871261:1); read_wait : 0x2aaae4205360 (871262:1); 0x8fadd70 (871263:1); 0x2aaaec0e87a0 (871264:1); 0x2aaaec0dddf0 (871265:1); 0x2aaae8069250 (871267:1); 0x938fc60 (871268:1); 0x94b8240 (871270:1); 0x956c400 (871271:1); 0x844d260 (871269:1); 0x93e6cb0 (871272:1); 0x84bae80 (871273:1); 0x94e1b10 (871274:1); 0x2aaaec1264f0 (871275:1); 0x9196460 (871277:1); 0x91d3fb0 (871278:1); 0x83e4fa0 (871280:1); 0x2aaae40ce760 (871282:1); 0x8f633b0 (871283:1); 0x9176b70 (871284:1); 0x92556b0 (871285:1); 0x95378f0 (871286:1); 0x89e9d10 (871287:1); 0x92d8c10 (871289:1); 0x2aaaec7f6350 (871290:1); 0x80cf6c0 (871292:1); 0x93a0ae0 (871293:1); 0x834faf0 (871294:1); 0x89f2c50 (871295:1); 0x7ff3550 (871296:1); 0x7f24cc0 (871297:1); 0x8aa55e0 (871300:1); 0x91c53f0 (871301:1); 0x2aaae4110080 (871302:1); 0x93dbf40 (871303:1); 0x92f82a0 (871304:1); 0x7cc8610 (871305:1); 0x93836b0 (871306:1); 0x7caf050 (871307:1); 0x92724e0 (871308:1); 0x2aaaec130b60 (871309:1); 0x2aaae411b5b0 (871310:1); 0x2aaaec513980 (871311:1); 0x9327f30 (871312:1); 0x91ff6c0 (871314:1); 0x2aaaec19c6a0 (871315:1); 0x8579c90 (871316:1); 0x84880d0 (871317:1); 0x9f226b0 (871318:1); 0x7d99e80 (871319:1); 0x942b0c0 (871320:1); 0x95604c0 (871321:1); 0x81aada0 (871322:1); 0x9476820 (871324:1); 0x8593e10 (871325:1); 0x8ade3f0 (871326:1); 0x8ae4d10 (871328:1); 0x82334d0 (871327:1); 0x8d90c40 (871329:1); 0x94cb420 (871330:1); 0x94a9da0 (871331:1); 0x8cb09d0 (871332:1); 0x92e3ea0 (871333:1); 0x9246e50 (871334:1); 0x8d20920 (871335:1); 0x7dc6360 (871337:1); 0x94449e0 (871336:1); 0x7d18740 (871338:1); 0x80c1780 (871340:1); 0x9452130 (871349:1); 0x7d2a740 (871354:1); 0x7f3a730 (871355:1); 0x7f3f6c0 (871356:1); 0x8d4c200 (871359:1); 0x93b73d0 (871358:1); 0x91a3df0 (871361:1); 0x91b1b60 (871360:1); 0x86fa6d0 (871362:1); 0x824d1f0 (871363:1); 0x8265de0 (871366:1); lock: 0x843ba20: lock: 0x8484468: read read : 0x8f84b30 (871261:1); 0x957e390 (871263:1); 0x95500c0 (871264:1); 0x86e5a70 (871265:1); 0x2aaaec47c0a0 (871267:1); 0x2aaaec1c3210 (871268:1); 0x7c5ad20 (871270:1); 0x91d9fb0 (871271:1); 0x927a0c0 (871272:1); 0x8588240 (871273:1); 0x85678e0 (871274:1); 0x8249450 (871275:1); 0x2aaae411fe20 (871277:1); 0x94964c0 (871278:1); 0x8300610 (871280:1); 0x855d970 (871283:1); 0x84a3500 (871284:1); 0x8384c80 (871294:1); 0x915cf30 (871295:1); 0x84198c0 (871296:1); 0x7daa2c0 (871297:1); 0x927d4e0 (871300:1); 0x91f57d0 (871301:1); 0x940fb00 (871302:1); 0x2aaae8f50000 (871303:1); 0x2aaae8fbb0b0 (871304:1); 0x94d2b70 (871306:1); 0x93259d0 (871307:1); 0x802a970 (871308:1); 0x2aaae4076310 (871310:1); 0x6a5a8d0 (871312:1); 0x9405f50 (871314:1); 0x952fc70 (871315:1); 0x91d5d80 (871316:1); 0x83d0dd0 (871317:1); 0x7d95d70 (871319:1); 0x8195590 (871320:1); 0x9556320 (871321:1); 0x93fff20 (871322:1); 0x81b6e90 (871324:1); 0x9422c70 (871325:1); 0x9494250 (871326:1); 0x8ae7da0 (871327:1); 0x8d89ab0 (871329:1); 0x94a6c60 (871331:1); 0x8caf070 (871332:1); 0x92f2540 (871334:1); 0x92ea960 (871335:1); 0x7dc0300 (871337:1); 0x943c080 (871336:1); 0x7d12230 (871338:1); 0x80bae50 (871340:1); 0x9460f40 (871349:1); 0x7d35cd0 (871354:1); 0x9459bf0 (871356:1); 0x91ae210 (871360:1); 0x86f4680 (871362:1); 0x9eee9d0 (871363:1); 0x82606d0 (871366:1); lock: 0x83290a8: read read : 0x2aaaec7e0700 (871282:1); 0x2aaaec198c30 (871285:1); 0x8f48a00 (871286:1); 0x846c8a0 (871287:1); 0x8437c30 (871289:1); 0x953a530 (871290:1); 0x2aaaec16c220 (871292:1); 0x8099b10 (871293:1); 0x8d12ef0 (871305:1); 0x2aaaec1d11f0 (871318:1); 0x9563e80 (871355:1); 0x8d47cc0 (871359:1); 0x9564b30 (871358:1); 0x7df4e10 (871361:1); lock: 0x7c5a568: read read : 0x2aaaec7e1f20 (871282:1); 0x8fb8780 (871285:1); 0x2aaaec1393d0 (871286:1); 0x938cfe0 (871287:1); 0x7c5eb10 (871289:1); 0x2aaaecb4a800 (871290:1); 0x2aaaec110cb0 (871292:1); 0x2aaae4124490 (871293:1); 0x2aaae8d6d280 (871305:1); 0x83decc0 (871318:1); 0x7d3aa10 (871355:1); 0x8d488b0 (871359:1); 0x8d50ec0 (871358:1); 0x8d46d70 (871361:1); lock: 0x82e0ba8: read read : 0x2aaaec7e4b70 (871305:1); 0x916efc0 (871318:1); 0x93b8cc0 (871358:1); lock: 0x845f3d0: lock: 0x85266d0: lock: 0x834acd8: read read : 0x8fa2440 (871262:1); 0x84115c0 (871268:1); 0x84109a0 (871271:1); 0x8c99d60 (871269:1); 0x82f6ae0 (871297:1); 0x91c8150 (871301:1); 0x9509e70 (871304:1); 0x2aaaec0f1b20 (871309:1); 0x2aaaec2529a0 (871311:1); 0x858e9a0 (871328:1); 0x94ce960 (871330:1); 0x9483eb0 (871333:1); 0x7d226f0 (871354:1); 0x86fd820 (871362:1); 0x82633f0 (871366:1); lock: 0x836a738: read read : 0x8d10fc0 (871261:1); 0x2aaae40b0770 (871268:1); 0x92577a0 (871271:1); 0x2aaae421c9b0 (871297:1); 0x2aaaec40d8b0 (871301:1); 0x7da0500 (871304:1); 0x7d23300 (871354:1); 0x7aafeb0 (871362:1); 0x8255b90 (871366:1); lock: 0x833be18: read read : 0x2aaaec7eb2f0 (871282:1); 0x2aaaec7e8260 (871282:1); 0x2aaaecb4b4c0 (871285:1); 0x92dabf0 (871285:1); 0x94b5900 (871286:1); 0x2aaae40bc650 (871286:1); 0x8fb6be0 (871287:1); 0x7ccaea0 (871287:1); 0x84497a0 (871289:1); 0x8469b90 (871289:1); 0x953b2c0 (871290:1); 0x2aaaec041090 (871290:1); 0x2aaaec14f120 (871292:1); 0x2aaae843a260 (871292:1); 0x2aaae80af8d0 (871293:1); 0x843a230 (871293:1); 0x92c16b0 (871305:1); 0x2aaaec15bea0 (871305:1); 0x2aaaec7fde10 (871318:1); 0x2aaae868bf00 (871318:1); 0x7f3c020 (871355:1); 0x82e35f0 (871355:1); 0x84824f0 (871359:1); 0x9566b70 (871359:1); 0x8f47410 (871358:1); 0x83d5280 (871358:1); 0x86ee640 (871361:1); 0x83fef60 (871361:1); lock: 0x8332468: read read : 0x2aaae4140460 (871261:1); 0x951ea60 (871262:1); 0x2aaae4068930 (871269:1); 0x93ea440 (871282:1); 0x2aaaec0eb4d0 (871285:1); 0x2aaaec169250 (871286:1); 0x2aaae86c5700 (871287:1); 0x84147f0 (871289:1); 0x8247500 (871290:1); 0x921a200 (871292:1); 0x831a5b0 (871293:1); 0x2aaaec452f70 (871305:1); 0x2aaaec461dc0 (871309:1); 0x2aaaec16f320 (871311:1); 0x7caa0b0 (871318:1); 0x7ccfb50 (871328:1); 0x94c7520 (871330:1); 0x841c530 (871333:1); 0x83f45d0 (871355:1); 0x8d4e2e0 (871359:1); 0x93272e0 (871358:1); 0x91a6b20 (871361:1); lock: 0x832d638: read read : 0x2aaaecb46340 (871282:1); 0x89b1b60 (871285:1); 0x2aaaec0f95e0 (871286:1); 0x9207990 (871287:1); 0x86e6980 (871289:1); 0x2aaaec0dd1f0 (871290:1); 0x8331800 (871292:1); 0x2aaaec189840 (871293:1); 0x2aaaec047360 (871305:1); 0x94eaf70 (871318:1); 0x8346c50 (871355:1); 0x8d49f30 (871359:1); 0x7d82eb0 (871358:1); 0x93d0590 (871361:1); lock: 0x831f0f8: read read : 0x92fe670 (871305:1); 0x92fcd70 (871318:1); 0x93b98e0 (871358:1); lock: 0x2aaae40abb18: read read : 0x8f87f80 (871261:1); lock: 0x819bc20: read read : 0x2aaae40d01a0 (871261:1); 0x8f43560 (871262:1); 0x2aaae41d9ad0 (871263:1); 0x94d87b0 (871264:1); 0x2aaaec120890 (871265:1); 0x2aaaec1c8410 (871267:1); 0x2aaaec4505d0 (871268:1); 0x83b0d60 (871270:1); 0x8b5ea20 (871271:1); 0x84b2240 (871269:1); 0x8fa18c0 (871272:1); 0x951b630 (871273:1); 0x8aa44f0 (871274:1); 0x2aaaec518590 (871275:1); 0x8558150 (871277:1); 0x951f5e0 (871278:1); 0x80d73b0 (871280:1); 0x91f1b90 (871283:1); 0x953ff30 (871284:1); 0x84697f0 (871294:1); 0x919a930 (871295:1); 0x846dc60 (871296:1); 0x91f6460 (871297:1); 0x92cbfd0 (871300:1); 0x82ea300 (871301:1); 0x2aaae40fe700 (871302:1); 0x7cbf760 (871303:1); 0x9306750 (871304:1); 0x7cd9460 (871306:1); 0x7f28920 (871307:1); 0x8aad3e0 (871308:1); 0x2aaaec13af00 (871309:1); 0x2aaae40d7bc0 (871310:1); 0x2aaaec519cd0 (871311:1); 0x9265760 (871312:1); 0x856a660 (871314:1); 0x2aaaec5151d0 (871315:1); 0x9576e00 (871316:1); 0x92da850 (871317:1); 0x83e6f20 (871319:1); 0x8fb2920 (871320:1); 0x8f823d0 (871321:1); 0x830b750 (871322:1); 0x83f9e50 (871324:1); 0x8394be0 (871325:1); 0x8d077a0 (871326:1); 0x84a7180 (871328:1); 0x82e83c0 (871327:1); 0x8ae8a30 (871329:1); 0x93918a0 (871330:1); 0x86db890 (871331:1); 0x809c400 (871332:1); 0x8d14660 (871333:1); 0x82fc390 (871334:1); 0x92e7b00 (871335:1); 0x8d1f670 (871337:1); 0x7ee7050 (871336:1); 0x91980a0 (871338:1); 0x830be70 (871340:1); 0x89f5610 (871349:1); 0x93034e0 (871354:1); 0x7d2c380 (871356:1); 0x93622f0 (871360:1); 0x8090950 (871362:1); 0x95687b0 (871363:1); 0x94eabd0 (871366:1); lock: 0x7db41c0: lock: 0x7ab9bc0: read read : 0x92b3de0 (871261:1); 0x9f2c7a0 (871263:1); 0x2aaae4142aa0 (871264:1); 0x2aaae406a100 (871265:1); 0x83fdc10 (871267:1); 0x2aaaec801b60 (871270:1); 0x2aaaec4ffff0 (871272:1); 0x2aaae82930e0 (871273:1); 0x7d8adc0 (871274:1); 0x2aaaec7f5dd0 (871275:1); 0x84a0cc0 (871277:1); 0x91d5800 (871278:1); 0x9194d80 (871280:1); 0x83952e0 (871283:1); 0x9399900 (871284:1); 0x8351fc0 (871294:1); 0x6a59470 (871295:1); 0x7ff69f0 (871296:1); 0x8aa8690 (871300:1); 0x2aaae40d3260 (871302:1); 0x93dec00 (871303:1); 0x849eaa0 (871306:1); 0x9576920 (871307:1); 0x9318460 (871308:1); 0x2aaae4135b90 (871310:1); 0x9203170 (871312:1); 0x8510330 (871314:1); 0x2aaaec401f10 (871315:1); 0x8031d20 (871316:1); 0x84a9560 (871317:1); 0x8fb2440 (871319:1); 0x942e560 (871320:1); 0x93f4b70 (871321:1); 0x842d5b0 (871322:1); 0x84b9d20 (871324:1); 0x8596ec0 (871325:1); 0x8ae1890 (871326:1); 0x86cf730 (871327:1); 0x8d940e0 (871329:1); 0x82e3070 (871331:1); 0x92d1500 (871332:1); 0x91f37e0 (871334:1); 0x924eea0 (871335:1); 0x9204220 (871337:1); 0x94472b0 (871336:1); 0x895fec0 (871338:1); 0x937ffb0 (871340:1); 0x9453980 (871349:1); 0x7f42b60 (871356:1); 0x830c180 (871360:1); 0x8250690 (871363:1); Key caches: default Buffer_size: 402653184 Block_size: 1024 Division_limit: 100 Age_limit: 300 blocks used: 298801 not flushed: 0 w_requests: 26667056 writes: 1678629 r_requests: 6193274189 reads: 836180 handler status: read_key: 2118464128 read_next: 2697533145 read_rnd 68090655 read_first: 11511 write: 117539957 delete 247018 update: 102193111 Table status: Opened tables: 12682 Open tables: 512 Open files: 417 Open streams: 0 Alarm status: Active alarms: 1 Max used alarms: 52 Next alarm time: 3600 Thread database.table_name Locked/Waiting Lock_type 2 esea.servers Waiting - write Highest priority write lock 871261 esea.servers Locked - read Low priority read lock 871261 esea.users Locked - read Low priority read lock 871261 esea.users_buddies Locked - read Low priority read lock 871261 esea.games Locked - read Low priority read lock 871261 esea.countries Locked - read Low priority read lock 871261 esea.users_playing Locked - read Low priority read lock 871261 esea.users_online Locked - read Low priority read lock 871262 esea.servers Waiting - read Low priority read lock 871262 esea.servers_locations Locked - read Low priority read lock 871263 esea.recruit_ads_players Locked - read Low priority read lock 871282 statistics.matches Locked - read Low priority read lock 871282 statistics.matches_periods Locked - read Low priority read lock 871282 esea.teams Locked - read Low priority read lock 871282 statistics.maps Locked - read Low priority read lock 871305 statistics.cs_stats_match Locked - read Low priority read lock 871305 statistics.references Locked - read Low priority read lock