MariaDB was crashed with long semaphore wait

=====================================

2019-11-18 08:54:07 0x7f79358cb700 INNODB MONITOR OUTPUT

=====================================

Per second averages calculated from the last 20 seconds

-----------------

BACKGROUND THREAD

-----------------

srv_master_thread loops: 40381 srv_active, 0 srv_shutdown, 82038 srv_idle

srv_master_thread log flush and writes: 122417

----------

SEMAPHORES

----------

OS WAIT ARRAY INFO: reservation count 49112997

--Thread 140158456289024 has waited at row0row.cc line 1072 for 953.00 seconds the semaphore:

X-lock on RW-latch at 0x7f9d34ba0880 created in file buf0buf.cc line 1471

a writer (thread id 0) has reserved it in mode  SX

number of readers 0, waiters flag 1, lock_word: 10000000

Last time read locked in file row0ins.cc line 2069

Last time write locked in file buf0flu.cc line 1226

--Thread 140158028384000 has waited at row0undo.cc line 292 for 945.00 seconds the semaphore:

S-lock on RW-latch at 0x558327e61880 created in file dict0dict.cc line 1108

a writer (thread id 140158557792000) has reserved it in mode  wait exclusive

number of readers 4, waiters flag 1, lock_word: fffffffffffffffc

Last time read locked in file row0undo.cc line 292

Last time write locked in file ha_innodb.cc line 12985

--Thread 140158464681728 has waited at row0row.cc line 1072 for 953.00 seconds the semaphore:

X-lock on RW-latch at 0x7f9d34ba0880 created in file buf0buf.cc line 1471

a writer (thread id 0) has reserved it in mode  SX

number of readers 0, waiters flag 1, lock_word: 10000000

Last time read locked in file row0ins.cc line 2069

Last time write locked in file buf0flu.cc line 1226

--Thread 140158030808832 has waited at row0undo.cc line 292 for 83.00 seconds the semaphore:

S-lock on RW-latch at 0x558327e61880 created in file dict0dict.cc line 1108

a writer (thread id 140158557792000) has reserved it in mode  wait exclusive

number of readers 4, waiters flag 1, lock_word: fffffffffffffffc

Last time read locked in file row0undo.cc line 292

Last time write locked in file ha_innodb.cc line 12985

--Thread 140158045054720 has waited at row0row.cc line 1072 for 953.00 seconds the semaphore:

S-lock on RW-latch at 0x7f8619dd8838 created in file buf0buf.cc line 1471

a writer (thread id 140158447896320) has reserved it in mode  wait exclusive

number of readers 2, waiters flag 1, lock_word: fffffffffffffffe

Last time read locked in file row0row.cc line 1072

Last time write locked in file mtr0mtr.ic line 147

--Thread 140158473074432 has waited at btr0cur.cc line 978 for 953.00 seconds the semaphore:

SX-lock on RW-latch at 0x7f75300732d0 created in file dict0dict.cc line 2612

a writer (thread id 140158447896320) has reserved it in mode  SX

number of readers 3, waiters flag 1, lock_word: ffffffd

Last time read locked in file btr0cur.cc line 1010

Last time write locked in file btr0cur.cc line 978

--Thread 140158035052288 has waited at row0undo.cc line 292 for 944.00 seconds the semaphore:

S-lock on RW-latch at 0x558327e61880 created in file dict0dict.cc line 1108

a writer (thread id 140158557792000) has reserved it in mode  wait exclusive

number of readers 4, waiters flag 1, lock_word: fffffffffffffffc

Last time read locked in file row0undo.cc line 292

Last time write locked in file ha_innodb.cc line 12985

--Thread 140158057481984 has waited at row0undo.cc line 292 for 945.00 seconds the semaphore:

S-lock on RW-latch at 0x558327e61880 created in file dict0dict.cc line 1108

a writer (thread id 140158557792000) has reserved it in mode  wait exclusive

number of readers 4, waiters flag 1, lock_word: fffffffffffffffc

Last time read locked in file row0undo.cc line 292

Last time write locked in file ha_innodb.cc line 12985

--Thread 140158557792000 has waited at dict0stats.cc line 2456 for 945.00 seconds the semaphore:

X-lock (wait_ex) on RW-latch at 0x558327e61880 created in file dict0dict.cc line 1108

a writer (thread id 140158557792000) has reserved it in mode  wait exclusive

number of readers 4, waiters flag 1, lock_word: fffffffffffffffc

Last time read locked in file row0undo.cc line 292

Last time write locked in file ha_innodb.cc line 12985

--Thread 140158447896320 has waited at mtr0mtr.ic line 147 for 953.00 seconds the semaphore:

X-lock (wait_ex) on RW-latch at 0x7f8619dd8838 created in file buf0buf.cc line 1471

a writer (thread id 140158447896320) has reserved it in mode  wait exclusive

number of readers 2, waiters flag 1, lock_word: fffffffffffffffe

Last time read locked in file row0row.cc line 1072

Last time write locked in file mtr0mtr.ic line 147

--Thread 140158037780224 has waited at dict0stats.cc line 2456 for 723.00 seconds the semaphore:

X-lock on RW-latch at 0x558327e61880 created in file dict0dict.cc line 1108

a writer (thread id 140158557792000) has reserved it in mode  wait exclusive

number of readers 4, waiters flag 1, lock_word: fffffffffffffffc

Last time read locked in file row0undo.cc line 292

Last time write locked in file ha_innodb.cc line 12985

OS WAIT ARRAY INFO: signal count 52624235

RW-shared spins 0, rounds 69038357, OS waits 17012133

RW-excl spins 0, rounds 472487789, OS waits 7814216

RW-sx spins 30092370, rounds 571255325, OS waits 10951222

Spin rounds per wait: 69038357.00 RW-shared, 472487789.00 RW-excl, 18.98 RW-sx

------------

TRANSACTIONS

------------

Trx id counter 67166267102

Purge done for trx's n:o < 67078595342 undo n:o < 0 state: running

