Pastebin
API
tools
faq
paste
Login
Sign up
Please fix the following errors:
New Paste
Syntax Highlighting
*************************** 1. row *************************** now(): 2014-07-21 04:06:01 *************************** 1. row *************************** Id: 2336222 User: dlh Host: DLH03:35538 db: dlhbe Command: Sleep Time: 4 State: Info: NULL *************************** 2. row *************************** Id: 2337424 User: dlh Host: dlh-vip:54202 db: dlhbe Command: Sleep Time: 9 State: Info: NULL *************************** 3. row *************************** Id: 3749630 User: repl Host: DLH03:38959 db: NULL Command: Binlog Dump Time: 1929524 State: Master has sent all binlog to slave; waiting for binlog to be updated Info: NULL *************************** 4. row *************************** Id: 6149757 User: dlh Host: dlh-vip:50788 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 5. row *************************** Id: 6152220 User: dlh Host: DLH03:39252 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 6. row *************************** Id: 6152552 User: dlh Host: dlh-vip:59600 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 7. row *************************** Id: 6153654 User: dlh Host: DLH03:42901 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 8. row *************************** Id: 6153956 User: dlh Host: DLH03:43325 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 9. row *************************** Id: 6153959 User: dlh Host: DLH03:43331 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 10. row *************************** Id: 6154058 User: dlh Host: dlh-vip:36630 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 11. row *************************** Id: 6154184 User: dlh Host: DLH03:43794 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 12. row *************************** Id: 6154213 User: dlh Host: DLH03:43803 db: dlhbe Command: Query Time: 54 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 13. row *************************** Id: 6154235 User: dlh Host: dlh-vip:36998 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 14. row *************************** Id: 6154239 User: dlh Host: dlh-vip:37003 db: dlhbe Command: Query Time: 54 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 15. row *************************** Id: 6154242 User: dlh Host: dlh-vip:37007 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 16. row *************************** Id: 6154246 User: dlh Host: dlh-vip:37010 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 17. row *************************** Id: 6154247 User: dlh Host: dlh-vip:37012 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 18. row *************************** Id: 6154250 User: dlh Host: dlh-vip:37016 db: dlhbe Command: Query Time: 54 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 19. row *************************** Id: 6154251 User: dlh Host: dlh-vip:37017 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 20. row *************************** Id: 6154252 User: dlh Host: dlh-vip:37018 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 21. row *************************** Id: 6154265 User: dlh Host: DLH03:43822 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 22. row *************************** Id: 6154269 User: dlh Host: DLH03:43824 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 23. row *************************** Id: 6155315 User: root Host: localhost db: dlhbe Command: Query Time: 1204 State: Sending data Info: SELECT /*!40001 SQL_NO_CACHE */ * FROM `db_external_notification` *************************** 24. row *************************** Id: 6156544 User: dlh Host: DLH03:44437 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 25. row *************************** Id: 6156612 User: dlh Host: dlh-vip:42326 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 26. row *************************** Id: 6158068 User: dlh Host: DLH03:44972 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 27. row *************************** Id: 6158069 User: dlh Host: DLH03:44973 db: dlhbe Command: Query Time: 53 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 28. row *************************** Id: 6158070 User: dlh Host: DLH03:44974 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 29. row *************************** Id: 6158073 User: dlh Host: DLH03:44975 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 30. row *************************** Id: 6158074 User: dlh Host: DLH03:44976 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 31. row *************************** Id: 6158075 User: dlh Host: DLH03:44977 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 32. row *************************** Id: 6158076 User: dlh Host: DLH03:44978 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 33. row *************************** Id: 6158077 User: dlh Host: DLH03:44979 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 34. row *************************** Id: 6158078 User: dlh Host: dlh-vip:45727 db: dlhbe Command: Query Time: 51 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 35. row *************************** Id: 6158079 User: dlh Host: dlh-vip:45728 db: dlhbe Command: Query Time: 0 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 36. row *************************** Id: 6158080 User: dlh Host: DLH03:44980 db: dlhbe Command: Query Time: 1 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 37. row *************************** Id: 6158081 User: dlh Host: dlh-vip:45729 db: dlhbe Command: Sleep Time: 27 State: Info: NULL *************************** 38. row *************************** Id: 6158082 User: dlh Host: dlh-vip:45730 db: dlhbe Command: Query Time: 0 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 39. row *************************** Id: 6158083 User: dlh Host: dlh-vip:45731 db: dlhbe Command: Query Time: 0 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 40. row *************************** Id: 6158087 User: dlh Host: DLH03:44986 db: dlhbe Command: Query Time: 1 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 41. row *************************** Id: 6158089 User: dlh Host: dlh-vip:45742 db: dlhbe Command: Sleep Time: 27 State: Info: NULL *************************** 42. row *************************** Id: 6158090 User: dlh Host: dlh-vip:45743 db: dlhbe Command: Query Time: 0 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 43. row *************************** Id: 6158091 User: dlh Host: dlh-vip:45744 db: dlhbe Command: Sleep Time: 0 State: Info: NULL *************************** 44. row *************************** Id: 6158092 User: dlh Host: dlh-vip:45745 db: dlhbe Command: Sleep Time: 27 State: Info: NULL *************************** 45. row *************************** Id: 6158093 User: dlh Host: dlh-vip:45746 db: dlhbe Command: Sleep Time: 27 State: Info: NULL *************************** 46. row *************************** Id: 6158094 User: dlh Host: dlh-vip:45747 db: dlhbe Command: Sleep Time: 27 State: Info: NULL *************************** 47. row *************************** Id: 6158095 User: dlh Host: dlh-vip:45748 db: dlhbe Command: Query Time: 0 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 48. row *************************** Id: 6158096 User: dlh Host: dlh-vip:45749 db: dlhbe Command: Sleep Time: 28 State: Info: NULL *************************** 49. row *************************** Id: 6158097 User: dlh Host: dlh-vip:45750 db: dlhbe Command: Sleep Time: 27 State: Info: NULL *************************** 50. row *************************** Id: 6158100 User: dlh Host: DLH03:44990 db: dlhbe Command: Query Time: 0 State: Waiting for table flush Info: insert into db_external_notification (... *************************** 51. row *************************** Id: 6158101 User: root Host: localhost db: NULL Command: Query Time: 0 State: init Info: show full processlist *************************** 1. row *************************** Type: InnoDB Name: Status: ===================================== 2014-07-21 04:06:01 861e4b70 INNODB MONITOR OUTPUT ===================================== Per second averages calculated from the last 60 seconds ----------------- BACKGROUND THREAD ----------------- srv_master_thread loops: 3456521 srv_active, 0 srv_shutdown, 1196243 srv_idle srv_master_thread log flush and writes: 4652764 ---------- SEMAPHORES ---------- OS WAIT ARRAY INFO: reservation count 49923667 OS WAIT ARRAY INFO: signal count 63709458 Mutex spin waits 154026294, rounds 667509484, OS waits 11940078 RW-shared spins 49738202, rounds 1094105577, OS waits 29201229 RW-excl spins 17827968, rounds 400775195, OS waits 7537888 Spin rounds per wait: 4.33 mutex, 22.00 RW-shared, 22.48 RW-excl ------------------------ LATEST DETECTED DEADLOCK ------------------------ 2014-07-20 11:50:09 85fe8b70 ..... ------------ TRANSACTIONS ------------ Trx id counter 1252628184 Purge done for trx's n:o < 1252538413 undo n:o < 0 state: running but idle History list length 25142 LIST OF TRANSACTIONS FOR EACH SESSION: ---TRANSACTION 0, not started MySQL thread id 6158101, OS thread handle 0x861e4b70, query id 368090598 localhost root init show engine innodb status ---TRANSACTION 1252626917, not started MySQL thread id 6158097, OS thread handle 0x8509db70, query id 368065640 dlh-vip 80.77.222.224 dlh cleaning up ---TRANSACTION 1252626903, not started MySQL thread id 6158093, OS thread handle 0x85874b70, query id 368064072 dlh-vip 80.77.222.224 dlh cleaning up ---TRANSACTION 1252628121, not started MySQL thread id 6158095, OS thread handle 0x84eceb70, query id 368088537 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626916, not started MySQL thread id 6158094, OS thread handle 0x8607bb70, query id 368065519 dlh-vip 80.77.222.224 dlh cleaning up ---TRANSACTION 1252626922, not started MySQL thread id 6158092, OS thread handle 0x85fb7b70, query id 368065550 dlh-vip 80.77.222.224 dlh cleaning up ---TRANSACTION 1252626947, not started MySQL thread id 6158090, OS thread handle 0x8636cb70, query id 368090479 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626918, not started MySQL thread id 6158089, OS thread handle 0x85c90b70, query id 368065608 dlh-vip 80.77.222.224 dlh cleaning up ---TRANSACTION 1252628080, not started MySQL thread id 6158087, OS thread handle 0x8c9ffb70, query id 368087871 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252628126, not started MySQL thread id 6158083, OS thread handle 0x8599ab70, query id 368088717 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252628082, not started MySQL thread id 6158082, OS thread handle 0x862a8b70, query id 368088333 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626901, not started MySQL thread id 6158081, OS thread handle 0x85cf2b70, query id 368064364 dlh-vip 80.77.222.224 dlh cleaning up ---TRANSACTION 1252628083, not started MySQL thread id 6158080, OS thread handle 0x84e3bb70, query id 368087766 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252628144, not started MySQL thread id 6158079, OS thread handle 0x86277b70, query id 368089342 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626745, not started MySQL thread id 6158078, OS thread handle 0x863ceb70, query id 368055627 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626597, not started MySQL thread id 6158070, OS thread handle 0x85969b70, query id 368054983 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626595, not started MySQL thread id 6158069, OS thread handle 0x85aa2b70, query id 368054560 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626594, not started MySQL thread id 6158068, OS thread handle 0x8540ab70, query id 368054518 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252622576, not started MySQL thread id 6156612, OS thread handle 0x8523bb70, query id 368054464 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626580, not started MySQL thread id 6156544, OS thread handle 0x85f42b70, query id 368054087 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252625043, not started MySQL thread id 6154251, OS thread handle 0x858d6b70, query id 368054016 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252625299, not started MySQL thread id 6154252, OS thread handle 0x860ddb70, query id 368053836 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252619213, not started MySQL thread id 6154269, OS thread handle 0x86019b70, query id 368054387 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626549, not started MySQL thread id 6154265, OS thread handle 0x8546cb70, query id 368054875 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626539, not started MySQL thread id 6154250, OS thread handle 0x8656cb70, query id 368053550 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626714, not started MySQL thread id 6154247, OS thread handle 0x8503bb70, query id 368054813 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626732, not started MySQL thread id 6154246, OS thread handle 0x85d85b70, query id 368055235 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626724, not started MySQL thread id 6154242, OS thread handle 0x85a40b70, query id 368055002 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626534, not started MySQL thread id 6154239, OS thread handle 0x850ffb70, query id 368053665 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626743, not started MySQL thread id 6154235, OS thread handle 0x85cc1b70, query id 368055556 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626552, not started MySQL thread id 6154213, OS thread handle 0x8526cb70, query id 368053610 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252619256, not started MySQL thread id 6154184, OS thread handle 0x850ceb70, query id 368054052 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626722, not started MySQL thread id 6154058, OS thread handle 0x852ceb70, query id 368054928 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626591, not started MySQL thread id 6153959, OS thread handle 0x8506cb70, query id 368054418 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252619241, not started MySQL thread id 6153956, OS thread handle 0x8cd5ab70, query id 368054273 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626553, not started MySQL thread id 6153654, OS thread handle 0x854ffb70, query id 368053962 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252622916, not started MySQL thread id 6152552, OS thread handle 0x8543bb70, query id 368054234 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626587, not started MySQL thread id 6152220, OS thread handle 0x8653bb70, query id 368054304 DLH03 80.77.222.221 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252626744, not started MySQL thread id 6149757, OS thread handle 0x86f99b70, query id 368055585 dlh-vip 80.77.222.224 dlh Waiting for table flush insert into db_external_notification (... ---TRANSACTION 1252628183, ACTIVE 0 sec preparing 11 lock struct(s), heap size 1024, 6 row lock(s), undo log entries 1 MySQL thread id 6158091, OS thread handle 0x85e1cb70, query id 368090599 dlh-vip 80.77.222.224 dlh init commit ---TRANSACTION 1252538404, ACTIVE 3358 sec fetching rows mysql tables in use 1, locked 0 MySQL thread id 6155315, OS thread handle 0x85f11b70, query id 367774810 localhost root Sending data SELECT /*!40001 SQL_NO_CACHE */ * FROM `db_external_notification` Trx read view will not see trx with id >= 1252538405, sees < 1252538391 -------- 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 (write thread) I/O thread 7 state: waiting for completed aio requests (write thread) I/O thread 8 state: waiting for completed aio requests (write thread) I/O thread 9 state: waiting for completed aio requests (write thread) Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] , ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0 Pending flushes (fsync) log: 1; buffer pool: 0 295282936 OS file reads, 473892052 OS file writes, 253451291 OS fsyncs 1 pending preads, 0 pending pwrites 293.18 reads/s, 8204 avg bytes/read, 62.32 writes/s, 38.78 fsyncs/s ------------------------------------- INSERT BUFFER AND ADAPTIVE HASH INDEX ------------------------------------- Ibuf: size 1, free list len 14072, seg size 14074, 11592456 merges merged operations: insert 12336707, delete mark 274853607, delete 28754017 discarded operations: insert 0, delete mark 0, delete 0 Hash table size 6225619, node heap has 167 buffer(s) 2606.47 hash searches/s, 1299.91 non-hash searches/s --- LOG --- Log sequence number 2303987096755 Log flushed up to 2303987096308 Pages flushed up to 2303985880828 Last checkpoint at 2303985880594 1 pending log writes, 0 pending chkp writes 133410571 log i/o's done, 23.85 log i/o's/second ---------------------- BUFFER POOL AND MEMORY ---------------------- Total memory allocated 1593704448; in additional pool allocated 0 Dictionary memory allocated 647018 Buffer pool size 96000 Free buffers 8007 Database pages 142275 Old database pages 52493 Modified db pages 557 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 116941040, not young 2313215399 1.42 youngs/s, 5589.27 non-youngs/s Pages read 295282134, created 5440190, written 312659916 293.18 reads/s, 1.65 creates/s, 33.75 writes/s Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 266 / 1000 Pages read ahead 0.13/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 142275, unzip_LRU len: 14375 I/O sum[128304]:cur[760], unzip sum[127808]:cur[760] ---------------------- INDIVIDUAL BUFFER POOL INFO ---------------------- ---BUFFER POOL 0 Buffer pool size 12000 Free buffers 958 Database pages 17728 Old database pages 6564 Modified db pages 88 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 14883227, not young 1366348819 0.22 youngs/s, 630.92 non-youngs/s Pages read 37128920, created 688829, written 46032172 33.70 reads/s, 0.22 creates/s, 4.90 writes/s Buffer pool hit rate 983 / 1000, young-making rate 0 / 1000 not 334 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 17728, unzip_LRU len: 1818 I/O sum[16038]:cur[95], unzip sum[15976]:cur[95] ---BUFFER POOL 1 Buffer pool size 12000 Free buffers 964 Database pages 17887 Old database pages 6611 Modified db pages 42 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 14832036, not young 1347853892 0.22 youngs/s, 742.89 non-youngs/s Pages read 37132279, created 671555, written 31068421 40.28 reads/s, 0.12 creates/s, 2.25 writes/s Buffer pool hit rate 986 / 1000, young-making rate 0 / 1000 not 266 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 17887, unzip_LRU len: 1834 I/O sum[16038]:cur[95], unzip sum[15976]:cur[95] ---BUFFER POOL 2 Buffer pool size 12000 Free buffers 1019 Database pages 17735 Old database pages 6530 Modified db pages 34 Pending reads 1 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 14456926, not young 1361677290 0.18 youngs/s, 790.47 non-youngs/s Pages read 37142751, created 694532, written 32566792 39.77 reads/s, 0.13 creates/s, 2.40 writes/s Buffer pool hit rate 989 / 1000, young-making rate 0 / 1000 not 235 / 1000 Pages read ahead 0.13/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 17735, unzip_LRU len: 1785 I/O sum[16038]:cur[95], unzip sum[15976]:cur[95] ---BUFFER POOL 3 Buffer pool size 12000 Free buffers 1024 Database pages 17805 Old database pages 6552 Modified db pages 51 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 14416382, not young 1369851293 0.25 youngs/s, 738.29 non-youngs/s Pages read 37127164, created 652209, written 43677577 37.80 reads/s, 0.62 creates/s, 6.03 writes/s Buffer pool hit rate 987 / 1000, young-making rate 0 / 1000 not 259 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 17805, unzip_LRU len: 1785 I/O sum[16038]:cur[95], unzip sum[15976]:cur[95] ---BUFFER POOL 4 Buffer pool size 12000 Free buffers 1024 Database pages 17775 Old database pages 6544 Modified db pages 124 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 14844262, not young 1383000270 0.10 youngs/s, 644.31 non-youngs/s Pages read 36638089, created 685866, written 53663045 33.98 reads/s, 0.13 creates/s, 8.35 writes/s Buffer pool hit rate 988 / 1000, young-making rate 0 / 1000 not 237 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 17775, unzip_LRU len: 1782 I/O sum[16038]:cur[95], unzip sum[15976]:cur[95] ---BUFFER POOL 5 Buffer pool size 12000 Free buffers 970 Database pages 17722 Old database pages 6560 Modified db pages 88 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 14147801, not young 1327998846 0.08 youngs/s, 692.84 non-youngs/s Pages read 35559278, created 666045, written 36917203 35.68 reads/s, 0.12 creates/s, 4.52 writes/s Buffer pool hit rate 990 / 1000, young-making rate 0 / 1000 not 209 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 17722, unzip_LRU len: 1805 I/O sum[16038]:cur[95], unzip sum[15976]:cur[95] ---BUFFER POOL 6 Buffer pool size 12000 Free buffers 1024 Database pages 17740 Old database pages 6537 Modified db pages 71 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 15062149, not young 1413480455 0.27 youngs/s, 730.74 non-youngs/s Pages read 37952905, created 677723, written 33215113 39.43 reads/s, 0.23 creates/s, 2.83 writes/s Buffer pool hit rate 985 / 1000, young-making rate 0 / 1000 not 291 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 17740, unzip_LRU len: 1776 I/O sum[16038]:cur[95], unzip sum[15976]:cur[95] ---BUFFER POOL 7 Buffer pool size 12000 Free buffers 1024 Database pages 17883 Old database pages 6595 Modified db pages 59 Pending reads 0 Pending writes: LRU 0, flush list 0, single page 0 Pages made young 14298257, not young 1332939126 0.10 youngs/s, 618.82 non-youngs/s Pages read 36600748, created 703431, written 35519593 32.53 reads/s, 0.08 creates/s, 2.47 writes/s Buffer pool hit rate 980 / 1000, young-making rate 0 / 1000 not 396 / 1000 Pages read ahead 0.00/s, evicted without access 0.00/s, Random read ahead 0.00/s LRU len: 17883, unzip_LRU len: 1790 I/O sum[16038]:cur[95], unzip sum[15976]:cur[95] -------------- ROW OPERATIONS -------------- 0 queries inside InnoDB, 0 queries in queue 1 read views open inside InnoDB Main thread process no. 10583, id 2329414512, state: sleeping Number of rows inserted 463254282, updated 120516095, deleted 228648646, read 733055259 97.83 inserts/s, 13.82 updates/s, 9.83 deletes/s, 6805.20 reads/s ---------------------------- END OF INNODB MONITOR OUTPUT ============================
Optional Paste Settings
Category:
None
Cryptocurrency
Cybersecurity
Fixit
Food
Gaming
Haiku
Help
History
Housing
Jokes
Legal
Money
Movies
Music
Pets
Photo
Science
Software
Source Code
Spirit
Sports
Travel
TV
Writing
Tags:
Syntax Highlighting:
None
Bash
C
C#
C++
CSS
HTML
JSON
Java
JavaScript
Lua
Markdown (PRO members only)
Objective C
PHP
Perl
Python
Ruby
Swift
4CS
6502 ACME Cross Assembler
6502 Kick Assembler
6502 TASM/64TASS
ABAP
AIMMS
ALGOL 68
APT Sources
ARM
ASM (NASM)
ASP
ActionScript
ActionScript 3
Ada
Apache Log
AppleScript
Arduino
Asymptote
AutoIt
Autohotkey
Avisynth
Awk
BASCOM AVR
BNF
BOO
Bash
Basic4GL
Batch
BibTeX
Blitz Basic
Blitz3D
BlitzMax
BrainFuck
C
C (WinAPI)
C Intermediate Language
C for Macs
C#
C++
C++ (WinAPI)
C++ (with Qt extensions)
C: Loadrunner
CAD DCL
CAD Lisp
CFDG
CMake
COBOL
CSS
Ceylon
ChaiScript
Chapel
Clojure
Clone C
Clone C++
CoffeeScript
ColdFusion
Cuesheet
D
DCL
DCPU-16
DCS
DIV
DOT
Dart
Delphi
Delphi Prism (Oxygene)
Diff
E
ECMAScript
EPC
Easytrieve
Eiffel
Email
Erlang
Euphoria
F#
FO Language
Falcon
Filemaker
Formula One
Fortran
FreeBasic
FreeSWITCH
GAMBAS
GDB
GDScript
Game Maker
Genero
Genie
GetText
Go
Godot GLSL
Groovy
GwBasic
HQ9 Plus
HTML
HTML 5
Haskell
Haxe
HicEst
IDL
INI file
INTERCAL
IO
ISPF Panel Definition
Icon
Inno Script
J
JCL
JSON
Java
Java 5
JavaScript
Julia
KSP (Kontakt Script)
KiXtart
Kotlin
LDIF
LLVM
LOL Code
LScript
Latex
Liberty BASIC
Linden Scripting
Lisp
Loco Basic
Logtalk
Lotus Formulas
Lotus Script
Lua
M68000 Assembler
MIX Assembler
MK-61/52
MPASM
MXML
MagikSF
Make
MapBasic
Markdown (PRO members only)
MatLab
Mercury
MetaPost
Modula 2
Modula 3
Motorola 68000 HiSoft Dev
MySQL
Nagios
NetRexx
Nginx
Nim
NullSoft Installer
OCaml
OCaml Brief
Oberon 2
Objeck Programming Langua
Objective C
Octave
Open Object Rexx
OpenBSD PACKET FILTER
OpenGL Shading
Openoffice BASIC
Oracle 11
Oracle 8
Oz
PARI/GP
PCRE
PHP
PHP Brief
PL/I
PL/SQL
POV-Ray
ParaSail
Pascal
Pawn
Per
Perl
Perl 6
Phix
Pic 16
Pike
Pixel Bender
PostScript
PostgreSQL
PowerBuilder
PowerShell
ProFTPd
Progress
Prolog
Properties
ProvideX
Puppet
PureBasic
PyCon
Python
Python for S60
QBasic
QML
R
RBScript
REBOL
REG
RPM Spec
Racket
Rails
Rexx
Robots
Roff Manpage
Ruby
Ruby Gnuplot
Rust
SAS
SCL
SPARK
SPARQL
SQF
SQL
SSH Config
Scala
Scheme
Scilab
SdlBasic
Smalltalk
Smarty
StandardML
StoneScript
SuperCollider
Swift
SystemVerilog
T-SQL
TCL
TeXgraph
Tera Term
TypeScript
TypoScript
UPC
Unicon
UnrealScript
Urbi
VB.NET
VBScript
VHDL
VIM
Vala
Vedit
VeriLog
Visual Pro Log
VisualBasic
VisualFoxPro
WHOIS
WhiteSpace
Winbatch
XBasic
XML
XPP
Xojo
Xorg Config
YAML
YARA
Z80 Assembler
ZXBasic
autoconf
jQuery
mIRC
newLISP
q/kdb+
thinBasic
Paste Expiration:
Never
Burn after read
10 Minutes
1 Hour
1 Day
1 Week
2 Weeks
1 Month
6 Months
1 Year
Paste Exposure:
Public
Unlisted
Private
Folder:
(members only)
Password
NEW
Enabled
Disabled
Burn after read
NEW
Paste Name / Title:
Create New Paste
Hello
Guest
Sign Up
or
Login
Sign in with Facebook
Sign in with Twitter
Sign in with Google
You are currently not logged in, this means you can not edit or delete anything you paste.
Sign Up
or
Login
Public Pastes
Crypto admin access
30 min ago | 0.43 KB
Documents
30 min ago | 0.43 KB
+12,000$ in 2 days
CSS | 31 min ago | 0.72 KB
Free Crypto Method
CSS | 31 min ago | 0.72 KB
CC:T GPS Beacon
10 hours ago | 0.49 KB
R4 Moon SPI Screen With Wifi
Arduino | 13 hours ago | 13.55 KB
Art school
1 day ago | 1.06 KB
Untitled
1 day ago | 6.00 KB
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the
Cookies Policy
.
OK, I Understand
Not a member of Pastebin yet?
Sign Up
, it unlocks many cool features!
