MySQL 4.1.9 - Requesting Optimization Tips

[Matt Florido]

I'm wondering if anyone can provide any tips as to how to conserve 
resources.  Currently, I see 10 instances of mysqld running. Each 
instance is approximately 18MB.  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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]