History list length 6307454

LIST OF TRANSACTIONS FOR EACH SESSION:

---TRANSACTION 421795933694472, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933682112, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933699416, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933698592, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933696944, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933691176, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933690352, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933682936, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933688704, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933687880, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933687056, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933686232, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933683760, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933695296, not started inserting

mysql tables in use 1, locked 1

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933684584, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 421795933680464, not started

0 lock struct(s), heap size 1136, 0 row lock(s)

---TRANSACTION 67166267101, ACTIVE 0 sec inserting

mysql tables in use 1, locked 1

0 lock struct(s), heap size 1136, 0 row lock(s)

MySQL thread id 21904, OS thread handle 140158051723008, query id 388751724  update

replace into (`campaign`,`source`,`ad`,`page`,`landing_page`,`date`,`website_visits`,`conv_my_stc_transactions`,`conv_my_stc_revenue`,`conv_form_fills`,`conv_coupon_views`,`datasource`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?)

---TRANSACTION 67164985040, ACTIVE 83 sec inserting

mysql tables in use 1, locked 1

ROLLING BACK 3 lock struct(s), heap size 1136, 2 row lock(s)

MySQL thread id 25756, OS thread handle 140158030808832, query id 388110553  update

replace into  (`ad_id`,`ad_name`,`adset_id`,`adset_name`,`campaign_id`,`campaign_name`,`date_start`,`date_stop`,`account_id`,`rs_score`,`rs_status`,`ad_reach`,`ad_recallers`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)

---TRANSACTION 67151659109, ACTIVE 944 sec inserting

mysql tables in use 1, locked 1

ROLLING BACK 2 lock struct(s), heap size 1136, 1 row lock(s)

MySQL thread id 25749, OS thread handle 140158035052288, query id 381446338  update

replace into (`clicks`,`impressions`,`spend`,`reach`,`objective`,`frequency`,`campaign_name`,`campaign_id`,`ad_id`,`ad_name`,`adset_id`,`adset_name`,`date_start`,`date_stop`,`age`,`gender`,`account_id`,`video_p25_watched`,`video_p50_watched`,`video_p75_watched`,`video_p95_watched`,`video_p100_watched`,`video_avg_watched`,`link_clicks`,`estimated_ad_recall`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

---TRANSACTION 67151642255, ACTIVE 945 sec inserting

mysql tables in use 1, locked 1

ROLLING BACK 2 lock struct(s), heap size 1136, 6 row lock(s)

MySQL thread id 21920, OS thread handle 140158028384000, query id 381437903  update

replace into  (`casenumber`,`saledate`,`calltype`,`locationcode`,`locname`,`informanthomephone`,`informantworkphone`,`informantmobilephone`,`totalprofessionalservices`,`casket`,`outerburialcontainer`,`totalservicesandmerchandise`,`import_file_name`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)

---TRANSACTION 67151642012, ACTIVE 945 sec inserting

mysql tables in use 1, locked 1

ROLLING BACK 3 lock struct(s), heap size 1136, 48 row lock(s)

MySQL thread id 25748, OS thread handle 140158057481984, query id 381437782  update

replace into (`currency`,`campaign_name`,`channel`,`bi_brand_non_brand`,`date`,`impressions`,`clicks`,`cost`,`ecomm_sale_ks_pixel`,`formleads`,`callrail_calls`,`click_to_call`,`account_name`,`network`) VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?,?)

---TRANSACTION 67151469362, ACTIVE 953 sec updating or deleting

mysql tables in use 1, locked 1

3 lock struct(s), heap size 1136, 8 row lock(s), undo log entries 2

MySQL thread id 25736, OS thread handle 140158045054720, query id 381351448  update

replace into (`campaign`,`date`,`ad_group`,`creative`,`ad_server_creative_placement_id`,`advertiser_cost__usd_`,`impressions`,`clicks`,`player_completed_views`,`player_starts`,`all_last_click___view_conversions`) VALUES(?,?,?,?,?,?,?,?,?,?,?)

--------

FILE I/O

--------

I/O thread 0 state: waiting for completed aio requests (insert buffer thread)

I/O thread 1 state: waiting for completed aio requests (log thread)

I/O thread 2 state: waiting for completed aio requests (read thread)

I/O thread 3 state: waiting for completed aio requests (read thread)

I/O thread 4 state: waiting for completed aio requests (read thread)

I/O thread 5 state: waiting for completed aio requests (read thread)

I/O thread 6 state: waiting for completed aio requests (read thread)

I/O thread 7 state: waiting for completed aio requests (read thread)

I/O thread 8 state: waiting for completed aio requests (read thread)

I/O thread 9 state: waiting for completed aio requests (read thread)

I/O thread 10 state: waiting for completed aio requests (read thread)

I/O thread 11 state: waiting for completed aio requests (read thread)

I/O thread 12 state: waiting for completed aio requests (read thread)

I/O thread 13 state: waiting for completed aio requests (read thread)

I/O thread 14 state: waiting for completed aio requests (read thread)

I/O thread 15 state: waiting for completed aio requests (read thread)

I/O thread 16 state: waiting for completed aio requests (read thread)

I/O thread 17 state: waiting for completed aio requests (read thread)

I/O thread 18 state: waiting for completed aio requests (read thread)

I/O thread 19 state: waiting for completed aio requests (read thread)

I/O thread 20 state: waiting for completed aio requests (read thread)

I/O thread 21 state: waiting for completed aio requests (read thread)

I/O thread 22 state: waiting for completed aio requests (read thread)

I/O thread 23 state: waiting for completed aio requests (read thread)

I/O thread 24 state: waiting for completed aio requests (read thread)

I/O thread 25 state: waiting for completed aio requests (read thread)

I/O thread 26 state: waiting for completed aio requests (read thread)

I/O thread 27 state: waiting for completed aio requests (read thread)

I/O thread 28 state: waiting for completed aio requests (read thread)

I/O thread 29 state: waiting for completed aio requests (read thread)

