List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:February 18 2005 3:26am
Subject:Re: MySQL 4.1.9 - Requesting Optimization Tips
View as plain text  
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
Thread
MySQL 4.1.9 - Requesting Optimization TipsMatt Florido18 Feb
  • Re: MySQL 4.1.9 - Requesting Optimization TipsPaul DuBois18 Feb
    • Re: MySQL 4.1.9 - Requesting Optimization TipsMatt Florido18 Feb
      • Re: MySQL 4.1.9 - Requesting Optimization TipsPaul DuBois18 Feb
      • MySQL constraint questionGerald Taylor18 Feb
        • Re: MySQL constraint questionSGreen22 Feb
          • Re: MySQL constraint questionMartijn Tonies22 Feb
            • Re: MySQL constraint questionGerald Taylor23 Feb