Need Help Tuning MySQL

Hello,

Below are my options set in my.cnf, but I fear they are not optimized for my database and my system.

Here is my server:
- Dual PIII 800's
- 1.5 GB of RAM
- 5 36.4 IBM Drives
- RAID 5

Here is my MySQL settings from my.cnf:

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
skip-locking
set-variable = key_buffer=200M
set-variable = max_allowed_packet=1M
set-variable = table_cache=250
set-variable = sort_buffer=6M
set-variable = record_buffer=6M
set-variable = thread_cache=128
set-variable = thread_concurrency=4 # Try number of CPU's*2
set-variable = myisam_sort_buffer_size=64M
set-variable = max_connections=300
set-variable = thread_stack=128K
#log-update

Notes: I wanted to turn my settings into:
table_cache = 900
max_connections = 600
key_buffer = 256
thread_cache = 600

Any help or suggestions would be greatly appreciated. :)

[Edited by VirtueTech on 01-02-2001 at 06:06 AM]

anyone with dual processors and mysql 3.23.25 should set "set-variable = thread_concurrency=4 # Try number of CPU's*2" ?

Those settings look good, along with the changes that you have outlined. I would go with those.

It is....its still dying.

#If you have any other info about this subject , Please add it free.#

8 January 2009 | cameltoepants.com | edit