I/O thread 30 state: waiting for completed aio requests (read thread)

I/O thread 31 state: waiting for completed aio requests (read thread)

I/O thread 32 state: waiting for completed aio requests (read thread)

I/O thread 33 state: waiting for completed aio requests (read thread)

I/O thread 34 state: waiting for completed aio requests (write thread)

I/O thread 35 state: waiting for completed aio requests (write thread)

I/O thread 36 state: waiting for completed aio requests (write thread)

I/O thread 37 state: waiting for completed aio requests (write thread)

I/O thread 38 state: waiting for completed aio requests (write thread)

I/O thread 39 state: waiting for completed aio requests (write thread)

I/O thread 40 state: waiting for completed aio requests (write thread)

I/O thread 41 state: waiting for completed aio requests (write thread)

I/O thread 42 state: waiting for completed aio requests (write thread)

I/O thread 43 state: waiting for completed aio requests (write thread)

I/O thread 44 state: waiting for completed aio requests (write thread)

I/O thread 45 state: waiting for completed aio requests (write thread)

I/O thread 46 state: waiting for completed aio requests (write thread)

I/O thread 47 state: waiting for completed aio requests (write thread)

I/O thread 48 state: waiting for completed aio requests (write thread)

I/O thread 49 state: waiting for completed aio requests (write thread)

I/O thread 50 state: waiting for completed aio requests (write thread)

I/O thread 51 state: waiting for completed aio requests (write thread)

I/O thread 52 state: waiting for completed aio requests (write thread)

I/O thread 53 state: waiting for completed aio requests (write thread)

I/O thread 54 state: waiting for completed aio requests (write thread)

I/O thread 55 state: waiting for completed aio requests (write thread)

I/O thread 56 state: waiting for completed aio requests (write thread)

I/O thread 57 state: waiting for completed aio requests (write thread)

I/O thread 58 state: waiting for completed aio requests (write thread)

I/O thread 59 state: waiting for completed aio requests (write thread)

I/O thread 60 state: waiting for completed aio requests (write thread)

I/O thread 61 state: waiting for completed aio requests (write thread)

I/O thread 62 state: waiting for completed aio requests (write thread)

I/O thread 63 state: waiting for completed aio requests (write thread)

I/O thread 64 state: waiting for completed aio requests (write thread)

I/O thread 65 state: waiting for completed aio requests (write thread)

Pending normal aio reads: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] , aio writes: [0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0] ,

 ibuf aio reads:, log i/o's:, sync i/o's:

Pending flushes (fsync) log: 1; buffer pool: 0

22815002 OS file reads, 346374492 OS file writes, 6044672 OS fsyncs

0.00 reads/s, 0 avg bytes/read, 7806.16 writes/s, 0.00 fsyncs/s

-------------------------------------

INSERT BUFFER AND ADAPTIVE HASH INDEX

-------------------------------------

Ibuf: size 2602, free list len 546302, seg size 548905, 722903 merges

merged operations:

 insert 4265123, delete mark 41305593, delete 11844058

discarded operations:

 insert 0, delete mark 0, delete 0

Hash table size 38249683, node heap has 40587 buffer(s)

Hash table size 38249683, node heap has 44853 buffer(s)

Hash table size 38249683, node heap has 2531 buffer(s)

Hash table size 38249683, node heap has 21614 buffer(s)

Hash table size 38249683, node heap has 9901 buffer(s)

Hash table size 38249683, node heap has 13056 buffer(s)

Hash table size 38249683, node heap has 17565 buffer(s)

Hash table size 38249683, node heap has 10678 buffer(s)

2926.90 hash searches/s, 11301.08 non-hash searches/s

---

LOG

---

Log sequence number 123692133745080

Log flushed up to   123688568773877

Pages flushed up to 123666362712167

Last checkpoint at  123666312151975

1 pending log flushes, 0 pending chkp writes

327744157 log i/o's done, 7806.50 log i/o's/second

----------------------

BUFFER POOL AND MEMORY

----------------------

Total large memory allocated 158469193728

Dictionary memory allocated 5177753

Buffer pool size   9437184

Free buffers       91

Database pages     9276308

Old database pages 3422953

Modified db pages  1381178

Percent of dirty pages(LRU & free pages): 14.889

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 24, single page 0

Pages made young 7042025, not young 610319239

0.00 youngs/s, 0.00 non-youngs/s

Pages read 22815002, created 7257949, written 16127263

0.00 reads/s, 165.54 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 9276308, unzip_LRU len: 0

I/O sum[14208]:cur[0], unzip sum[0]:cur[0]

----------------------

INDIVIDUAL BUFFER POOL INFO

----------------------

---BUFFER POOL 0

Buffer pool size   147456

Free buffers       1

Database pages     144909

Old database pages 53471

Modified db pages  26128

Percent of dirty pages(LRU & free pages): 18.030

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 112336, not young 9200133

0.00 youngs/s, 0.00 non-youngs/s

Pages read 360569, created 113516, written 503882

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144909, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 1

Buffer pool size   147456

Free buffers       2

Database pages     144953

Old database pages 53488

Modified db pages  20645

Percent of dirty pages(LRU & free pages): 14.242

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 109701, not young 9621890

0.00 youngs/s, 0.00 non-youngs/s

Pages read 361053, created 114052, written 239003

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144953, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 2

Buffer pool size   147456

Free buffers       1

Database pages     144961

Old database pages 53490

Modified db pages  21043

Percent of dirty pages(LRU & free pages): 14.516

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110805, not young 9232729

0.00 youngs/s, 0.00 non-youngs/s

Pages read 358067, created 113547, written 255503

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144961, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 3

Buffer pool size   147456

Free buffers       1

Database pages     144943

Old database pages 53484

Modified db pages  21397

Percent of dirty pages(LRU & free pages): 14.762

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 110217, not young 10219218

0.00 youngs/s, 0.00 non-youngs/s

Pages read 358825, created 114009, written 283134

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144943, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 4

