Advertisement
Guest User

SHOW GLOBAL STATUS

a guest
Jan 15th, 2018
722
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.12 KB | None | 0 0
  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
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement