shri
Wed 1st Aug '01, 12:00am
extended status report is
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 44 |
| Aborted_connects | 3020 |
| Bytes_received | 170102268 |
| Bytes_sent | 2146507500 |
| Connections | 6709 |
| Created_tmp_disk_tables | 7922 |
| Created_tmp_tables | 22157 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 1 |
| Delayed_writes | 17948 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 6008 |
| Handler_read_first | 4806 |
| Handler_read_key | 5833445 |
| Handler_read_next | 9824956 |
| Handler_read_prev | 658720 |
| Handler_read_rnd | 5014838 |
| Handler_read_rnd_next | 252577000 |
| Handler_update | 83497 |
| Handler_write | 636734 |
| Key_blocks_used | 16168 |
| Key_read_requests | 28659361 |
| Key_reads | 15540 |
| Key_write_requests | 79452 |
| Key_writes | 50030 |
| Max_used_connections | 69 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 164 |
| Open_files | 284 |
| Open_streams | 0 |
| Opened_tables | 1272 |
| Questions | 1280278 |
| Select_full_join | 8497 |
| Select_full_range_join | 0 |
| Select_range | 572496 |
| Select_range_check | 0 |
| Select_scan | 257289 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 620922 |
| Sort_rows | 6158383 |
| Sort_scan | 198952 |
| Table_locks_immediate | 1364741 |
| Table_locks_waited | 233 |
| Threads_cached | 5 |
| Threads_created | 646 |
| Threads_connected | 20 |
| Threads_running | 1 |
| Uptime | 122687 |
+--------------------------+------------+
my.cnf is
[mysqld]
set-variable = max_connections=500
Yes, its empty as I wanted to start from scratch
Memory settings are
total used free shared buffers cached
Mem: 1028856 973644 55212 0 30472 747432
-/+ buffers/cache: 195740 833116
Swap: 525288 484 524804
What do you think I should add to improve the performance?
There are about 3 vbulletins running on this with one very large one (500MB) and 2 smaller ones (50-100MB) each.
Regards,
Shri
+--------------------------+------------+
| Variable_name | Value |
+--------------------------+------------+
| Aborted_clients | 44 |
| Aborted_connects | 3020 |
| Bytes_received | 170102268 |
| Bytes_sent | 2146507500 |
| Connections | 6709 |
| Created_tmp_disk_tables | 7922 |
| Created_tmp_tables | 22157 |
| Created_tmp_files | 0 |
| Delayed_insert_threads | 1 |
| Delayed_writes | 17948 |
| Delayed_errors | 0 |
| Flush_commands | 1 |
| Handler_delete | 6008 |
| Handler_read_first | 4806 |
| Handler_read_key | 5833445 |
| Handler_read_next | 9824956 |
| Handler_read_prev | 658720 |
| Handler_read_rnd | 5014838 |
| Handler_read_rnd_next | 252577000 |
| Handler_update | 83497 |
| Handler_write | 636734 |
| Key_blocks_used | 16168 |
| Key_read_requests | 28659361 |
| Key_reads | 15540 |
| Key_write_requests | 79452 |
| Key_writes | 50030 |
| Max_used_connections | 69 |
| Not_flushed_key_blocks | 0 |
| Not_flushed_delayed_rows | 0 |
| Open_tables | 164 |
| Open_files | 284 |
| Open_streams | 0 |
| Opened_tables | 1272 |
| Questions | 1280278 |
| Select_full_join | 8497 |
| Select_full_range_join | 0 |
| Select_range | 572496 |
| Select_range_check | 0 |
| Select_scan | 257289 |
| Slave_running | OFF |
| Slave_open_temp_tables | 0 |
| Slow_launch_threads | 0 |
| Slow_queries | 0 |
| Sort_merge_passes | 0 |
| Sort_range | 620922 |
| Sort_rows | 6158383 |
| Sort_scan | 198952 |
| Table_locks_immediate | 1364741 |
| Table_locks_waited | 233 |
| Threads_cached | 5 |
| Threads_created | 646 |
| Threads_connected | 20 |
| Threads_running | 1 |
| Uptime | 122687 |
+--------------------------+------------+
my.cnf is
[mysqld]
set-variable = max_connections=500
Yes, its empty as I wanted to start from scratch
Memory settings are
total used free shared buffers cached
Mem: 1028856 973644 55212 0 30472 747432
-/+ buffers/cache: 195740 833116
Swap: 525288 484 524804
What do you think I should add to improve the performance?
There are about 3 vbulletins running on this with one very large one (500MB) and 2 smaller ones (50-100MB) each.
Regards,
Shri