Buffer pool size   147456

Free buffers       1

Database pages     144908

Old database pages 53471

Modified db pages  20903

Percent of dirty pages(LRU & free pages): 14.425

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109760, not young 9319865

0.00 youngs/s, 0.00 non-youngs/s

Pages read 358994, created 114953, written 274164

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144908, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 5

Buffer pool size   147456

Free buffers       2

Database pages     144980

Old database pages 53498

Modified db pages  20812

Percent of dirty pages(LRU & free pages): 14.355

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 111352, not young 9896291

0.00 youngs/s, 0.00 non-youngs/s

Pages read 359935, created 113401, written 251532

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144980, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 6

Buffer pool size   147456

Free buffers       2

Database pages     144936

Old database pages 53481

Modified db pages  20869

Percent of dirty pages(LRU & free pages): 14.398

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 107840, not young 8866700

0.00 youngs/s, 0.00 non-youngs/s

Pages read 353825, created 113263, written 243921

0.00 reads/s, 0.05 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144936, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 7

Buffer pool size   147456

Free buffers       1

Database pages     144961

Old database pages 53490

Modified db pages  20931

Percent of dirty pages(LRU & free pages): 14.439

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 111270, not young 9055104

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357151, created 112695, written 240505

0.00 reads/s, 4.75 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144961, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 8

Buffer pool size   147456

Free buffers       2

Database pages     144982

Old database pages 53498

Modified db pages  21173

Percent of dirty pages(LRU & free pages): 14.604

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110924, not young 10225302

0.00 youngs/s, 0.00 non-youngs/s

Pages read 360676, created 113865, written 242205

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144982, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 9

Buffer pool size   147456

Free buffers       1

Database pages     144967

Old database pages 53493

Modified db pages  20798

Percent of dirty pages(LRU & free pages): 14.347

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 111442, not young 9925783

0.00 youngs/s, 0.00 non-youngs/s

Pages read 360745, created 110977, written 240999

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144967, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 10

Buffer pool size   147456

Free buffers       1

Database pages     144883

Old database pages 53462

Modified db pages  21463

Percent of dirty pages(LRU & free pages): 14.814

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 105130, not young 10225999

0.00 youngs/s, 0.00 non-youngs/s

Pages read 351359, created 113255, written 247109

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144883, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 11

Buffer pool size   147456

Free buffers       2

Database pages     144992

Old database pages 53502

Modified db pages  21453

Percent of dirty pages(LRU & free pages): 14.796

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 107451, not young 9257704

0.00 youngs/s, 0.00 non-youngs/s

Pages read 352717, created 114283, written 245612

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144992, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 12

Buffer pool size   147456

Free buffers       1

Database pages     144953

Old database pages 53488

Modified db pages  20877

Percent of dirty pages(LRU & free pages): 14.402

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108231, not young 9344128

0.00 youngs/s, 0.00 non-youngs/s

Pages read 356382, created 114699, written 254435

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144953, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 13

Buffer pool size   147456

Free buffers       2

Database pages     144959

Old database pages 53490

Modified db pages  21125

Percent of dirty pages(LRU & free pages): 14.573

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110097, not young 8964163

0.00 youngs/s, 0.00 non-youngs/s

Pages read 356493, created 112931, written 245242

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144959, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 14

Buffer pool size   147456

Free buffers       1

Database pages     144948

Old database pages 53486

Modified db pages  22120

Percent of dirty pages(LRU & free pages): 15.260

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108282, not young 9036261

0.00 youngs/s, 0.00 non-youngs/s

Pages read 353896, created 114038, written 247985

0.00 reads/s, 0.05 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144948, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 15

Buffer pool size   147456

Free buffers       1

Database pages     144901

Old database pages 53468

Modified db pages  21116

Percent of dirty pages(LRU & free pages): 14.573

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 112004, not young 9349251

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357733, created 112985, written 238525

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144901, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 16

Buffer pool size   147456

Free buffers       1

Database pages     144955

Old database pages 53488

Modified db pages  21999

Percent of dirty pages(LRU & free pages): 15.176

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108183, not young 9439602

0.00 youngs/s, 0.00 non-youngs/s

Pages read 351008, created 112313, written 255366

0.00 reads/s, 3.30 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144955, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 17

Buffer pool size   147456

Free buffers       1

Database pages     144990

Old database pages 53501

Modified db pages  21400

Percent of dirty pages(LRU & free pages): 14.759

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 107629, not young 9220428

0.00 youngs/s, 0.00 non-youngs/s

Pages read 354453, created 112579, written 247504

0.00 reads/s, 6.35 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144990, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 18

Buffer pool size   147456

Free buffers       1

Database pages     144905

Old database pages 53470

Modified db pages  21371

Percent of dirty pages(LRU & free pages): 14.748

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109874, not young 9424295

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357669, created 112543, written 254571

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144905, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 19

Buffer pool size   147456

Free buffers       1

Database pages     144959

Old database pages 53490

Modified db pages  21985

Percent of dirty pages(LRU & free pages): 15.166

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 111878, not young 9788366

0.00 youngs/s, 0.00 non-youngs/s

Pages read 360237, created 115821, written 250548

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144959, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 20

Buffer pool size   147456

Free buffers       1

Database pages     144913

Old database pages 53473

Modified db pages  21675

Percent of dirty pages(LRU & free pages): 14.957

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 111394, not young 9738385

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357634, created 112327, written 244378

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144913, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 21

Buffer pool size   147456

Free buffers       0

Database pages     144936

Old database pages 53481

Modified db pages  21727

Percent of dirty pages(LRU & free pages): 14.991

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110420, not young 9932824

0.00 youngs/s, 0.00 non-youngs/s

Pages read 359471, created 113119, written 252153

0.00 reads/s, 2.90 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144936, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 22

Buffer pool size   147456

Free buffers       4

Database pages     144955

Old database pages 53488

Modified db pages  22018

Percent of dirty pages(LRU & free pages): 15.189

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108423, not young 8625866

