List:General Discussion« Previous MessageNext Message »
From:Matt Florido Date:February 18 2005 3:21am
Subject:MySQL 4.1.9 - Requesting Optimization Tips
View as plain text  
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.

  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
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