SHOW STATUS

From Meta, a Wikimedia project coordination wiki
Jump to navigation Jump to search

Suda, Sun Jun 6 12:13:29 UTC 2004

+--------------------------+------------+
| Variable_name            | Value      |
+--------------------------+------------+
| Aborted_clients          | 53         |
| Aborted_connects         | 1780       |
| Bytes_received           | 4020486827 |
| Bytes_sent               | 639257988  |
| Com_admin_commands       | 1972       |
| Com_alter_table          | 299        |
| Com_analyze              | 0          |
| Com_backup_table         | 0          |
| Com_begin                | 2865746    |
| Com_change_db            | 3604439    |
| Com_change_master        | 0          |
| Com_check                | 0          |
| Com_commit               | 2691735    |
| Com_create_db            | 0          |
| Com_create_function      | 0          |
| Com_create_index         | 0          |
| Com_create_table         | 582        |
| Com_delete               | 213388     |
| Com_delete_multi         | 12065      |
| Com_drop_db              | 0          |
| Com_drop_function        | 0          |
| Com_drop_index           | 0          |
| Com_drop_table           | 293        |
| Com_flush                | 0          |
| Com_grant                | 2          |
| Com_ha_close             | 0          |
| Com_ha_open              | 0          |
| Com_ha_read              | 0          |
| Com_insert               | 192452     |
| Com_insert_select        | 80427      |
| Com_kill                 | 0          |
| Com_load                 | 0          |
| Com_load_master_data     | 0          |
| Com_load_master_table    | 0          |
| Com_lock_tables          | 1330       |
| Com_optimize             | 0          |
| Com_purge                | 0          |
| Com_rename_table         | 147        |
| Com_repair               | 0          |
| Com_replace              | 142826     |
| Com_replace_select       | 0          |
| Com_reset                | 0          |
| Com_restore_table        | 0          |
| Com_revoke               | 0          |
| Com_rollback             | 0          |
| Com_savepoint            | 0          |
| Com_select               | 65105430   |
| Com_set_option           | 3372       |
| Com_show_binlog_events   | 0          |
| Com_show_binlogs         | 0          |
| Com_show_create          | 3372       |
| Com_show_databases       | 2          |
| Com_show_fields          | 3497171    |
| Com_show_grants          | 3          |
| Com_show_keys            | 3          |
| Com_show_logs            | 0          |
| Com_show_master_status   | 0          |
| Com_show_new_master      | 0          |
| Com_show_open_tables     | 0          |
| Com_show_processlist     | 7858       |
| Com_show_slave_hosts     | 0          |
| Com_show_slave_status    | 0          |
| Com_show_status          | 8277       |
| Com_show_innodb_status   | 2          |
| Com_show_tables          | 3484       |
| Com_show_variables       | 25         |
| Com_slave_start          | 0          |
| Com_slave_stop           | 0          |
| Com_truncate             | 1          |
| Com_unlock_tables        | 0          |
| Com_update               | 410618     |
| Connections              | 3604644    |
| Created_tmp_disk_tables  | 23548      |
| Created_tmp_tables       | 44730      |
| Created_tmp_files        | 7151       |
| Delayed_insert_threads   | 0          |
| Delayed_writes           | 7          |
| Delayed_errors           | 0          |
| Flush_commands           | 1          |
| Handler_commit           | 2692214    |
| Handler_delete           | 80618      |
| Handler_read_first       | 279700     |
| Handler_read_key         | 208939970  |
| Handler_read_next        | 968029677  |
| Handler_read_prev        | 1208       |
| Handler_read_rnd         | 2617754    |
| Handler_read_rnd_next    | 475546944  |
| Handler_rollback         | 3503868    |
| Handler_update           | 116776     |
| Handler_write            | 3440115    |
| Key_blocks_used          | 16216      |
| Key_read_requests        | 1311268    |
| Key_reads                | 8892       |
| Key_write_requests       | 279052     |
| Key_writes               | 30828      |
| Max_used_connections     | 800        |
| Not_flushed_key_blocks   | 0          |
| Not_flushed_delayed_rows | 0          |
| Open_tables              | 4000       |
| Open_files               | 881        |
| Open_streams             | 0          |
| Opened_tables            | 9034       |
| Questions                | 183785239  |
| Qcache_queries_in_cache  | 26569      |
| Qcache_inserts           | 14987486   |
| Qcache_hits              | 101335726  |
| Qcache_lowmem_prunes     | 149706     |
| Qcache_not_cached        | 50118032   |
| Qcache_free_memory       | 65686728   |
| Qcache_free_blocks       | 19713      |
| Qcache_total_blocks      | 74395      |
| Rpl_status               | NULL       |
| Select_full_join         | 382        |
| Select_full_range_join   | 0          |
| Select_range             | 129380     |
| Select_range_check       | 15157      |
| Select_scan              | 178057     |
| Slave_open_temp_tables   | 0          |
| Slave_running            | OFF        |
| Slow_launch_threads      | 0          |
| Slow_queries             | 3828       |
| Sort_merge_passes        | 0          |
| Sort_range               | 61052      |
| Sort_rows                | 13932910   |
| Sort_scan                | 49576      |
| Table_locks_immediate    | 66587672   |
| Table_locks_waited       | 12565      |
| Threads_cached           | 5          |
| Threads_created          | 420986     |
| Threads_connected        | 32         |
| Threads_running          | 2          |
| Uptime                   | 93615      |
+--------------------------+------------+
132 rows in set (0.02 sec)