At 19:21 -0800 2/17/05, Matt Florido wrote:
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.
If you're running Linux, there's nothing to optimize here. These are
threads of the same process, not 10 different processes.
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
--
Paul DuBois, MySQL Documentation Team
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]