MySQL 4.1.9 - Requesting Optimization Tips

[Matt Florido]

I'm running MySQL 4.1.9 on FC3 and it seems to be a resource hog. 
(understated)  I'm wondering if anyone can provide any tips as to how to 
conserve resources.  Currently, I see 10 instances of mysqld running. 
For my application of MySQL, I don't require a large amount of resources 
allocated to mysqld.

  7085 mysql     16   0 90060  17m 2608 S  0.0  3.5   0:00.05 mysqld
  7086 mysql     16   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld
  7087 mysql     20   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld
  7088 mysql     24   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld
  7089 mysql     24   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld
  7090 mysql     20   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld
  7091 mysql     16   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld
  7092 mysql     16   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld
  7093 mysql     16   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld
  7094 mysql     15   0 90060  17m 2608 S  0.0  3.5   0:00.00 mysqld

I found some information on mysql.com.  I basically reduced some of the 
startup options by half.

key_buffer_size=32M
back_log=25
table_cache=32
net_buffer_length=1M
max_allowed_packet=3M
query_cache_limit = 1M
query_cache_size = 16M
query_cache_type = 1
read_buffer_size=2M
read_rnd_buffer_size=8M

-- 
Regards,
Matt Florido
(Newly acquainted with FC3)