my.cnf suggestions? :)

[Toibs]

Eva2000,

Please Scuse me for being a little cheeky, bit i haven't got a clue what the best settings (well anything other than the default which to be honest i never thought i'd have to change - oops!! too popular!) for my system (well my my.cnf file) would be. Is it possible you could give me some advice as you have done above (it would be MUCH appreciated!)

Server - Dedicated P3 850 / 512Mb apache-1.3.20 php-4.06.....

Settings are default i believe....

| delayed_insert_limit | 100 |
| delayed_insert_timeout | 300 |
| delayed_queue_size | 1000 |
| flush | OFF |
| flush_time | 0 |
| have_bdb | NO |
| have_gemini | NO |
| have_innodb | NO |
| have_isam | YES |
| have_raid | NO |
| have_ssl | NO |
| init_file | |
| interactive_timeout | 28800 |
| join_buffer_size | 131072 |
| key_buffer_size | 8388600 |
| language | /usr/local/mysql/share/mysql/english/ |
| large_files_support | ON |
| locked_in_memory | OFF |
| log | OFF |
| log_update | OFF |
| log_bin | OFF |
| log_slave_updates | OFF |
| long_query_time | 10 |
| low_priority_updates | OFF |
| lower_case_table_names | 0 |
| max_allowed_packet | 1048576 |
| max_binlog_cache_size | 4294967295 |
| max_binlog_size | 1073741824 |
| max_connections | 100 |
| max_connect_errors | 10 |
| max_delayed_threads | 20 |
| max_heap_table_size | 16777216 |
| max_join_size | 4294967295 |
| max_sort_length | 1024 |
| max_user_connections | 0 |
| max_tmp_tables | 32 |
| max_write_lock_count | 4294967295 |
| myisam_recover_options | OFF |
| myisam_max_extra_sort_file_size | 256 |
| myisam_max_sort_file_size | 2047 |
| myisam_sort_buffer_size | 8388608 |
| net_buffer_length | 16384 |
| net_read_timeout | 30 |
| net_retry_count | 10 |
| net_write_timeout | 60 |
| open_files_limit | 0 |
| pid_file | /usr/local/mysql/data/***********.pid |
| port | 3306 |
| protocol_version | 10 |
| record_buffer | 131072 |
| query_buffer_size | 0 |
| safe_show_database | OFF |
| server_id | 0 |
| slave_net_timeout | 3600 |
| skip_locking | ON |
| skip_networking | OFF |
| skip_show_database | OFF |
| slow_launch_time | 2 |
| socket | /tmp/mysql.sock |
| sort_buffer | 2097144 |
| table_cache | 64 |
| table_type | MYISAM |
| thread_cache_size | 0 |
| thread_stack | 65536 |
| transaction_isolation | READ-COMMITTED |
| timezone | GMT |
| tmp_table_size | 33554432 |
| tmpdir | /tmp/ |
| version | 3.23.40 |
| wait_timeout | 28800 |

When quiet (well never quiet, lets say "most of the time") load average is anywhere between 1 and 3. When it gets busy, we get about 350-400 simultaneous users, and the load limiting functions cut in (set to 9!!).

Also whats the best book to get in your oppinion to give me a chance with Mysql... like Mysql for dummies or something.... :)

Thanks Lots :)

Paul

[eva2000]

alot easier with a thread split :)

i'd upgrade to 1 gb ram if you can and try something like in /etc/my.cnf


[client]
port = 3306
socket = /usr/local/mysql/data/mysql.sock

[mysqld]
port = 3306
socket = /usr/local/mysql/data/mysql.sock
skip-locking
set-variable = max_connections=500
set-variable = key_buffer=16M
set-variable = join_buffer=6M
set-variable = record_buffer=6M
set-variable = sort_buffer=8M
set-variable = table_cache=1024
set-variable = thread_cache_size=256

[myisamchk]
set-variable = key_buffer=128M
set-variable = sort_buffer=128M
set-variable = read_buffer=8M
set-variable = write_buffer=8M

[eva2000]

you might have to change the socket path to /tmp/mysql.sock for your my.cnf file