mysql> show innodb status\G
*************************** 1. row ***************************
Status:
=====================================
070107 15:09:33 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 2 seconds
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 426443, signal count 291561
--Thread 92251 has waited at page0page.c line 197 for 1.00 seconds the semaphore:
X-lock on RW-latch at 0x431acb68 created in file btr0sea.c line 139
a writer (thread id 92251) has reserved it in mode  wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 746
Last time write locked in file btr0cur.c line 1484
--Thread 804928 has waited at btr0sea.c line 1420 for 1.00 seconds the semaphore:
X-lock on RW-latch at 0x431acb68 created in file btr0sea.c line 139
a writer (thread id 92251) has reserved it in mode  wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 746
Last time write locked in file btr0cur.c line 1484
--Thread 781325 has waited at btr0cur.c line 1484 for 1.00 seconds the semaphore:
X-lock on RW-latch at 0x431acb68 created in file btr0sea.c line 139
a writer (thread id 92251) has reserved it in mode  wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 746
Last time write locked in file btr0cur.c line 1484
--Thread 194751 has waited at btr0cur.c line 1484 for 1.00 seconds the semaphore:
X-lock on RW-latch at 0x431acb68 created in file btr0sea.c line 139
a writer (thread id 92251) has reserved it in mode  wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 746
Last time write locked in file btr0cur.c line 1484
--Thread 966874 has waited at btr0cur.c line 1484 for 1.00 seconds the semaphore:
X-lock on RW-latch at 0x431acb68 created in file btr0sea.c line 139
a writer (thread id 92251) has reserved it in mode  wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 746
Last time write locked in file btr0cur.c line 1484
--Thread 120951 has waited at btr0cur.c line 1484 for 1.00 seconds the semaphore:
X-lock on RW-latch at 0x431acb68 created in file btr0sea.c line 139
a writer (thread id 92251) has reserved it in mode  wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 746
Last time write locked in file btr0cur.c line 1484
--Thread 893197 has waited at btr0cur.c line 1484 for 1.00 seconds the semaphore:
X-lock on RW-latch at 0x431acb68 created in file btr0sea.c line 139
a writer (thread id 92251) has reserved it in mode  wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 746
Last time write locked in file btr0cur.c line 1484
--Thread 934923 has waited at btr0cur.c line 1484 for 1.00 seconds the semaphore:
X-lock on RW-latch at 0x431acb68 created in file btr0sea.c line 139
a writer (thread id 92251) has reserved it in mode  wait exclusive
number of readers 0, waiters flag 1
Last time read locked in file btr0sea.c line 746
Last time write locked in file btr0cur.c line 1484
Mutex spin waits 12795886, rounds 57448103, OS waits 237518
RW-shared spins 99814, OS waits 24975; RW-excl spins 365251, OS waits 70117
------------
TRANSACTIONS
------------
Trx id counter 0 996261720
Purge done for trx's n:o < 0 996246225 undo n:o < 0 0
History list length 3563
Total number of lock structs in row lock hash table 7
... truncated...

