Jason Ho
Sun 18th Feb '01, 9:13am
SPUG.org MySQL Statisticsload averages: 1.41, 1.24, 1.13 20:50:10
Sun Feb 18 20:50:10 SGT 2001
+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| Aborted_clients | 0 |
| Aborted_connects | 16 |
| Created_tmp_tables | 319 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 20 |
| Handler_read_first | 0 |
| Handler_read_key | 9582 |
| Handler_read_next | 11931 |
| Handler_read_rnd | 3857436 |
| Handler_update | 628 |
| Handler_write | 2986 |
| Key_blocks_used | 172 |
| Key_read_requests | 19319 |
| Key_reads | 172 |
| Key_write_requests | 49 |
| Key_writes | 49 |
| Max_used_connections | 24 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 44 |
| Open_files | 62 |
| Open_streams | 0 |
| Opened_tables | 51 |
| Questions | 8406 |
| Running_threads | 21 |
| Slow_queries | 0 |
| Uptime | 713 |
+--------------------------+---------+
Key Reads/Key Requests = 0.008903 (Cache hit = 99.991097%)
Queries/second = 11.790 (/hour = 42442.637)
Slow Queries/second = 0.000 (/hour = 0.000)
Uptime = 11 min 53 sec
My site is currently hosted on a virtual server and we normally have around 40-50 online at any one time. At peak we have around 70-80 people online.
We experience some slowness in loading the forum from time to time. Sometimes a new post will take 3 minutes to post.
Appreciate any advice in fine tuning / optimising the database. :)
Sun Feb 18 20:50:10 SGT 2001
+--------------------------+---------+
| Variable_name | Value |
+--------------------------+---------+
| Aborted_clients | 0 |
| Aborted_connects | 16 |
| Created_tmp_tables | 319 |
| Delayed_insert_threads | 0 |
| Delayed_writes | 0 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 20 |
| Handler_read_first | 0 |
| Handler_read_key | 9582 |
| Handler_read_next | 11931 |
| Handler_read_rnd | 3857436 |
| Handler_update | 628 |
| Handler_write | 2986 |
| Key_blocks_used | 172 |
| Key_read_requests | 19319 |
| Key_reads | 172 |
| Key_write_requests | 49 |
| Key_writes | 49 |
| Max_used_connections | 24 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 44 |
| Open_files | 62 |
| Open_streams | 0 |
| Opened_tables | 51 |
| Questions | 8406 |
| Running_threads | 21 |
| Slow_queries | 0 |
| Uptime | 713 |
+--------------------------+---------+
Key Reads/Key Requests = 0.008903 (Cache hit = 99.991097%)
Queries/second = 11.790 (/hour = 42442.637)
Slow Queries/second = 0.000 (/hour = 0.000)
Uptime = 11 min 53 sec
My site is currently hosted on a virtual server and we normally have around 40-50 online at any one time. At peak we have around 70-80 people online.
We experience some slowness in loading the forum from time to time. Sometimes a new post will take 3 minutes to post.
Appreciate any advice in fine tuning / optimising the database. :)