0.00 youngs/s, 0.00 non-youngs/s

Pages read 351149, created 110052, written 251835

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144955, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 23

Buffer pool size   147456

Free buffers       2

Database pages     144938

Old database pages 53482

Modified db pages  21616

Percent of dirty pages(LRU & free pages): 14.914

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109927, not young 10250613

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355655, created 112212, written 254677

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144938, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 24

Buffer pool size   147456

Free buffers       3

Database pages     144963

Old database pages 53491

Modified db pages  21364

Percent of dirty pages(LRU & free pages): 14.737

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 112658, not young 9806788

0.00 youngs/s, 0.00 non-youngs/s

Pages read 361200, created 112895, written 249307

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144963, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 25

Buffer pool size   147456

Free buffers       2

Database pages     144937

Old database pages 53482

Modified db pages  21381

Percent of dirty pages(LRU & free pages): 14.752

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 141445, not young 12624903

0.00 youngs/s, 0.00 non-youngs/s

Pages read 362207, created 118198, written 242253

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144937, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 26

Buffer pool size   147456

Free buffers       1

Database pages     144913

Old database pages 53473

Modified db pages  21918

Percent of dirty pages(LRU & free pages): 15.125

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 112236, not young 9945266

0.00 youngs/s, 0.00 non-youngs/s

Pages read 359103, created 115166, written 246984

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144913, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 27

Buffer pool size   147456

Free buffers       2

Database pages     144923

Old database pages 53476

Modified db pages  22580

Percent of dirty pages(LRU & free pages): 15.580

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110243, not young 10292178

0.00 youngs/s, 0.00 non-youngs/s

Pages read 358103, created 113078, written 253375

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144923, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 28

Buffer pool size   147456

Free buffers       1

Database pages     144956

Old database pages 53489

Modified db pages  21197

Percent of dirty pages(LRU & free pages): 14.623

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 106958, not young 9834381

0.00 youngs/s, 0.00 non-youngs/s

Pages read 353607, created 111102, written 237580

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144956, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 29

Buffer pool size   147456

Free buffers       0

Database pages     144918

Old database pages 53475

Modified db pages  22069

Percent of dirty pages(LRU & free pages): 15.229

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108537, not young 10126990

0.00 youngs/s, 0.00 non-youngs/s

Pages read 356126, created 112673, written 244877

0.00 reads/s, 2.25 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144918, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 30

Buffer pool size   147456

Free buffers       1

Database pages     144934

Old database pages 53481

Modified db pages  21714

Percent of dirty pages(LRU & free pages): 14.982

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108750, not young 9375153

0.00 youngs/s, 0.00 non-youngs/s

Pages read 359463, created 113142, written 257622

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144934, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 31

Buffer pool size   147456

Free buffers       3

Database pages     144956

Old database pages 53489

Modified db pages  21517

Percent of dirty pages(LRU & free pages): 14.843

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 109225, not young 9876443

0.00 youngs/s, 0.00 non-youngs/s

Pages read 354376, created 112530, written 245411

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144956, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 32

Buffer pool size   147456

Free buffers       1

Database pages     144948

Old database pages 53486

Modified db pages  22756

Percent of dirty pages(LRU & free pages): 15.699

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 107776, not young 9302514

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355307, created 113628, written 246290

0.00 reads/s, 0.00 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144948, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 33

Buffer pool size   147456

Free buffers       2

Database pages     144924

Old database pages 53477

Modified db pages  21921

Percent of dirty pages(LRU & free pages): 15.126

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 109746, not young 9286110

0.00 youngs/s, 0.00 non-youngs/s

Pages read 353838, created 114277, written 248945

0.00 reads/s, 2.40 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144924, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 34

Buffer pool size   147456

Free buffers       2

Database pages     144999

Old database pages 53505

Modified db pages  20856

Percent of dirty pages(LRU & free pages): 14.383

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108818, not young 9821739

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355011, created 113121, written 243533

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144999, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 35

Buffer pool size   147456

Free buffers       2

Database pages     144915

Old database pages 53474

Modified db pages  21404

Percent of dirty pages(LRU & free pages): 14.770

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 109420, not young 9886599

0.00 youngs/s, 0.00 non-youngs/s

Pages read 351533, created 112481, written 240488

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144915, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 36

Buffer pool size   147456

Free buffers       3

Database pages     144933

Old database pages 53480

Modified db pages  21294

Percent of dirty pages(LRU & free pages): 14.692

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110025, not young 9519484

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355830, created 112532, written 250293

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144933, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 37

Buffer pool size   147456

Free buffers       1

Database pages     144964

Old database pages 53492

Modified db pages  21299

Percent of dirty pages(LRU & free pages): 14.692

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108996, not young 9556020

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355998, created 113515, written 250275

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144964, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 38

Buffer pool size   147456

Free buffers       2

Database pages     144931

Old database pages 53479

Modified db pages  21363

Percent of dirty pages(LRU & free pages): 14.740

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109675, not young 8480821

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355217, created 113737, written 241535

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144931, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 39

Buffer pool size   147456

Free buffers       2

Database pages     144951

Old database pages 53487

Modified db pages  21038

Percent of dirty pages(LRU & free pages): 14.514

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 107904, not young 9907361

0.00 youngs/s, 0.00 non-youngs/s

Pages read 352335, created 113158, written 242112

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144951, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 40

Buffer pool size   147456

Free buffers       1

Database pages     144939

Old database pages 53482

Modified db pages  21573

Percent of dirty pages(LRU & free pages): 14.884

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109289, not young 9601547

0.00 youngs/s, 0.00 non-youngs/s

Pages read 356523, created 114272, written 244932

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144939, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 41

Buffer pool size   147456

Free buffers       2

Database pages     144964

Old database pages 53492

Modified db pages  21778

Percent of dirty pages(LRU & free pages): 15.023

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 108451, not young 9202651

0.00 youngs/s, 0.00 non-youngs/s

Pages read 351524, created 114148, written 247744

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144964, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 42

