Advertisement
Guest User

Untitled

a guest
Nov 2nd, 2011
110
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. mysql> show engine innodb status\G
  2. *************************** 1. row ***************************
  3. Type: InnoDB
  4. Name:
  5. Status:
  6. =====================================
  7. 111102 11:56:17 INNODB MONITOR OUTPUT
  8. =====================================
  9. Per second averages calculated from the last 45 seconds
  10. -----------------
  11. BACKGROUND THREAD
  12. -----------------
  13. srv_master_thread loops: 1 1_second, 1 sleeps, 0 10_second, 1 background, 1 flush
  14. srv_master_thread log flush and writes: 1
  15. ----------
  16. SEMAPHORES
  17. ----------
  18. OS WAIT ARRAY INFO: reservation count 3, signal count 3
  19. Mutex spin waits 2, rounds 30, OS waits 1
  20. RW-shared spins 2, rounds 60, OS waits 2
  21. RW-excl spins 0, rounds 0, OS waits 0
  22. Spin rounds per wait: 15.00 mutex, 30.00 RW-shared, 0.00 RW-excl
  23. ------------
  24. TRANSACTIONS
  25. ------------
  26. Trx id counter 700
  27. Purge done for trx's n:o < 0 undo n:o < 0
  28. History list length 0
  29. LIST OF TRANSACTIONS FOR EACH SESSION:
  30. ---TRANSACTION 0, not started
  31. MySQL thread id 3, query id 2 localhost root
  32. show engine innodb status
  33. --------
  34. FILE I/O
  35. --------
  36. I/O thread 0 state: waiting for i/o request (insert buffer thread)
  37. I/O thread 1 state: waiting for i/o request (log thread)
  38. I/O thread 2 state: waiting for i/o request (read thread)
  39. I/O thread 3 state: waiting for i/o request (read thread)
  40. I/O thread 4 state: waiting for i/o request (read thread)
  41. I/O thread 5 state: waiting for i/o request (read thread)
  42. I/O thread 6 state: waiting for i/o request (write thread)
  43. I/O thread 7 state: waiting for i/o request (write thread)
  44. I/O thread 8 state: waiting for i/o request (write thread)
  45. I/O thread 9 state: waiting for i/o request (write thread)
  46. Pending normal aio reads: 0 [0, 0, 0, 0] , aio writes: 0 [0, 0, 0, 0] ,
  47. ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  48. Pending flushes (fsync) log: 0; buffer pool: 0
  49. 156 OS file reads, 3 OS file writes, 3 OS fsyncs
  50. 0.00 reads/s, 0 avg bytes/read, 0.00 writes/s, 0.00 fsyncs/s
  51. -------------------------------------
  52. INSERT BUFFER AND ADAPTIVE HASH INDEX
  53. -------------------------------------
  54. Ibuf: size 1, free list len 0, seg size 2, 0 merges
  55. merged operations:
  56. insert 0, delete mark 0, delete 0
  57. discarded operations:
  58. insert 0, delete mark 0, delete 0
  59. Hash table size 34679, node heap has 0 buffer(s)
  60. 0.00 hash searches/s, 0.00 non-hash searches/s
  61. ---
  62. LOG
  63. ---
  64. Log sequence number 1609676
  65. Log flushed up to 1609676
  66. Last checkpoint at 1609676
  67. 0 pending log writes, 0 pending chkp writes
  68. 8 log i/o's done, 0.00 log i/o's/second
  69. ----------------------
  70. BUFFER POOL AND MEMORY
  71. ----------------------
  72. Total memory allocated 17170432; in additional pool allocated 0
  73. Dictionary memory allocated 33650
  74. Buffer pool size 1024
  75. Free buffers 879
  76. Database pages 145
  77. Old database pages 0
  78. Modified db pages 0
  79. Pending reads 0
  80. Pending writes: LRU 0, flush list 0, single page 0
  81. Pages made young 0, not young 0
  82. 0.00 youngs/s, 0.00 non-youngs/s
  83. Pages read 145, created 0, written 0
  84. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  85. No buffer pool page gets since the last printout
  86. Pages read ahead 0.00/s, evicted without access 0.00/s
  87. LRU len: 145, unzip_LRU len: 0
  88. I/O sum[0]:cur[0], unzip sum[0]:cur[0]
  89. --------------
  90. ROW OPERATIONS
  91. --------------
  92. 0 queries inside InnoDB, 0 queries in queue
  93. 1 read views open inside InnoDB
  94. Main thread process no. 17344, id 139725114775296, state: waiting for server activity
  95. Number of rows inserted 0, updated 0, deleted 0, read 0
  96. 0.00 inserts/s, 0.00 updates/s, 0.00 deletes/s, 0.00 reads/s
  97. ----------------------------
  98. END OF INNODB MONITOR OUTPUT
  99. ============================
  100.  
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement