Pastebin launched a little side project called VERYVIRAL.com, check it out ;-) Want more features on Pastebin? Sign Up, it's FREE!
Guest

csaba

By: a guest on Apr 30th, 2009  |  syntax: None  |  size: 8.83 KB  |  views: 137  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. mysql> show status where value is not NULL and value > 0;
  2. +-----------------------------------+-------------+
  3. | Variable_name                     | Value       |
  4. +-----------------------------------+-------------+
  5. | Aborted_clients                   | 18          |
  6. | Aborted_connects                  | 8           |
  7. | Binlog_cache_use                  | 1           |
  8. | Bytes_received                    | 153         |
  9. | Bytes_sent                        | 158         |
  10. | Com_select                        | 1           |
  11. | Com_show_status                   | 1           |
  12. | Connections                       | 373919      |
  13. | Created_tmp_files                 | 5           |
  14. | Flush_commands                    | 1           |
  15. | Innodb_buffer_pool_pages_data     | 57368       |
  16. | Innodb_buffer_pool_pages_dirty    | 34          |
  17. | Innodb_buffer_pool_pages_flushed  | 781370      |
  18. | Innodb_buffer_pool_pages_free     | 71386       |
  19. | Innodb_buffer_pool_pages_misc     | 2317        |
  20. | Innodb_buffer_pool_pages_total    | 131071      |
  21. | Innodb_buffer_pool_read_ahead_rnd | 107         |
  22. | Innodb_buffer_pool_read_ahead_seq | 518         |
  23. | Innodb_buffer_pool_read_requests  | 4654468237  |
  24. | Innodb_buffer_pool_reads          | 38518       |
  25. | Innodb_buffer_pool_write_requests | 11064471    |
  26. | Innodb_data_fsyncs                | 307243      |
  27. | Innodb_data_read                  | 891424768   |
  28. | Innodb_data_reads                 | 45190       |
  29. | Innodb_data_writes                | 807464      |
  30. | Innodb_data_written               | 26130312704 |
  31. | Innodb_dblwr_pages_written        | 781370      |
  32. | Innodb_dblwr_writes               | 25601       |
  33. | Innodb_log_write_requests         | 991206      |
  34. | Innodb_log_writes                 | 143626      |
  35. | Innodb_os_log_fsyncs              | 156239      |
  36. | Innodb_os_log_written             | 519873536   |
  37. | Innodb_page_size                  | 16384       |
  38. | Innodb_pages_created              | 3094        |
  39. | Innodb_pages_read                 | 54275       |
  40. | Innodb_pages_written              | 781370      |
  41. | Innodb_row_lock_time              | 1641        |
  42. | Innodb_row_lock_time_avg          | 38          |
  43. | Innodb_row_lock_time_max          | 404         |
  44. | Innodb_row_lock_waits             | 43          |
  45. | Innodb_rows_deleted               | 113069      |
  46. | Innodb_rows_inserted              | 245552      |
  47. | Innodb_rows_read                  | 5731965165  |
  48. | Innodb_rows_updated               | 632014      |
  49. | Key_blocks_unused                 | 319655      |
  50. | Key_blocks_used                   | 17899       |
  51. | Key_read_requests                 | 72524430    |
  52. | Key_reads                         | 280913      |
  53. | Key_write_requests                | 27574424    |
  54. | Key_writes                        | 72290       |
  55. | Max_used_connections              | 28          |
  56. | Open_files                        | 43          |
  57. | Open_table_definitions            | 149         |
  58. | Open_tables                       | 64          |
  59. | Opened_files                      | 507064      |
  60. | Qcache_free_blocks                | 2124        |
  61. | Qcache_free_memory                | 18190568    |
  62. | Qcache_hits                       | 2727723     |
  63. | Qcache_inserts                    | 1971639     |
  64. | Qcache_lowmem_prunes              | 118446      |
  65. | Qcache_not_cached                 | 289771      |
  66. | Qcache_queries_in_cache           | 6462        |
  67. | Qcache_total_blocks               | 15291       |
  68. | Queries                           | 8617082     |
  69. | Questions                         | 2           |
  70. | Table_locks_immediate             | 5989091     |
  71. | Table_locks_waited                | 1450        |
  72. | Threads_cached                    | 6           |
  73. | Threads_connected                 | 3           |
  74. | Threads_created                   | 850         |
  75. | Threads_running                   | 1           |
  76. | Uptime                            | 128596      |
  77. | Uptime_since_flush_status         | 128596      |
  78. +-----------------------------------+-------------+
  79.  
  80. mysql> show engine innodb status;
  81.  
  82. | InnoDB |      |
  83. =====================================
  84. 090430 11:01:34 INNODB MONITOR OUTPUT
  85. =====================================
  86. Per second averages calculated from the last 8 seconds
  87. ----------
  88. SEMAPHORES
  89. ----------
  90. OS WAIT ARRAY INFO: reservation count 57120, signal count 391776
  91. Mutex spin waits 10883795, rounds 8917227, OS waits 16784
  92. RW-shared spins 354778, OS waits 17810; RW-excl spins 70483, OS waits 14158
  93. Spin rounds per wait: 0.82 mutex, 4.52 RW-shared, 12.49 RW-excl
  94. --------
  95. FILE I/O
  96. --------
  97. I/O thread 0 state: waiting for i/o request (insert buffer thread)
  98. I/O thread 1 state: waiting for i/o request (log thread)
  99. I/O thread 2 state: waiting for i/o request (read thread)
  100. I/O thread 3 state: waiting for i/o request (read thread)
  101. I/O thread 4 state: waiting for i/o request (read thread)
  102. I/O thread 5 state: waiting for i/o request (read thread)
  103. I/O thread 6 state: waiting for i/o request (read thread)
  104. I/O thread 7 state: waiting for i/o request (read thread)
  105. I/O thread 8 state: waiting for i/o request (read thread)
  106. I/O thread 9 state: waiting for i/o request (read thread)
  107. I/O thread 10 state: waiting for i/o request (read thread)
  108. I/O thread 11 state: waiting for i/o request (read thread)
  109. I/O thread 12 state: waiting for i/o request (read thread)
  110. I/O thread 13 state: waiting for i/o request (read thread)
  111. I/O thread 14 state: waiting for i/o request (read thread)
  112. I/O thread 15 state: waiting for i/o request (read thread)
  113. I/O thread 16 state: waiting for i/o request (read thread)
  114. I/O thread 17 state: waiting for i/o request (read thread)
  115. I/O thread 18 state: waiting for i/o request (write thread)
  116. I/O thread 19 state: waiting for i/o request (write thread)
  117. I/O thread 20 state: waiting for i/o request (write thread)
  118. I/O thread 21 state: waiting for i/o request (write thread)
  119. I/O thread 22 state: waiting for i/o request (write thread)
  120. I/O thread 23 state: waiting for i/o request (write thread)
  121. I/O thread 24 state: waiting for i/o request (write thread)
  122. I/O thread 25 state: waiting for i/o request (write thread)
  123. I/O thread 26 state: waiting for i/o request (write thread)
  124. I/O thread 27 state: waiting for i/o request (write thread)
  125. I/O thread 28 state: waiting for i/o request (write thread)
  126. I/O thread 29 state: waiting for i/o request (write thread)
  127. I/O thread 30 state: waiting for i/o request (write thread)
  128. I/O thread 31 state: waiting for i/o request (write thread)
  129. I/O thread 32 state: waiting for i/o request (write thread)
  130. I/O thread 33 state: waiting for i/o request (write thread)
  131. Pending normal aio reads: 0, aio writes: 0,
  132.  ibuf aio reads: 0, log i/o's: 0, sync i/o's: 0
  133. Pending flushes (fsync) log: 0; buffer pool: 0
  134. 45201 OS file reads, 816322 OS file writes, 310483 OS fsyncs
  135. 0.00 reads/s, 0 avg bytes/read, 0.87 writes/s, 0.87 fsyncs/s
  136. -------------------------------------
  137. INSERT BUFFER AND ADAPTIVE HASH INDEX
  138. -------------------------------------
  139. Ibuf: size 1, free list len 0, seg size 2,
  140. 2039 inserts, 2039 merged recs, 1480 merges
  141. Hash table size 4425293, node heap has 2316 buffer(s)
  142. 710.54 hash searches/s, 636.42 non-hash searches/s
  143. ---
  144. LOG
  145. ---
  146. Log sequence number 1714920054
  147. Log flushed up to   1714919574
  148. Last checkpoint at  1714906765
  149. Max checkpoint age  7782360
  150. Modified age        13289
  151. Checkpoint age      13289
  152. 0 pending log writes, 0 pending chkp writes
  153. 157977 log i/o's done, 0.87 log i/o's/second
  154. ----------------------
  155. BUFFER POOL AND MEMORY
  156. ----------------------
  157. Total memory allocated 2197815296; in additional pool allocated 0
  158. Internal hash tables (constant factor + variable factor)
  159.     Adaptive hash index 73351896        (35402344 + 37949552)
  160.     Page hash           2213656
  161.     Dictionary cache    9462320         (8851984 + 610336)
  162.     File system         118288  (82672 + 35616)
  163.     Lock system         5314152         (5313416 + 736)
  164.     Recovery system     0       (0 + 0)
  165.     Threads             409976  (406936 + 3040)
  166. Dictionary memory allocated 610336
  167. Buffer pool size        131071
  168. Buffer pool size, bytes 2147467264
  169. Free buffers            71361
  170. Database pages          57394
  171. Modified db pages       27
  172. Pending reads 0
  173. Pending writes: LRU 0, flush list 0, single page 0
  174. Pages read 54286, created 3109, written 789675
  175. 0.00 reads/s, 0.00 creates/s, 0.00 writes/s
  176. Buffer pool hit rate 1000 / 1000
  177. LRU len: 57394, unzip_LRU len: 0
  178. I/O sum[260]:cur[0], unzip sum[0]:cur[0]
  179. --------------
  180. ROW OPERATIONS
  181. --------------
  182. 0 queries inside InnoDB, 0 queries in queue
  183. 1 read views open inside InnoDB
  184. Main thread process no. 19805, id 1414224208, state: sleeping
  185. Number of rows inserted 248427, updated 637423, deleted 114195, read 5773482532
  186. 1.25 inserts/s, 3.25 updates/s, 0.00 deletes/s, 5453.07 reads/s
clone this paste RAW Paste Data