Buffer pool size   147456

Free buffers       2

Database pages     144900

Old database pages 53468

Modified db pages  22178

Percent of dirty pages(LRU & free pages): 15.305

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108064, not young 9175554

0.00 youngs/s, 0.00 non-youngs/s

Pages read 352912, created 114487, written 262151

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144900, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 43

Buffer pool size   147456

Free buffers       2

Database pages     144951

Old database pages 53487

Modified db pages  20693

Percent of dirty pages(LRU & free pages): 14.276

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109320, not young 8743150

0.00 youngs/s, 0.00 non-youngs/s

Pages read 351134, created 113713, written 243393

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144951, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 44

Buffer pool size   147456

Free buffers       1

Database pages     144916

Old database pages 53474

Modified db pages  21532

Percent of dirty pages(LRU & free pages): 14.858

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110311, not young 9605638

0.00 youngs/s, 0.00 non-youngs/s

Pages read 354743, created 113571, written 245707

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144916, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 45

Buffer pool size   147456

Free buffers       1

Database pages     144940

Old database pages 53483

Modified db pages  21410

Percent of dirty pages(LRU & free pages): 14.771

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109462, not young 9071163

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355838, created 113243, written 253390

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144940, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 46

Buffer pool size   147456

Free buffers       1

Database pages     144971

Old database pages 53494

Modified db pages  21366

Percent of dirty pages(LRU & free pages): 14.738

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108511, not young 8777835

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357139, created 113248, written 243394

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144971, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 47

Buffer pool size   147456

Free buffers       2

Database pages     144921

Old database pages 53476

Modified db pages  21568

Percent of dirty pages(LRU & free pages): 14.882

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 111274, not young 9232989

0.00 youngs/s, 0.00 non-youngs/s

Pages read 360000, created 111524, written 248842

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144921, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 48

Buffer pool size   147456

Free buffers       1

Database pages     144950

Old database pages 53486

Modified db pages  21399

Percent of dirty pages(LRU & free pages): 14.763

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109729, not young 9153445

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355824, created 112997, written 240555

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144950, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 49

Buffer pool size   147456

Free buffers       1

Database pages     144951

Old database pages 53487

Modified db pages  21387

Percent of dirty pages(LRU & free pages): 14.754

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108581, not young 9633191

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357554, created 112887, written 245779

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144951, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 50

Buffer pool size   147456

Free buffers       2

Database pages     144900

Old database pages 53468

Modified db pages  20825

Percent of dirty pages(LRU & free pages): 14.372

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 108458, not young 8847389

0.00 youngs/s, 0.00 non-youngs/s

Pages read 353709, created 109697, written 235346

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144900, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 51

Buffer pool size   147456

Free buffers       1

Database pages     144978

Old database pages 53497

Modified db pages  22004

Percent of dirty pages(LRU & free pages): 15.177

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110072, not young 9459819

0.00 youngs/s, 0.00 non-youngs/s

Pages read 358822, created 114998, written 248437

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144978, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 52

Buffer pool size   147456

Free buffers       1

Database pages     144910

Old database pages 53472

Modified db pages  22143

Percent of dirty pages(LRU & free pages): 15.280

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 107790, not young 9413527

0.00 youngs/s, 0.00 non-youngs/s

Pages read 356598, created 112780, written 251845

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144910, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 53

Buffer pool size   147456

Free buffers       1

Database pages     144925

Old database pages 53477

Modified db pages  21393

Percent of dirty pages(LRU & free pages): 14.761

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 107890, not young 9241682

0.00 youngs/s, 0.00 non-youngs/s

Pages read 356597, created 111015, written 243544

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144925, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 54

Buffer pool size   147456

Free buffers       1

Database pages     144985

Old database pages 53499

Modified db pages  21459

Percent of dirty pages(LRU & free pages): 14.801

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 106952, not young 8969707

0.00 youngs/s, 0.00 non-youngs/s

Pages read 347490, created 111176, written 236464

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144985, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 55

Buffer pool size   147456

Free buffers       1

Database pages     144969

Old database pages 53493

Modified db pages  21606

Percent of dirty pages(LRU & free pages): 14.904

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109284, not young 9421591

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357562, created 112863, written 242024

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144969, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 56

Buffer pool size   147456

Free buffers       1

Database pages     144936

Old database pages 53481

Modified db pages  21509

Percent of dirty pages(LRU & free pages): 14.840

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 109139, not young 9371649

0.00 youngs/s, 0.00 non-youngs/s

Pages read 355925, created 114000, written 240569

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144936, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 57

Buffer pool size   147456

Free buffers       1

Database pages     144892

Old database pages 53465

Modified db pages  21458

Percent of dirty pages(LRU & free pages): 14.809

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 111941, not young 10153573

0.00 youngs/s, 0.00 non-youngs/s

Pages read 362308, created 114986, written 255049

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144892, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 58

Buffer pool size   147456

Free buffers       1

Database pages     144933

Old database pages 53480

Modified db pages  21875

Percent of dirty pages(LRU & free pages): 15.093

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 110014, not young 9371009

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357577, created 114753, written 245289

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144933, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 59

Buffer pool size   147456

Free buffers       0

Database pages     145004

Old database pages 53506

Modified db pages  21695

Percent of dirty pages(LRU & free pages): 14.962

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 110584, not young 10053258

0.00 youngs/s, 0.00 non-youngs/s

Pages read 360602, created 117041, written 247955

0.00 reads/s, 1.50 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 145004, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 60

Buffer pool size   147456

Free buffers       2

Database pages     144903

Old database pages 53469

Modified db pages  22446

Percent of dirty pages(LRU & free pages): 15.490

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 110566, not young 9547068

0.00 youngs/s, 0.00 non-youngs/s

Pages read 358447, created 115431, written 258934

0.00 reads/s, 1.10 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144903, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 61

Buffer pool size   147456

Free buffers       1

Database pages     144945

Old database pages 53485

Modified db pages  22494

