Advertisement
Guest User

SHOW Status

a guest
Jan 16th, 2014
791
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.06 KB | None | 0 0
  1. Aborted_clients 203
  2. Aborted_connects 2
  3. Binlog_cache_disk_use 61
  4. Binlog_cache_use 66907
  5. Binlog_stmt_cache_disk_use 0
  6. Binlog_stmt_cache_use 10878376
  7. Bytes_received 1117
  8. Bytes_sent 89891
  9. Com_admin_commands 0
  10. Com_assign_to_keycache 0
  11. Com_alter_db 0
  12. Com_alter_db_upgrade 0
  13. Com_alter_event 0
  14. Com_alter_function 0
  15. Com_alter_procedure 0
  16. Com_alter_server 0
  17. Com_alter_table 0
  18. Com_alter_tablespace 0
  19. Com_analyze 0
  20. Com_begin 0
  21. Com_binlog 0
  22. Com_call_procedure 0
  23. Com_change_db 1
  24. Com_change_master 0
  25. Com_check 0
  26. Com_checksum 0
  27. Com_commit 0
  28. Com_create_db 0
  29. Com_create_event 0
  30. Com_create_function 0
  31. Com_create_index 0
  32. Com_create_procedure 0
  33. Com_create_server 0
  34. Com_create_table 0
  35. Com_create_trigger 0
  36. Com_create_udf 0
  37. Com_create_user 0
  38. Com_create_view 0
  39. Com_dealloc_sql 0
  40. Com_delete 0
  41. Com_delete_multi 0
  42. Com_do 0
  43. Com_drop_db 0
  44. Com_drop_event 0
  45. Com_drop_function 0
  46. Com_drop_index 0
  47. Com_drop_procedure 0
  48. Com_drop_server 0
  49. Com_drop_table 0
  50. Com_drop_trigger 0
  51. Com_drop_user 0
  52. Com_drop_view 0
  53. Com_empty_query 0
  54. Com_execute_sql 0
  55. Com_flush 0
  56. Com_grant 0
  57. Com_ha_close 0
  58. Com_ha_open 0
  59. Com_ha_read 0
  60. Com_help 0
  61. Com_insert 0
  62. Com_insert_select 0
  63. Com_install_plugin 0
  64. Com_kill 0
  65. Com_load 0
  66. Com_lock_tables 0
  67. Com_optimize 0
  68. Com_preload_keys 0
  69. Com_prepare_sql 0
  70. Com_purge 0
  71. Com_purge_before_date 0
  72. Com_release_savepoint 0
  73. Com_rename_table 0
  74. Com_rename_user 0
  75. Com_repair 0
  76. Com_replace 0
  77. Com_replace_select 0
  78. Com_reset 0
  79. Com_resignal 0
  80. Com_revoke 0
  81. Com_revoke_all 0
  82. Com_rollback 0
  83. Com_rollback_to_savepoint 0
  84. Com_savepoint 0
  85. Com_select 4
  86. Com_set_option 4
  87. Com_signal 0
  88. Com_show_authors 0
  89. Com_show_binlog_events 0
  90. Com_show_binlogs 0
  91. Com_show_charsets 0
  92. Com_show_client_statistics 0
  93. Com_show_collations 0
  94. Com_show_contributors 0
  95. Com_show_create_db 0
  96. Com_show_create_event 0
  97. Com_show_create_func 0
  98. Com_show_create_proc 0
  99. Com_show_create_table 0
  100. Com_show_create_trigger 0
  101. Com_show_databases 0
  102. Com_show_engine_logs 0
  103. Com_show_engine_mutex 0
  104. Com_show_engine_status 0
  105. Com_show_events 0
  106. Com_show_errors 0
  107. Com_show_fields 0
  108. Com_show_function_status 0
  109. Com_show_grants 0
  110. Com_show_index_statistics 0
  111. Com_show_keys 0
  112. Com_show_master_status 0
  113. Com_show_open_tables 0
  114. Com_show_plugins 0
  115. Com_show_privileges 0
  116. Com_show_procedure_status 0
  117. Com_show_processlist 0
  118. Com_show_profile 0
  119. Com_show_profiles 0
  120. Com_show_relaylog_events 0
  121. Com_show_slave_hosts 0
  122. Com_show_slave_status 0
  123. Com_show_slave_status_nolock 0
  124. Com_show_status 11
  125. Com_show_storage_engines 0
  126. Com_show_table_statistics 0
  127. Com_show_table_status 0
  128. Com_show_tables 2
  129. Com_show_temporary_tables 0
  130. Com_show_thread_statistics 0
  131. Com_show_triggers 0
  132. Com_show_user_statistics 0
  133. Com_show_variables 0
  134. Com_show_warnings 0
  135. Com_slave_start 0
  136. Com_slave_stop 0
  137. Com_stmt_close 0
  138. Com_stmt_execute 0
  139. Com_stmt_fetch 0
  140. Com_stmt_prepare 0
  141. Com_stmt_reprepare 0
  142. Com_stmt_reset 0
  143. Com_stmt_send_long_data 0
  144. Com_truncate 0
  145. Com_uninstall_plugin 0
  146. Com_unlock_tables 0
  147. Com_update 0
  148. Com_update_multi 0
  149. Com_xa_commit 0
  150. Com_xa_end 0
  151. Com_xa_prepare 0
  152. Com_xa_recover 0
  153. Com_xa_rollback 0
  154. Com_xa_start 0
  155. Compression OFF
  156. Connections 45406
  157. Created_tmp_disk_tables 0
  158. Created_tmp_files 354
  159. Created_tmp_tables 10
  160. Delayed_errors 0
  161. Delayed_insert_threads 0
  162. Delayed_writes 0
  163. Flashcache_enabled OFF
  164. Flush_commands 7
  165. Handler_commit 0
  166. Handler_delete 0
  167. Handler_discover 0
  168. Handler_prepare 0
  169. Handler_read_first 0
  170. Handler_read_key 303
  171. Handler_read_last 0
  172. Handler_read_next 0
  173. Handler_read_prev 0
  174. Handler_read_rnd 47
  175. Handler_read_rnd_next 763
  176. Handler_rollback 0
  177. Handler_savepoint 0
  178. Handler_savepoint_rollback 0
  179. Handler_update 256
  180. Handler_write 757
  181. Key_blocks_not_flushed 4
  182. Key_blocks_unused 729407
  183. Key_blocks_used 128040
  184. Key_read_requests 174435057963
  185. Key_reads 212510
  186. Key_write_requests 465417695
  187. Key_writes 12174517
  188. Last_query_cost 12.499000
  189. Max_used_connections 366
  190. Not_flushed_delayed_rows 0
  191. Open_files 2229
  192. Open_streams 0
  193. Open_table_definitions 51
  194. Open_tables 2192
  195. Opened_files 59600119
  196. Opened_table_definitions 0
  197. Opened_tables 0
  198. Performance_schema_cond_classes_lost 0
  199. Performance_schema_cond_instances_lost 0
  200. Performance_schema_file_classes_lost 0
  201. Performance_schema_file_handles_lost 0
  202. Performance_schema_file_instances_lost 0
  203. Performance_schema_locker_lost 0
  204. Performance_schema_mutex_classes_lost 0
  205. Performance_schema_mutex_instances_lost 0
  206. Performance_schema_rwlock_classes_lost 0
  207. Performance_schema_rwlock_instances_lost 0
  208. Performance_schema_table_handles_lost 0
  209. Performance_schema_table_instances_lost 0
  210. Performance_schema_thread_classes_lost 0
  211. Performance_schema_thread_instances_lost 0
  212. Prepared_stmt_count 0
  213. Qcache_free_blocks 2400
  214. Qcache_free_memory 5336536
  215. Qcache_hits 25303641
  216. Qcache_inserts 16796962
  217. Qcache_lowmem_prunes 16222959
  218. Qcache_not_cached 32857802
  219. Qcache_queries_in_cache 8716
  220. Qcache_total_blocks 62675
  221. Queries 149955145
  222. Questions 22
  223. Rpl_status AUTH_MASTER
  224. Select_full_join 0
  225. Select_full_range_join 0
  226. Select_range 0
  227. Select_range_check 0
  228. Select_scan 6
  229. Slave_heartbeat_period 1800.000
  230. Slave_open_temp_tables 0
  231. Slave_received_heartbeats 0
  232. Slave_retried_transactions 0
  233. Slave_running ON
  234. Slow_launch_threads 0
  235. Slow_queries 4
  236. Sort_merge_passes 0
  237. Sort_range 0
  238. Sort_rows 47
  239. Sort_scan 4
  240. Ssl_accept_renegotiates 0
  241. Ssl_accepts 0
  242. Ssl_callback_cache_hits 0
  243. Ssl_cipher
  244. Ssl_cipher_list
  245. Ssl_client_connects 0
  246. Ssl_connect_renegotiates 0
  247. Ssl_ctx_verify_depth 0
  248. Ssl_ctx_verify_mode 0
  249. Ssl_default_timeout 0
  250. Ssl_finished_accepts 0
  251. Ssl_finished_connects 0
  252. Ssl_session_cache_hits 0
  253. Ssl_session_cache_misses 0
  254. Ssl_session_cache_mode NONE
  255. Ssl_session_cache_overflows 0
  256. Ssl_session_cache_size 0
  257. Ssl_session_cache_timeouts 0
  258. Ssl_sessions_reused 0
  259. Ssl_used_session_cache_entries 0
  260. Ssl_verify_depth 0
  261. Ssl_verify_mode 0
  262. Ssl_version
  263. Table_locks_immediate 329535535
  264. Table_locks_waited 127874
  265. Tc_log_max_pages_used 0
  266. Tc_log_page_size 0
  267. Tc_log_page_waits 0
  268. Threadpool_idle_threads 0
  269. Threadpool_threads 0
  270. Threads_cached 41
  271. Threads_connected 220
  272. Threads_created 439
  273. Threads_running 99
  274. Uptime 518166
  275. Uptime_since_flush_status 518166
  276. binlog_commits 10945283
  277. binlog_group_commits 10945283
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement