Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> schow
-> show status\g
ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'schow
show status' at line 1
mysql> status
--------------
mysql Ver 12.22 Distrib 4.0.18, for suse-linux (i686)
Connection id: 11403223
Current database:
Current user: root@localhost
SSL: Not in use
Current pager: less
Using outfile: ''
Server version: 4.0.18-Max
Protocol version: 10
Connection: Localhost via UNIX socket
Client characterset: latin1
Server characterset: latin1
UNIX socket: /var/lib/mysql/mysql.sock
Uptime: 104 days 3 hours 24 min 0 sec
Threads: 1 Questions: 317854723 Slow queries: 2720 Opens: 3289228 Flush tables: 1 Open tables: 64 Queries per second avg: 35.326
--------------
mysql> show status\g
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 88 |
| Aborted_connects | 8006 |
| Bytes_received | 2602474935 |
| Bytes_sent | 460911960 |
| Com_admin_commands | 0 |
| Com_alter_table | 80 |
| Com_analyze | 1 |
| Com_backup_table | 0 |
| Com_begin | 0 |
| Com_change_db | 45602946 |
| Com_change_master | 0 |
| Com_check | 1 |
| Com_commit | 0 |
| Com_create_db | 43 |
| Com_create_function | 0 |
| Com_create_index | 0 |
| Com_create_table | 1846 |
| Com_delete | 4291870 |
| Com_delete_multi | 0 |
| Com_drop_db | 2 |
| Com_drop_function | 0 |
| Com_drop_index | 0 |
| Com_drop_table | 104 |
| Com_flush | 6 |
| Com_grant | 10 |
| Com_ha_close | 0 |
| Com_ha_open | 0 |
| Com_ha_read | 0 |
| Com_insert | 1944714 |
| Com_insert_select | 159 |
| Com_kill | 0 |
| Com_load | 0 |
| Com_load_master_data | 0 |
| Com_load_master_table | 0 |
| Com_lock_tables | 3020172 |
| Com_optimize | 1144210 |
| Com_purge | 0 |
| Com_rename_table | 35 |
| Com_repair | 2 |
| Com_replace | 3673778 |
| Com_replace_select | 0 |
| Com_reset | 0 |
| Com_restore_table | 0 |
| Com_revoke | 3 |
| Com_rollback | 0 |
| Com_savepoint | 0 |
| Com_select | 220631519 |
| Com_set_option | 378 |
| Com_show_binlog_events | 0 |
| Com_show_binlogs | 0 |
| Com_show_create | 378 |
| Com_show_databases | 1893 |
| Com_show_fields | 16708 |
| Com_show_grants | 120 |
| Com_show_keys | 38 |
| Com_show_logs | 0 |
| Com_show_master_status | 0 |
| Com_show_new_master | 0 |
| Com_show_open_tables | 0 |
| Com_show_processlist | 256 |
| Com_show_slave_hosts | 0 |
| Com_show_slave_status | 0 |
| Com_show_status | 6 |
| Com_show_innodb_status | 1 |
| Com_show_tables | 305676 |
| Com_show_variables | 8 |
| Com_slave_start | 0 |
| Com_slave_stop | 0 |
| Com_truncate | 210 |
| Com_unlock_tables | 3020173 |
| Com_update | 22733870 |
| Connections | 11403273 |
| Created_tmp_disk_tables | 3999089 |
| Created_tmp_tables | 6111148 |
| Created_tmp_files | 311 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_commit | 0 |
| Handler_delete | 2390300 |
| Handler_read_first | 15759309 |
| Handler_read_key | 977050178 |
| Handler_read_next | 3829460138 |
| Handler_read_prev | 202878746 |
| Handler_read_rnd | 1713370001 |
| Handler_read_rnd_next | 133799667 |
| Handler_rollback | 3 |
| Handler_update | 87475212 |
| Handler_write | 43283817 |
| Key_blocks_used | 15586 |
| Key_read_requests | 2063560650 |
| Key_reads | 66797070 |
| Key_write_requests | 51380713 |
| Key_writes | 23005743 |
| Max_used_connections | 100 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 63 |
| Open_files | 124 |
| Open_streams | 0 |
| Opened_tables | 3289231 |
| Questions | 317855260 |
| 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 | 7563 |
| Select_full_range_join | 49 |
| Select_range | 7853035 |
| Select_range_check | 0 |
| Select_scan | 55443929 |
| Slave_open_temp_tables | 0 |
| Slave_running | OFF |
| Slow_launch_threads | 71 |
| Slow_queries | 2720 |
| Sort_merge_passes | 7 |
| Sort_range | 12611617 |
| Sort_rows | 3390172086 |
| Sort_scan | 20703322 |
| Table_locks_immediate | 250939010 |
| Table_locks_waited | 2093905 |
| Threads_cached | 0 |
| Threads_created | 11403272 |
| Threads_connected | 1 |
| Threads_running | 1 |
| Uptime | 8997938 |
+--------------------------+------------+
132 rows in set (0.02 sec)
entwerder "mysqladmin -p status" oder "mysql -p" und dann "show status\g" in der mysql Eingabeaufforderung.