MySQL 4.1.9 - Requesting Optimization Tips

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)


[Index of Archives]     [Current Fedora Users]     [Fedora Desktop]     [Fedora SELinux]     [Yosemite News]     [Yosemite Photos]     [KDE Users]     [Fedora Tools]     [Fedora Docs]

  Powered by Linux