---TRANSACTION 0 996228406, not started, process no 13423, OS thread id 888057
MySQL thread id 3554, query id 18716756 www1 10.0.0.1 asp
---TRANSACTION 0 996176442, not started, process no 13415, OS thread id 882930 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3549, query id 18751387 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '169459' LIMIT 1
---TRANSACTION 0 996173403, not started, process no 13416, OS thread id 883956
MySQL thread id 3550, query id 18659253 www1 10.0.0.1 asp
---TRANSACTION 0 996261677, not started, process no 13420, OS thread id 884981 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3551, query id 18751276 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '88669' LIMIT 1
---TRANSACTION 0 996259597, not started, process no 13412, OS thread id 880880 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3547, query id 18751409 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '99579' LIMIT 1
---TRANSACTION 0 996173590, not started, process no 13408, OS thread id 879855
MySQL thread id 3546, query id 18659439 www1 10.0.0.1 asp
---TRANSACTION 0 996172930, not started, process no 13398, OS thread id 878830
MySQL thread id 3544, query id 18658758 www1 10.0.0.1 asp
---TRANSACTION 0 996251665, not started, process no 13397, OS thread id 877799 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3543, query id 18751411 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '28026' LIMIT 1
---TRANSACTION 0 996223136, not started, process no 13396, OS thread id 876774
MySQL thread id 3542, query id 18711234 www1 10.0.0.1 asp
---TRANSACTION 0 996172138, not started, process no 13297, OS thread id 873686
MySQL thread id 3541, query id 18657965 www1 10.0.0.1 asp
---TRANSACTION 0 996261533, not started, process no 13295, OS thread id 871634 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3540, query id 18751384 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '212993' LIMIT 1
---TRANSACTION 0 996154048, not started, process no 13283, OS thread id 869572 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3519, query id 18751425 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '78139' LIMIT 1
---TRANSACTION 0 996180658, not started, process no 13064, OS thread id 749761 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3518, query id 18751354 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '141911' LIMIT 1
---TRANSACTION 0 996154112, not started, process no 13275, OS thread id 867512 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3516, query id 18751432 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '180078' LIMIT 1
---TRANSACTION 0 996154080, not started, process no 13276, OS thread id 868538
MySQL thread id 3517, query id 18638944 www1 10.0.0.1 asp
---TRANSACTION 0 996172941, not started, process no 13256, OS thread id 847977
MySQL thread id 3515, query id 18658771 www1 10.0.0.1 asp
---TRANSACTION 0 996172345, not started, process no 13274, OS thread id 866486
MySQL thread id 3514, query id 18658167 www1 10.0.0.1 asp
---TRANSACTION 0 996247491, not started, process no 13273, OS thread id 865456 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3513, query id 18751329 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '288853' LIMIT 1
---TRANSACTION 0 996153852, not started, process no 13272, OS thread id 864431
MySQL thread id 3512, query id 18639117 www1 10.0.0.1 asp
---TRANSACTION 0 996173132, not started, process no 13269, OS thread id 861356
MySQL thread id 3508, query id 18658973 www1 10.0.0.1 asp
---TRANSACTION 0 996252771, not started, process no 13271, OS thread id 863406 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3510, query id 18751312 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '24742' LIMIT 1
---TRANSACTION 0 996173119, not started, process no 13270, OS thread id 862381
MySQL thread id 3509, query id 18658956 www1 10.0.0.1 asp
---TRANSACTION 0 996179644, not started, process no 13268, OS thread id 860330 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3507, query id 18751369 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '89665' LIMIT 1
---TRANSACTION 0 996223090, not started, process no 13267, OS thread id 859305
MySQL thread id 3506, query id 18711189 www1 10.0.0.1 asp
---TRANSACTION 0 996243132, not started, process no 13265, OS thread id 857255
MySQL thread id 3504, query id 18731988 www1 10.0.0.1 asp
---TRANSACTION 0 996261016, not started, process no 13266, OS thread id 858280 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3505, query id 18751309 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '284942' LIMIT 1
---TRANSACTION 0 996173112, not started, process no 13264, OS thread id 856226
MySQL thread id 3503, query id 18658950 www1 10.0.0.1 asp
---TRANSACTION 0 996173067, not started, process no 13255, OS thread id 846951 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3490, query id 18751421 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '58341' LIMIT 1
---TRANSACTION 0 996172818, not started, process no 13263, OS thread id 855200
MySQL thread id 3502, query id 18658638 www1 10.0.0.1 asp
---TRANSACTION 0 996251755, not started, process no 13262, OS thread id 854175 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3501, query id 18751410 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '3599' LIMIT 1
---TRANSACTION 0 996173448, not started, process no 13261, OS thread id 853150
MySQL thread id 3500, query id 18659304 www1 10.0.0.1 asp
---TRANSACTION 0 996173652, not started, process no 13202, OS thread id 823441
MySQL thread id 3499, query id 18659507 www1 10.0.0.1 asp
---TRANSACTION 0 996206633, not started, process no 13258, OS thread id 850062
MySQL thread id 3498, query id 18694033 www1 10.0.0.1 asp
---TRANSACTION 0 996180648, not started, process no 12990, OS thread id 746677 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3489, query id 18751364 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '57499' LIMIT 1
---TRANSACTION 0 996173312, not started, process no 13215, OS thread id 824483
MySQL thread id 3488, query id 18659180 www1 10.0.0.1 asp
---TRANSACTION 0 996243032, not started, process no 13246, OS thread id 845926
MySQL thread id 3487, query id 18731894 www1 10.0.0.1 asp
---TRANSACTION 0 996179765, not started, process no 13245, OS thread id 844894 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3486, query id 18751366 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '56317' LIMIT 1
---TRANSACTION 0 996260863, not started, process no 13244, OS thread id 843865 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3485, query id 18751427 www1 10.0.0.1 asp statistics
SELECT celkem, celkem_dnes, tyden, rank, rank_cat FROM clients_counter WHERE ID = '23534' AND invis=""
---TRANSACTION 0 996172972, not started, process no 13243, OS thread id 842832
MySQL thread id 3484, query id 18658803 www1 10.0.0.1 asp
---TRANSACTION 0 996247463, not started, process no 13242, OS thread id 841802 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3483, query id 18751334 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '202527' LIMIT 1
---TRANSACTION 0 996154072, not started, process no 13240, OS thread id 839739 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3481, query id 18751431 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '307989' LIMIT 1
---TRANSACTION 0 996172784, not started, process no 13241, OS thread id 840764 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3482, query id 18751395 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '23221' LIMIT 1
---TRANSACTION 0 996172174, not started, process no 13239, OS thread id 838714
MySQL thread id 3480, query id 18658019 www1 10.0.0.1 asp
---TRANSACTION 0 996173682, not started, process no 13238, OS thread id 837681
MySQL thread id 3479, query id 18659543 www1 10.0.0.1 asp
---TRANSACTION 0 996261139, not started, process no 13237, OS thread id 836651 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3478, query id 18751302 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '43967' LIMIT 1
---TRANSACTION 0 996172705, not started, process no 13236, OS thread id 835626 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3477, query id 18751404 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '295980' LIMIT 1
---TRANSACTION 0 996180672, not started, process no 13235, OS thread id 834599 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3476, query id 18751350 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '99995' LIMIT 1
---TRANSACTION 0 996247396, not started, process no 13234, OS thread id 833573 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3475, query id 18751325 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '17532' LIMIT 1
---TRANSACTION 0 996178794, not started, process no 13232, OS thread id 831522
MySQL thread id 3473, query id 18664823 www1 10.0.0.1 asp
---TRANSACTION 0 996243084, not started, process no 13231, OS thread id 830494
MySQL thread id 3472, query id 18731933 www1 10.0.0.1 asp
---TRANSACTION 0 996261531, not started, process no 13233, OS thread id 832547 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3474, query id 18751342 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '27181' LIMIT 1
---TRANSACTION 0 996172491, not started, process no 13230, OS thread id 829469
MySQL thread id 3471, query id 18658294 www1 10.0.0.1 asp
---TRANSACTION 0 996180858, not started, process no 13229, OS thread id 828437 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3470, query id 18751346 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '71680' LIMIT 1
---TRANSACTION 0 996172735, not started, process no 13160, OS thread id 813154 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3469, query id 18751397 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '49172' LIMIT 1
---TRANSACTION 0 996172915, not started, process no 10643, OS thread id 441618
MySQL thread id 3468, query id 18658750 www1 10.0.0.1 asp
---TRANSACTION 0 996228597, not started, process no 13227, OS thread id 826588
MySQL thread id 3467, query id 18716939 www1 10.0.0.1 asp
---TRANSACTION 0 996179737, not started, process no 13159, OS thread id 812129 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3466, query id 18751365 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '307989' LIMIT 1
---TRANSACTION 0 996154134, not started, process no 13114, OS thread id 778551
MySQL thread id 3465, query id 18639084 www1 10.0.0.1 asp
---TRANSACTION 0 996243174, not started, process no 13228, OS thread id 827621 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3464, query id 18751429 www1 10.0.0.1 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '247179' LIMIT 1
---TRANSACTION 0 996173168, not started, process no 13216, OS thread id 825521
MySQL thread id 3463, query id 18659036 www1 10.0.0.1 asp
---TRANSACTION 0 996261320, not started, process no 13179, OS thread id 822411 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3372, query id 18751348 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '191211' LIMIT 1
---TRANSACTION 0 996261455, not started, process no 13154, OS thread id 806978 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3371, query id 18751284 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '169462' LIMIT 1
---TRANSACTION 0 996184973, not started, process no 13148, OS thread id 802873 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3370, query id 18751416 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '169780' LIMIT 1
---TRANSACTION 0 996261691, not started, process no 13079, OS thread id 752863 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3369, query id 18751281 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '170800' LIMIT 1
---TRANSACTION 0 996231772, not started, process no 13168, OS thread id 821374
MySQL thread id 3368, query id 18720213 www2 10.0.0.2 asp
---TRANSACTION 0 996259194, not started, process no 13162, OS thread id 815204 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3367, query id 18751310 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '170800' LIMIT 1
---TRANSACTION 0 996261317, not started, process no 13167, OS thread id 820334 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3366, query id 18751300 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '15280' LIMIT 1
---TRANSACTION 0 996186257, not started, process no 13163, OS thread id 816232
MySQL thread id 3365, query id 18672683 www2 10.0.0.2 asp
---TRANSACTION 0 996185139, not started, process no 13166, OS thread id 819308 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3364, query id 18751420 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '75352' LIMIT 1
---TRANSACTION 0 996261693, not started, process no 13164, OS thread id 817258 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3363, query id 18751278 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '354988' LIMIT 1
---TRANSACTION 0 996186197, not started, process no 13156, OS thread id 809030 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3362, query id 18751440 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '127368' LIMIT 1
---TRANSACTION 0 996261322, not started, process no 13153, OS thread id 805953 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3355, query id 18751298 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '102325' LIMIT 1
---TRANSACTION 0 996184919, not started, process no 13161, OS thread id 814179 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3352, query id 18751408 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '130281' LIMIT 1
---TRANSACTION 0 996253395, not started, process no 13157, OS thread id 810056 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3348, query id 18751315 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '11810' LIMIT 1
---TRANSACTION 0 996180944, not started, process no 13155, OS thread id 808003 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3346, query id 18751394 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '232906' LIMIT 1
---TRANSACTION 0 996186201, not started, process no 13147, OS thread id 801848 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3338, query id 18751428 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '191211' LIMIT 1
---TRANSACTION 0 996185987, not started, process no 13146, OS thread id 800819
MySQL thread id 3337, query id 18672431 www2 10.0.0.2 asp
---TRANSACTION 0 996256482, not started, process no 13145, OS thread id 799790 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3336, query id 18751359 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '191524' LIMIT 1
---TRANSACTION 0 996185902, not started, process no 13144, OS thread id 798765 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3335, query id 18751441 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '289989' LIMIT 1
---TRANSACTION 0 996261370, not started, process no 13143, OS thread id 797740 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3334, query id 18751294 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '81980' LIMIT 1
---TRANSACTION 0 996261686, not started, process no 13142, OS thread id 796713 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3333, query id 18751282 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '193382' LIMIT 1
---TRANSACTION 0 996253367, not started, process no 13107, OS thread id 771365 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3332, query id 18751321 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '102326' LIMIT 1
---TRANSACTION 0 996253266, not started, process no 13141, OS thread id 795688 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3331, query id 18751326 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '17532' LIMIT 1
---TRANSACTION 0 996261713, not started, process no 13140, OS thread id 794656 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3330, query id 18751277 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '277332' LIMIT 1
---TRANSACTION 0 996186243, not started, process no 13083, OS thread id 756979 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3329, query id 18751446 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '246269' LIMIT 1
---TRANSACTION 0 996261244, not started, process no 13139, OS thread id 793631 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3328, query id 18751352 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '99579' LIMIT 1
---TRANSACTION 0 996261257, not started, process no 13138, OS thread id 792604 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3327, query id 18751301 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '99941' LIMIT 1
---TRANSACTION 0 996185128, not started, process no 13137, OS thread id 791579 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3326, query id 18751418 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '47963' LIMIT 1
---TRANSACTION 0 996260848, not started, process no 13136, OS thread id 790554 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3325, query id 18751304 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '344683' LIMIT 1
---TRANSACTION 0 996185097, not started, process no 13134, OS thread id 788504 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3323, query id 18751417 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '81077' LIMIT 1
---TRANSACTION 0 996231643, not started, process no 13135, OS thread id 789529
MySQL thread id 3324, query id 18720099 www2 10.0.0.2 asp
---TRANSACTION 0 996231695, not started, process no 13133, OS thread id 787479
MySQL thread id 3322, query id 18720135 www2 10.0.0.2 asp
---TRANSACTION 0 996253391, not started, process no 13076, OS thread id 751832 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3321, query id 18751362 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '294537' LIMIT 1
---TRANSACTION 0 996261365, not started, process no 13132, OS thread id 786454 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3320, query id 18751343 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '193549' LIMIT 1
---TRANSACTION 0 996253322, not started, process no 13130, OS thread id 784403 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3318, query id 18751319 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '57142' LIMIT 1
---TRANSACTION 0 996261609, not started, process no 13131, OS thread id 785428 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3319, query id 18751328 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '102357' LIMIT 1
---TRANSACTION 0 996186035, not started, process no 13129, OS thread id 783378
MySQL thread id 3317, query id 18672483 www2 10.0.0.2 asp
---TRANSACTION 0 996180935, not started, process no 13128, OS thread id 782353 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3316, query id 18751405 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '127803' LIMIT 1
---TRANSACTION 0 996253361, not started, process no 13126, OS thread id 780300 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3314, query id 18751320 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '117435' LIMIT 1
---TRANSACTION 0 996253295, not started, process no 13111, OS thread id 775476 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3313, query id 18751330 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '161417' LIMIT 1
---TRANSACTION 0 996180552, not started, process no 13087, OS thread id 761119 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3312, query id 18751393 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '198945' LIMIT 1
---TRANSACTION 0 996256485, not started, process no 13089, OS thread id 763169 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3311, query id 18751311 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '201077' LIMIT 1
---TRANSACTION 0 996259257, not started, process no 13103, OS thread id 767273 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3309, query id 18751306 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '17532' LIMIT 1
---TRANSACTION 0 996259170, not started, process no 13108, OS thread id 772392 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3310, query id 18751308 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '112827' LIMIT 1
---TRANSACTION 0 996261286, not started, process no 13112, OS thread id 776501 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3308, query id 18751299 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '307989' LIMIT 1
---TRANSACTION 0 996261340, not started, process no 13106, OS thread id 770336 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3307, query id 18751297 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '133519' LIMIT 1
---TRANSACTION 0 996255040, not started, process no 12139, OS thread id 594008 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3306, query id 18751313 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '7853' LIMIT 1
---TRANSACTION 0 996261635, not started, process no 13113, OS thread id 777526 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3305, query id 18751287 www2 10.0.0.2 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '243578' LIMIT 1
---TRANSACTION 0 995982350, not started, process no 13090, OS thread id 764195
MySQL thread id 3268, query id 18459136 www7 10.0.0.7 asp
---TRANSACTION 0 996222305, not started, process no 13105, OS thread id 769296 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3270, query id 18751436 www7 10.0.0.7 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '89239' LIMIT 1
---TRANSACTION 0 996178452, not started, process no 13080, OS thread id 753888
MySQL thread id 3267, query id 18664537 www7 10.0.0.7 asp
---TRANSACTION 0 996261562, not started, process no 12166, OS thread id 611474 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3266, query id 18751376 www7 10.0.0.7 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '38796' LIMIT 1
---TRANSACTION 0 994567208, not started, process no 13063, OS thread id 748736 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3265, query id 18751438 www7 10.0.0.7 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '14121' LIMIT 1
---TRANSACTION 0 995460944, not started, process no 13084, OS thread id 758023
MySQL thread id 3264, query id 17912491 www7 10.0.0.7 asp
---TRANSACTION 0 994620840, not started, process no 13091, OS thread id 765220
MySQL thread id 3263, query id 17031622 www7 10.0.0.7 asp
---TRANSACTION 0 994623189, not started, process no 12181, OS thread id 624956
MySQL thread id 3262, query id 17033517 www7 10.0.0.7 asp
---TRANSACTION 0 995982650, not started, process no 13082, OS thread id 755949
MySQL thread id 3261, query id 18459399 www7 10.0.0.7 asp
---TRANSACTION 0 996178505, not started, process no 12989, OS thread id 745652
MySQL thread id 3156, query id 18664614 www7 10.0.0.7 asp
---TRANSACTION 0 996015051, not started, process no 12988, OS thread id 744626
MySQL thread id 3155, query id 18493241 www7 10.0.0.7 asp
---TRANSACTION 0 996257514, not started, process no 12938, OS thread id 742571 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3152, query id 18751423 www7 10.0.0.7 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '89239' LIMIT 1
---TRANSACTION 0 996261405, not started, process no 12929, OS thread id 741541 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3151, query id 18751392 www7 10.0.0.7 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '33857' LIMIT 1
---TRANSACTION 0 994567240, not started, process no 12886, OS thread id 739477 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3145, query id 18751448 www7 10.0.0.7 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '1983' LIMIT 1
---TRANSACTION 0 995535898, not started, process no 12887, OS thread id 740513
MySQL thread id 3146, query id 17991514 www7 10.0.0.7 asp
---TRANSACTION 0 994675213, not started, process no 12877, OS thread id 738452
MySQL thread id 3144, query id 17088211 www7 10.0.0.7 asp
---TRANSACTION 0 995982143, not started, process no 12846, OS thread id 736349
MySQL thread id 3142, query id 18458976 www7 10.0.0.7 asp
---TRANSACTION 0 995407691, not started, process no 12875, OS thread id 737375
MySQL thread id 3143, query id 17856259 www7 10.0.0.7 asp
---TRANSACTION 0 996100676, not started, process no 12845, OS thread id 735324
MySQL thread id 3140, query id 18582998 www7 10.0.0.7 asp
---TRANSACTION 0 996141698, not started, process no 12643, OS thread id 678091
MySQL thread id 3139, query id 18626057 www7 10.0.0.7 asp
---TRANSACTION 0 994569986, not started, process no 12802, OS thread id 726157
MySQL thread id 3135, query id 16977619 www7 10.0.0.7 asp
---TRANSACTION 0 995460811, not started, process no 12840, OS thread id 734294
MySQL thread id 3134, query id 17912545 www7 10.0.0.7 asp
---TRANSACTION 0 996179419, not started, process no 12839, OS thread id 733263
MySQL thread id 3133, query id 18665610 www7 10.0.0.7 asp
---TRANSACTION 0 995780586, not started, process no 10963, OS thread id 490818
MySQL thread id 3132, query id 18247780 www7 10.0.0.7 asp
---TRANSACTION 0 995407653, not started, process no 12838, OS thread id 732235
MySQL thread id 3131, query id 17856215 www7 10.0.0.7 asp
---TRANSACTION 0 996261472, not started, process no 12837, OS thread id 731204 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3130, query id 18751422 www7 10.0.0.7 asp statistics
SELECT celkem, celkem_dnes, tyden, rank, rank_cat FROM clients_counter WHERE ID = '23534' AND invis=""
---TRANSACTION 0 996165382, not started, process no 12836, OS thread id 730150
MySQL thread id 3129, query id 18650895 www7 10.0.0.7 asp
---TRANSACTION 0 996178796, not started, process no 12835, OS thread id 729124
MySQL thread id 3128, query id 18664826 www7 10.0.0.7 asp
---TRANSACTION 0 994570068, not started, process no 12834, OS thread id 728097
MySQL thread id 3127, query id 16977678 www7 10.0.0.7 asp
---TRANSACTION 0 996260912, not started, process no 12767, OS thread id 712780 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3126, query id 18751399 www7 10.0.0.7 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '82074' LIMIT 1
---TRANSACTION 0 994621269, not started, process no 11075, OS thread id 527607
MySQL thread id 3125, query id 17031498 www7 10.0.0.7 asp
---TRANSACTION 0 995469708, not started, process no 12801, OS thread id 725132
MySQL thread id 3124, query id 17921818 www7 10.0.0.7 asp
---TRANSACTION 0 994621252, not started, process no 12650, OS thread id 683307
MySQL thread id 3121, query id 17031492 www7 10.0.0.7 asp
---TRANSACTION 0 996259691, not started, process no 12194, OS thread id 638297 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 3123, query id 18751407 www7 10.0.0.7 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '10461' LIMIT 1
---TRANSACTION 0 994621419, not started, process no 9192, OS thread id 203976
MySQL thread id 3122, query id 17031651 www7 10.0.0.7 asp
---TRANSACTION 0 993734028, not started, process no 12149, OS thread id 604285
MySQL thread id 2691, query id 18751454 localhost root
show innodb status
---TRANSACTION 0 995864161, not started, process no 12183, OS thread id 627008
MySQL thread id 2555, query id 18335434 www6 10.0.0.6 asp
---TRANSACTION 0 996096043, not started, process no 12182, OS thread id 625982
MySQL thread id 2554, query id 18578060 www6 10.0.0.6 asp
---TRANSACTION 0 996261544, not started, process no 12180, OS thread id 623931
MySQL thread id 2552, query id 18751096 www6 10.0.0.6 asp
---TRANSACTION 0 995781858, not started, process no 12179, OS thread id 622905
MySQL thread id 2551, query id 18249094 www6 10.0.0.6 asp
---TRANSACTION 0 996067297, not started, process no 12176, OS thread id 619820
MySQL thread id 2547, query id 18547992 www6 10.0.0.6 asp
---TRANSACTION 0 996067426, not started, process no 12175, OS thread id 618791
MySQL thread id 2546, query id 18548062 www6 10.0.0.6 asp
---TRANSACTION 0 996261563, not started, process no 12147, OS thread id 602221 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 2545, query id 18751449 www6 10.0.0.6 asp statistics
SELECT celkem, kategorie, media, ignore_IP, pages, paid_level, hits_dnes, hits_multiplier FROM clients WHERE ID = '1002818' LIMIT 1
---TRANSACTION 0 995671073, not started, process no 11849, OS thread id 562462 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 2543, query id 18751453 www6 10.0.0.6 asp statistics
SELECT celkem, kategorie, media, ignore_IP, pages, paid_level, hits_dnes, hits_multiplier FROM clients WHERE ID = '322158' LIMIT 1
---TRANSACTION 0 996254810, not started, process no 12174, OS thread id 617753
MySQL thread id 2542, query id 18744094 www6 10.0.0.6 asp
---TRANSACTION 0 996246035, not started, process no 9775, OS thread id 327987 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 901, query id 18751450 www6 10.0.0.6 asp statistics
SELECT celkem, kategorie, media, ignore_IP, pages, paid_level, hits_dnes, hits_multiplier FROM clients WHERE ID = '212993' LIMIT 1
---TRANSACTION 0 996123879, not started, process no 9692, OS thread id 310539
MySQL thread id 710, query id 18607417 www6 10.0.0.6 asp
---TRANSACTION 0 996118843, not started, process no 9695, OS thread id 313647
MySQL thread id 711, query id 18602134 www6 10.0.0.6 asp
---TRANSACTION 0 996160400, not started, process no 9327, OS thread id 296226 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 546, query id 18751451 www6 10.0.0.6 asp statistics
SELECT celkem, kategorie, media, ignore_IP, pages, paid_level, hits_dnes, hits_multiplier FROM clients WHERE ID = '1005194' LIMIT 1
---TRANSACTION 0 996261500, not started, process no 9305, OS thread id 283926 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 490, query id 18751388 www6 10.0.0.6 asp statistics
SELECT celkem, kategorie, media, ignore_IP, pages, paid_level, hits_dnes, hits_multiplier FROM clients WHERE ID = '212993' LIMIT 1
---TRANSACTION 0 996259564, not started, process no 9275, OS thread id 266501 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 396, query id 18751316 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '303928' LIMIT 1
---TRANSACTION 0 996223045, not started, process no 9107, OS thread id 117876 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 394, query id 18751363 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '70670' LIMIT 1
---TRANSACTION 0 996222797, not started, process no 9226, OS thread id 226526 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 361, query id 18751367 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '43800' LIMIT 1
---TRANSACTION 0 996222700, not started, process no 9225, OS thread id 225501 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 359, query id 18751377 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '99995' LIMIT 1
---TRANSACTION 0 996186306, not started, process no 9260, OS thread id 261376 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 355, query id 18751371 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '45648' LIMIT 1
---TRANSACTION 0 996185917, not started, process no 9261, OS thread id 262401 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 356, query id 18751374 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '133519' LIMIT 1
---TRANSACTION 0 996164042, not started, process no 9259, OS thread id 260351 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 354, query id 18751433 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '74978' LIMIT 1
---TRANSACTION 0 996172366, not started, process no 9258, OS thread id 259326 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 353, query id 18751390 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '286798' LIMIT 1
---TRANSACTION 0 996247722, not started, process no 9257, OS thread id 258301 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 352, query id 18751291 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '276519' LIMIT 1
---TRANSACTION 0 996217201, not started, process no 9255, OS thread id 256251
MySQL thread id 350, query id 18705172 www5 10.0.0.5 asp
---TRANSACTION 0 996186233, not started, process no 9256, OS thread id 257276 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 351, query id 18751372 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '133519' LIMIT 1
---TRANSACTION 0 996163496, not started, process no 9229, OS thread id 229601 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 349, query id 18751442 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '35024' LIMIT 1
---TRANSACTION 0 996155174, not started, process no 9215, OS thread id 217301 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 348, query id 18751419 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '320832' LIMIT 1
---TRANSACTION 0 996222709, not started, process no 9217, OS thread id 219351 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 302, query id 18751385 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '245365' LIMIT 1
---TRANSACTION 0 996222768, not started, process no 9214, OS thread id 216276 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 296, query id 18751356 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '1983' LIMIT 1
---TRANSACTION 0 996165736, not started, process no 9147, OS thread id 157851 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 218, query id 18751406 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '216637' LIMIT 1
---TRANSACTION 0 996261703, not started, process no 9125, OS thread id 135301 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 289, query id 18751283 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '198945' LIMIT 1
---TRANSACTION 0 996259659, not started, process no 9207, OS thread id 209101 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 286, query id 18751317 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '195103' LIMIT 1
---TRANSACTION 0 996259698, not started, process no 9189, OS thread id 200901 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 272, query id 18751303 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '172874' LIMIT 1
---TRANSACTION 0 996243425, not started, process no 9186, OS thread id 197826 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 267, query id 18751335 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '320306' LIMIT 1
---TRANSACTION 0 996222549, not started, process no 9181, OS thread id 192701 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 260, query id 18751396 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '155722' LIMIT 1
---TRANSACTION 0 996261675, not started, process no 9123, OS thread id 133251 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 256, query id 18751292 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '112147' LIMIT 1
---TRANSACTION 0 996261717, not started, process no 9179, OS thread id 190651 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 255, query id 18751273 www5 10.0.0.5 asp Sending data
SELECT count(*) FROM ips WHERE ID = '133035'
---TRANSACTION 0 996222809, not started, process no 9158, OS thread id 169126 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 252, query id 18751358 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '122297' LIMIT 1
---TRANSACTION 0 996222991, not started, process no 9156, OS thread id 167076 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 230, query id 18751381 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '28093' LIMIT 1
---TRANSACTION 0 996222996, not started, process no 9149, OS thread id 159901 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 220, query id 18751378 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '167359' LIMIT 1
---TRANSACTION 0 996186300, not started, process no 9148, OS thread id 158876 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 219, query id 18751349 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '71680' LIMIT 1
---TRANSACTION 0 996164221, not started, process no 9146, OS thread id 156826
MySQL thread id 217, query id 18649671 www5 10.0.0.5 asp
---TRANSACTION 0 996171566, not started, process no 9145, OS thread id 155801 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 216, query id 18751400 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '17532' LIMIT 1
---TRANSACTION 0 996186020, not started, process no 9142, OS thread id 152726 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 213, query id 18751375 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '180052' LIMIT 1
---TRANSACTION 0 996163575, not started, process no 9143, OS thread id 153751
MySQL thread id 214, query id 18649003 www5 10.0.0.5 asp
---TRANSACTION 0 996259551, not started, process no 9121, OS thread id 131201 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 193, query id 18751327 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '99579' LIMIT 1
---TRANSACTION 0 996222914, not started, process no 9120, OS thread id 130176 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 186, query id 18751345 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '241936' LIMIT 1
---TRANSACTION 0 996222781, not started, process no 9119, OS thread id 129151 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 181, query id 18751353 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '26393' LIMIT 1
---TRANSACTION 0 996228415, not started, process no 8821, OS thread id 54326 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 174, query id 18751341 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '99579' LIMIT 1
---TRANSACTION 0 996222698, not started, process no 9108, OS thread id 118901 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 171, query id 18751373 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '106260' LIMIT 1
---TRANSACTION 0 996223060, not started, process no 9111, OS thread id 121976 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 169, query id 18751361 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '141779' LIMIT 1
---TRANSACTION 0 996259657, not started, process no 9114, OS thread id 125051 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 168, query id 18751324 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '118579' LIMIT 1
---TRANSACTION 0 996222856, not started, process no 9109, OS thread id 119926 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 161, query id 18751391 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '191211' LIMIT 1
---TRANSACTION 0 996163589, not started, process no 9104, OS thread id 114801
MySQL thread id 150, query id 18649013 www5 10.0.0.5 asp
---TRANSACTION 0 996171943, not started, process no 9103, OS thread id 113776 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 149, query id 18751401 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '117772' LIMIT 1
---TRANSACTION 0 996261706, not started, process no 8969, OS thread id 97376 waiting in InnoDB queue
mysql tables in use 1, locked 1
MySQL thread id 148, query id 18751274 www5 10.0.0.5 asp Updating
UPDATE clients_counter SET celkem = celkem + 1, celkem_dnes = celkem_dnes + 1, hits_dnes = hits_dnes + 1, total = total + 1 WHERE ID = '78139'
---TRANSACTION 0 996186313, not started, process no 9102, OS thread id 112751 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 146, query id 18751355 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '50777' LIMIT 1
---TRANSACTION 0 996172417, not started, process no 8924, OS thread id 91226 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 114, query id 18751383 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '60561' LIMIT 1
---TRANSACTION 0 996247420, not started, process no 8861, OS thread id 85076 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 112, query id 18751332 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '253800' LIMIT 1
---TRANSACTION 0 996247376, not started, process no 8849, OS thread id 83026 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 91, query id 18751323 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '274849' LIMIT 1
---TRANSACTION 0 996155169, not started, process no 8848, OS thread id 82001 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 90, query id 18751424 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '112827' LIMIT 1
---TRANSACTION 0 996261042, not started, process no 8840, OS thread id 73801 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 78, query id 18751279 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '272627' LIMIT 1
---TRANSACTION 0 996217293, not started, process no 8836, OS thread id 69701 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 74, query id 18751447 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '112827' LIMIT 1
---TRANSACTION 0 996163552, not started, process no 8822, OS thread id 55351 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 68, query id 18751444 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '102357' LIMIT 1
---TRANSACTION 0 996163472, not started, process no 8828, OS thread id 61501 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 64, query id 18751439 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '17532' LIMIT 1
---TRANSACTION 0 996247729, not started, process no 8820, OS thread id 53301 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 55, query id 18751295 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '178043' LIMIT 1
---TRANSACTION 0 996166775, not started, process no 8819, OS thread id 52276 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 52, query id 18751402 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '133519' LIMIT 1
---TRANSACTION 0 996167365, not started, process no 8817, OS thread id 50226 waiting in InnoDB queue
mysql tables in use 1, locked 0
MySQL thread id 50, query id 18751403 www5 10.0.0.5 asp statistics
SELECT celkem, kategorie, media, '', pages, paid_level, hits_dnes, hits_multiplier FROM clients_counter WHERE ID = '78139' LIMIT 1
---TRANSACTION 0 996261719, ACTIVE 1 sec, process no 13436, OS thread id 893197 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 3560, query id 18751271 www1 10.0.0.1 asp Updating
UPDATE clients_counter SET hits_dnes = hits_dnes + 1 WHERE ID = '36463'
---TRANSACTION 0 996261718, ACTIVE 1 sec, process no 14452, OS thread id 934923 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 4192, query id 18751270 www5 10.0.0.5 asp Updating
UPDATE clients_counter SET hits_dnes = hits_dnes + hits_multiplier WHERE ID = '50028'
---TRANSACTION 0 996261716, ACTIVE 1 sec, process no 9110, OS thread id 120951 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 268, query id 18751268 www5 10.0.0.5 asp Updating
UPDATE clients_counter SET hits_dnes = hits_dnes + 1 WHERE ID = '212993'
---TRANSACTION 0 996261714, ACTIVE 1 sec, process no 14499, OS thread id 966874 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 4230, query id 18751266 www5 10.0.0.5 asp Updating
UPDATE clients_counter SET celkem = celkem + 1, celkem_dnes = celkem_dnes + 1, hits_dnes = hits_dnes + 1, total = total + 1 WHERE ID = '158670'
---TRANSACTION 0 996261712, ACTIVE 1 sec, process no 9183, OS thread id 194751 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 263, query id 18751264 www5 10.0.0.5 asp Updating
UPDATE clients_counter SET hits_dnes = hits_dnes + hits_multiplier WHERE ID = '100072'
---TRANSACTION 0 996261709, ACTIVE 1 sec, process no 13127, OS thread id 781325 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 3315, query id 18751260 www2 10.0.0.2 asp Updating
UPDATE clients_counter SET celkem = celkem + 1, celkem_dnes = celkem_dnes + 1, hits_dnes = hits_dnes + 1, total = total + 1 WHERE ID = '216517'
---TRANSACTION 0 996261708, ACTIVE 1 sec, process no 13150, OS thread id 804928 inserting, thread declared inside InnoDB 500
mysql tables in use 1, locked 1
1 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 3341, query id 18751258 www2 10.0.0.2 asp update
INSERT INTO ips SET ID = '87055', cas = NOW()
---TRANSACTION 0 996261707, ACTIVE 1 sec, process no 8925, OS thread id 92251 updating or deleting, thread declared inside InnoDB 499
mysql tables in use 1, locked 1
2 lock struct(s), heap size 320, undo log entries 1
MySQL thread id 115, query id 18751256 www5 10.0.0.5 asp Updating
UPDATE clients_counter SET celkem = celkem + 1, celkem_dnes = celkem_dnes + 1, hits_dnes = hits_dnes + 1, total = total + 1 WHERE ID = '93660'
--------
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
4475 OS file reads, 14561 OS file writes, 9803 OS fsyncs
1.00 reads/s, 16384 avg bytes/read, 1.00 writes/s, 1.00 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
603 inserts, 603 merged recs, 104 merges
Hash table size 1867769, used cells 538482, node heap has 624 buffer(s)
2011.99 hash searches/s, 1226.39 non-hash searches/s
---
LOG
---
Log sequence number 17 2429752674
Log flushed up to   17 2429485610
Last checkpoint at  17 2351901566
0 pending log writes, 0 pending chkp writes
8027 log i/o's done, 1.00 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 596017065; in additional pool allocated 4416768
Buffer pool size   28800
Free buffers       21760
Database pages     6416
Modified db pages  2414
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages read 4835, created 1581, written 58551
1.00 reads/s, 0.00 creates/s, 0.00 writes/s
Buffer pool hit rate 1000 / 1000
--------------
ROW OPERATIONS
--------------
8 queries inside InnoDB, 180 queries in queue
1 read views open inside InnoDB
Main thread process no. 8756, id 8201, state: sleeping
Number of rows inserted 490607, updated 4084328, deleted 450358, read 406521760
75.46 inserts/s, 631.68 updates/s, 0.00 deletes/s, 56174.91 reads/s
----------------------------
END OF INNODB MONITOR OUTPUT
============================