=====================================
100320 15:46:24 INNODB MONITOR OUTPUT
=====================================
Per second averages calculated from the last 19 seconds
----------
BACKGROUND THREAD
----------
srv_master_thread loops: 378592 1_second, 378591 sleeps, 37855 10_second, 3675 background, 3675 flush
srv_master_thread log flush and writes: 382584
----------
SEMAPHORES
----------
OS WAIT ARRAY INFO: reservation count 20669512, signal count 42085038
--Thread 2145843520 has waited at ./include/log0log.ic line 322 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b6c0d0 '&log_sys->mutex', lock var 0
waiters flag 0
--Thread 2142648640 has waited at trx/trx0trx.c line 1033 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 0
waiters flag 0
--Thread 2018580800 has waited at trx/trx0trx.c line 738 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 0
waiters flag 0
--Thread 1262725440 has waited at trx/trx0trx.c line 738 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 0
waiters flag 0
--Thread 1254738240 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1874544960 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1967196480 has waited at trx/trx0trx.c line 1033 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 0
waiters flag 0
--Thread 1278167360 has waited at trx/trx0trx.c line 1033 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 0
waiters flag 0
--Thread 2070763840 has waited at trx/trx0trx.c line 738 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 2077419840 has waited at trx/trx0trx.c line 1033 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 1292011840 has waited at lock/lock0lock.c line 3770 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 1280031040 has waited at trx/trx0trx.c line 738 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 1235302720 has waited at trx/trx0trx.c line 738 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 1919805760 has waited at trx/trx0trx.c line 1033 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 1280297280 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1790945600 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1641851200 has waited at trx/trx0trx.c line 738 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 2010327360 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2115758400 has waited at trx/trx0trx.c line 738 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 2136258880 has waited at trx/trx0trx.c line 1033 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 2133596480 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1741158720 has waited at trx/trx0trx.c line 1033 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 1
waiters flag 0
--Thread 2039347520 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2080614720 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2001275200 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1884662080 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1276569920 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1865759040 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1958144320 has waited at trx/trx0trx.c line 1033 for 0.0000 seconds the semaphore:
Mutex at 0x48ace40 '&kernel_mutex', lock var 0
waiters flag 0
--Thread 1762990400 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1922201920 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2067568960 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1828751680 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1287485760 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2022308160 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2069698880 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1289881920 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2127472960 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2077952320 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2050529600 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2130135360 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2084075840 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2081413440 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2100582720 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1880934720 has waited at trx/trx0trx.c line 1888 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1263790400 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1267517760 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1999677760 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 1872947520 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
--Thread 2138921280 has waited at trx/trx0undo.c line 1796 for 0.0000 seconds the semaphore:
Mutex at 0x2abf68b76a18 '&rseg->mutex', lock var 1
waiters flag 1
Mutex spin waits 402818050, rounds 1525643142, OS waits 15710890
RW-shared spins 17524902, OS waits 3416443; RW-excl spins 4524539, OS waits 1014358
Spin rounds per wait: 3.79 mutex, 9.61 RW-shared, 36.88 RW-excl
--------
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 (read thread)
I/O thread 4 state: waiting for i/o request (read thread)
I/O thread 5 state: waiting for i/o request (read thread)
I/O thread 6 state: waiting for i/o request (write thread)
I/O thread 7 state: waiting for i/o request (write thread)
I/O thread 8 state: waiting for i/o request (write thread)
I/O thread 9 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
2352019 OS file reads, 969591788 OS file writes, 6092093 OS fsyncs
0.00 reads/s, 0 avg bytes/read, 1488.34 writes/s, 13.05 fsyncs/s
-------------------------------------
INSERT BUFFER AND ADAPTIVE HASH INDEX
-------------------------------------
Ibuf: size 1, free list len 0, seg size 2,
0 inserts, 0 merged recs, 0 merges
Hash table size 169998233, node heap has 114634 buffer(s)
3143.15 hash searches/s, 42587.23 non-hash searches/s
---
LOG
---
Log sequence number 897148773600
Log flushed up to   897148278010
Last checkpoint at  896783925619
Max checkpoint age    434154333
Checkpoint age target 420587011
Modified age          364847981
Checkpoint age        364847981
0 pending log writes, 0 pending chkp writes
879615445 log i/o's done, 1281.51 log i/o's/second
----------------------
BUFFER POOL AND MEMORY
----------------------
Total memory allocated 88038440960; in additional pool allocated 0
Internal hash tables (constant factor + variable factor)
    Adaptive hash index 3238153528 	(1359985864 + 1878167664)
    Page hash           84999896
    Dictionary cache    340055096 	(339997936 + 57160)
    File system         86488 	(82672 + 3816)
    Lock system         213044664 	(212498744 + 545920)
    Recovery system     0 	(0 + 0)
    Threads             407416 	(406936 + 480)