Percent of dirty pages(LRU & free pages): 15.519

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 110027, not young 9322499

0.00 youngs/s, 0.00 non-youngs/s

Pages read 359557, created 115407, written 247999

0.00 reads/s, 3.30 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144945, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 62

Buffer pool size   147456

Free buffers       1

Database pages     144941

Old database pages 53483

Modified db pages  21110

Percent of dirty pages(LRU & free pages): 14.564

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 2, single page 0

Pages made young 111434, not young 8944235

0.00 youngs/s, 0.00 non-youngs/s

Pages read 357184, created 112681, written 241240

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144941, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

---BUFFER POOL 63

Buffer pool size   147456

Free buffers       2

Database pages     144932

Old database pages 53480

Modified db pages  21962

Percent of dirty pages(LRU & free pages): 15.153

Max dirty pages percent: 75.000

Pending reads 0

Pending writes: LRU 0, flush list 0, single page 0

Pages made young 107900, not young 10201420

0.00 youngs/s, 0.00 non-youngs/s

Pages read 354483, created 114363, written 251013

0.00 reads/s, 3.20 creates/s, 0.00 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, Random read ahead 0.00/s

LRU len: 144932, unzip_LRU len: 0

I/O sum[222]:cur[0], unzip sum[0]:cur[0]

--------------

ROW OPERATIONS

--------------

0 queries inside InnoDB, 0 queries in queue

3 read views open inside InnoDB

Process ID=29311, Main thread ID=140158591362816, state: flushing log

Number of rows inserted 271814413, updated 170000953, deleted 61691005, read 48688048564

7815.86 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

Number of system rows inserted 0, updated 0, deleted 0, read 0

0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s

----------------------------

END OF INNODB MONITOR OUTPUT

============================

InnoDB: ###### Diagnostic info printed to the standard error stream

2019-11-18  8:54:07 140158574577408 [ERROR] [FATAL] InnoDB: Semaphore wait has lasted > 600 seconds. We intentionally crash the server because it appears to be hung.

191118  8:54:07 [ERROR] mysqld got signal 6 ;

This could be because you hit a bug. It is also possible that this binary

or one of the libraries it was linked against is corrupt, improperly built,

or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help

diagnose the problem, but since we have already crashed,

something is definitely wrong and this may fail.

Server version: 10.2.15-MariaDB

key_buffer_size=134217728

read_buffer_size=131072

max_used_connections=138

max_threads=2507

thread_count=36

It is possible that mysqld could use up to

key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 5639693 K  bytes of memory

Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0

Attempting backtrace. You can use the following information to find out

where mysqld died. If you see no messages after this, something went

terribly wrong...

stack_bottom = 0x0 thread_stack 0x49000

/usr/sbin/mysqld(my_print_stacktrace+0x2e)[0x55824a75ff9e]

/usr/sbin/mysqld(handle_fatal_signal+0x355)[0x55824a1eba05]

/lib64/libpthread.so.0(+0xf5e0)[0x7f9f5212d5e0]

/lib64/libc.so.6(gsignal+0x37)[0x7f9f5063a1f7]

/lib64/libc.so.6(abort+0x148)[0x7f9f5063b8e8]

/usr/sbin/mysqld(+0x9a7a73)[0x55824a525a73]

/usr/sbin/mysqld(+0x954ff7)[0x55824a4d2ff7]

/lib64/libpthread.so.0(+0x7e25)[0x7f9f52125e25]

/lib64/libc.so.6(clone+0x6d)[0x7f9f506fd34d]

The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains

information that should help you find out what is causing the crash.

2019-11-18  8:54:33 140319486716032 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2019-11-18  8:54:33 140319486716032 [Note] InnoDB: Uses event mutexes

2019-11-18  8:54:33 140319486716032 [Note] InnoDB: Compressed tables use zlib 1.2.7

2019-11-18  8:54:33 140319486716032 [Note] InnoDB: Using Linux native AIO

2019-11-18  8:54:33 140319486716032 [Note] InnoDB: Number of pools: 1

2019-11-18  8:54:33 140319486716032 [Note] InnoDB: Using SSE2 crc32 instructions

2019-11-18  8:54:33 140319486716032 [Note] InnoDB: Initializing buffer pool, total size = 144G, instances = 64, chunk size = 128M

2019-11-18  8:54:43 140319486716032 [Note] InnoDB: Completed initialization of buffer pool

2019-11-18  8:54:45 140151671248640 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2019-11-18  8:54:45 140319486716032 [Note] InnoDB: Highest supported file format is Barracuda.

2019-11-18  8:54:47 140319486716032 [Note] InnoDB: Starting crash recovery from checkpoint LSN=123686452084648

2019-11-18  8:54:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123666746720768

2019-11-18  8:55:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123667392578048

2019-11-18  8:55:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123668031750656

2019-11-18  8:55:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123668676952576

2019-11-18  8:55:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123669316321792

2019-11-18  8:56:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123669987344896

2019-11-18  8:56:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123670659219968

2019-11-18  8:56:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123671297540608

2019-11-18  8:56:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123671927800320

2019-11-18  8:57:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123672564613632

2019-11-18  8:57:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123673130451456

2019-11-18  8:57:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123673654542848

2019-11-18  8:57:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123674199802368

2019-11-18  8:58:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123674741260800

2019-11-18  8:58:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123675260502528

2019-11-18  8:58:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123675796324864

2019-11-18  8:58:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123676318056960

2019-11-18  8:59:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123676834087424

2019-11-18  8:59:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123677359292928

2019-11-18  8:59:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123677824401920

2019-11-18  8:59:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123678273913344

2019-11-18  9:00:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123678723359232

2019-11-18  9:00:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123679154323968

2019-11-18  9:00:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123679567987200

2019-11-18  9:00:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123680011207168

2019-11-18  9:01:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123680452985344

2019-11-18  9:01:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123680891093504

2019-11-18  9:01:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123681314128384

2019-11-18  9:01:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123681755447808

