List:General Discussion« Previous MessageNext Message »
From:Vincent Stoessel Date:March 31 1999 9:53pm
Subject:extended status explanation
View as plain text  
Hello Monty,
Thanks for adding the docs for show status,
You knew this was coming, can we get doc on the
extended status data? I would really like to know what 
all the values are telling me on this  server.
Soem I know already but what are the Key_*
and Handle_* stuff?

Thanks.

+--------------------------+-----------+
| Variable_name            | Value     |
+--------------------------+-----------+
| Aborted_clients          | 0         |
| Aborted_connects         | 0         |
| Created_tmp_tables       | 0         |
| Delayed_insert_threads   | 0         |
| Delayed_writes           | 0         |
| Delayed_errors           | 0         |
| Flush_commands           | 1         |
| Handler_delete           | 1701      |
| Handler_read_first       | 68        |
| Handler_read_key         | 5363785   |
| Handler_read_next        | 225871120 |
| Handler_read_rnd         | 94803494  |
| Handler_update           | 42556     |
| Handler_write            | 1755      |
| Key_blocks_used          | 1129      |
| Key_read_requests        | 16324051  |
| Key_reads                | 1117      |
| Key_write_requests       | 37253     |
| Key_writes               | 23510     |
| Max_used_connections     | 153       |
| Not_flushed_key_blocks   | 0         |
| Not_flushed_delayed_rows | 0         |
| Open_tables              | 91        |
| Open_files               | 48        |
| Open_streams             | 0         |
| Opened_tables            | 95        |
| Questions                | 429005    |
| Running_threads          | 127       |
| Slow_queries             | 84        |
| Uptime                   | 70015     |
+--------------------------+-----------+

-- 
Vincent Stoessel 
vince@stripped
Thread
extended status explanationVincent Stoessel1 Apr
  • extended status explanationMichael Widenius1 Apr
  • Re: extended status explanationKing Xaymaca3 Apr
  • Re: extended status explanationKing Xaymaca3 Apr