SHARE
TWEET

SHOW GLOBAL STATUS

a guest Jan 15th, 2018 104 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Aborted_clients;1121
  2. Aborted_connects;377
  3. Binlog_cache_disk_use;838129
  4. Binlog_cache_use;108704408
  5. Binlog_stmt_cache_disk_use;0
  6. Binlog_stmt_cache_use;38
  7. Bytes_received;7428375202782
  8. Bytes_sent;27172546939084
  9. Com_admin_commands;16105552
  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_instance;0
  16. Com_alter_procedure;0
  17. Com_alter_server;0
  18. Com_alter_table;1
  19. Com_alter_tablespace;0
  20. Com_alter_user;0
  21. Com_analyze;0
  22. Com_begin;459564
  23. Com_binlog;0
  24. Com_call_procedure;9
  25. Com_change_db;278
  26. Com_change_master;0
  27. Com_change_repl_filter;0
  28. Com_check;0
  29. Com_checksum;0
  30. Com_commit;1672382928
  31. Com_create_db;0
  32. Com_create_event;0
  33. Com_create_function;0
  34. Com_create_index;0
  35. Com_create_procedure;9
  36. Com_create_server;0
  37. Com_create_table;5
  38. Com_create_trigger;0
  39. Com_create_udf;0
  40. Com_create_user;0
  41. Com_create_view;0
  42. Com_dealloc_sql;0
  43. Com_delete;37537668
  44. Com_delete_multi;198418338
  45. Com_do;0
  46. Com_drop_db;1
  47. Com_drop_event;0
  48. Com_drop_function;0
  49. Com_drop_index;0
  50. Com_drop_procedure;9
  51. Com_drop_server;0
  52. Com_drop_table;0
  53. Com_drop_trigger;0
  54. Com_drop_user;0
  55. Com_drop_view;0
  56. Com_empty_query;0
  57. Com_execute_sql;0
  58. Com_explain_other;0
  59. Com_flush;4
  60. Com_get_diagnostics;0
  61. Com_grant;2
  62. Com_ha_close;0
  63. Com_ha_open;0
  64. Com_ha_read;0
  65. Com_help;0
  66. Com_insert;693300264
  67. Com_insert_select;9
  68. Com_install_plugin;0
  69. Com_kill;602
  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;1
  84. Com_resignal;0
  85. Com_revoke;2
  86. Com_revoke_all;0
  87. Com_rollback;770457
  88. Com_rollback_to_savepoint;0
  89. Com_savepoint;0
  90. Com_select;6763083714
  91. Com_set_option;1935549
  92. Com_signal;0
  93. Com_show_binlog_events;0
  94. Com_show_binlogs;10469
  95. Com_show_charsets;18
  96. Com_show_collations;20
  97. Com_show_create_db;0
  98. Com_show_create_event;0
  99. Com_show_create_func;10
  100. Com_show_create_proc;67
  101. Com_show_create_table;738
  102. Com_show_create_trigger;0
  103. Com_show_databases;129
  104. Com_show_engine_logs;0
  105. Com_show_engine_mutex;0
  106. Com_show_engine_status;10512
  107. Com_show_events;2
  108. Com_show_errors;0
  109. Com_show_fields;52750
  110. Com_show_function_code;0
  111. Com_show_function_status;80
  112. Com_show_grants;0
  113. Com_show_keys;494
  114. Com_show_master_status;32
  115. Com_show_open_tables;0
  116. Com_show_plugins;3
  117. Com_show_privileges;3
  118. Com_show_procedure_code;0
  119. Com_show_procedure_status;80
  120. Com_show_processlist;10500
  121. Com_show_profile;24
  122. Com_show_profiles;25
  123. Com_show_relaylog_events;0
  124. Com_show_slave_hosts;4
  125. Com_show_slave_status;115755
  126. Com_show_status;94890
  127. Com_show_storage_engines;10513
  128. Com_show_table_status;751
  129. Com_show_tables;243
  130. Com_show_triggers;22080
  131. Com_show_variables;11083
  132. Com_show_warnings;446199
  133. Com_show_create_user;0
  134. Com_shutdown;0
  135. Com_slave_start;0
  136. Com_slave_stop;1
  137. Com_group_replication_start;0
  138. Com_group_replication_stop;0
  139. Com_stmt_execute;1043
  140. Com_stmt_close;38
  141. Com_stmt_fetch;0
  142. Com_stmt_prepare;39
  143. Com_stmt_reset;0
  144. Com_stmt_send_long_data;0
  145. Com_truncate;0
  146. Com_uninstall_plugin;0
  147. Com_unlock_tables;0
  148. Com_update;214511608
  149. Com_update_multi;79274476
  150. Com_xa_commit;0
  151. Com_xa_end;0
  152. Com_xa_prepare;0
  153. Com_xa_recover;0
  154. Com_xa_rollback;0
  155. Com_xa_start;0
  156. Com_stmt_reprepare;0
  157. Connection_errors_accept;0
  158. Connection_errors_internal;0
  159. Connection_errors_max_connections;343
  160. Connection_errors_peer_address;0
  161. Connection_errors_select;0
  162. Connection_errors_tcpwrap;0
  163. Connections;667044
  164. Created_tmp_disk_tables;297023373
  165. Created_tmp_files;960491
  166. Created_tmp_tables;1107271497
  167. Delayed_errors;0
  168. Delayed_insert_threads;0
  169. Delayed_writes;0
  170. Flush_commands;1
  171. Handler_commit;10269367863
  172. Handler_delete;67942367
  173. Handler_discover;0
  174. Handler_external_lock;59338937322
  175. Handler_mrr_init;0
  176. Handler_prepare;1944813450
  177. Handler_read_first;756438188
  178. Handler_read_key;548534383741
  179. Handler_read_last;138367
  180. Handler_read_next;4079004958606
  181. Handler_read_prev;90130110885
  182. Handler_read_rnd;103566987913
  183. Handler_read_rnd_next;55056167035
  184. Handler_rollback;528204
  185. Handler_savepoint;0
  186. Handler_savepoint_rollback;0
  187. Handler_update;441868819
  188. Handler_write;4675495909
  189. Innodb_buffer_pool_dump_status;Dumping of buffer pool not started
  190. Innodb_buffer_pool_load_status;Buffer pool(s) load completed at 171209 21:44:13
  191. Innodb_buffer_pool_resize_status;
  192. Innodb_buffer_pool_pages_data;34079586
  193. Innodb_buffer_pool_bytes_data;558359937024
  194. Innodb_buffer_pool_pages_dirty;4291574
  195. Innodb_buffer_pool_bytes_dirty;70313148416
  196. Innodb_buffer_pool_pages_flushed;523716598
  197. Innodb_buffer_pool_pages_free;7114
  198. Innodb_buffer_pool_pages_misc;2154550
  199. Innodb_buffer_pool_pages_total;36241250
  200. Innodb_buffer_pool_read_ahead_rnd;0
  201. Innodb_buffer_pool_read_ahead;827935
  202. Innodb_buffer_pool_read_ahead_evicted;0
  203. Innodb_buffer_pool_read_requests;4298086005281
  204. Innodb_buffer_pool_reads;61040718
  205. Innodb_buffer_pool_wait_free;0
  206. Innodb_buffer_pool_write_requests;28509391910
  207. Innodb_data_fsyncs;418999741
  208. Innodb_data_pending_fsyncs;1
  209. Innodb_data_pending_reads;0
  210. Innodb_data_pending_writes;0
  211. Innodb_data_read;1238596489728
  212. Innodb_data_reads;75601344
  213. Innodb_data_writes;733452062
  214. Innodb_data_written;17182685869568
  215. Innodb_dblwr_pages_written;459782684
  216. Innodb_dblwr_writes;97725876
  217. Innodb_log_waits;0
  218. Innodb_log_write_requests;1884165405
  219. Innodb_log_writes;110905716
  220. Innodb_os_log_fsyncs;111317185
  221. Innodb_os_log_pending_fsyncs;0
  222. Innodb_os_log_pending_writes;0
  223. Innodb_os_log_written;1071443919360
  224. Innodb_page_size;16384
  225. Innodb_pages_created;17974160
  226. Innodb_pages_read;75599666
  227. Innodb_pages_written;523717889
  228. Innodb_row_lock_current_waits;13
  229. Innodb_row_lock_time;59749973
  230. Innodb_row_lock_time_avg;94
  231. Innodb_row_lock_time_max;51940
  232. Innodb_row_lock_waits;632292
  233. Innodb_rows_deleted;77816513
  234. Innodb_rows_inserted;6808186895
  235. Innodb_rows_read;4417253808042
  236. Innodb_rows_updated;375126787
  237. Innodb_num_open_files;1940
  238. Innodb_truncated_status_writes;0
  239. Innodb_available_undo_logs;128
  240. Key_blocks_not_flushed;0
  241. Key_blocks_unused;6698
  242. Key_blocks_used;20
  243. Key_read_requests;11766
  244. Key_reads;1274
  245. Key_write_requests;246
  246. Key_writes;49
  247. Locked_connects;0
  248. Max_execution_time_exceeded;1301
  249. Max_execution_time_set;6763083714
  250. Max_execution_time_set_failed;0
  251. Max_used_connections;701
  252. Max_used_connections_time;2018-01-12 11:09:15
  253. Not_flushed_delayed_rows;0
  254. Ongoing_anonymous_transaction_count;0
  255. Open_files;234
  256. Open_streams;0
  257. Open_table_definitions;2000
  258. Open_tables;10000
  259. Opened_files;1988692
  260. Opened_table_definitions;165224
  261. Opened_tables;1421299
  262. Performance_schema_accounts_lost;0
  263. Performance_schema_cond_classes_lost;0
  264. Performance_schema_cond_instances_lost;0
  265. Performance_schema_digest_lost;0
  266. Performance_schema_file_classes_lost;0
  267. Performance_schema_file_handles_lost;0
  268. Performance_schema_file_instances_lost;0
  269. Performance_schema_hosts_lost;0
  270. Performance_schema_index_stat_lost;0
  271. Performance_schema_locker_lost;0
  272. Performance_schema_memory_classes_lost;0
  273. Performance_schema_metadata_lock_lost;0
  274. Performance_schema_mutex_classes_lost;0
  275. Performance_schema_mutex_instances_lost;0
  276. Performance_schema_nested_statement_lost;0
  277. Performance_schema_prepared_statements_lost;0
  278. Performance_schema_program_lost;0
  279. Performance_schema_rwlock_classes_lost;0
  280. Performance_schema_rwlock_instances_lost;0
  281. Performance_schema_session_connect_attrs_lost;0
  282. Performance_schema_socket_classes_lost;0
  283. Performance_schema_socket_instances_lost;0
  284. Performance_schema_stage_classes_lost;0
  285. Performance_schema_statement_classes_lost;0
  286. Performance_schema_table_handles_lost;0
  287. Performance_schema_table_instances_lost;0
  288. Performance_schema_table_lock_stat_lost;0
  289. Performance_schema_thread_classes_lost;0
  290. Performance_schema_thread_instances_lost;0
  291. Performance_schema_users_lost;0
  292. Prepared_stmt_count;0
  293. Qcache_free_blocks;0
  294. Qcache_free_memory;0
  295. Qcache_hits;0
  296. Qcache_inserts;0
  297. Qcache_lowmem_prunes;0
  298. Qcache_not_cached;0
  299. Qcache_queries_in_cache;0
  300. Qcache_total_blocks;0
  301. Queries;9678805194
  302. Questions;9658430713
  303. Select_full_join;338957314
  304. Select_full_range_join;25677424
  305. Select_range;412124485
  306. Select_range_check;15466
  307. Select_scan;124606973
  308. Slave_open_temp_tables;0
  309. Slow_launch_threads;0
  310. Slow_queries;634325
  311. Sort_merge_passes;1136548
  312. Sort_range;95587270
  313. Sort_rows;15319417032
  314. Sort_scan;1051348359
  315. Ssl_accept_renegotiates;0
  316. Ssl_accepts;0
  317. Ssl_callback_cache_hits;0
  318. Ssl_cipher;
  319. Ssl_cipher_list;
  320. Ssl_client_connects;0
  321. Ssl_connect_renegotiates;0
  322. Ssl_ctx_verify_depth;0
  323. Ssl_ctx_verify_mode;0
  324. Ssl_default_timeout;0
  325. Ssl_finished_accepts;0
  326. Ssl_finished_connects;0
  327. Ssl_server_not_after;Apr 16 12:01:48 2026 GMT
  328. Ssl_server_not_before;Apr 18 12:01:48 2016 GMT
  329. Ssl_session_cache_hits;0
  330. Ssl_session_cache_misses;0
  331. Ssl_session_cache_mode;Unknown
  332. Ssl_session_cache_overflows;0
  333. Ssl_session_cache_size;0
  334. Ssl_session_cache_timeouts;0
  335. Ssl_sessions_reused;0
  336. Ssl_used_session_cache_entries;0
  337. Ssl_verify_depth;0
  338. Ssl_verify_mode;0
  339. Ssl_version;
  340. Table_locks_immediate;112233
  341. Table_locks_waited;0
  342. Table_open_cache_hits;29546057689
  343. Table_open_cache_misses;1421299
  344. Table_open_cache_overflows;1411244
  345. Tc_log_max_pages_used;0
  346. Tc_log_page_size;0
  347. Tc_log_page_waits;0
  348. Threads_cached;65
  349. Threads_connected;344
  350. Threads_created;4629
  351. Threads_running;71
  352. Uptime;3158494
  353. Uptime_since_flush_status;3158494
RAW Paste Data
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!
 
Top