Advertisement
Guest User

show global status

a guest
Jan 5th, 2018
450
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 11.79 KB | None | 0 0
  1. Aborted_clients, 30
  2. Aborted_connects, 3
  3. Binlog_snapshot_file, mysql-bin.001273
  4. Binlog_snapshot_position, 457064194
  5. Binlog_cache_disk_use, 101059
  6. Binlog_cache_use, 268235072
  7. Binlog_stmt_cache_disk_use, 0
  8. Binlog_stmt_cache_use, 893
  9. Bytes_received, 415143372399
  10. Bytes_sent, 32041855238999
  11. Com_admin_commands, 150035
  12. Com_assign_to_keycache, 0
  13. Com_alter_db, 0
  14. Com_alter_db_upgrade, 0
  15. Com_alter_event, 0
  16. Com_alter_function, 0
  17. Com_alter_instance, 0
  18. Com_alter_procedure, 0
  19. Com_alter_server, 0
  20. Com_alter_table, 12
  21. Com_alter_tablespace, 0
  22. Com_alter_user, 0
  23. Com_analyze, 0
  24. Com_begin, 24
  25. Com_binlog, 0
  26. Com_call_procedure, 0
  27. Com_change_db, 809514
  28. Com_change_master, 0
  29. Com_change_repl_filter, 0
  30. Com_check, 0
  31. Com_checksum, 0
  32. Com_commit, 7
  33. Com_create_compression_dictionary, 0
  34. Com_create_db, 0
  35. Com_create_event, 0
  36. Com_create_function, 0
  37. Com_create_index, 0
  38. Com_create_procedure, 0
  39. Com_create_server, 0
  40. Com_create_table, 797
  41. Com_create_trigger, 0
  42. Com_create_udf, 0
  43. Com_create_user, 0
  44. Com_create_view, 0
  45. Com_dealloc_sql, 0
  46. Com_delete, 856731
  47. Com_delete_multi, 0
  48. Com_do, 0
  49. Com_drop_compression_dictionary, 0
  50. Com_drop_db, 0
  51. Com_drop_event, 0
  52. Com_drop_function, 0
  53. Com_drop_index, 0
  54. Com_drop_procedure, 0
  55. Com_drop_server, 0
  56. Com_drop_table, 90
  57. Com_drop_trigger, 0
  58. Com_drop_user, 0
  59. Com_drop_view, 0
  60. Com_empty_query, 0
  61. Com_execute_sql, 0
  62. Com_explain_other, 0
  63. Com_flush, 0
  64. Com_get_diagnostics, 0
  65. Com_grant, 0
  66. Com_ha_close, 0
  67. Com_ha_open, 0
  68. Com_ha_read, 0
  69. Com_help, 0
  70. Com_insert, 88969136
  71. Com_insert_select, 0
  72. Com_install_plugin, 0
  73. Com_kill, 0
  74. Com_load, 0
  75. Com_lock_tables, 0
  76. Com_lock_tables_for_backup, 0
  77. Com_lock_binlog_for_backup, 0
  78. Com_optimize, 0
  79. Com_preload_keys, 0
  80. Com_prepare_sql, 0
  81. Com_purge, 0
  82. Com_purge_before_date, 0
  83. Com_release_savepoint, 24
  84. Com_rename_table, 0
  85. Com_rename_user, 0
  86. Com_repair, 0
  87. Com_replace, 0
  88. Com_replace_select, 0
  89. Com_reset, 0
  90. Com_resignal, 0
  91. Com_revoke, 0
  92. Com_revoke_all, 0
  93. Com_rollback, 0
  94. Com_rollback_to_savepoint, 809380
  95. Com_savepoint, 24
  96. Com_select, 2357722453
  97. Com_set_option, 344993953
  98. Com_signal, 0
  99. Com_show_binlog_events, 0
  100. Com_show_binlogs, 0
  101. Com_show_charsets, 21
  102. Com_show_client_statistics, 0
  103. Com_show_collations, 20
  104. Com_show_create_db, 0
  105. Com_show_create_event, 0
  106. Com_show_create_func, 0
  107. Com_show_create_proc, 0
  108. Com_show_create_table, 809382
  109. Com_show_create_trigger, 0
  110. Com_show_databases, 42
  111. Com_show_engine_logs, 0
  112. Com_show_engine_mutex, 0
  113. Com_show_engine_status, 1
  114. Com_show_events, 0
  115. Com_show_errors, 0
  116. Com_show_fields, 1693279
  117. Com_show_function_code, 0
  118. Com_show_function_status, 55
  119. Com_show_grants, 0
  120. Com_show_index_statistics, 0
  121. Com_show_keys, 36
  122. Com_show_master_status, 0
  123. Com_show_open_tables, 0
  124. Com_show_plugins, 4
  125. Com_show_privileges, 0
  126. Com_show_procedure_code, 0
  127. Com_show_procedure_status, 55
  128. Com_show_processlist, 0
  129. Com_show_profile, 0
  130. Com_show_profiles, 0
  131. Com_show_relaylog_events, 0
  132. Com_show_slave_hosts, 0
  133. Com_show_slave_status, 4
  134. Com_show_status, 5332
  135. Com_show_storage_engines, 21
  136. Com_show_table_statistics, 0
  137. Com_show_table_status, 809380
  138. Com_show_tables, 156675
  139. Com_show_thread_statistics, 0
  140. Com_show_triggers, 883877
  141. Com_show_user_statistics, 0
  142. Com_show_variables, 331
  143. Com_show_warnings, 0
  144. Com_show_create_user, 0
  145. Com_shutdown, 0
  146. Com_slave_start, 0
  147. Com_slave_stop, 0
  148. Com_group_replication_start, 0
  149. Com_group_replication_stop, 0
  150. Com_stmt_execute, 7
  151. Com_stmt_close, 7
  152. Com_stmt_fetch, 0
  153. Com_stmt_prepare, 7
  154. Com_stmt_reset, 0
  155. Com_stmt_send_long_data, 0
  156. Com_truncate, 0
  157. Com_uninstall_plugin, 0
  158. Com_unlock_binlog, 0
  159. Com_unlock_tables, 24
  160. Com_update, 202120925
  161. Com_update_multi, 0
  162. Com_xa_commit, 0
  163. Com_xa_end, 0
  164. Com_xa_prepare, 0
  165. Com_xa_recover, 0
  166. Com_xa_rollback, 0
  167. Com_xa_start, 0
  168. Com_stmt_reprepare, 0
  169. Connection_errors_accept, 0
  170. Connection_errors_internal, 0
  171. Connection_errors_max_connections, 0
  172. Connection_errors_peer_address, 0
  173. Connection_errors_select, 0
  174. Connection_errors_tcpwrap, 0
  175. Connections, 170473414
  176. Created_tmp_disk_tables, 2577361
  177. Created_tmp_files, 535345
  178. Created_tmp_tables, 7024628
  179. Delayed_errors, 0
  180. Delayed_insert_threads, 0
  181. Delayed_writes, 0
  182. Flush_commands, 1
  183. Handler_commit, 2917084912
  184. Handler_delete, 94976602
  185. Handler_discover, 0
  186. Handler_external_lock, 5798343937
  187. Handler_mrr_init, 0
  188. Handler_prepare, 536470110
  189. Handler_read_first, 19842312
  190. Handler_read_key, 18980819894
  191. Handler_read_last, 215
  192. Handler_read_next, 373258256564
  193. Handler_read_prev, 11498907
  194. Handler_read_rnd, 387293568
  195. Handler_read_rnd_next, 410577358850
  196. Handler_rollback, 29
  197. Handler_savepoint, 48
  198. Handler_savepoint_rollback, 1618760
  199. Handler_update, 180438057
  200. Handler_write, 158706363
  201. Innodb_background_log_sync, 2020325
  202. Innodb_buffer_pool_dump_status, Dumping of buffer pool not started
  203. Innodb_buffer_pool_load_status, Buffer pool(s) load completed at 171212 22:32:56
  204. Innodb_buffer_pool_resize_status,
  205. Innodb_buffer_pool_pages_data, 1294853
  206. Innodb_buffer_pool_bytes_data, 21214871552
  207. Innodb_buffer_pool_pages_dirty, 4251
  208. Innodb_buffer_pool_bytes_dirty, 69648384
  209. Innodb_buffer_pool_pages_flushed, 220833222
  210. Innodb_buffer_pool_pages_free, 8191
  211. Innodb_buffer_pool_pages_LRU_flushed, 0
  212. Innodb_buffer_pool_pages_made_not_young, 9366461599
  213. Innodb_buffer_pool_pages_made_young, 4123453
  214. Innodb_buffer_pool_pages_misc, 7516
  215. Innodb_buffer_pool_pages_old, 477818
  216. Innodb_buffer_pool_pages_total, 1310560
  217. Innodb_buffer_pool_read_ahead_rnd, 0
  218. Innodb_buffer_pool_read_ahead, 92372791
  219. Innodb_buffer_pool_read_ahead_evicted, 0
  220. Innodb_buffer_pool_read_requests, 1261731098703
  221. Innodb_buffer_pool_reads, 42793206
  222. Innodb_buffer_pool_wait_free, 6049
  223. Innodb_buffer_pool_write_requests, 3343520842
  224. Innodb_checkpoint_age, 11353125
  225. Innodb_checkpoint_max_age, 53647074
  226. Innodb_data_fsyncs, 72680406
  227. Innodb_data_pending_fsyncs, 0
  228. Innodb_data_pending_reads, 0
  229. Innodb_data_pending_writes, 0
  230. Innodb_data_read, 2218035810816
  231. Innodb_data_reads, 135411594
  232. Innodb_data_writes, 105700190
  233. Innodb_data_written, 1612059185664
  234. Innodb_dblwr_pages_written, 85587951
  235. Innodb_dblwr_writes, 16335687
  236. Innodb_ibuf_free_list, 470
  237. Innodb_ibuf_segment_size, 472
  238. Innodb_log_waits, 0
  239. Innodb_log_write_requests, 474127312
  240. Innodb_log_writes, 3530110
  241. Innodb_lsn_current, 954372560872
  242. Innodb_lsn_flushed, 954372500753
  243. Innodb_lsn_last_checkpoint, 954361207747
  244. Innodb_master_thread_active_loops, 2019223
  245. Innodb_master_thread_idle_loops, 1104
  246. Innodb_max_trx_id, 1972896285
  247. Innodb_mem_adaptive_hash, 463137600
  248. Innodb_mem_dictionary, 213920301
  249. Innodb_oldest_view_low_limit_trx_id, 1972896274
  250. Innodb_os_log_fsyncs, 3814533
  251. Innodb_os_log_pending_fsyncs, 0
  252. Innodb_os_log_pending_writes, 0
  253. Innodb_os_log_written, 234594526208
  254. Innodb_page_size, 16384
  255. Innodb_pages_created, 1148434
  256. Innodb_pages_read, 135378226
  257. Innodb_pages_written, 85603350
  258. Innodb_purge_trx_id, 1972896275
  259. Innodb_purge_undo_no, 0
  260. Innodb_row_lock_current_waits, 0
  261. Innodb_row_lock_time, 2975521
  262. Innodb_row_lock_time_avg, 7
  263. Innodb_row_lock_time_max, 5060
  264. Innodb_row_lock_waits, 398208
  265. Innodb_rows_deleted, 94976602
  266. Innodb_rows_inserted, 102716752
  267. Innodb_rows_read, 801823650560
  268. Innodb_rows_updated, 180430027
  269. Innodb_num_open_files, 400
  270. Innodb_truncated_status_writes, 0
  271. Innodb_available_undo_logs, 128
  272. Innodb_secondary_index_triggered_cluster_reads, 372806214202
  273. Innodb_secondary_index_triggered_cluster_reads_avoided, 0
  274. Key_blocks_not_flushed, 0
  275. Key_blocks_unused, 6698
  276. Key_blocks_used, 3
  277. Key_read_requests, 446
  278. Key_reads, 103
  279. Key_write_requests, 0
  280. Key_writes, 0
  281. Locked_connects, 0
  282. Max_execution_time_exceeded, 0
  283. Max_execution_time_set, 0
  284. Max_execution_time_set_failed, 0
  285. Max_used_connections, 110
  286. Max_used_connections_time, 2017-12-13 13:55:46
  287. Not_flushed_delayed_rows, 0
  288. Ongoing_anonymous_transaction_count, 2
  289. Open_files, 2
  290. Open_streams, 0
  291. Open_table_definitions, 16384
  292. Open_tables, 400
  293. Opened_files, 4379053
  294. Opened_table_definitions, 3568448
  295. Opened_tables, 84342523
  296. Performance_schema_accounts_lost, 0
  297. Performance_schema_cond_classes_lost, 0
  298. Performance_schema_cond_instances_lost, 0
  299. Performance_schema_digest_lost, 40999949
  300. Performance_schema_file_classes_lost, 0
  301. Performance_schema_file_handles_lost, 0
  302. Performance_schema_file_instances_lost, 0
  303. Performance_schema_hosts_lost, 0
  304. Performance_schema_index_stat_lost, 0
  305. Performance_schema_locker_lost, 0
  306. Performance_schema_memory_classes_lost, 0
  307. Performance_schema_metadata_lock_lost, 0
  308. Performance_schema_mutex_classes_lost, 0
  309. Performance_schema_mutex_instances_lost, 0
  310. Performance_schema_nested_statement_lost, 0
  311. Performance_schema_prepared_statements_lost, 0
  312. Performance_schema_program_lost, 0
  313. Performance_schema_rwlock_classes_lost, 0
  314. Performance_schema_rwlock_instances_lost, 0
  315. Performance_schema_session_connect_attrs_lost, 0
  316. Performance_schema_socket_classes_lost, 0
  317. Performance_schema_socket_instances_lost, 0
  318. Performance_schema_stage_classes_lost, 0
  319. Performance_schema_statement_classes_lost, 0
  320. Performance_schema_table_handles_lost, 0
  321. Performance_schema_table_instances_lost, 0
  322. Performance_schema_table_lock_stat_lost, 0
  323. Performance_schema_thread_classes_lost, 0
  324. Performance_schema_thread_instances_lost, 0
  325. Performance_schema_users_lost, 0
  326. Prepared_stmt_count, 0
  327. Qcache_free_blocks, 0
  328. Qcache_free_memory, 0
  329. Qcache_hits, 1114734380
  330. Qcache_inserts, 407638858
  331. Qcache_lowmem_prunes, 1378747
  332. Qcache_not_cached, 576552564
  333. Qcache_queries_in_cache, 0
  334. Qcache_total_blocks, 0
  335. Queries, 4286808122
  336. Questions, 4286658071
  337. Rsa_public_key, -----BEGIN PUBLIC KEY-----
  338. MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAtzUTVDa4lbjvEjCn22cC
  339. 2je3KMvIY8AdQAaCx7FFfQaapce3Upz7BUF8v9fSP8p2ULPA7GP1C9zraVTYeTM3
  340. i5aNkRO0Fxfk4qpjd7FkRV+J9ZWsqQbAj3JwYa2eR/Su5nGEkWOepmuXl5mKEIpw
  341. fcFRcM1M15fdtoM5Cqap48wSmUB93zyvhzrNA7oeFKxKpawgypYBq1rp9EDCLxpE
  342. YuXduwifUOgF52yzHo+knL9H8spXnn7CzdMYcvmq6BVzomq7JweGRgS5VzAEOhDc
  343. Boiw6Cy8JUnje4T6Imbh0q8eESatOBz3fEu0b+pa6l3XP1VI5RUuSHHkzxFgAjzu
  344. qQIDAQAB
  345. -----END PUBLIC KEY-----
  346.  
  347. Select_full_join, 128
  348. Select_full_range_join, 0
  349. Select_range, 21729969
  350. Select_range_check, 0
  351. Select_scan, 19298109
  352. Slave_open_temp_tables, 0
  353. Slow_launch_threads, 0
  354. Slow_queries, 0
  355. Sort_merge_passes, 277362
  356. Sort_range, 26307173
  357. Sort_rows, 20777577917
  358. Sort_scan, 5463028
  359. Ssl_accept_renegotiates, 0
  360. Ssl_accepts, 53
  361. Ssl_callback_cache_hits, 0
  362. Ssl_cipher, DHE-RSA-AES256-SHA
  363. Ssl_cipher_list, ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES256-GCM-SHA384:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:DHE-RSA-AES128-SHA256:DHE-DSS-AES128-SHA256:DHE-DSS-AES256-GCM-SHA384:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-DSS-AES128-SHA:DHE-RSA-AES128-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:DHE-RSA-AES256-GCM-SHA384
  364. Ssl_client_connects, 0
  365. Ssl_connect_renegotiates, 0
  366. Ssl_ctx_verify_depth, 18446744073709551615
  367. Ssl_ctx_verify_mode, 5
  368. Ssl_default_timeout, 7200
  369. Ssl_finished_accepts, 53
  370. Ssl_finished_connects, 0
  371. Ssl_server_not_after, Oct 18 12:01:10 2027 GMT
  372. Ssl_server_not_before, Oct 20 12:01:10 2017 GMT
  373. Ssl_session_cache_hits, 0
  374. Ssl_session_cache_misses, 0
  375. Ssl_session_cache_mode, SERVER
  376. Ssl_session_cache_overflows, 0
  377. Ssl_session_cache_size, 128
  378. Ssl_session_cache_timeouts, 0
  379. Ssl_sessions_reused, 0
  380. Ssl_used_session_cache_entries, 52
  381. Ssl_verify_depth, 18446744073709551615
  382. Ssl_verify_mode, 5
  383. Ssl_version, TLSv1.1
  384. Table_locks_immediate, 6150
  385. Table_locks_waited, 0
  386. Table_open_cache_hits, 2775450445
  387. Table_open_cache_misses, 84342523
  388. Table_open_cache_overflows, 84342104
  389. Tc_log_max_pages_used, 0
  390. Tc_log_page_size, 0
  391. Tc_log_page_waits, 0
  392. Threadpool_idle_threads, 0
  393. Threadpool_threads, 0
  394. Threads_cached, 44
  395. Threads_connected, 6
  396. Threads_created, 3597
  397. Threads_running, 5
  398. Uptime, 2049161
  399. Uptime_since_flush_status, 2049161
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement