API tools faq
paste
Guest User

mysql_status

a guest
Dec 16th, 2011
335
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.28 KB | None | 0 0
raw download clone embed print report
  1. Variable_name Value
  2. Aborted_clients 129
  3. Aborted_connects 4
  4. Binlog_cache_disk_use 0
  5. Binlog_cache_use 0
  6. Compression OFF
  7. Connections 5925
  8. Created_tmp_disk_tables 0
  9. Created_tmp_files 5
  10. Created_tmp_tables 0
  11. Delayed_errors 0
  12. Delayed_insert_threads 0
  13. Delayed_writes 0
  14. Flush_commands 4
  15. Handler_commit 0
  16. Handler_delete 0
  17. Handler_discover 0
  18. Handler_prepare 0
  19. Handler_read_first 0
  20. Handler_read_key 0
  21. Handler_read_next 0
  22. Handler_read_prev 0
  23. Handler_read_rnd 0
  24. Handler_read_rnd_next 0
  25. Handler_rollback 0
  26. Handler_savepoint 0
  27. Handler_write 0
  28. Innodb_buffer_pool_pages_data 60353
  29. Innodb_buffer_pool_pages_dirty 3331
  30. Innodb_buffer_pool_pages_flushed 44809
  31. Innodb_buffer_pool_pages_free 0
  32. Innodb_buffer_pool_pages_misc 5183
  33. Innodb_buffer_pool_pages_total 65536
  34. Innodb_buffer_pool_read_ahead_rnd 315089
  35. Innodb_buffer_pool_read_ahead_seq 109507
  36. Innodb_buffer_pool_read_requests 4562160685
  37. Innodb_buffer_pool_reads 4815836
  38. Innodb_buffer_pool_wait_free 0
  39. Innodb_buffer_pool_write_requests 14753352
  40. Innodb_data_fsyncs 3736
  41. Innodb_data_pending_fsyncs 0
  42. Innodb_data_pending_reads 0
  43. Innodb_data_pending_writes 0
  44. Innodb_data_read 456468320256
  45. Innodb_data_reads 8291262
  46. Innodb_data_writes 29747
  47. Innodb_data_written 1961716736
  48. Innodb_dblwr_pages_written 44809
  49. Innodb_dblwr_writes 650
  50. Innodb_log_waits 0
  51. Innodb_log_write_requests 1173429
  52. Innodb_log_writes 2363
  53. Innodb_os_log_fsyncs 1837
  54. Innodb_os_log_pending_fsyncs 0
  55. Innodb_os_log_pending_writes 0
  56. Innodb_os_log_written 493256192
  57. Innodb_page_size 16384
  58. Innodb_pages_created 5763
  59. Innodb_pages_read 27860482
  60. Innodb_pages_written 44809
  61. Innodb_row_lock_current_waits 0
  62. Innodb_row_lock_time 845
  63. Innodb_row_lock_time_avg 105
  64. Innodb_row_lock_time_max 576
  65. Innodb_row_lock_waits 8
  66. Innodb_rows_deleted 1881470
  67. Innodb_rows_inserted 364751
  68. Innodb_rows_read 4524388992
  69. Innodb_rows_updated 313077
  70. Key_blocks_not_flushed 0
  71. Key_blocks_unused 214183
  72. Key_blocks_used 400
  73. Key_read_requests 20979
  74. Key_reads 574
  75. Key_write_requests 8071
  76. Key_writes 1669
  77. Last_query_cost 0.000000
  78. Max_used_connections 159
  79. Not_flushed_delayed_rows 0
  80. Open_files 15
  81. Open_streams 0
  82. Open_table_definitions 92
  83. Open_tables 205
  84. Opened_files 110498
  85. Opened_table_definitions 0
  86. Opened_tables 0
  87. Prepared_stmt_count 0
  88. Qcache_free_blocks 13661
  89. Qcache_free_memory 31514048
  90. Qcache_hits 30943
  91. Qcache_inserts 134175
  92. Qcache_lowmem_prunes 0
  93. Qcache_not_cached 30832
  94. Qcache_queries_in_cache 10959
  95. Qcache_total_blocks 35629
  96. Queries 661970
  97. Questions 2
  98. Rpl_status NULL
  99. Select_full_join 0
  100. Select_full_range_join 0
  101. Select_range 0
  102. Select_range_check 0
  103. Select_scan 0
  104. Slave_open_temp_tables 0
  105. Slave_retried_transactions 0
  106. Table_locks_immediate 516453
  107. Table_locks_waited 0
  108. Tc_log_max_pages_used 0
  109. Tc_log_page_size 0
  110. Tc_log_page_waits 0
  111. Threads_cached 35
  112. Threads_connected 124
  113. Threads_created 159
  114. Threads_running 1
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!