· 7 years ago · Apr 08, 2018, 03:18 PM
1Jul 23 18:26:59 meth mysqld[2348]: ------- TRX HAS BEEN WAITING 0 SEC FOR THIS LOCK TO BE GRANTED:
2Jul 23 18:26:59 meth mysqld[2348]: TABLE LOCK table `shopify_stats/countries` trx id 0 1204820818 lock mode AUTO-INC waiting
3Jul 23 18:26:59 meth mysqld[2348]: ------------------
4Jul 23 18:26:59 meth mysqld[2348]: ---TRANSACTION 0 1204820814, ACTIVE 0 sec, process no 2347, OS thread id 1152506208
5Jul 23 18:26:59 meth mysqld[2348]: 1 lock struct(s), heap size 368, undo log entries 1
6Jul 23 18:26:59 meth mysqld[2348]: MySQL thread id 29463, query id 53166194 app1.shopify.internal 192.168.1.9 shopify
7Jul 23 18:26:59 meth mysqld[2348]: COMMIT
8Jul 23 18:26:59 meth mysqld[2348]: Trx read view will not see trx with id >= 0 1204820815, sees < 0 1204820806
9Jul 23 18:26:59 meth mysqld[2348]: ---TRANSACTION 0 1204820813, ACTIVE 0 sec, process no 2347, OS thread id 1142638944
10Jul 23 18:26:59 meth mysqld[2348]: 2 lock struct(s), heap size 368, undo log entries 1
11Jul 23 18:26:59 meth mysqld[2348]: MySQL thread id 29373, query id 53166183 app1.shopify.internal 192.168.1.9 shopify
12Jul 23 18:26:59 meth mysqld[2348]: COMMIT
13Jul 23 18:26:59 meth mysqld[2348]: ---TRANSACTION 0 1204820812, ACTIVE (PREPARED) 0 sec, process no 2347, OS thread id 1144260960 preparing
14Jul 23 18:26:59 meth mysqld[2348]: mysql tables in use 1, locked 1
15Jul 23 18:26:59 meth mysqld[2348]: 4 lock struct(s), heap size 1216, undo log entries 1
16Jul 23 18:26:59 meth mysqld[2348]: MySQL thread id 30, query id 53166180 app2.shopify.internal 192.168.1.10 shopify_stats update
17Jul 23 18:26:59 meth mysqld[2348]: INSERT INTO countries (hits, date, country, uid) VALUES (1, '2008-07-23', 'es', '92362') ON DUPLICATE KEY UPDATE date='2008-07-23', country='es', uid='92362', hits=hits+1
18Jul 23 18:26:59 meth mysqld[2348]: ---TRANSACTION 0 1204820811, ACTIVE 0 sec, process no 2347, OS thread id 1143855456, thread declared inside InnoDB 498
19Jul 23 18:26:59 meth mysqld[2348]: mysql tables in use 1, locked 1
20Jul 23 18:26:59 meth mysqld[2348]: 4 lock struct(s), heap size 1216, undo log entries 1
21Jul 23 18:26:59 meth mysqld[2348]: MySQL thread id 27, query id 53166179 app4.shopify.internal 192.168.1.12 shopify_stats update
22Jul 23 18:26:59 meth mysqld[2348]: INSERT INTO visits (hits, date, uid) VALUES (1, '2008-07-23', '17766') ON DUPLICATE KEY UPDATE date='2008-07-23', uid='17766', hits=hits+1
23Jul 23 18:26:59 meth mysqld[2348]: --------
24Jul 23 18:26:59 meth mysqld[2348]: FILE I/O
25Jul 23 18:26:59 meth mysqld[2348]: --------
26Jul 23 18:26:59 meth mysqld[2348]: I/O thread 0 state: waiting for i/o request (insert buffer thread)
27Jul 23 18:26:59 meth mysqld[2348]: I/O thread 1 state: waiting for i/o request (log thread)
28Jul 23 18:26:59 meth mysqld[2348]: I/O thread 2 state: waiting for i/o request (read thread)
29Jul 23 18:26:59 meth mysqld[2348]: I/O thread 3 state: waiting for i/o request (write thread)
30Jul 23 18:26:59 meth mysqld[2348]: Pending normal aio reads: 0, aio writes: 0,
31Jul 23 18:26:59 meth mysqld[2348]: ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
32Jul 23 18:26:59 meth mysqld[2348]: Pending flushes (fsync) log: 1; buffer pool: 0
33Jul 23 18:26:59 meth mysqld[2348]: 176346 OS file reads, 9270763 OS file writes, 8034602 OS fsyncs
34Jul 23 18:26:59 meth mysqld[2348]: 0.00 reads/s, 0 avg bytes/read, 39.06 writes/s, 37.94 fsyncs/s
35Jul 23 18:26:59 meth mysqld[2348]: -------------------------------------
36Jul 23 18:26:59 meth mysqld[2348]: INSERT BUFFER AND ADAPTIVE HASH INDEX
37Jul 23 18:26:59 meth mysqld[2348]: -------------------------------------
38Jul 23 18:26:59 meth mysqld[2348]: Ibuf: size 1, free list len 0, seg size 2,
39Jul 23 18:26:59 meth mysqld[2348]: 8 inserts, 8 merged recs, 8 merges
40Jul 23 18:26:59 meth mysqld[2348]: Hash table size 12750011, used cells 7947513, node heap has 18364 buffer(s)
41Jul 23 18:26:59 meth mysqld[2348]: 26862.57 hash searches/s, 26601.02 non-hash searches/s
42Jul 23 18:26:59 meth mysqld[2348]: ---
43Jul 23 18:26:59 meth mysqld[2348]: LOG
44Jul 23 18:26:59 meth mysqld[2348]: ---
45Jul 23 18:26:59 meth mysqld[2348]: Log sequence number 57 4136146738
46Jul 23 18:26:59 meth mysqld[2348]: Log flushed up to 57 4136146282
47Jul 23 18:26:59 meth mysqld[2348]: Last checkpoint at 57 4123002722
48Jul 23 18:26:59 meth mysqld[2348]: 1 pending log writes, 0 pending chkp writes
49Jul 23 18:26:59 meth mysqld[2348]: 7844866 log i/o's done, 37.56 log i/o's/second
50Jul 23 18:26:59 meth mysqld[2348]: ----------------------
51Jul 23 18:26:59 meth mysqld[2348]: BUFFER POOL AND MEMORY
52Jul 23 18:26:59 meth mysqld[2348]: ----------------------
53Jul 23 18:26:59 meth mysqld[2348]: Total memory allocated 7173949114; in additional pool allocated 20970496
54Jul 23 18:26:59 meth mysqld[2348]: Buffer pool size 393216
55Jul 23 18:26:59 meth mysqld[2348]: Free buffers 57990
56Jul 23 18:26:59 meth mysqld[2348]: Database pages 316862
57Jul 23 18:26:59 meth mysqld[2348]: Modified db pages 1350
58Jul 23 18:26:59 meth mysqld[2348]: Pending reads 0
59Jul 23 18:26:59 meth mysqld[2348]: Pending writes: LRU 0, flush list 0, single page 0
60Jul 23 18:26:59 meth mysqld[2348]: Pages read 286547, created 30315, written 2037201
61Jul 23 18:26:59 meth mysqld[2348]: 0.00 reads/s, 0.00 creates/s, 1.50 writes/s
62Jul 23 18:26:59 meth mysqld[2348]: Buffer pool hit rate 1000 / 1000
63Jul 23 18:26:59 meth mysqld[2348]: --------------
64Jul 23 18:26:59 meth mysqld[2348]: ROW OPERATIONS
65Jul 23 18:26:59 meth mysqld[2348]: --------------
66Jul 23 18:26:59 meth mysqld[2348]: 2 queries inside InnoDB, 0 queries in queue
67Jul 23 18:26:59 meth mysqld[2348]: 2 read views open inside InnoDB
68Jul 23 18:26:59 meth mysqld[2348]: Main thread process no. 2347, id 1140881760, state: sleeping
69Jul 23 18:26:59 meth mysqld[2348]: Number of rows inserted 10077789, updated 9871393, deleted 250793, read 42674582092
70Jul 23 18:26:59 meth mysqld[2348]: 5.75 inserts/s, 10.81 updates/s, 3.19 deletes/s, 57582.59 reads/s
71Jul 23 18:26:59 meth mysqld[2348]: ----------------------------
72Jul 23 18:26:59 meth mysqld[2348]: END OF INNODB MONITOR OUTPUT
73Jul 23 18:26:59 meth mysqld[2348]: ============================