Dictionary memory allocated 57160
Buffer pool size        5242880
Buffer pool size, bytes 85899345920
Free buffers            1759475
Database pages          3368771
Old database pages      1243530
Modified db pages       70261
Pending reads 0
Pending writes: LRU 0, flush list 0, single page 0
Pages made young 0, not young 0
0.00 youngs/s, 0.00 non-youngs/s
Pages read 2352002, created 1016769, written 108235268
0.00 reads/s, 1.26 creates/s, 248.30 writes/s
Buffer pool hit rate 1000 / 1000, young-making rate 0 / 1000 not 0 / 1000
Pages read ahead 0.00/s, evicted without access 0.00/s
LRU len: 3368771, unzip_LRU len: 0
I/O sum[0]:cur[0], unzip sum[0]:cur[0]
--------------
ROW OPERATIONS
--------------
0 queries inside InnoDB, 0 queries in queue
583 read views open inside InnoDB
Main thread process no. 3907, id 1201703232, state: sleeping
Number of rows inserted 331220762, updated 780093431, deleted 205176124, read 38634161513
437.24 inserts/s, 1173.20 updates/s, 271.93 deletes/s, 105181.10 reads/s
------------
TRANSACTIONS
------------
Trx id counter 7C6E3DD1
Purge done for trx's n:o < 7C6E35C9 undo n:o < 0
History list length 426
... truncated...
46 n bits 208 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3B00 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3B00 lock mode IX
RECORD LOCKS space id 149 page no 340704 n bits 240 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3B00 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AFE, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1956813120
2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1
MySQL thread id 136941, query id 10041436150 10.4.223.80 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AFF, sees < 7C6E3A09
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3AFE lock mode IX
RECORD LOCKS space id 147 page no 890345 n bits 80 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3AFE lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AF8, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1987963200
2 lock struct(s), heap size 368, 0 row lock(s), undo log entries 2
MySQL thread id 140338, query id 10041432937 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AF9, sees < 7C6E39D9
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AF8 lock mode IX
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AF8 lock mode IX
---TRANSACTION 7C6E3AF7, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2063042880
2 lock struct(s), heap size 368, 2 row lock(s), undo log entries 2
MySQL thread id 141000, query id 10041436824 10.4.223.86 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AF8, sees < 7C6E39D9
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3AF7 lock mode IX
RECORD LOCKS space id 147 page no 1146358 n bits 96 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3AF7 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AF5, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1106262336
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 140147, query id 10041438028 10.4.223.82 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AF6, sees < 7C6E39D9
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AF5 lock mode IX
RECORD LOCKS space id 148 page no 388588 n bits 488 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AF5 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AF5 lock mode IX
RECORD LOCKS space id 149 page no 46904 n bits 352 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AF5 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AF0, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1949092160
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140390, query id 10041432713 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AF1, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AF0 lock mode IX
RECORD LOCKS space id 146 page no 25610 n bits 168 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AF0 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AF0 lock mode IX
RECORD LOCKS space id 149 page no 155182 n bits 392 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AF0 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AEE, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2115225920
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140503, query id 10041432749 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AEF, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AEE lock mode IX
RECORD LOCKS space id 146 page no 25135 n bits 168 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AEE lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AEE lock mode IX
RECORD LOCKS space id 149 page no 330586 n bits 376 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AEE lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AED, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1252874560
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140571, query id 10041433295 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AEE, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AED lock mode IX
RECORD LOCKS space id 146 page no 19001 n bits 184 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AED lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AED lock mode IX
RECORD LOCKS space id 149 page no 279638 n bits 368 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AED lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AEC, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2121615680
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 141072, query id 10041433144 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AED, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AEC lock mode IX
RECORD LOCKS space id 146 page no 21995 n bits 200 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AEC lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AEC lock mode IX
RECORD LOCKS space id 149 page no 722927 n bits 240 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AEB lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AE9, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2058783040
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 139638, query id 10041436093 10.36.63.95 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AEA, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AE9 lock mode IX
RECORD LOCKS space id 146 page no 14160 n bits 248 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AE9 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AE9 lock mode IX
RECORD LOCKS space id 149 page no 288378 n bits 336 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AE9 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AE8, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1253673280
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 139948, query id 10041432812 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AE9, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AE8 lock mode IX
RECORD LOCKS space id 146 page no 1761 n bits 184 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AE8 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AE8 lock mode IX
RECORD LOCKS space id 149 page no 335533 n bits 384 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AE8 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AE7, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1944832320
2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1
MySQL thread id 139353, query id 10041432624 10.4.223.90 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AE8, sees < 7C6E39D9
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3AE7 lock mode IX
RECORD LOCKS space id 147 page no 1321995 n bits 96 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3AE7 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AE6, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1642117440
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140224, query id 10041432635 10.4.223.82 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AE7, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AE6 lock mode IX
RECORD LOCKS space id 146 page no 575 n bits 224 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AE6 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AE6 lock mode IX
RECORD LOCKS space id 149 page no 473054 n bits 304 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AE6 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AE5, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1880934720
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 141212, query id 10041432655 10.4.223.88 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AE6, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AE5 lock mode IX
RECORD LOCKS space id 146 page no 15618 n bits 232 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AE5 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AE5 lock mode IX
RECORD LOCKS space id 149 page no 754751 n bits 232 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AE5 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AE0, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1268582720
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140547, query id 10041435147 10.4.223.90 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AE1, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AE0 lock mode IX
RECORD LOCKS space id 146 page no 21941 n bits 184 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AE0 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AE0 lock mode IX
RECORD LOCKS space id 149 page no 145185 n bits 320 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3ADD lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3ADD lock mode IX
RECORD LOCKS space id 147 page no 974477 n bits 88 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3ADD lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_contracts` trx id 7C6E3ADD lock mode IX
RECORD LOCKS space id 150 page no 17857 n bits 408 index `PRIMARY` of table `citydb`.`player_contracts` trx id 7C6E3ADD lock_mode X locks rec but not gap
---TRANSACTION 7C6E3ADB, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2088335680
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 139305, query id 10041434991 10.36.63.95 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ADC, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3ADB lock mode IX
RECORD LOCKS space id 146 page no 1888 n bits 216 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3ADB lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3ADB lock mode IX
RECORD LOCKS space id 149 page no 42490 n bits 232 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3ADB lock_mode X locks rec but not gap
---TRANSACTION 7C6E3ADA, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2035620160
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140585, query id 10041433028 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ADB, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3ADA lock mode IX
RECORD LOCKS space id 146 page no 18824 n bits 200 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3ADA lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3ADA lock mode IX
RECORD LOCKS space id 149 page no 508370 n bits 368 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3ADA lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AD9, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2049464640
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140467, query id 10041432481 10.4.223.80 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ADA, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AD9 lock mode IX
RECORD LOCKS space id 146 page no 18824 n bits 200 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3ADA lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3ADA lock mode IX
RECORD LOCKS space id 149 page no 508370 n bits 368 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3ADA lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AD9, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2049464640
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140467, query id 10041432481 10.4.223.80 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ADA, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AD9 lock mode IX
RECORD LOCKS space id 146 page no 5906 n bits 224 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AD9 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AD9 lock mode IX
RECORD LOCKS space id 149 page no 818257 n bits 320 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AD9 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AD8, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1928857920
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 141173, query id 10041432674 10.4.223.86 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AD9, sees < 7C6E39D9
TABLE LOCK table `citydb`.`players` trx id 7C6E3AD8 lock mode IX
RECORD LOCKS space id 146 page no 24990 n bits 176 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AD8 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AD8 lock mode IX
RECORD LOCKS space id 149 page no 16707 n bits 328 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AD8 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AD7, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1272043840
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 140468, query id 10041439769 10.4.223.88 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AD8, sees < 7C6E39D9
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AD7 lock mode IX
RECORD LOCKS space id 148 page no 647119 n bits 536 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AD7 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AD7 lock mode IX
RECORD LOCKS space id 149 page no 486470 n bits 368 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AD7 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AD3, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2008197440
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 140221, query id 10041438807 10.4.223.82 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AD4, sees < 7C6E39D9
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AD3 lock mode IX
RECORD LOCKS space id 148 page no 445005 n bits 552 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AD3 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AD3 lock mode IX
RECORD LOCKS space id 149 page no 678758 n bits 288 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AD3 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3ACE, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2067568960
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 138718, query id 10041432668 10.36.63.95 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ACF, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3ACE lock mode IX
RECORD LOCKS space id 146 page no 187 n bits 224 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3ACE lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3ACE lock mode IX
RECORD LOCKS space id 149 page no 382096 n bits 376 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3ACE lock_mode X locks rec but not gap
---TRANSACTION 7C6E3ACB, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1287485760
5 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 3
MySQL thread id 141312, query id 10041432927 10.4.223.82 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ACC, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_contracts` trx id 7C6E3ACB lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3ACB lock mode IX
RECORD LOCKS space id 146 page no 13690 n bits 272 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3ACB lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3ACB lock mode IX
RECORD LOCKS space id 149 page no 31584 n bits 248 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3ACB lock_mode X locks rec but not gap
---TRANSACTION 7C6E3ACA, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1992755520
2 lock struct(s), heap size 368, 0 row lock(s), undo log entries 2
MySQL thread id 139191, query id 10041432427 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ACB, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3ACA lock mode IX
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3ACA lock mode IX
---TRANSACTION 7C6E3AC9, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1282959680
5 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 141296, query id 10041437771 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ACA, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AC9 lock mode IX
RECORD LOCKS space id 148 page no 160459 n bits 600 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AC9 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AC9 lock mode IX
RECORD LOCKS space id 149 page no 144341 n bits 288 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AC9 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AC9, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1282959680
5 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 141296, query id 10041437771 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ACA, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AC9 lock mode IX
RECORD LOCKS space id 148 page no 160459 n bits 600 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AC9 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AC9 lock mode IX
RECORD LOCKS space id 149 page no 144341 n bits 288 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AC9 lock_mode X locks rec but not gap
RECORD LOCKS space id 149 page no 144345 n bits 352 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AC9 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AC8, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1810114880
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 141181, query id 10041432666 10.36.63.93 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AC9, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3AC8 lock mode IX
RECORD LOCKS space id 146 page no 3930 n bits 160 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AC8 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AC8 lock mode IX
RECORD LOCKS space id 149 page no 444704 n bits 400 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AC8 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AC6, ACTIVE 4 sec, process no 3907, OS thread id 1275771200
5 lock struct(s), heap size 1216, 1 row lock(s), undo log entries 46
MySQL thread id 141270, query id 10041442923 10.4.223.80 citydbuser
update player_buildings set building_id=121, leisure_start=null, state='clean', state_date='2010-03-20 15:46:20.0', growth_start=null where player_id=100000180864920 and corner=32382
Trx read view will not see trx with id >= 7C6E3AC7, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AC6 lock mode IX
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AC6 lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3AC6 lock mode IX
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3AC6 lock mode IX
RECORD LOCKS space id 149 page no 337504 n bits 368 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AC6 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AC5, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2020444480
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140844, query id 10041438885 10.4.223.86 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AC6, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3AC5 lock mode IX
RECORD LOCKS space id 146 page no 12145 n bits 176 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AC5 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AC5 lock mode IX
RECORD LOCKS space id 149 page no 148090 n bits 296 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AC5 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AC3, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2055321920
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 140546, query id 10041437998 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AC4, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AC3 lock mode IX
RECORD LOCKS space id 148 page no 577596 n bits 568 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AC3 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AC3 lock mode IX
RECORD LOCKS space id 149 page no 279328 n bits 400 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AC3 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AC1, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1249147200
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 141019, query id 10041437002 10.36.63.95 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AC2, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AC1 lock mode IX
RECORD LOCKS space id 148 page no 725383 n bits 576 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AC1 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AC1 lock mode IX
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AC0 lock mode IX
RECORD LOCKS space id 149 page no 627162 n bits 360 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AC0 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3AC0 lock mode IX
---TRANSACTION 7C6E3ABE, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1944033600
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 140411, query id 10041438183 10.4.223.88 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ABF, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3ABE lock mode IX
RECORD LOCKS space id 146 page no 19859 n bits 192 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3ABB lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3ABB lock mode IX
RECORD LOCKS space id 149 page no 368561 n bits 288 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3ABB lock_mode X locks rec but not gap
---TRANSACTION 7C6E3ABA, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1964267840
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 137688, query id 10041432858 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3ABB, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3ABA lock mode IX
RECORD LOCKS space id 146 page no 12691 n bits 176 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3ABA lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3ABA lock mode IX
RECORD LOCKS space id 149 page no 700885 n bits 384 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3ABA lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AB7, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2129070400
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 138599, query id 10041432539 10.4.223.86 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AB8, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3AB7 lock mode IX
RECORD LOCKS space id 146 page no 5136 n bits 176 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AB7 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AB7 lock mode IX
RECORD LOCKS space id 149 page no 545493 n bits 344 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AB7 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AB6, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2081413440
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 141202, query id 10041439173 10.36.63.95 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AB7, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AB6 lock mode IX
RECORD LOCKS space id 148 page no 654350 n bits 296 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AB6 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AB6 lock mode IX
RECORD LOCKS space id 149 page no 374159 n bits 376 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AB6 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AB4, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1890253120
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 139625, query id 10041432790 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AB5, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3AB4 lock mode IX
RECORD LOCKS space id 148 page no 654350 n bits 296 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AB6 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AB6 lock mode IX
RECORD LOCKS space id 149 page no 374159 n bits 376 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AB6 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AB4, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1890253120
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 139625, query id 10041432790 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AB5, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3AB4 lock mode IX
RECORD LOCKS space id 146 page no 8040 n bits 232 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AB4 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AB4 lock mode IX
RECORD LOCKS space id 149 page no 713787 n bits 360 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AB4 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AB2, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2145843520
5 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 3
MySQL thread id 139231, query id 10041436726 10.4.223.86 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AB3, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_achievements` trx id 7C6E3AB2 lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3AB2 lock mode IX
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AB1 lock mode IX
RECORD LOCKS space id 149 page no 77084 n bits 256 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AB1 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AAE, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1964001600
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 141157, query id 10041436499 10.36.63.93 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AAF, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3AAE lock mode IX
RECORD LOCKS space id 148 page no 581986 n bits 568 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3AAE lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AAE lock mode IX
RECORD LOCKS space id 149 page no 714932 n bits 392 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AAE lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AAC, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2140252480
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 138751, query id 10041432715 10.4.223.90 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AAD, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3AAC lock mode IX
RECORD LOCKS space id 146 page no 23844 n bits 160 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AAC lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AAC lock mode IX
RECORD LOCKS space id 149 page no 576782 n bits 384 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AAC lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AA2, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2077952320
2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1
MySQL thread id 141161, query id 10041431695 10.4.223.90 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AA3, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3AA2 lock mode IX
RECORD LOCKS space id 147 page no 1217570 n bits 88 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3AA2 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3AA0, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1261660480 committing
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 139387, query id 10041432365 10.36.63.91 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3AA2, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3AA0 lock mode IX
RECORD LOCKS space id 146 page no 7599 n bits 248 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3AA0 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3AA0 lock mode IX
RECORD LOCKS space id 149 page no 296912 n bits 400 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3AA0 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A9B, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1979976000
2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1
MySQL thread id 141164, query id 10041431661 10.36.63.95 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A9C, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A9B lock mode IX
RECORD LOCKS space id 147 page no 1349411 n bits 80 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A9B lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A9A, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2094725440
2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1
MySQL thread id 136976, query id 10041431690 10.4.223.86 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A9B, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A9A lock mode IX
RECORD LOCKS space id 146 page no 13794 n bits 224 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A9A lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A95, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2118953280
5 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 3
MySQL thread id 138705, query id 10041437804 10.36.63.95 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A96, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_contracts` trx id 7C6E3A95 lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3A95 lock mode IX
RECORD LOCKS space id 146 page no 23462 n bits 168 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A95 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A95 lock mode IX
RECORD LOCKS space id 149 page no 717725 n bits 392 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A95 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A91, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1259796800
2 lock struct(s), heap size 368, 2 row lock(s), undo log entries 2
MySQL thread id 141140, query id 10041431736 10.4.223.88 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A92, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A91 lock mode IX
RECORD LOCKS space id 147 page no 1085138 n bits 104 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A91 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A90, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1884662080
2 lock struct(s), heap size 368, 2 row lock(s), undo log entries 2
MySQL thread id 140466, query id 10041431819 10.4.223.82 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A91, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A90 lock mode IX
RECORD LOCKS space id 147 page no 313005 n bits 104 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A90 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A8E, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2032691520
5 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 3
MySQL thread id 138248, query id 10041432049 10.36.63.91 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A8F, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_contracts` trx id 7C6E3A8E lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3A8E lock mode IX
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A8D lock mode IX
RECORD LOCKS space id 149 page no 532707 n bits 384 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A8C lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A8B, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2127739200
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 139959, query id 10041432252 10.36.63.93 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A8C, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A8B lock mode IX
RECORD LOCKS space id 146 page no 11183 n bits 192 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A8B lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A8B lock mode IX
RECORD LOCKS space id 149 page no 301679 n bits 304 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A8B lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A8A, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2044672320
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 140454, query id 10041432691 10.4.223.86 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A8B, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A8A lock mode IX
RECORD LOCKS space id 146 page no 11183 n bits 192 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A8B lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A8B lock mode IX
RECORD LOCKS space id 149 page no 751030 n bits 352 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A8A lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A88, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2135193920
6 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 139975, query id 10041432799 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A89, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A88 lock mode IX
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A88 lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3A88 lock mode IX
RECORD LOCKS space id 149 page no 751030 n bits 352 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A8A lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A88, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2135193920
6 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 139975, query id 10041432799 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A89, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A88 lock mode IX
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A88 lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3A88 lock mode IX
RECORD LOCKS space id 146 page no 12837 n bits 192 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A88 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A88 lock mode IX
---TRANSACTION 7C6E3A88, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2135193920
6 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 139975, query id 10041432799 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A89, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A88 lock mode IX
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A88 lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3A88 lock mode IX
RECORD LOCKS space id 146 page no 12837 n bits 192 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A88 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A88 lock mode IX
RECORD LOCKS space id 147 page no 956053 n bits 104 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A88 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A87, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1245153600
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 140402, query id 10041432521 10.36.63.91 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A88, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A87 lock mode IX
RECORD LOCKS space id 146 page no 22146 n bits 176 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A85 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A85 lock mode IX
RECORD LOCKS space id 149 page no 234256 n bits 192 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A85 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A83, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1251010880
6 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 8
MySQL thread id 140492, query id 10041432941 10.4.223.80 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A84, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A83 lock mode IX
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A83 lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3A83 lock mode IX
RECORD LOCKS space id 146 page no 17898 n bits 272 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A83 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A83 lock mode IX
RECORD LOCKS space id 147 page no 1444510 n bits 96 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A83 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A7E, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1946163520
2 lock struct(s), heap size 368, 1 row lock(s), undo log entries 1
MySQL thread id 141218, query id 10041431475 10.4.223.82 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A7F, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A7E lock mode IX
RECORD LOCKS space id 146 page no 17362 n bits 208 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A7D lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A7D lock mode IX
RECORD LOCKS space id 147 page no 1006502 n bits 88 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A7D lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A7C, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1981573440
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 137411, query id 10041432313 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A7D, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A7C lock mode IX
RECORD LOCKS space id 146 page no 1404 n bits 240 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A7C lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A7C lock mode IX
RECORD LOCKS space id 147 page no 1125366 n bits 96 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A77 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A75, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1868155200
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140549, query id 10041431548 10.4.223.82 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A76, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A75 lock mode IX
RECORD LOCKS space id 146 page no 16343 n bits 240 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A75 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A75 lock mode IX
RECORD LOCKS space id 149 page no 441769 n bits 360 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A75 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A74, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2006333760
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140931, query id 10041432177 10.4.223.88 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A75, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A74 lock mode IX
RECORD LOCKS space id 146 page no 20055 n bits 192 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A74 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A74 lock mode IX
RECORD LOCKS space id 149 page no 441769 n bits 360 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A75 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A74, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2006333760
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140931, query id 10041432177 10.4.223.88 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A75, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A74 lock mode IX
RECORD LOCKS space id 146 page no 20055 n bits 192 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A74 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A74 lock mode IX
RECORD LOCKS space id 149 page no 741120 n bits 360 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A74 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A72, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2073426240
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 137829, query id 10041439927 10.36.63.91 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A73, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A72 lock mode IX
RECORD LOCKS space id 148 page no 190427 n bits 504 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3A72 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A72 lock mode IX
RECORD LOCKS space id 149 page no 132839 n bits 384 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A70 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A6F, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1936312640
5 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 3
MySQL thread id 140199, query id 10041431837 10.36.63.91 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A70, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_contracts` trx id 7C6E3A6F lock mode IX
TABLE LOCK table `citydb`.`players` trx id 7C6E3A6F lock mode IX
RECORD LOCKS space id 146 page no 315 n bits 232 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A6F lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A6F lock mode IX
RECORD LOCKS space id 149 page no 14483 n bits 336 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A6F lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A6E, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1675663680
2 lock struct(s), heap size 368, 2 row lock(s), undo log entries 2
MySQL thread id 140458, query id 10041431316 10.36.63.91 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A6F, sees < 7C6E39B2
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A6E lock mode IX
RECORD LOCKS space id 147 page no 377681 n bits 88 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A6E lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A6C, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1973320000
8 lock struct(s), heap size 1216, 4 row lock(s), undo log entries 4
MySQL thread id 135567, query id 10041431452 10.4.223.84 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A6D, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A6C lock mode IX
RECORD LOCKS space id 146 page no 19699 n bits 184 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A6C lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A6C lock mode IX
RECORD LOCKS space id 149 page no 720419 n bits 272 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A6C lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_stats` trx id 7C6E3A6C lock mode IX
RECORD LOCKS space id 147 page no 279999 n bits 96 index `PRIMARY` of table `citydb`.`player_stats` trx id 7C6E3A6C lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_contracts` trx id 7C6E3A6C lock mode IX
RECORD LOCKS space id 150 page no 16624 n bits 368 index `PRIMARY` of table `citydb`.`player_contracts` trx id 7C6E3A6C lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A6B, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2007398720
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 5
MySQL thread id 136949, query id 10041432437 10.4.223.88 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A6C, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A6B lock mode IX
RECORD LOCKS space id 148 page no 215729 n bits 576 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3A6B lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A6B lock mode IX
RECORD LOCKS space id 149 page no 176228 n bits 384 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A68 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A65, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 1106528576
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 141168, query id 10041431454 10.4.223.82 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A66, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A65 lock mode IX
RECORD LOCKS space id 148 page no 114612 n bits 552 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3A60 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A60 lock mode IX
RECORD LOCKS space id 149 page no 621059 n bits 360 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A60 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A5C, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2103245120
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140413, query id 10041431481 10.36.63.89 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A5D, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A5C lock mode IX
RECORD LOCKS space id 146 page no 14450 n bits 224 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A5C lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A5C lock mode IX
RECORD LOCKS space id 149 page no 104627 n bits 264 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A5C lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A5B, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2097920320
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 141096, query id 10041431887 10.4.223.90 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A5C, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A5B lock mode IX
RECORD LOCKS space id 148 page no 224668 n bits 584 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3A44 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A44 lock mode IX
RECORD LOCKS space id 149 page no 734030 n bits 296 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A5B lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A44, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2100582720
4 lock struct(s), heap size 1216, 3 row lock(s), undo log entries 5
MySQL thread id 140004, query id 10041432649 10.4.223.88 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A45, sees < 7C6E39B2
TABLE LOCK table `citydb`.`city_grid` trx id 7C6E3A44 lock mode IX
RECORD LOCKS space id 148 page no 224668 n bits 584 index `PRIMARY` of table `citydb`.`city_grid` trx id 7C6E3A44 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A44 lock mode IX
RECORD LOCKS space id 149 page no 12101 n bits 376 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A26 lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A0F, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2141583680
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 140452, query id 10041423369 10.36.63.93 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A10, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A0F lock mode IX
RECORD LOCKS space id 146 page no 3580 n bits 216 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A0A lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A0A lock mode IX
RECORD LOCKS space id 149 page no 804858 n bits 376 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A0A lock_mode X
RECORD LOCKS space id 149 page no 804863 n bits 136 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A0A lock_mode X locks rec but not gap
---TRANSACTION 7C6E3A09, ACTIVE (PREPARED) 4 sec, process no 3907, OS thread id 2075289920
4 lock struct(s), heap size 1216, 2 row lock(s), undo log entries 2
MySQL thread id 138208, query id 10041423401 10.4.223.86 citydbuser
commit
Trx read view will not see trx with id >= 7C6E3A0A, sees < 7C6E39B2
TABLE LOCK table `citydb`.`players` trx id 7C6E3A09 lock mode IX
RECORD LOCKS space id 146 page no 18321 n bits 184 index `PRIMARY` of table `citydb`.`players` trx id 7C6E3A09 lock_mode X locks rec but not gap
TABLE LOCK table `citydb`.`player_buildings` trx id 7C6E3A09 lock mode IX
RECORD LOCKS space id 149 page no 759584 n bits 352 index `PRIMARY` of table `citydb`.`player_buildings` trx id 7C6E3A09 lock_mode X locks rec but not gap