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)

你只要将email发到[email protected],就要以订阅MySQL
的邮件列表。而当你要取消订阅时,只要将email发到[email protected]就行了。
你所发出的这些email只有地址是有意义的,主题和内容都将被忽略。如果你的回复地址无效,能可以明确指定你的地址。你可以将你的地址插入到我们的地址时,并将你的地址中的“@”换为“=”比如,你要注册[email protected],你可以将email发到mysql-subscribe-
[email protected]。
发到[email protected]和[email protected]的邮件是由ezmlm自动处理的,有关ezmlm的信息可以参看ezmlm的网站。
你要自己发布消息,可以将email发到[email protected],但是不要将订阅或取消订阅的信息发到这个信箱中,因为发到这个信箱中的所有信息会自动转发到数以千计的其他用户。
你的本地站点可能计阅了许多份[email protected],如果是这样的话,你的本地站点可能存在着一个邮件列表。在这种情况下,请你联系你们的系统管理员进行处理。
目前的MySQL邮件列表包括:
announce
这是用来发布新版本的MySQL及相关程序的通告。这个邮件内容不多,我们认为所有的MySQL及户都应该拥有。
mysql
这里主要计论一般的MySQL问题,请注意这里的有些问题论述得比专业的更好,如果你把错误发布出来,你也许可以得到一个答案!
mysql-digest
前面MySQL的分类列表,这意味着你每可以得到所有个别的消息而不用收到一个硕大的邮件。
bugs
在这里,你只能用mysqlbug
script发布一些完整的、可重复的bug报告,如果你是在windows环境下运行的话,你还必须对你的操作系统以及MySQL版本进行描述)。在你发布前,你最好用最新的MySQL版本进行测试!所有人都应该能够通过使用mysql
test <
script对该bug进行重复。所有在这儿提出的bug都将在下一个MySQL版本中得到改正!如果只牵涉到一些小的代码变动的话,我们也可能发布一些补丁进行纠正。
bugs-digest
bugs的分类列表
developer
这和下面的internals基本差不多。
developer-digest
这和下面的internals-digest基本差不多。
internals
为从事MySQL代码设计工作的人员准备的。在这里人们可以计论MySQL的发展,也可以发布补丁
internals-digest
internals的分类列表。
java
讨论MySQL和Java。主要是关于JDBC drivers.
java-digest
java的分类列表。
win32
关于所有MySQL在Microsoft操作系统例如:Win95, Win98, NT, and
Win2000)下运行的问题
win32-digest
win32的分类列表。
myodbc
关于使用ODBC连接MySQL的所有问题。
myodbc-digest
myodbc的分类列表。
plusplus
关于C++对MySQL的编程接口的设计。
plusplus-digest
plusplus的分类列表。
msql-mysql-modules
关于MySQL的Perl支持。
msql-mysql-modules-digest
msql-mysql-modules的分类列表。
订阅或取消订阅所有邮件列表的方法都和上面介绍的方法一样,只是用适当的词代替mysq就行了。例如,订阅或取消订阅myodbc,应该发送信息到[email protected]或myodbc-
[email protected]。

打印MySQL的状态参数列表,便于查询和阅读。

 protected]](
的邮件列表。而当你要取消订阅时,只要将email发到[email protected]就行…

相关文章

发表评论

电子邮件地址不会被公开。 必填项已用*标注

网站地图xml地图