MySQL 4.1.9 - Requesting Optimization Tips
Matt Florido
matt at floridonet.com
Thu Feb 17 03:20:11 UTC 2005
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)
More information about the fedora-list
mailing list