| Performance_schema_table_handles_lost |
| Performance_schema_table_instances_lost |
| Performance_schema_thread_classes_lost |
| Performance_schema_thread_instances_lost |
| Performance_schema_users_lost |
+-----------------------------------------------+-------+
23 rows in set (0.00 sec)
24
数据库安全之ssl连接的状态20+个：
mysql> show status like 'ssl_%';
+--------------------------------+-------+
| Variable_name | Value |
+--------------------------------+-------+
| Ssl_accept_renegotiates |
| Ssl_accepts |
| Ssl_callback_cache_hits |
| Ssl_cipher |
| Ssl_cipher_list |
| Ssl_client_connects |
| Ssl_connect_renegotiates |
| Ssl_ctx_verify_depth |
| Ssl_ctx_verify_mode |
| Ssl_default_timeout |
| Ssl_finished_accepts |
| Ssl_finished_connects |
| Ssl_server_not_after |
| Ssl_server_not_before |
| Ssl_session_cache_hits |
| Ssl_session_cache_misses |
| Ssl_session_cache_mode |
| Ssl_session_cache_overflows |
| Ssl_session_cache_size |
| Ssl_session_cache_timeouts |
| Ssl_sessions_reused |
| Ssl_used_session_cache_entries |
| Ssl_verify_depth |
| Ssl_verify_mode |
| Ssl_version |
+--------------------------------+-------+
25 rows in set (0.00 sec)
25
统计各种数据库操作的数量 的状态：
mysql> show status like 'com_%';
+---------------------------+-------+
| Variable_name | Value |
+---------------------------+-------+
| Com_admin_commands |
| Com_assign_to_keycache |
| Com_alter_db |
| Com_alter_db_upgrade |
| Com_alter_event |
| Com_alter_function |
| Com_alter_procedure |
| Com_alter_server |
| Com_alter_table |
| Com_alter_tablespace |
| Com_alter_user |
| Com_analyze |
| Com_begin |
| Com_binlog |
| Com_call_procedure |
| Com_change_db |
| Com_change_master |
| Com_check |
| Com_checksum |
| Com_commit |
| Com_create_db |
| Com_create_event |
| Com_create_function |
| Com_create_index |
| Com_create_procedure |
| Com_create_table |
| Com_create_trigger |
| Com_create_udf |
| Com_create_user |
| Com_create_view |
| Com_dealloc_sql |
| Com_delete |
| Com_delete_multi |
| Com_do |
| Com_drop_db |
| Com_drop_event |
| Com_drop_function |
| Com_drop_index |
| Com_drop_procedure |
| Com_drop_server |
| Com_drop_table |
| Com_drop_trigger |
| Com_drop_user |
| Com_drop_view |
| Com_empty_query |
| Com_execute_sql |
| Com_flush |
| Com_get_diagnostics |
| Com_grant |
| Com_ha_close |
| Com_ha_open |
| Com_ha_read |
| Com_help |
| Com_insert |
| Com_insert_select |
| Com_install_plugin |
| Com_kill |
| Com_load |
| Com_lock_tables |
| Com_optimize |
| Com_preload_keys |
| Com_prepare_sql |
| Com_purge |
| Com_purge_before_date |
| Com_release_savepoint |
| Com_rename_table |
| Com_rename_user |
| Com_repair |
| Com_replace |
| Com_replace_select |
| Com_reset |
| Com_resignal |
| Com_revoke |
| Com_revoke_all |
| Com_rollback |
| Com_rollback_to_savepoint |
| Com_savepoint |
| Com_select |
| Com_set_option |
| Com_signal |
| Com_show_binlog_events |
| Com_show_binlogs |
| Com_show_charsets |
| Com_show_collations |
| Com_show_create_db |
| Com_show_create_event |
| Com_show_create_func |
| Com_show_create_proc |
| Com_show_create_table |
| Com_show_create_trigger |
| Com_show_databases |
| Com_show_engine_logs |
| Com_show_engine_mutex |
| Com_show_engine_status |
| Com_show_events |
| Com_show_errors |
| Com_show_fields |
| C