Re: MySQL 4.1.9 - Requesting Optimization Tips
At 19:44 -0800 2/17/05, Matt Florido wrote: Paul DuBois wrote: 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. Paul, thanks for the fast response. Ah...so this is ignorance on my part. You're saying mysqld is not running separate processes even though Top reports separate PID. Instead of each "thread" consuming appx. 18MB, the entire process is consuming just 18MB? Yes, that's right. On my Linux box, I typically have several versions of MySQL running. Right now there are 249 mysqld processes, but I certainly don't have 249 servers going all at once. It's really only 21. -- 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]
Re: MySQL 4.1.9 - Requesting Optimization Tips
Paul DuBois wrote: 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. Paul, thanks for the fast response. Ah...so this is ignorance on my part. You're saying mysqld is not running separate processes even though Top reports separate PID. Instead of each "thread" consuming appx. 18MB, the entire process is consuming just 18MB? -- Regards, Matt Florido -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL 4.1.9 - Requesting Optimization Tips
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]