I am running a mysql server on a stand-alone host that is queried by a web server. I am currently seeing an average of 33 queries per second, although this is often a lot higher. The problem is, when large numbers of connections start to arrive, the machine load gets very high - but MySQL doesn't use all of the available memory. My settings are as follows: Machine: PIII-600 Memory: 512MB Disk: 30GB Kernel: 2.4.2-2 (Redhat 7.1 vanilla install) MySQL: 3.23.39-1 (RPM from mysql.com ftp server) mysql.cnf: max_connections=400 back_log=20 key_buffer=128M table_cache=256 max_allowed_packet=1M myisam_sort_buffer_size=64M thread_cache=16 The queries sent from the web server - using DBI/DBD are almost all very simple ones - usually single table, single-row selects keyed on an indexed column. Even under heavy load, the machine shows over 200MB of the 512MB memory free, yet the load figure is often up at 5 or 10. Is there anything I should be looking at changing? This is an obvious case for replication, and I'll be doing that soon anyway - I'd just like to know if I can increase performance on this machine at all. current status: +--------------------------+-----------+ | Aborted_clients | 1 | | Aborted_connects | 0 | | Bytes_received | 32784777 | | Bytes_sent | 245072296 | | Connections | 3893 | | Created_tmp_disk_tables | 0 | | Created_tmp_tables | 2361 | | Created_tmp_files | 10 | | Delayed_insert_threads | 0 | | Delayed_writes | 0 | | Delayed_errors | 0 | | Flush_commands | 1 | | Handler_delete | 273 | | Handler_read_first | 440 | | Handler_read_key | 7061350 | | Handler_read_next | 50967714 | | Handler_read_prev | 12778 | | Handler_read_rnd | 722971 | | Handler_read_rnd_next | 455943118 | | Handler_update | 82700 | | Handler_write | 1353355 | | Key_blocks_used | 5074 | | Key_read_requests | 23130416 | | Key_reads | 5053 | | Key_write_requests | 3206 | | Key_writes | 3010 | | Max_used_connections | 27 | | Not_flushed_key_blocks | 0 | | Not_flushed_delayed_rows | 0 | | Open_tables | 85 | | Open_files | 118 | | Open_streams | 0 | | Opened_tables | 95 | | Questions | 520808 | | Select_full_join | 2 | | Select_full_range_join | 0 | | Select_range | 4 | | Select_range_check | 0 | | Select_scan | 133411 | | Slave_running | OFF | | Slave_open_temp_tables | 0 | | Slow_launch_threads | 0 | | Slow_queries | 35 | | Sort_merge_passes | 5 | | Sort_range | 13445 | | Sort_rows | 986289 | | Sort_scan | 45793 | | Table_locks_immediate | 523411 | | Table_locks_waited | 374 | | Threads_cached | 5 | | Threads_created | 28 | | Threads_connected | 22 | | Threads_running | 3 | | Uptime | 15452 | +--------------------------+-----------+ --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
