午夜国产狂喷潮在线观看|国产AⅤ精品一区二区久久|中文字幕AV中文字幕|国产看片高清在线

    MySQL狀態(tài)參數(shù)列表
    來源:易賢網(wǎng) 閱讀:1170 次 日期:2014-09-17 16:17:31
    溫馨提示:易賢網(wǎng)小編為您整理了“MySQL狀態(tài)參數(shù)列表”,方便廣大網(wǎng)友查閱!

    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的狀態(tài)參數(shù)列表,便于查詢和閱讀。

    更多信息請查看IT技術(shù)專欄

    更多信息請查看數(shù)據(jù)庫
    易賢網(wǎng)手機(jī)網(wǎng)站地址:MySQL狀態(tài)參數(shù)列表
    由于各方面情況的不斷調(diào)整與變化,易賢網(wǎng)提供的所有考試信息和咨詢回復(fù)僅供參考,敬請考生以權(quán)威部門公布的正式信息和咨詢?yōu)闇?zhǔn)!

    2025國考·省考課程試聽報名

    • 報班類型
    • 姓名
    • 手機(jī)號
    • 驗(yàn)證碼
    關(guān)于我們 | 聯(lián)系我們 | 人才招聘 | 網(wǎng)站聲明 | 網(wǎng)站幫助 | 非正式的簡要咨詢 | 簡要咨詢須知 | 新媒體/短視頻平臺 | 手機(jī)站點(diǎn) | 投訴建議
    工業(yè)和信息化部備案號:滇ICP備2023014141號-1 云南省教育廳備案號:云教ICP備0901021 滇公網(wǎng)安備53010202001879號 人力資源服務(wù)許可證:(云)人服證字(2023)第0102001523號
    云南網(wǎng)警備案專用圖標(biāo)
    聯(lián)系電話:0871-65099533/13759567129 獲取招聘考試信息及咨詢關(guān)注公眾號:hfpxwx
    咨詢QQ:1093837350(9:00—18:00)版權(quán)所有:易賢網(wǎng)
    云南網(wǎng)警報警專用圖標(biāo)