2019-11-18  9:02:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123682197291520

2019-11-18  9:02:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123682643591680

2019-11-18  9:02:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123683121152512

2019-11-18  9:02:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123683531211264

2019-11-18  9:03:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123684056613376

2019-11-18  9:03:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123684562878976

2019-11-18  9:03:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123685008785920

2019-11-18  9:03:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123685441716736

2019-11-18  9:04:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123685853348352

2019-11-18  9:04:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123686238306816

2019-11-18  9:04:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123686647120384

2019-11-18  9:04:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123687156793856

2019-11-18  9:05:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123687779058176

2019-11-18  9:05:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123688427799040

2019-11-18  9:05:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123689089909248

2019-11-18  9:05:59 140319486716032 [Note] InnoDB: Read redo log up to LSN=123689764733440

2019-11-18  9:06:14 140319486716032 [Note] InnoDB: Read redo log up to LSN=123690432741888

2019-11-18  9:06:29 140319486716032 [Note] InnoDB: Read redo log up to LSN=123691113267712

2019-11-18  9:06:44 140319486716032 [Note] InnoDB: Read redo log up to LSN=123691798643200

2019-11-18  9:06:59 140319486716032 [Note] InnoDB: To recover: 1400082 pages from log

2019-11-18  9:07:14 140319486716032 [Note] InnoDB: To recover: 1399786 pages from log

2019-11-18  9:07:29 140319486716032 [Note] InnoDB: To recover: 1399488 pages from log

2019-11-18  9:07:37 140319486716032 [Note] InnoDB: 7 transaction(s) which must be rolled back or cleaned up in total 6 row operations to undo

2019-11-18  9:07:37 140319486716032 [Note] InnoDB: Trx id counter is 67166278400

2019-11-18  9:07:37 140319486716032 [Note] InnoDB: Starting final batch to recover 1399327 pages from redo log.

2019-11-18  9:07:44 140151990171392 [Note] InnoDB: To recover: 1355738 pages from log

2019-11-18  9:07:59 140152174810880 [Note] InnoDB: To recover: 1239097 pages from log

2019-11-18  9:08:14 140152116061952 [Note] InnoDB: To recover: 1096783 pages from log

2019-11-18  9:08:29 140152032134912 [Note] InnoDB: To recover: 969256 pages from log

2019-11-18  9:08:44 140152107669248 [Note] InnoDB: To recover: 879424 pages from log

2019-11-18  9:08:59 140152149632768 [Note] InnoDB: To recover: 789394 pages from log

2019-11-18  9:09:14 140152116061952 [Note] InnoDB: To recover: 659659 pages from log

2019-11-18  9:09:29 140151956600576 [Note] InnoDB: To recover: 558816 pages from log

2019-11-18  9:09:44 140152099276544 [Note] InnoDB: To recover: 468811 pages from log

2019-11-18  9:09:59 140152006956800 [Note] InnoDB: To recover: 368592 pages from log

2019-11-18  9:10:14 140152199988992 [Note] InnoDB: To recover: 285262 pages from log

2019-11-18  9:10:29 140152191596288 [Note] InnoDB: To recover: 184779 pages from log

2019-11-18  9:10:44 140152141240064 [Note] InnoDB: To recover: 106142 pages from log

2019-11-18  9:10:59 140152006956800 [Note] InnoDB: To recover: 11098 pages from log

2019-11-18  9:11:18 140319486716032 [Note] InnoDB: 128 out of 128 rollback segments are active.

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Starting in background the rollback of recovered transactions

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: To roll back: 7 transactions, 6 rows

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Rolled back recovered transaction 67166278063

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Rolled back recovered transaction 67166278062

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Rolled back recovered transaction 67166278061

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Rolled back recovered transaction 67166278052

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Rolled back recovered transaction 67164985040

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Rolled back recovered transaction 67151659109

2019-11-18  9:11:18 140319486716032 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"

2019-11-18  9:11:18 140319486716032 [Note] InnoDB: Creating shared tablespace for temporary tables

2019-11-18  9:11:18 140319486716032 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2019-11-18  9:11:18 140319486716032 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Rolled back recovered transaction 67151642012

2019-11-18  9:11:18 140147047782144 [Note] InnoDB: Rollback of non-prepared transactions completed

2019-11-18  9:11:18 140319486716032 [Note] InnoDB: 5.7.22 started; log sequence number 123692136544372

2019-11-18  9:11:18 140155745097472 [Note] InnoDB: Loading buffer pool(s) from /u01/mysql/ib_buffer_pool

2019-11-18  9:11:18 140319486716032 [Note] Plugin 'FEEDBACK' is disabled.

191118  9:11:18 server_audit: MariaDB Audit Plugin version 1.4.4 STARTED.

191118  9:11:18 server_audit: logging started to the file server_audit.log.

2019-11-18  9:11:18 140319486716032 [Note] Recovering after a crash using tc.log

2019-11-18  9:11:18 140319486716032 [Note] Starting crash recovery...

2019-11-18  9:11:18 140319486716032 [Note] Crash recovery finished.

2019-11-18  9:11:18 140319486716032 [Note] Server socket created on IP: '::'.

2019-11-18  9:11:20 140319486716032 [Note] Reading of all Master_info entries succeded

2019-11-18  9:11:20 140319486716032 [Note] Added new Master_info '' to hash table

2019-11-18  9:11:20 140319486716032 [Note] /usr/sbin/mysqld: ready for connections.

Version: '10.2.15-MariaDB'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MariaDB Server

2019-11-18  9:11:51 140155727705856 [Warning] IP address  could not be resolved: Name or service not known

2019-11-18  9:12:17 140155724977920 [Warning] Access denied for user  (using password: YES)

2019-11-18  9:16:43 140155723765504 [Warning] IP address  could not be resolved: Name or service not known

2019-11-18  9:32:53 140155368978176 [Warning] Access denied for user  (using password: NO)

2019-11-18  9:35:02 140155368675072 [Warning] Access denied for user  (using password: NO)