tune mysql

[madunix]

i have an old server running redhat 32bit on dual 2GHz and 2GBRAM with mysql4
am thinking to improve mysql with the following parameter can you
check it please.

skip-locking
skip-innodb
query_cache_type=1
query_cache_limit=1M
query_cache_size=32M
max_connections=200
interactive_timeout=100

# Reduced wait_timeout to prevent idle clients holding connections.
wait_timeout=15
connect_timeout=10

# Checked opened tables and adjusted accordingly after running for a while.
table_cache=512
tmp_table_size=32M


# Reduced it to 32 to prevent memory hogging. Also, see notes below.
thread_cache=32

# Reduced it by checking current size of *.MYI files, see notes below.
key_buffer=128M

# Commented out the buffer sizes and keeping the default.
sort_buffer_size=2M

#read_buffer
# 1Mb of read_rnd_buffer_size for 1GB RAM -- see notes below.
read_rnd_buffer_size=1M
read_buffer_size=1M

# myisam_sort_buffer_size used for ALTER, OPTIMIZE, REPAIR TABLE commands.
myisam_sort_buffer_size=32M

# thread_concurrency = 2 * (no. of CPU)
thread_concurrency=2

#logs
log_slow_queries=/var/log/mysqld.slow.log
long_query_time=2


Thanks