Advertisement
Guest User

SHOW GLOBAL

a guest
Jul 3rd, 2019
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 15.04 KB | None | 0 0
  1. **EDIT:**
  2. SHOW GLOBAL STATUS:
  3.  
  4. 'Aborted_clients', '0'
  5. 'Aborted_connects', '2'
  6. 'Access_denied_errors', '0'
  7. 'Acl_column_grants', '0'
  8. 'Acl_database_grants', '4'
  9. 'Acl_function_grants', '0'
  10. 'Acl_procedure_grants', '0'
  11. 'Acl_proxy_users', '1'
  12. 'Acl_role_grants', '0'
  13. 'Acl_roles', '0'
  14. 'Acl_table_grants', '0'
  15. 'Acl_users', '5'
  16. 'Aria_pagecache_blocks_not_flushed', '0'
  17. 'Aria_pagecache_blocks_unused', '15706'
  18. 'Aria_pagecache_blocks_used', '434'
  19. 'Aria_pagecache_read_requests', '10124082'
  20. 'Aria_pagecache_reads', '7244'
  21. 'Aria_pagecache_write_requests', '3561690'
  22. 'Aria_pagecache_writes', '123425'
  23. 'Aria_transaction_log_syncs', '80'
  24. 'Binlog_commits', '10927'
  25. 'Binlog_group_commits', '10927'
  26. 'Binlog_group_commit_trigger_count', '0'
  27. 'Binlog_group_commit_trigger_lock_wait', '0'
  28. 'Binlog_group_commit_trigger_timeout', '0'
  29. 'Binlog_snapshot_file', 'mysql-bin.000832'
  30. 'Binlog_snapshot_position', '12678323'
  31. 'Binlog_bytes_written', '12678065'
  32. 'Binlog_cache_disk_use', '0'
  33. 'Binlog_cache_use', '10927'
  34. 'Binlog_stmt_cache_disk_use', '0'
  35. 'Binlog_stmt_cache_use', '0'
  36. 'Busy_time', '0.000000'
  37. 'Bytes_received', '68275775'
  38. 'Bytes_sent', '66382818'
  39. 'Com_admin_commands', '961'
  40. 'Com_alter_db', '0'
  41. 'Com_alter_db_upgrade', '0'
  42. 'Com_alter_event', '0'
  43. 'Com_alter_function', '0'
  44. 'Com_alter_procedure', '0'
  45. 'Com_alter_server', '0'
  46. 'Com_alter_table', '0'
  47. 'Com_alter_tablespace', '0'
  48. 'Com_alter_user', '0'
  49. 'Com_analyze', '0'
  50. 'Com_assign_to_keycache', '0'
  51. 'Com_begin', '8887'
  52. 'Com_binlog', '0'
  53. 'Com_call_procedure', '0'
  54. 'Com_change_db', '2'
  55. 'Com_change_master', '0'
  56. 'Com_check', '0'
  57. 'Com_checksum', '0'
  58. 'Com_commit', '8887'
  59. 'Com_compound_sql', '0'
  60. 'Com_create_db', '0'
  61. 'Com_create_event', '0'
  62. 'Com_create_function', '0'
  63. 'Com_create_index', '0'
  64. 'Com_create_procedure', '0'
  65. 'Com_create_role', '0'
  66. 'Com_create_server', '0'
  67. 'Com_create_table', '0'
  68. 'Com_create_temporary_table', '2'
  69. 'Com_create_trigger', '0'
  70. 'Com_create_udf', '0'
  71. 'Com_create_user', '0'
  72. 'Com_create_view', '0'
  73. 'Com_dealloc_sql', '0'
  74. 'Com_delete', '5369'
  75. 'Com_delete_multi', '0'
  76. 'Com_do', '0'
  77. 'Com_drop_db', '0'
  78. 'Com_drop_event', '0'
  79. 'Com_drop_function', '0'
  80. 'Com_drop_index', '0'
  81. 'Com_drop_procedure', '0'
  82. 'Com_drop_role', '0'
  83. 'Com_drop_server', '0'
  84. 'Com_drop_table', '2'
  85. 'Com_drop_temporary_table', '0'
  86. 'Com_drop_trigger', '0'
  87. 'Com_drop_user', '0'
  88. 'Com_drop_view', '0'
  89. 'Com_empty_query', '0'
  90. 'Com_execute_immediate', '0'
  91. 'Com_execute_sql', '0'
  92. 'Com_flush', '0'
  93. 'Com_get_diagnostics', '0'
  94. 'Com_grant', '0'
  95. 'Com_grant_role', '0'
  96. 'Com_ha_close', '0'
  97. 'Com_ha_open', '0'
  98. 'Com_ha_read', '0'
  99. 'Com_help', '0'
  100. 'Com_insert', '5870'
  101. 'Com_insert_select', '2'
  102. 'Com_install_plugin', '0'
  103. 'Com_kill', '0'
  104. 'Com_load', '2'
  105. 'Com_lock_tables', '0'
  106. 'Com_multi', '0'
  107. 'Com_optimize', '0'
  108. 'Com_preload_keys', '0'
  109. 'Com_prepare_sql', '0'
  110. 'Com_purge', '0'
  111. 'Com_purge_before_date', '0'
  112. 'Com_release_savepoint', '0'
  113. 'Com_rename_table', '0'
  114. 'Com_rename_user', '0'
  115. 'Com_repair', '0'
  116. 'Com_replace', '0'
  117. 'Com_replace_select', '0'
  118. 'Com_reset', '0'
  119. 'Com_resignal', '0'
  120. 'Com_revoke', '0'
  121. 'Com_revoke_all', '0'
  122. 'Com_revoke_role', '0'
  123. 'Com_rollback', '0'
  124. 'Com_rollback_to_savepoint', '0'
  125. 'Com_savepoint', '0'
  126. 'Com_select', '55356'
  127. 'Com_set_option', '10100'
  128. 'Com_show_authors', '0'
  129. 'Com_show_binlog_events', '0'
  130. 'Com_show_binlogs', '0'
  131. 'Com_show_charsets', '0'
  132. 'Com_show_collations', '0'
  133. 'Com_show_contributors', '0'
  134. 'Com_show_create_db', '0'
  135. 'Com_show_create_event', '0'
  136. 'Com_show_create_func', '0'
  137. 'Com_show_create_proc', '0'
  138. 'Com_show_create_table', '0'
  139. 'Com_show_create_trigger', '0'
  140. 'Com_show_create_user', '0'
  141. 'Com_show_databases', '0'
  142. 'Com_show_engine_logs', '0'
  143. 'Com_show_engine_mutex', '0'
  144. 'Com_show_engine_status', '0'
  145. 'Com_show_errors', '0'
  146. 'Com_show_events', '0'
  147. 'Com_show_explain', '0'
  148. 'Com_show_fields', '0'
  149. 'Com_show_function_status', '0'
  150. 'Com_show_generic', '0'
  151. 'Com_show_grants', '0'
  152. 'Com_show_keys', '0'
  153. 'Com_show_master_status', '0'
  154. 'Com_show_open_tables', '0'
  155. 'Com_show_plugins', '0'
  156. 'Com_show_privileges', '0'
  157. 'Com_show_procedure_status', '0'
  158. 'Com_show_processlist', '0'
  159. 'Com_show_profile', '0'
  160. 'Com_show_profiles', '0'
  161. 'Com_show_relaylog_events', '0'
  162. 'Com_show_slave_hosts', '0'
  163. 'Com_show_slave_status', '0'
  164. 'Com_show_status', '3'
  165. 'Com_show_storage_engines', '0'
  166. 'Com_show_table_status', '0'
  167. 'Com_show_tables', '0'
  168. 'Com_show_triggers', '0'
  169. 'Com_show_variables', '3'
  170. 'Com_show_warnings', '0'
  171. 'Com_shutdown', '0'
  172. 'Com_signal', '0'
  173. 'Com_start_all_slaves', '0'
  174. 'Com_start_slave', '0'
  175. 'Com_stmt_close', '0'
  176. 'Com_stmt_execute', '0'
  177. 'Com_stmt_fetch', '0'
  178. 'Com_stmt_prepare', '0'
  179. 'Com_stmt_reprepare', '0'
  180. 'Com_stmt_reset', '0'
  181. 'Com_stmt_send_long_data', '0'
  182. 'Com_stop_all_slaves', '0'
  183. 'Com_stop_slave', '0'
  184. 'Com_truncate', '0'
  185. 'Com_uninstall_plugin', '0'
  186. 'Com_unlock_tables', '0'
  187. 'Com_update', '90'
  188. 'Com_update_multi', '2'
  189. 'Com_xa_commit', '0'
  190. 'Com_xa_end', '0'
  191. 'Com_xa_prepare', '0'
  192. 'Com_xa_recover', '0'
  193. 'Com_xa_rollback', '0'
  194. 'Com_xa_start', '0'
  195. 'Compression', 'OFF'
  196. 'Connection_errors_accept', '0'
  197. 'Connection_errors_internal', '0'
  198. 'Connection_errors_max_connections', '0'
  199. 'Connection_errors_peer_address', '0'
  200. 'Connection_errors_select', '0'
  201. 'Connection_errors_tcpwrap', '0'
  202. 'Connections', '10103'
  203. 'Cpu_time', '0.000000'
  204. 'Created_tmp_disk_tables', '15777'
  205. 'Created_tmp_files', '35'
  206. 'Created_tmp_tables', '33066'
  207. 'Delayed_errors', '0'
  208. 'Delayed_insert_threads', '0'
  209. 'Delayed_writes', '0'
  210. 'Delete_scan', '5154'
  211. 'Empty_queries', '3089'
  212. 'Executed_events', '0'
  213. 'Executed_triggers', '0'
  214. 'Feature_check_constraint', '0'
  215. 'Feature_delay_key_write', '0'
  216. 'Feature_dynamic_columns', '0'
  217. 'Feature_fulltext', '0'
  218. 'Feature_gis', '0'
  219. 'Feature_locale', '0'
  220. 'Feature_subquery', '3889'
  221. 'Feature_timezone', '0'
  222. 'Feature_trigger', '0'
  223. 'Feature_window_functions', '99'
  224. 'Feature_xml', '0'
  225. 'Flush_commands', '1'
  226. 'Handler_commit', '77009'
  227. 'Handler_delete', '350'
  228. 'Handler_discover', '0'
  229. 'Handler_external_lock', '0'
  230. 'Handler_icp_attempts', '5658872'
  231. 'Handler_icp_match', '5591534'
  232. 'Handler_mrr_init', '0'
  233. 'Handler_mrr_key_refills', '0'
  234. 'Handler_mrr_rowid_refills', '0'
  235. 'Handler_prepare', '12800'
  236. 'Handler_read_first', '3349'
  237. 'Handler_read_key', '35677725'
  238. 'Handler_read_last', '128'
  239. 'Handler_read_next', '1301944186'
  240. 'Handler_read_prev', '7201995'
  241. 'Handler_read_retry', '0'
  242. 'Handler_read_rnd', '7423296'
  243. 'Handler_read_rnd_deleted', '80'
  244. 'Handler_read_rnd_next', '45511720'
  245. 'Handler_rollback', '4'
  246. 'Handler_savepoint', '0'
  247. 'Handler_savepoint_rollback', '0'
  248. 'Handler_tmp_update', '7300273'
  249. 'Handler_tmp_write', '16367530'
  250. 'Handler_update', '56583'
  251. 'Handler_write', '6080'
  252. 'Innodb_buffer_pool_dump_status', ''
  253. 'Innodb_buffer_pool_load_status', 'Buffer pool(s) load completed at 190703 13:48:56'
  254. 'Innodb_buffer_pool_resize_status', ''
  255. 'Innodb_buffer_pool_pages_data', '551445'
  256. 'Innodb_buffer_pool_bytes_data', '9034874880'
  257. 'Innodb_buffer_pool_pages_dirty', '0'
  258. 'Innodb_buffer_pool_bytes_dirty', '0'
  259. 'Innodb_buffer_pool_pages_flushed', '33499'
  260. 'Innodb_buffer_pool_pages_free', '181655'
  261. 'Innodb_buffer_pool_pages_misc', '4135'
  262. 'Innodb_buffer_pool_pages_total', '737235'
  263. 'Innodb_buffer_pool_read_ahead_rnd', '0'
  264. 'Innodb_buffer_pool_read_ahead', '1500'
  265. 'Innodb_buffer_pool_read_ahead_evicted', '0'
  266. 'Innodb_buffer_pool_read_requests', '246600856'
  267. 'Innodb_buffer_pool_reads', '549467'
  268. 'Innodb_buffer_pool_wait_free', '0'
  269. 'Innodb_buffer_pool_write_requests', '70858'
  270. 'Innodb_data_fsyncs', '37339'
  271. 'Innodb_data_pending_fsyncs', '0'
  272. 'Innodb_data_pending_reads', '0'
  273. 'Innodb_data_pending_writes', '0'
  274. 'Innodb_data_read', '9029372416'
  275. 'Innodb_data_reads', '552651'
  276. 'Innodb_data_writes', '66772'
  277. 'Innodb_data_written', '1121710592'
  278. 'Innodb_dblwr_pages_written', '33354'
  279. 'Innodb_dblwr_writes', '12381'
  280. 'Innodb_log_waits', '0'
  281. 'Innodb_log_write_requests', '21614'
  282. 'Innodb_log_writes', '17310'
  283. 'Innodb_os_log_fsyncs', '11148'
  284. 'Innodb_os_log_pending_fsyncs', '0'
  285. 'Innodb_os_log_pending_writes', '0'
  286. 'Innodb_os_log_written', '24557056'
  287. 'Innodb_page_size', '16384'
  288. 'Innodb_pages_created', '439'
  289. 'Innodb_pages_read', '551006'
  290. 'Innodb_pages0_read', '1535'
  291. 'Innodb_pages_written', '33499'
  292. 'Innodb_row_lock_current_waits', '0'
  293. 'Innodb_row_lock_time', '1105'
  294. 'Innodb_row_lock_time_avg', '50'
  295. 'Innodb_row_lock_time_max', '291'
  296. 'Innodb_row_lock_waits', '22'
  297. 'Innodb_rows_deleted', '350'
  298. 'Innodb_rows_inserted', '716'
  299. 'Innodb_rows_read', '1346902191'
  300. 'Innodb_rows_updated', '4935'
  301. 'Innodb_system_rows_deleted', '0'
  302. 'Innodb_system_rows_inserted', '0'
  303. 'Innodb_system_rows_read', '0'
  304. 'Innodb_system_rows_updated', '0'
  305. 'Innodb_num_open_files', '1539'
  306. 'Innodb_truncated_status_writes', '0'
  307. 'Innodb_available_undo_logs', '128'
  308. 'Innodb_undo_truncations', '0'
  309. 'Innodb_page_compression_saved', '0'
  310. 'Innodb_num_index_pages_written', '0'
  311. 'Innodb_num_non_index_pages_written', '0'
  312. 'Innodb_num_pages_page_compressed', '0'
  313. 'Innodb_num_page_compressed_trim_op', '0'
  314. 'Innodb_num_pages_page_decompressed', '0'
  315. 'Innodb_num_pages_page_compression_error', '0'
  316. 'Innodb_num_pages_encrypted', '0'
  317. 'Innodb_num_pages_decrypted', '0'
  318. 'Innodb_have_lz4', 'OFF'
  319. 'Innodb_have_lzo', 'OFF'
  320. 'Innodb_have_lzma', 'ON'
  321. 'Innodb_have_bzip2', 'OFF'
  322. 'Innodb_have_snappy', 'OFF'
  323. 'Innodb_have_punch_hole', 'ON'
  324. 'Innodb_defragment_compression_failures', '0'
  325. 'Innodb_defragment_failures', '0'
  326. 'Innodb_defragment_count', '0'
  327. 'Innodb_onlineddl_rowlog_rows', '0'
  328. 'Innodb_onlineddl_rowlog_pct_used', '0'
  329. 'Innodb_onlineddl_pct_progress', '0'
  330. 'Innodb_secondary_index_triggered_cluster_reads', '8679571'
  331. 'Innodb_secondary_index_triggered_cluster_reads_avoided', '0'
  332. 'Innodb_encryption_rotation_pages_read_from_cache', '0'
  333. 'Innodb_encryption_rotation_pages_read_from_disk', '0'
  334. 'Innodb_encryption_rotation_pages_modified', '0'
  335. 'Innodb_encryption_rotation_pages_flushed', '0'
  336. 'Innodb_encryption_rotation_estimated_iops', '0'
  337. 'Innodb_encryption_key_rotation_list_length', '0'
  338. 'Innodb_encryption_n_merge_blocks_encrypted', '0'
  339. 'Innodb_encryption_n_merge_blocks_decrypted', '0'
  340. 'Innodb_encryption_n_rowlog_blocks_encrypted', '0'
  341. 'Innodb_encryption_n_rowlog_blocks_decrypted', '0'
  342. 'Innodb_scrub_background_page_reorganizations', '0'
  343. 'Innodb_scrub_background_page_splits', '0'
  344. 'Innodb_scrub_background_page_split_failures_underflow', '0'
  345. 'Innodb_scrub_background_page_split_failures_out_of_filespace', '0'
  346. 'Innodb_scrub_background_page_split_failures_missing_index', '0'
  347. 'Innodb_scrub_background_page_split_failures_unknown', '0'
  348. 'Innodb_scrub_log', '0'
  349. 'Innodb_encryption_num_key_requests', '0'
  350. 'Key_blocks_not_flushed', '0'
  351. 'Key_blocks_unused', '26785'
  352. 'Key_blocks_used', '0'
  353. 'Key_blocks_warm', '0'
  354. 'Key_read_requests', '0'
  355. 'Key_reads', '0'
  356. 'Key_write_requests', '0'
  357. 'Key_writes', '0'
  358. 'Last_query_cost', '0.000000'
  359. 'Master_gtid_wait_count', '0'
  360. 'Master_gtid_wait_time', '0'
  361. 'Master_gtid_wait_timeouts', '0'
  362. 'Max_statement_time_exceeded', '0'
  363. 'Max_used_connections', '9'
  364. 'Memory_used', '412089296'
  365. 'Not_flushed_delayed_rows', '0'
  366. 'Open_files', '26'
  367. 'Open_streams', '0'
  368. 'Open_table_definitions', '90'
  369. 'Open_tables', '226'
  370. 'Opened_files', '63355'
  371. 'Opened_plugin_libraries', '0'
  372. 'Opened_table_definitions', '93'
  373. 'Opened_tables', '235'
  374. 'Opened_views', '0'
  375. 'Performance_schema_accounts_lost', '0'
  376. 'Performance_schema_cond_classes_lost', '0'
  377. 'Performance_schema_cond_instances_lost', '0'
  378. 'Performance_schema_digest_lost', '0'
  379. 'Performance_schema_file_classes_lost', '0'
  380. 'Performance_schema_file_handles_lost', '0'
  381. 'Performance_schema_file_instances_lost', '0'
  382. 'Performance_schema_hosts_lost', '0'
  383. 'Performance_schema_locker_lost', '0'
  384. 'Performance_schema_mutex_classes_lost', '0'
  385. 'Performance_schema_mutex_instances_lost', '0'
  386. 'Performance_schema_rwlock_classes_lost', '0'
  387. 'Performance_schema_rwlock_instances_lost', '0'
  388. 'Performance_schema_session_connect_attrs_lost', '0'
  389. 'Performance_schema_socket_classes_lost', '0'
  390. 'Performance_schema_socket_instances_lost', '0'
  391. 'Performance_schema_stage_classes_lost', '0'
  392. 'Performance_schema_statement_classes_lost', '0'
  393. 'Performance_schema_table_handles_lost', '0'
  394. 'Performance_schema_table_instances_lost', '0'
  395. 'Performance_schema_thread_classes_lost', '0'
  396. 'Performance_schema_thread_instances_lost', '0'
  397. 'Performance_schema_users_lost', '0'
  398. 'Prepared_stmt_count', '0'
  399. 'Qcache_free_blocks', '66'
  400. 'Qcache_free_memory', '95869800'
  401. 'Qcache_hits', '37672'
  402. 'Qcache_inserts', '9946'
  403. 'Qcache_lowmem_prunes', '0'
  404. 'Qcache_not_cached', '7736'
  405. 'Qcache_queries_in_cache', '1403'
  406. 'Qcache_total_blocks', '53978'
  407. 'Queries', '104672'
  408. 'Questions', '104672'
  409. 'Rows_read', '788941284'
  410. 'Rows_sent', '601883'
  411. 'Rows_tmp_read', '28147757'
  412. 'Rpl_status', 'AUTH_MASTER'
  413. 'Select_full_join', '6864'
  414. 'Select_full_range_join', '48'
  415. 'Select_range', '7627'
  416. 'Select_range_check', '26'
  417. 'Select_scan', '17137'
  418. 'Slave_connections', '0'
  419. 'Slave_heartbeat_period', '0.000'
  420. 'Slave_open_temp_tables', '0'
  421. 'Slave_received_heartbeats', '0'
  422. 'Slave_retried_transactions', '0'
  423. 'Slave_running', 'OFF'
  424. 'Slave_skipped_errors', '0'
  425. 'Slaves_connected', '0'
  426. 'Slaves_running', '0'
  427. 'Slow_launch_threads', '0'
  428. 'Slow_queries', '33'
  429. 'Sort_merge_passes', '22'
  430. 'Sort_priority_queue_sorts', '471'
  431. 'Sort_range', '528'
  432. 'Sort_rows', '10022396'
  433. 'Sort_scan', '11681'
  434. 'Ssl_accept_renegotiates', '0'
  435. 'Ssl_accepts', '0'
  436. 'Ssl_callback_cache_hits', '0'
  437. 'Ssl_cipher', ''
  438. 'Ssl_cipher_list', ''
  439. 'Ssl_client_connects', '0'
  440. 'Ssl_connect_renegotiates', '0'
  441. 'Ssl_ctx_verify_depth', '0'
  442. 'Ssl_ctx_verify_mode', '0'
  443. 'Ssl_default_timeout', '0'
  444. 'Ssl_finished_accepts', '0'
  445. 'Ssl_finished_connects', '0'
  446. 'Ssl_server_not_after', ''
  447. 'Ssl_server_not_before', ''
  448. 'Ssl_session_cache_hits', '0'
  449. 'Ssl_session_cache_misses', '0'
  450. 'Ssl_session_cache_mode', 'NONE'
  451. 'Ssl_session_cache_overflows', '0'
  452. 'Ssl_session_cache_size', '0'
  453. 'Ssl_session_cache_timeouts', '0'
  454. 'Ssl_sessions_reused', '0'
  455. 'Ssl_used_session_cache_entries', '0'
  456. 'Ssl_verify_depth', '0'
  457. 'Ssl_verify_mode', '0'
  458. 'Ssl_version', ''
  459. 'Subquery_cache_hit', '10'
  460. 'Subquery_cache_miss', '1074'
  461. 'Syncs', '165'
  462. 'Table_locks_immediate', '20'
  463. 'Table_locks_waited', '0'
  464. 'Tc_log_max_pages_used', '0'
  465. 'Tc_log_page_size', '0'
  466. 'Tc_log_page_waits', '0'
  467. 'Threadpool_idle_threads', '0'
  468. 'Threadpool_threads', '0'
  469. 'Threads_cached', '6'
  470. 'Threads_connected', '3'
  471. 'Threads_created', '9'
  472. 'Threads_running', '1'
  473. 'Update_scan', '0'
  474. 'Uptime', '11063'
  475. 'Uptime_since_flush_status', '11063'
  476. 'wsrep_cluster_conf_id', '18446744073709551615'
  477. 'wsrep_cluster_size', '0'
  478. 'wsrep_cluster_state_uuid', ''
  479. 'wsrep_cluster_status', 'Disconnected'
  480. 'wsrep_connected', 'OFF'
  481. 'wsrep_local_bf_aborts', '0'
  482. 'wsrep_local_index', '18446744073709551615'
  483. 'wsrep_provider_name', ''
  484. 'wsrep_provider_vendor', ''
  485. 'wsrep_provider_version', ''
  486. 'wsrep_ready', 'OFF'
  487. 'wsrep_thread_count', '0'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement