리눅스 쉘에서 mysqladmin으로 MYSQL의 현재 상황 자세히 살펴보기

[root@file bin]# pwd

/usr/local/mysql/bin

[root@file bin]#

[root@file bin]# ./mysqladmin -u root -p extended-status

Enter password: ********

+--------------------------+-------+

| Variable_name            | Value |

+--------------------------+-------+

| Aborted_clients          | 0     |

| Aborted_connects         | 1     |

| Bytes_received           | 867   |

| Bytes_sent               | 7192  |

| Com_admin_commands       | 0     |

| Com_alter_table          | 0     |

| Com_analyze              | 0     |

| Com_backup_table         | 0     |

| Com_begin                | 0     |

| Com_change_db            | 2     |

| Com_change_master        | 0     |

| Com_check                | 0     |

| Com_commit               | 0     |

| Com_create_db            | 1     |

| Com_create_function      | 0     |

| Com_create_index         | 0     |

| Com_create_table         | 0     |

| Com_delete               | 0     |

| Com_delete_multi         | 0     |

| Com_drop_db              | 9     |

| Com_drop_function        | 0     |

| Com_drop_index           | 0     |

| Com_drop_table           | 0     |

| Com_flush                | 1     |

| Com_grant                | 0     |

| Com_ha_close             | 0     |

| Com_ha_open              | 0     |

| Com_ha_read              | 0     |

| Com_insert               | 0     |

| Com_insert_select        | 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_purge                | 0     |

| Com_rename_table         | 0     |

| Com_repair               | 0     |

| Com_replace              | 0     |

| Com_replace_select       | 0     |

| Com_reset                | 0     |

| Com_restore_table        | 0     |

| Com_revoke               | 0     |

| Com_rollback             | 0     |

| Com_savepoint            | 0     |

| Com_select               | 0     |

| Com_set_option           | 0     |

| Com_show_binlog_events   | 0     |

| Com_show_binlogs         | 0     |

| Com_show_create          | 0     |

| Com_show_databases       | 8     |

| Com_show_fields          | 12    |

| Com_show_grants          | 0     |

| Com_show_keys            | 0     |

| Com_show_logs            | 0     |

| Com_show_master_status   | 0     |

| Com_show_new_master      | 0     |

| Com_show_open_tables     | 0     |

| Com_show_processlist     | 0     |

| Com_show_slave_hosts     | 0     |

| Com_show_slave_status    | 0     |

| Com_show_status          | 1     |

| Com_show_innodb_status   | 0     |

| Com_show_tables          | 5     |

| Com_show_variables       | 0     |

| Com_slave_start          | 0     |

| Com_slave_stop           | 0     |

| Com_truncate             | 0     |

| Com_unlock_tables        | 0     |

| Com_update               | 0     |

| Connections              | 7     |

| Created_tmp_disk_tables  | 0     |

| Created_tmp_tables       | 0     |

| Created_tmp_files        | 0     |

| Delayed_insert_threads   | 0     |

| Delayed_writes           | 0     |

| Delayed_errors           | 0     |

| Flush_commands           | 1     |

| Handler_commit           | 0     |

| Handler_delete           | 0     |

| Handler_read_first       | 2     |

| Handler_read_key         | 0     |

| Handler_read_next        | 0     |

| Handler_read_prev        | 0     |

| Handler_read_rnd         | 0     |

| Handler_read_rnd_next    | 47    |

| Handler_rollback         | 1     |

| Handler_update           | 0     |

| Handler_write            | 0     |

| Key_blocks_used          | 0     |

| Key_read_requests        | 0     |

| Key_reads                | 0     |

| Key_write_requests       | 0     |

| Key_writes               | 0     |

| Max_used_connections     | 1     |

| Not_flushed_key_blocks   | 0     |

| Not_flushed_delayed_rows | 0     |

| Open_tables              | 1     |

| Open_files               | 2     |

| Open_streams             | 0     |

| Opened_tables            | 12    |

| Questions                | 42    |

| Qcache_queries_in_cache  | 0     |

| Qcache_inserts           | 0     |

| Qcache_hits              | 0     |

| Qcache_lowmem_prunes     | 0     |

| Qcache_not_cached        | 0     |

| Qcache_free_memory       | 0     |

| Qcache_free_blocks       | 0     |

| Qcache_total_blocks      | 0     |

| Rpl_status               | NULL  |

| Select_full_join         | 0     |

| Select_full_range_join   | 0     |

| Select_range             | 0     |

| Select_range_check       | 0     |

| Select_scan              | 0     |

| Slave_open_temp_tables   | 0     |

| Slave_running            | OFF   |

| Slow_launch_threads      | 0     |

| Slow_queries             | 0     |

| Sort_merge_passes        | 0     |

| Sort_range               | 0     |

| Sort_rows                | 0     |

| Sort_scan                | 0     |

| Table_locks_immediate    | 11    |

| Table_locks_waited       | 0     |

| Threads_cached           | 0     |

| Threads_created          | 6     |

| Threads_connected        | 2     |

| Threads_running          | 1     |

| Uptime                   | 374   |

+--------------------------+-------+

[root@file bin]#

[root@file bin]# ./mysql -u root -p mysql

Enter password: ********

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 4 to server version: 4.0.14

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

mysql> show status;

+--------------------------+-------+

| Variable_name            | Value |

+--------------------------+-------+

| Aborted_clients          | 0     |

| Aborted_connects         | 0     |

| Bytes_received           | 299   |

| Bytes_sent               | 3056  |

| Com_admin_commands       | 0     |

| Com_alter_table          | 0     |

| Com_analyze              | 0     |

…..
…..