Skip to content

Instantly share code, notes, and snippets.

@kuzaxak

kuzaxak/persona

Created January 4, 2017 12:30
Show Gist options
  • Save kuzaxak/0a3e576643fd3c5deacf93ea2136a4af to your computer and use it in GitHub Desktop.
Save kuzaxak/0a3e576643fd3c5deacf93ea2136a4af to your computer and use it in GitHub Desktop.
Download ZIP
Raw
persona
mariadb_1 | =====================================
mariadb_1 | 2017-01-04 12:28:32 0x7f3710ff9700 INNODB MONITOR OUTPUT
mariadb_1 | =====================================
mariadb_1 | Per second averages calculated from the last 20 seconds
mariadb_1 | -----------------
mariadb_1 | BACKGROUND THREAD
mariadb_1 | -----------------
mariadb_1 | srv_master_thread loops: 62 srv_active, 0 srv_shutdown, 167 srv_idle
mariadb_1 | srv_master_thread log flush and writes: 228
mariadb_1 | ----------
mariadb_1 | SEMAPHORES
mariadb_1 | ----------
mariadb_1 | OS WAIT ARRAY INFO: reservation count 272
mariadb_1 | --Thread 139874350896896 has waited at btr0btr.cc line 177 for 493.00 seconds the semaphore:
mariadb_1 | SX-lock on RW-latch at 0x7f37516b3e50 created in file buf0buf.cc line 1453
mariadb_1 | a writer (thread id 139874868471552) has reserved it in mode exclusive
mariadb_1 | number of readers 0, waiters flag 1, lock_word: 0
mariadb_1 | Last time read locked in file row0ins.cc line 2486
mariadb_1 | Last time write locked in file /mnt/workspace/percona-server-5.7-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.16-10/storage/innobase/include/mtr0mtr.ic line 153
mariadb_1 | --Thread 139874655098624 has waited at log0log.cc line 1318 for 501.00 seconds the semaphore:
mariadb_1 | Mutex at 0x2672628, Mutex LOG_WRITE created log0log.cc:863, lock var 1
mariadb_1 |
mariadb_1 | OS WAIT ARRAY INFO: signal count 158
mariadb_1 | RW-shared spins 0, rounds 43, OS waits 16
mariadb_1 | RW-excl spins 0, rounds 30, OS waits 1
mariadb_1 | RW-sx spins 13, rounds 390, OS waits 13
mariadb_1 | Spin rounds per wait: 43.00 RW-shared, 30.00 RW-excl, 30.00 RW-sx
mariadb_1 | ------------
mariadb_1 | TRANSACTIONS
mariadb_1 | ------------
mariadb_1 | Trx id counter 2152
mariadb_1 | Purge done for trx's n:o < 2149 undo n:o < 0 state: running but idle
mariadb_1 | History list length 34
mariadb_1 | LIST OF TRANSACTIONS FOR EACH SESSION:
mariadb_1 | ---TRANSACTION 2151, ACTIVE 501 sec inserting
mariadb_1 | mysql tables in use 1, locked 1
mariadb_1 | 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 24
mariadb_1 | MySQL thread id 3, OS thread handle 139874868471552, query id 357 localhost root update
mariadb_1 | INSERT INTO `insly_loimport` VALUES (72545,'Doyle Decorating Limited','LiabilitiesOnly','MGBW427','Richard Scott','LAPSED','yes','','1000','12.05.2014','','20.05.2014','20.05.2014','09:01:31','9 Windsor Way\nSandy\nBeds','SG19 1JL','9 Windsor Way\nSandy\nBeds','SG19 1JL','','','','','','','','','120/WA92430','No','no','','','','','','','','','','','','','','Endorsement 27 - Professional Services Exclusion (Applicable to Section B) :: Underwriters shall have no liability under this Policy to provide any indemnity or benefit for any legal liability arising out of breach of professional duty or
mariadb_1 | --------
mariadb_1 | FILE I/O
mariadb_1 | --------
mariadb_1 | I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
mariadb_1 | I/O thread 1 state: waiting for completed aio requests (log thread)
mariadb_1 | I/O thread 2 state: waiting for completed aio requests (read thread)
mariadb_1 | I/O thread 3 state: waiting for completed aio requests (read thread)
mariadb_1 | I/O thread 4 state: waiting for completed aio requests (read thread)
mariadb_1 | I/O thread 5 state: waiting for completed aio requests (read thread)
mariadb_1 | I/O thread 6 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 7 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 8 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 9 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 10 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 11 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 12 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 13 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 14 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 15 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 16 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 17 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 18 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 19 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 20 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 21 state: waiting for completed aio requests (write thread)
mariadb_1 | Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
mariadb_1 | ibuf aio reads:, log i/o's:, sync i/o's:
mariadb_1 | Pending flushes (fsync) log: 0; buffer pool: 0
mariadb_1 | 434 OS file reads, 6702 OS file writes, 587 OS fsyncs
mariadb_1 | 0 pending preads, 2 pending pwrites
mariadb_1 | 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
mariadb_1 | -------------------------------------
mariadb_1 | INSERT BUFFER AND ADAPTIVE HASH INDEX
mariadb_1 | -------------------------------------
mariadb_1 | Ibuf: size 1, free list len 0, seg size 2, 0 merges
mariadb_1 | merged operations:
mariadb_1 | insert 0, delete mark 0, delete 0
mariadb_1 | discarded operations:
mariadb_1 | insert 0, delete mark 0, delete 0
mariadb_1 | Hash table size 276671, node heap has 0 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 0 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 0 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 1 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 1 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 1 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 1 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 0 buffer(s)
mariadb_1 | 0.00 hash searches/s, 0.00 non-hash searches/s
mariadb_1 | ---
mariadb_1 | LOG
mariadb_1 | ---
mariadb_1 | Log sequence number 321312492
mariadb_1 | Log flushed up to 318443378
mariadb_1 | Pages flushed up to 41426042
mariadb_1 | Last checkpoint at 37083260
mariadb_1 | Max checkpoint age 1738750649
mariadb_1 | Checkpoint age target 1684414692
mariadb_1 | Modified age 279886450
mariadb_1 | Checkpoint age 284229232
mariadb_1 | 1 pending log flushes, 0 pending chkp writes
mariadb_1 | 97 log i/o's done, 0.00 log i/o's/second
mariadb_1 | ----------------------
mariadb_1 | BUFFER POOL AND MEMORY
mariadb_1 | ----------------------
mariadb_1 | Total large memory allocated 1117782016
mariadb_1 | Dictionary memory allocated 342972
mariadb_1 | Internal hash tables (constant factor + variable factor)
mariadb_1 | Adaptive hash index 17806144 (17706944 + 99200)
mariadb_1 | Page hash 139112 (buffer pool 0 only)
mariadb_1 | Dictionary cache 4769708 (4426736 + 342972)
mariadb_1 | File system 833632 (812272 + 21360)
mariadb_1 | Lock system 2658312 (2657176 + 1136)
mariadb_1 | Recovery system 0 (0 + 0)
mariadb_1 | Buffer pool size 65528
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 33076
mariadb_1 | Database pages 32448
mariadb_1 | Old database pages 11813
mariadb_1 | Modified db pages 28420
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 4, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 407, created 32041, written 3814
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 32448, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ----------------------
mariadb_1 | INDIVIDUAL BUFFER POOL INFO
mariadb_1 | ----------------------
mariadb_1 | ---BUFFER POOL 0
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4143
mariadb_1 | Database pages 4047
mariadb_1 | Old database pages 1473
mariadb_1 | Modified db pages 3525
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 75, created 3972, written 476
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4047, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 1
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4184
mariadb_1 | Database pages 4006
mariadb_1 | Old database pages 1458
mariadb_1 | Modified db pages 3531
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 5, created 4001, written 473
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4006, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 2
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4157
mariadb_1 | Database pages 4033
mariadb_1 | Old database pages 1468
mariadb_1 | Modified db pages 3551
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 9, created 4024, written 473
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4033, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 3
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4056
mariadb_1 | Database pages 4134
mariadb_1 | Old database pages 1506
mariadb_1 | Modified db pages 3628
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 91, created 4043, written 474
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4134, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 4
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4108
mariadb_1 | Database pages 4083
mariadb_1 | Old database pages 1487
mariadb_1 | Modified db pages 3631
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 68, created 4015, written 474
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4083, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 5
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4170
mariadb_1 | Database pages 4021
mariadb_1 | Old database pages 1464
mariadb_1 | Modified db pages 3491
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 59, created 3962, written 473
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4021, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 6
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4152
mariadb_1 | Database pages 4039
mariadb_1 | Old database pages 1470
mariadb_1 | Modified db pages 3520
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 2, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 56, created 3983, written 470
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4039, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 7
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4106
mariadb_1 | Database pages 4085
mariadb_1 | Old database pages 1487
mariadb_1 | Modified db pages 3543
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 2, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 44, created 4041, written 501
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4085, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | --------------
mariadb_1 | ROW OPERATIONS
mariadb_1 | --------------
mariadb_1 | 0 queries inside InnoDB, 0 queries in queue
mariadb_1 | 0 read views open inside InnoDB
mariadb_1 | 1 RW transactions active inside InnoDB
mariadb_1 | Process ID=1, Main thread ID=139874401253120, state: flushing log
mariadb_1 | Number of rows inserted 37482, updated 0, deleted 0, read 8
mariadb_1 | 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
mariadb_1 | ----------------------------
mariadb_1 | END OF INNODB MONITOR OUTPUT
mariadb_1 | ============================
mariadb_1 | InnoDB: ###### Diagnostic info printed to the standard error stream
mariadb_1 | 2017-01-04T12:28:51.367148Z 0 [Warning] InnoDB: A long semaphore wait:
mariadb_1 | --Thread 139874350896896 has waited at btr0btr.cc line 177 for 512.00 seconds the semaphore:
mariadb_1 | SX-lock on RW-latch at 0x7f37516b3e50 created in file buf0buf.cc line 1453
mariadb_1 | a writer (thread id 139874868471552) has reserved it in mode exclusive
mariadb_1 | number of readers 0, waiters flag 1, lock_word: 0
mariadb_1 | Last time read locked in file row0ins.cc line 2486
mariadb_1 | Last time write locked in file /mnt/workspace/percona-server-5.7-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.16-10/storage/innobase/include/mtr0mtr.ic line 153
mariadb_1 | 2017-01-04T12:28:51.367193Z 0 [Warning] InnoDB: A long semaphore wait:
mariadb_1 | --Thread 139874655098624 has waited at log0log.cc line 1318 for 520.00 seconds the semaphore:
mariadb_1 | Mutex at 0x2672628, Mutex LOG_WRITE created log0log.cc:863, lock var 1
mariadb_1 |
mariadb_1 | InnoDB: ###### Starts InnoDB Monitor for 30 secs to print diagnostic info:
mariadb_1 | InnoDB: Pending preads 0, pwrites 2
mariadb_1 |
mariadb_1 | =====================================
mariadb_1 | 2017-01-04 12:28:52 0x7f3710ff9700 INNODB MONITOR OUTPUT
mariadb_1 | =====================================
mariadb_1 | Per second averages calculated from the last 20 seconds
mariadb_1 | -----------------
mariadb_1 | BACKGROUND THREAD
mariadb_1 | -----------------
mariadb_1 | srv_master_thread loops: 62 srv_active, 0 srv_shutdown, 167 srv_idle
mariadb_1 | srv_master_thread log flush and writes: 228
mariadb_1 | ----------
mariadb_1 | SEMAPHORES
mariadb_1 | ----------
mariadb_1 | OS WAIT ARRAY INFO: reservation count 272
mariadb_1 | --Thread 139874350896896 has waited at btr0btr.cc line 177 for 513.00 seconds the semaphore:
mariadb_1 | SX-lock on RW-latch at 0x7f37516b3e50 created in file buf0buf.cc line 1453
mariadb_1 | a writer (thread id 139874868471552) has reserved it in mode exclusive
mariadb_1 | number of readers 0, waiters flag 1, lock_word: 0
mariadb_1 | Last time read locked in file row0ins.cc line 2486
mariadb_1 | Last time write locked in file /mnt/workspace/percona-server-5.7-debian-binary/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.16-10/storage/innobase/include/mtr0mtr.ic line 153
mariadb_1 | --Thread 139874655098624 has waited at log0log.cc line 1318 for 521.00 seconds the semaphore:
mariadb_1 | Mutex at 0x2672628, Mutex LOG_WRITE created log0log.cc:863, lock var 1
mariadb_1 |
mariadb_1 | OS WAIT ARRAY INFO: signal count 158
mariadb_1 | RW-shared spins 0, rounds 43, OS waits 16
mariadb_1 | RW-excl spins 0, rounds 30, OS waits 1
mariadb_1 | RW-sx spins 13, rounds 390, OS waits 13
mariadb_1 | Spin rounds per wait: 43.00 RW-shared, 30.00 RW-excl, 30.00 RW-sx
mariadb_1 | ------------
mariadb_1 | TRANSACTIONS
mariadb_1 | ------------
mariadb_1 | Trx id counter 2152
mariadb_1 | Purge done for trx's n:o < 2149 undo n:o < 0 state: running but idle
mariadb_1 | History list length 34
mariadb_1 | LIST OF TRANSACTIONS FOR EACH SESSION:
mariadb_1 | ---TRANSACTION 2151, ACTIVE 521 sec inserting
mariadb_1 | mysql tables in use 1, locked 1
mariadb_1 | 1 lock struct(s), heap size 1136, 0 row lock(s), undo log entries 24
mariadb_1 | MySQL thread id 3, OS thread handle 139874868471552, query id 357 localhost root update
mariadb_1 | INSERT INTO `insly_loimport` VALUES (72545,'Doyle Decorating Limited','LiabilitiesOnly','MGBW427','Richard Scott','LAPSED','yes','','1000','12.05.2014','','20.05.2014','20.05.2014','09:01:31','9 Windsor Way\nSandy\nBeds','SG19 1JL','9 Windsor Way\nSandy\nBeds','SG19 1JL','','','','','','','','','120/WA92430','No','no','','','','','','','','','','','','','','Endorsement 27 - Professional Services Exclusion (Applicable to Section B) :: Underwriters shall have no liability under this Policy to provide any indemnity or benefit for any legal liability arising out of breach of professional duty or
mariadb_1 | --------
mariadb_1 | FILE I/O
mariadb_1 | --------
mariadb_1 | I/O thread 0 state: waiting for completed aio requests (insert buffer thread)
mariadb_1 | I/O thread 1 state: waiting for completed aio requests (log thread)
mariadb_1 | I/O thread 2 state: waiting for completed aio requests (read thread)
mariadb_1 | I/O thread 3 state: waiting for completed aio requests (read thread)
mariadb_1 | I/O thread 4 state: waiting for completed aio requests (read thread)
mariadb_1 | I/O thread 5 state: waiting for completed aio requests (read thread)
mariadb_1 | I/O thread 6 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 7 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 8 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 9 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 10 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 11 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 12 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 13 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 14 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 15 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 16 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 17 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 18 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 19 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 20 state: waiting for completed aio requests (write thread)
mariadb_1 | I/O thread 21 state: waiting for completed aio requests (write thread)
mariadb_1 | Pending normal aio reads: [0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,
mariadb_1 | ibuf aio reads:, log i/o's:, sync i/o's:
mariadb_1 | Pending flushes (fsync) log: 0; buffer pool: 0
mariadb_1 | 434 OS file reads, 6702 OS file writes, 587 OS fsyncs
mariadb_1 | 0 pending preads, 2 pending pwrites
mariadb_1 | 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
mariadb_1 | -------------------------------------
mariadb_1 | INSERT BUFFER AND ADAPTIVE HASH INDEX
mariadb_1 | -------------------------------------
mariadb_1 | Ibuf: size 1, free list len 0, seg size 2, 0 merges
mariadb_1 | merged operations:
mariadb_1 | insert 0, delete mark 0, delete 0
mariadb_1 | discarded operations:
mariadb_1 | insert 0, delete mark 0, delete 0
mariadb_1 | Hash table size 276671, node heap has 0 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 0 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 0 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 1 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 1 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 1 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 1 buffer(s)
mariadb_1 | Hash table size 276671, node heap has 0 buffer(s)
mariadb_1 | 0.00 hash searches/s, 0.00 non-hash searches/s
mariadb_1 | ---
mariadb_1 | LOG
mariadb_1 | ---
mariadb_1 | Log sequence number 321312492
mariadb_1 | Log flushed up to 318443378
mariadb_1 | Pages flushed up to 41426042
mariadb_1 | Last checkpoint at 37083260
mariadb_1 | Max checkpoint age 1738750649
mariadb_1 | Checkpoint age target 1684414692
mariadb_1 | Modified age 279886450
mariadb_1 | Checkpoint age 284229232
mariadb_1 | 1 pending log flushes, 0 pending chkp writes
mariadb_1 | 97 log i/o's done, 0.00 log i/o's/second
mariadb_1 | ----------------------
mariadb_1 | BUFFER POOL AND MEMORY
mariadb_1 | ----------------------
mariadb_1 | Total large memory allocated 1117782016
mariadb_1 | Dictionary memory allocated 342972
mariadb_1 | Internal hash tables (constant factor + variable factor)
mariadb_1 | Adaptive hash index 17806144 (17706944 + 99200)
mariadb_1 | Page hash 139112 (buffer pool 0 only)
mariadb_1 | Dictionary cache 4769708 (4426736 + 342972)
mariadb_1 | File system 833632 (812272 + 21360)
mariadb_1 | Lock system 2658312 (2657176 + 1136)
mariadb_1 | Recovery system 0 (0 + 0)
mariadb_1 | Buffer pool size 65528
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 33076
mariadb_1 | Database pages 32448
mariadb_1 | Old database pages 11813
mariadb_1 | Modified db pages 28420
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 4, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 407, created 32041, written 3814
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 32448, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ----------------------
mariadb_1 | INDIVIDUAL BUFFER POOL INFO
mariadb_1 | ----------------------
mariadb_1 | ---BUFFER POOL 0
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4143
mariadb_1 | Database pages 4047
mariadb_1 | Old database pages 1473
mariadb_1 | Modified db pages 3525
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 75, created 3972, written 476
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4047, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 1
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4184
mariadb_1 | Database pages 4006
mariadb_1 | Old database pages 1458
mariadb_1 | Modified db pages 3531
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 5, created 4001, written 473
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4006, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 2
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4157
mariadb_1 | Database pages 4033
mariadb_1 | Old database pages 1468
mariadb_1 | Modified db pages 3551
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 9, created 4024, written 473
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4033, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 3
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4056
mariadb_1 | Database pages 4134
mariadb_1 | Old database pages 1506
mariadb_1 | Modified db pages 3628
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 91, created 4043, written 474
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4134, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 4
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4108
mariadb_1 | Database pages 4083
mariadb_1 | Old database pages 1487
mariadb_1 | Modified db pages 3631
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 68, created 4015, written 474
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4083, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 5
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4170
mariadb_1 | Database pages 4021
mariadb_1 | Old database pages 1464
mariadb_1 | Modified db pages 3491
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 0, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 59, created 3962, written 473
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4021, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 6
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4152
mariadb_1 | Database pages 4039
mariadb_1 | Old database pages 1470
mariadb_1 | Modified db pages 3520
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 2, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 56, created 3983, written 470
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4039, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | ---BUFFER POOL 7
mariadb_1 | Buffer pool size 8191
mariadb_1 | Buffer pool size, bytes 0
mariadb_1 | Free buffers 4106
mariadb_1 | Database pages 4085
mariadb_1 | Old database pages 1487
mariadb_1 | Modified db pages 3543
mariadb_1 | Pending reads 0
mariadb_1 | Pending writes: LRU 0, flush list 2, single page 0
mariadb_1 | Pages made young 0, not young 0
mariadb_1 | 0.00 youngs/s, 0.00 non-youngs/s
mariadb_1 | Pages read 44, created 4041, written 501
mariadb_1 | 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
mariadb_1 | No buffer pool page gets since the last printout
mariadb_1 | Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s
mariadb_1 | LRU len: 4085, unzip_LRU len: 0
mariadb_1 | I/O sum[0]:cur[0], unzip sum[0]:cur[0]
mariadb_1 | --------------
mariadb_1 | ROW OPERATIONS
mariadb_1 | --------------
mariadb_1 | 0 queries inside InnoDB, 0 queries in queue
mariadb_1 | 0 read views open inside InnoDB
mariadb_1 | 1 RW transactions active inside InnoDB
mariadb_1 | Process ID=1, Main thread ID=139874401253120, state: flushing log
mariadb_1 | Number of rows inserted 37482, updated 0, deleted 0, read 8
mariadb_1 | 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
mariadb_1 | ----------------------------
mariadb_1 | END OF INNODB MONITOR OUTPUT
mariadb_1 | ============================
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment