Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-21078

MariaDB was crashed with long semaphore wait

    XMLWordPrintable

    Details

      Description

      MariaDB Was crashed and recovered after 15 mins. Not sure what went wrong, can you please help on this. Below is the log entries in mariadb.log

      =====================================
      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)
      

        Attachments

          Activity

            People

            Assignee:
            marko Marko Mäkelä
            Reporter:
            prabha Prabha
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: