MySQL状态参数列表-范文、应用文-IT技术专栏-数据库-范文大全-在线学习网

网站首页汉语字词英语词汇考试资料写作素材旧版资料

标题	MySQL状态参数列表
范文	mysql> show status; +-----------------------------------+-----------+ \| Variable_name \| Value \| +-----------------------------------+-----------+ \| Aborted_clients \| 0 \| \| Aborted_connects \| 0 \| \| Binlog_cache_disk_use \| 0 \| \| Binlog_cache_use \| 0 \| \| Bytes_received \| 265 \| \| Bytes_sent \| 2597 \| \| Com_admin_commands \| 0 \| \| Com_assign_to_keycache \| 0 \| \| Com_alter_db \| 0 \| \| Com_alter_db_upgrade \| 0 \| \| Com_alter_event \| 0 \| \| Com_alter_function \| 0 \| \| Com_alter_procedure \| 0 \| \| Com_alter_server \| 0 \| \| Com_alter_table \| 0 \| \| Com_alter_tablespace \| 0 \| \| Com_analyze \| 0 \| \| Com_backup_table \| 0 \| \| Com_begin \| 0 \| \| Com_binlog \| 0 \| \| Com_call_procedure \| 0 \| \| Com_change_db \| 2 \| \| Com_change_master \| 0 \| \| Com_check \| 0 \| \| Com_checksum \| 0 \| \| Com_commit \| 0 \| \| Com_create_db \| 0 \| \| Com_create_event \| 0 \| \| Com_create_function \| 0 \| \| Com_create_index \| 0 \| \| Com_create_procedure \| 0 \| \| Com_create_server \| 0 \| \| Com_create_table \| 0 \| \| Com_create_trigger \| 0 \| \| Com_create_udf \| 0 \| \| Com_create_user \| 0 \| \| Com_create_view \| 0 \| \| Com_dealloc_sql \| 0 \| \| Com_delete \| 0 \| \| Com_delete_multi \| 0 \| \| Com_do \| 0 \| \| Com_drop_db \| 0 \| \| Com_drop_event \| 0 \| \| Com_drop_function \| 0 \| \| Com_drop_index \| 0 \| \| Com_drop_procedure \| 0 \| \| Com_drop_server \| 0 \| \| Com_drop_table \| 0 \| \| Com_drop_trigger \| 0 \| \| Com_drop_user \| 0 \| \| Com_drop_view \| 0 \| \| Com_empty_query \| 0 \| \| Com_execute_sql \| 0 \| \| Com_flush \| 0 \| \| Com_grant \| 0 \| \| Com_ha_close \| 0 \| \| Com_ha_open \| 0 \| \| Com_ha_read \| 0 \| \| Com_help \| 0 \| \| Com_insert \| 0 \| \| Com_insert_select \| 0 \| \| Com_install_plugin \| 0 \| \| Com_kill \| 0 \| \| Com_load \| 0 \| \| Com_load_master_data \| 0 \| \| Com_load_master_table \| 0 \| \| Com_lock_tables \| 0 \| \| Com_optimize \| 0 \| \| Com_preload_keys \| 0 \| \| Com_prepare_sql \| 0 \| \| Com_purge \| 0 \| \| Com_purge_before_date \| 0 \| \| Com_release_savepoint \| 0 \| \| Com_rename_table \| 0 \| \| Com_rename_user \| 0 \| \| Com_repair \| 0 \| \| Com_replace \| 0 \| \| Com_replace_select \| 0 \| \| Com_reset \| 0 \| \| Com_restore_table \| 0 \| \| Com_revoke \| 0 \| \| Com_revoke_all \| 0 \| \| Com_rollback \| 0 \| \| Com_rollback_to_savepoint \| 0 \| \| Com_savepoint \| 0 \| \| Com_select \| 5 \| \| Com_set_option \| 0 \| \| Com_show_authors \| 0 \| \| Com_show_binlog_events \| 0 \| \| Com_show_binlogs \| 0 \| \| Com_show_charsets \| 0 \| \| Com_show_collations \| 0 \| \| Com_show_column_types \| 0 \| \| Com_show_contributors \| 0 \| \| Com_show_create_db \| 0 \| \| Com_show_create_event \| 0 \| \| Com_show_create_func \| 0 \| \| Com_show_create_proc \| 0 \| \| Com_show_create_table \| 0 \| \| Com_show_create_trigger \| 0 \| \| Com_show_databases \| 0 \| \| Com_show_engine_logs \| 0 \| \| Com_show_engine_mutex \| 0 \| \| Com_show_engine_status \| 0 \| \| Com_show_events \| 0 \| \| Com_show_errors \| 0 \| \| Com_show_fields \| 0 \| \| Com_show_function_status \| 0 \| \| Com_show_grants \| 0 \| \| Com_show_keys \| 0 \| \| Com_show_master_status \| 0 \| \| Com_show_new_master \| 0 \| \| Com_show_open_tables \| 0 \| \| Com_show_plugins \| 0 \| \| Com_show_privileges \| 0 \| \| Com_show_procedure_status \| 0 \| \| Com_show_processlist \| 0 \| \| Com_show_profile \| 0 \| \| Com_show_profiles \| 0 \| \| Com_show_slave_hosts \| 0 \| \| Com_show_slave_status \| 0 \| \| Com_show_status \| 1 \| \| Com_show_storage_engines \| 0 \| \| Com_show_table_status \| 0 \| \| Com_show_tables \| 0 \| \| Com_show_triggers \| 0 \| \| Com_show_variables \| 0 \| \| Com_show_warnings \| 0 \| \| Com_slave_start \| 0 \| \| Com_slave_stop \| 0 \| \| Com_stmt_close \| 0 \| \| Com_stmt_execute \| 0 \| \| Com_stmt_fetch \| 0 \| \| Com_stmt_prepare \| 0 \| \| Com_stmt_reprepare \| 0 \| \| Com_stmt_reset \| 0 \| \| Com_stmt_send_long_data \| 0 \| \| Com_truncate \| 0 \| \| Com_uninstall_plugin \| 0 \| \| Com_unlock_tables \| 0 \| \| Com_update \| 0 \| \| Com_update_multi \| 0 \| \| Com_xa_commit \| 0 \| \| Com_xa_end \| 0 \| \| Com_xa_prepare \| 0 \| \| Com_xa_recover \| 0 \| \| Com_xa_rollback \| 0 \| \| Com_xa_start \| 0 \| \| Compression \| OFF \| \| Connections \| 3 \| \| Created_tmp_disk_tables \| 0 \| \| Created_tmp_files \| 5 \| \| Created_tmp_tables \| 0 \| \| Delayed_errors \| 0 \| \| Delayed_insert_threads \| 0 \| \| Delayed_writes \| 0 \| \| Flush_commands \| 1 \| \| Handler_commit \| 0 \| \| Handler_delete \| 0 \| \| Handler_discover \| 0 \| \| Handler_prepare \| 0 \| \| Handler_read_first \| 0 \| \| Handler_read_key \| 0 \| \| Handler_read_next \| 0 \| \| Handler_read_prev \| 0 \| \| Handler_read_rnd \| 0 \| \| Handler_read_rnd_next \| 1 \| \| Handler_rollback \| 0 \| \| Handler_savepoint \| 0 \| \| Handler_savepoint_rollback \| 0 \| \| Handler_update \| 0 \| \| Handler_write \| 0 \| \| Innodb_buffer_pool_pages_data \| 103 \| \| Innodb_buffer_pool_pages_dirty \| 0 \| \| Innodb_buffer_pool_pages_flushed \| 3 \| \| Innodb_buffer_pool_pages_free \| 409 \| \| Innodb_buffer_pool_pages_misc \| 0 \| \| Innodb_buffer_pool_pages_total \| 512 \| \| Innodb_buffer_pool_read_ahead_rnd \| 2 \| \| Innodb_buffer_pool_read_ahead_seq \| 0 \| \| Innodb_buffer_pool_read_requests \| 3085 \| \| Innodb_buffer_pool_reads \| 87 \| \| Innodb_buffer_pool_wait_free \| 0 \| \| Innodb_buffer_pool_write_requests \| 3 \| \| Innodb_data_fsyncs \| 11 \| \| Innodb_data_pending_fsyncs \| 0 \| \| Innodb_data_pending_reads \| 0 \| \| Innodb_data_pending_writes \| 0 \| \| Innodb_data_read \| 3870720 \| \| Innodb_data_reads \| 113 \| \| Innodb_data_writes \| 12 \| \| Innodb_data_written \| 101888 \| \| Innodb_dblwr_pages_written \| 3 \| \| Innodb_dblwr_writes \| 2 \| \| Innodb_log_waits \| 0 \| \| Innodb_log_write_requests \| 0 \| \| Innodb_log_writes \| 3 \| \| Innodb_os_log_fsyncs \| 7 \| \| Innodb_os_log_pending_fsyncs \| 0 \| \| Innodb_os_log_pending_writes \| 0 \| \| Innodb_os_log_written \| 1536 \| \| Innodb_page_size \| 16384 \| \| Innodb_pages_created \| 0 \| \| Innodb_pages_read \| 103 \| \| Innodb_pages_written \| 3 \| \| Innodb_row_lock_current_waits \| 0 \| \| Innodb_row_lock_time \| 0 \| \| Innodb_row_lock_time_avg \| 0 \| \| Innodb_row_lock_time_max \| 0 \| \| Innodb_row_lock_waits \| 0 \| \| Innodb_rows_deleted \| 0 \| \| Innodb_rows_inserted \| 0 \| \| Innodb_rows_read \| 0 \| \| Innodb_rows_updated \| 0 \| \| Key_blocks_not_flushed \| 0 \| \| Key_blocks_unused \| 14347 \| \| Key_blocks_used \| 0 \| \| Key_read_requests \| 0 \| \| Key_reads \| 0 \| \| Key_write_requests \| 0 \| \| Key_writes \| 0 \| \| Last_query_cost \| 11.508961 \| \| Max_used_connections \| 2 \| \| Not_flushed_delayed_rows \| 0 \| \| Open_files \| 6 \| \| Open_streams \| 0 \| \| Open_table_definitions \| 28 \| \| Open_tables \| 14 \| \| Opened_files \| 326 \| \| Opened_table_definitions \| 0 \| \| Opened_tables \| 0 \| \| Prepared_stmt_count \| 0 \| \| Qcache_free_blocks \| 0 \| \| Qcache_free_memory \| 0 \| \| Qcache_hits \| 0 \| \| Qcache_inserts \| 0 \| \| Qcache_lowmem_prunes \| 0 \| \| Qcache_not_cached \| 0 \| \| Qcache_queries_in_cache \| 0 \| \| Qcache_total_blocks \| 0 \| \| Questions \| 61 \| \| Rpl_status \| NULL \| \| Select_full_join \| 0 \| \| Select_full_range_join \| 0 \| \| Select_range \| 0 \| \| Select_range_check \| 0 \| \| Select_scan \| 1 \| \| Slave_open_temp_tables \| 0 \| \| Slave_retried_transactions \| 0 \| \| Slave_running \| OFF \| \| Slow_launch_threads \| 0 \| \| Slow_queries \| 0 \| \| Sort_merge_passes \| 0 \| \| Sort_range \| 0 \| \| Sort_rows \| 0 \| \| Sort_scan \| 0 \| \| Ssl_accept_renegotiates \| 0 \| \| Ssl_accepts \| 0 \| \| Ssl_callback_cache_hits \| 0 \| \| Ssl_cipher \| \| \| Ssl_cipher_list \| \| \| Ssl_client_connects \| 0 \| \| Ssl_connect_renegotiates \| 0 \| \| Ssl_ctx_verify_depth \| 0 \| \| Ssl_ctx_verify_mode \| 0 \| \| Ssl_default_timeout \| 0 \| \| Ssl_finished_accepts \| 0 \| \| Ssl_finished_connects \| 0 \| \| Ssl_session_cache_hits \| 0 \| \| Ssl_session_cache_misses \| 0 \| \| Ssl_session_cache_mode \| NONE \| \| Ssl_session_cache_overflows \| 0 \| \| Ssl_session_cache_size \| 0 \| \| Ssl_session_cache_timeouts \| 0 \| \| Ssl_sessions_reused \| 0 \| \| Ssl_used_session_cache_entries \| 0 \| \| Ssl_verify_depth \| 0 \| \| Ssl_verify_mode \| 0 \| \| Ssl_version \| \| \| Table_locks_immediate \| 33 \| \| Table_locks_waited \| 0 \| \| Tc_log_max_pages_used \| 0 \| \| Tc_log_page_size \| 0 \| \| Tc_log_page_waits \| 0 \| \| Threads_cached \| 0 \| \| Threads_connected \| 2 \| \| Threads_created \| 2 \| \| Threads_running \| 1 \| \| Uptime \| 6318 \| \| Uptime_since_flush_status \| 6318 \| +-----------------------------------+-----------+ 290 rows in set (0.14 sec) 打印MySQL的状态参数列表，便于查询和阅读。
随便看	高三家长会学生代表发言稿高三家长会学生发言稿高三家长会发言稿范文高三家长会家长代表发言稿2023 教师节精选高中作文800字诚信让生活更美好作文范文2022 红楼梦读后感800字范文6篇精选高二关于传统文化的议论文五篇五四运动演讲稿500字范文精选5篇 2020最美的声音高一作文记叙文 2020高三作文美丽中国800字范文高中传统文化作文800字十篇语文的学习方法是什么最新语文学习方法总结关于语文的学习方法关于语文学习方法高中弘扬中华传统文化议论文古代文化常识知识点总结大全幼儿园教师个人工作计划2022下半年八篇八年级语文教研计划7篇初中语文阅读理解答题技巧有哪些高考语文新闻类文本阅读答题技巧高考语文答题技巧方法有哪些最新中考语文阅读答题技巧方法做语文卷子的答题技巧方法 labor-force labor-intensive labor-intensive laborious laboriously laborious process laborious task laborious work labor law labor-law 幽渺幽灵幽玄幽禁幽秘幽美幽艳幽芳幽越幽邃常州市2015年胡威已具备电力工程专业中级专业技术资格的通知常州市2015年李永莉已具备播音专业高级专业技术资格的通知 2015年常州市李爱权已具备环保工程高级专业技术资格的通知 2015年常州市597人已具备卫生/护理/社区卫生专业高级专业技术资格的通知 2015年常州市殷强已具备二级律师高级专业技术资格的通知常州市2014年度医学工程/卫生管理专业技术资格考试结果的通知 2015年常州市2人已具备地矿工程专业高级专业技术资格的通知 2015年常州市370人具备建设工程专业中级专业技术资格的通知 2015年常州市叶真如等14人具备纺织工程专业中级专业技术资格的通知 2014年青岛市黄岛区党校教师职务高级资格评审结果通知

在线学习网范文大全提供好词好句、学习总结、工作总结、演讲稿等写作素材及范文模板，是学习及工作的有利工具。