Guest User

SHOW GLOBAL STATUS

a guest
Aug 27th, 2015
373
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SHOW GLOBAL STATUS;
  2.  
  3. Variable_name,VALUE
  4. Aborted_clients,451
  5. Aborted_connects,22
  6. Binlog_cache_disk_use,0
  7. Binlog_cache_use,0
  8. Binlog_stmt_cache_disk_use,0
  9. Binlog_stmt_cache_use,0
  10. Bytes_received,287558822593
  11. Bytes_sent,789224435473
  12. Com_admin_commands,954599867
  13. Com_assign_to_keycache,0
  14. Com_alter_db,0
  15. Com_alter_db_upgrade,0
  16. Com_alter_event,0
  17. Com_alter_function,0
  18. Com_alter_procedure,0
  19. Com_alter_server,0
  20. Com_alter_table,0
  21. Com_alter_tablespace,0
  22. Com_alter_user,0
  23. Com_analyze,0
  24. Com_begin,4280090
  25. Com_binlog,0
  26. Com_call_procedure,0
  27. Com_change_db,953574484
  28. Com_change_master,0
  29. Com_check,0
  30. Com_checksum,0
  31. Com_commit,4216540
  32. Com_create_db,0
  33. Com_create_event,0
  34. Com_create_function,0
  35. Com_create_index,0
  36. Com_create_procedure,0
  37. Com_create_server,0
  38. Com_create_table,3
  39. Com_create_trigger,0
  40. Com_create_udf,0
  41. Com_create_user,0
  42. Com_create_view,0
  43. Com_dealloc_sql,0
  44. Com_delete,842
  45. Com_delete_multi,264
  46. Com_do,0
  47. Com_drop_db,0
  48. Com_drop_event,0
  49. Com_drop_function,0
  50. Com_drop_index,0
  51. Com_drop_procedure,0
  52. Com_drop_server,0
  53. Com_drop_table,0
  54. Com_drop_trigger,0
  55. Com_drop_user,0
  56. Com_drop_view,0
  57. Com_empty_query,0
  58. Com_execute_sql,0
  59. Com_flush,0
  60. Com_get_diagnostics,0
  61. Com_grant,0
  62. Com_ha_close,0
  63. Com_ha_open,0
  64. Com_ha_read,0
  65. Com_help,24
  66. Com_insert,30050199
  67. Com_insert_select,251539
  68. Com_install_plugin,0
  69. Com_kill,130
  70. Com_load,0
  71. Com_lock_tables,0
  72. Com_optimize,0
  73. Com_preload_keys,0
  74. Com_prepare_sql,0
  75. Com_purge,0
  76. Com_purge_before_date,0
  77. Com_release_savepoint,0
  78. Com_rename_table,0
  79. Com_rename_user,0
  80. Com_repair,0
  81. Com_replace,0
  82. Com_replace_select,0
  83. Com_reset,0
  84. Com_resignal,0
  85. Com_revoke,0
  86. Com_revoke_all,0
  87. Com_rollback,63532
  88. Com_rollback_to_savepoint,0
  89. Com_savepoint,0
  90. Com_select,771524414
  91. Com_set_option,4318458
  92. Com_signal,0
  93. Com_show_binlog_events,0
  94. Com_show_binlogs,0
  95. Com_show_charsets,0
  96. Com_show_collations,19466
  97. Com_show_create_db,0
  98. Com_show_create_event,0
  99. Com_show_create_func,0
  100. Com_show_create_proc,0
  101. Com_show_create_table,1262
  102. Com_show_create_trigger,0
  103. Com_show_databases,71
  104. Com_show_engine_logs,0
  105. Com_show_engine_mutex,0
  106. Com_show_engine_status,3
  107. Com_show_events,0
  108. Com_show_errors,0
  109. Com_show_fields,6289
  110. Com_show_function_code,0
  111. Com_show_function_status,88
  112. Com_show_grants,1
  113. Com_show_keys,156
  114. Com_show_master_status,0
  115. Com_show_open_tables,710365
  116. Com_show_plugins,6
  117. Com_show_privileges,0
  118. Com_show_procedure_code,0
  119. Com_show_procedure_status,88
  120. Com_show_processlist,710471
  121. Com_show_profile,0
  122. Com_show_profiles,0
  123. Com_show_relaylog_events,0
  124. Com_show_slave_hosts,0
  125. Com_show_slave_status,5
  126. Com_show_status,143761
  127. Com_show_storage_engines,6
  128. Com_show_table_status,1260
  129. Com_show_tables,270
  130. Com_show_triggers,5227
  131. Com_show_variables,19636
  132. Com_show_warnings,10725594
  133. Com_slave_start,0
  134. Com_slave_stop,0
  135. Com_stmt_close,3
  136. Com_stmt_execute,3
  137. Com_stmt_fetch,0
  138. Com_stmt_prepare,3
  139. Com_stmt_reprepare,0
  140. Com_stmt_reset,0
  141. Com_stmt_send_long_data,0
  142. Com_truncate,0
  143. Com_uninstall_plugin,0
  144. Com_unlock_tables,21
  145. Com_update,287315111
  146. Com_update_multi,278
  147. Com_xa_commit,0
  148. Com_xa_end,0
  149. Com_xa_prepare,0
  150. Com_xa_recover,0
  151. Com_xa_rollback,0
  152. Com_xa_start,0
  153. Compression,OFF
  154. Connection_errors_accept,0
  155. Connection_errors_internal,0
  156. Connection_errors_max_connections,0
  157. Connection_errors_peer_address,0
  158. Connection_errors_select,0
  159. Connection_errors_tcpwrap,0
  160. Connections,23878
  161. Created_tmp_disk_tables,11984
  162. Created_tmp_files,333
  163. Created_tmp_tables,136339633
  164. Delayed_errors,0
  165. Delayed_insert_threads,0
  166. Delayed_writes,0
  167. Flush_commands,1
  168. Handler_commit,1088971397
  169. Handler_delete,710
  170. Handler_discover,0
  171. Handler_external_lock,3338678878
  172. Handler_mrr_init,0
  173. Handler_prepare,0
  174. Handler_read_first,66030379
  175. Handler_read_key,68221990511
  176. Handler_read_last,2089259
  177. Handler_read_next,430967198881
  178. Handler_read_prev,1928705163
  179. Handler_read_rnd,322637330
  180. Handler_read_rnd_next,766168067814
  181. Handler_rollback,214014
  182. Handler_savepoint,0
  183. Handler_savepoint_rollback,0
  184. Handler_update,302448265
  185. Handler_write,356124604076
  186. Innodb_buffer_pool_dump_status,"not started"
  187. Innodb_buffer_pool_load_status,"not started"
  188. Innodb_buffer_pool_pages_data,679626
  189. Innodb_buffer_pool_bytes_data,2545057792
  190. Innodb_buffer_pool_pages_dirty,6784
  191. Innodb_buffer_pool_bytes_dirty,111149056
  192. Innodb_buffer_pool_pages_flushed,179458342
  193. Innodb_buffer_pool_pages_free,8195
  194. Innodb_buffer_pool_pages_misc,98611
  195. Innodb_buffer_pool_pages_total,786432
  196. Innodb_buffer_pool_read_ahead_rnd,0
  197. Innodb_buffer_pool_read_ahead,2092594
  198. Innodb_buffer_pool_read_ahead_evicted,0
  199. Innodb_buffer_pool_read_requests,2931363575
  200. Innodb_buffer_pool_reads,21354175
  201. Innodb_buffer_pool_wait_free,0
  202. Innodb_buffer_pool_write_requests,2731936439
  203. Innodb_data_fsyncs,328085306
  204. Innodb_data_pending_fsyncs,0
  205. Innodb_data_pending_reads,0
  206. Innodb_data_pending_writes,0
  207. Innodb_data_read,2064699392
  208. Innodb_data_reads,23456825
  209. Innodb_data_writes,494633453
  210. Innodb_data_written,1802749952
  211. Innodb_dblwr_pages_written,179458342
  212. Innodb_dblwr_writes,8919997
  213. Innodb_have_atomic_builtins,ON
  214. Innodb_log_waits,0
  215. Innodb_log_write_requests,330586159
  216. Innodb_log_writes,306041138
  217. Innodb_os_log_fsyncs,306257647
  218. Innodb_os_log_pending_fsyncs,0
  219. Innodb_os_log_pending_writes,0
  220. Innodb_os_log_written,314550301184
  221. Innodb_page_size,16384
  222. Innodb_pages_created,1168760
  223. Innodb_pages_read,23456725
  224. Innodb_pages_written,179458342
  225. Innodb_row_lock_current_waits,0
  226. Innodb_row_lock_time,15207
  227. Innodb_row_lock_time_avg,8
  228. Innodb_row_lock_time_max,11527
  229. Innodb_row_lock_waits,1758
  230. Innodb_rows_deleted,710
  231. Innodb_rows_inserted,17635862
  232. Innodb_rows_read,221284233
  233. Innodb_rows_updated,299091276
  234. Innodb_num_open_files,95
  235. Innodb_truncated_status_writes,0
  236. Innodb_available_undo_logs,128
  237. Key_blocks_not_flushed,0
  238. Key_blocks_unused,6698
  239. Key_blocks_used,6698
  240. Key_read_requests,266067262
  241. Key_reads,30
  242. Key_write_requests,49708330
  243. Key_writes,3610585
  244. Last_query_cost,0.000000
  245. Last_query_partial_plans,0
  246. Max_used_connections,136
  247. Not_flushed_delayed_rows,0
  248. Open_files,49
  249. Open_streams,0
  250. Open_table_definitions,234
  251. Open_tables,565
  252. Opened_files,59129
  253. Opened_table_definitions,237
  254. Opened_tables,585
  255. Performance_schema_accounts_lost,0
  256. Performance_schema_cond_classes_lost,0
  257. Performance_schema_cond_instances_lost,0
  258. Performance_schema_digest_lost,0
  259. Performance_schema_file_classes_lost,0
  260. Performance_schema_file_handles_lost,0
  261. Performance_schema_file_instances_lost,0
  262. Performance_schema_hosts_lost,0
  263. Performance_schema_locker_lost,0
  264. Performance_schema_mutex_classes_lost,0
  265. Performance_schema_mutex_instances_lost,0
  266. Performance_schema_rwlock_classes_lost,0
  267. Performance_schema_rwlock_instances_lost,0
  268. Performance_schema_session_connect_attrs_lost,0
  269. Performance_schema_socket_classes_lost,0
  270. Performance_schema_socket_instances_lost,0
  271. Performance_schema_stage_classes_lost,0
  272. Performance_schema_statement_classes_lost,0
  273. Performance_schema_table_handles_lost,0
  274. Performance_schema_table_instances_lost,0
  275. Performance_schema_thread_classes_lost,0
  276. Performance_schema_thread_instances_lost,0
  277. Performance_schema_users_lost,0
  278. Prepared_stmt_count,0
  279. Qcache_free_blocks,0
  280. Qcache_free_memory,0
  281. Qcache_hits,0
  282. Qcache_inserts,0
  283. Qcache_lowmem_prunes,0
  284. Qcache_not_cached,0
  285. Qcache_queries_in_cache,0
  286. Qcache_total_blocks,0
  287. Queries,3022563216
  288. Questions,2067963342
  289. Select_full_join,29673902
  290. Select_full_range_join,1944559
  291. Select_range,56660414
  292. Select_range_check,45806
  293. Select_scan,70915674
  294. Slave_heartbeat_period,
  295. Slave_last_heartbeat,
  296. Slave_open_temp_tables,0
  297. Slave_received_heartbeats,
  298. Slave_retried_transactions,
  299. Slave_running,OFF
  300. Slow_launch_threads,0
  301. Slow_queries,406
  302. Sort_merge_passes,1728
  303. Sort_range,188806
  304. Sort_rows,592086635
  305. Sort_scan,15709918
  306. Ssl_accept_renegotiates,0
  307. Ssl_accepts,0
  308. Ssl_callback_cache_hits,0
  309. Ssl_cipher,
  310. Ssl_cipher_list,
  311. Ssl_client_connects,0
  312. Ssl_connect_renegotiates,0
  313. Ssl_ctx_verify_depth,0
  314. Ssl_ctx_verify_mode,0
  315. Ssl_default_timeout,0
  316. Ssl_finished_accepts,0
  317. Ssl_finished_connects,0
  318. Ssl_server_not_after,
  319. Ssl_server_not_before,
  320. Ssl_session_cache_hits,0
  321. Ssl_session_cache_misses,0
  322. Ssl_session_cache_mode,NONE
  323. Ssl_session_cache_overflows,0
  324. Ssl_session_cache_size,0
  325. Ssl_session_cache_timeouts,0
  326. Ssl_sessions_reused,0
  327. Ssl_used_session_cache_entries,0
  328. Ssl_verify_depth,0
  329. Ssl_verify_mode,0
  330. Ssl_version,
  331. Table_locks_immediate,1669177718
  332. Table_locks_waited,0
  333. Table_open_cache_hits,1669343715
  334. Table_open_cache_misses,572
  335. Table_open_cache_overflows,0
  336. Tc_log_max_pages_used,0
  337. Tc_log_page_size,0
  338. Tc_log_page_waits,0
  339. Threads_cached,0
  340. Threads_connected,60
  341. Threads_created,1339
  342. Threads_running,2
  343. Uptime,1821852
  344. Uptime_since_flush_status,1821852
RAW Paste Data