List:General Discussion« Previous MessageNext Message »
From:Michael Widenius Date:May 2 1999 9:30am
Subject:3.22.21 RAM Usage
View as plain text  
>>>>> "jkraai" == jkraai  <jkraai@stripped> writes:

jkraai> Just upgraded from 3.21.33b to 3.22.21.  Running 
jkraai> on RH5.2.

jkraai> Previously, when I'd do a top, mysqld's were using 
jkraai> around 20M of RAM each.

jkraai> Here's the /etc/my.cnf:
jkraai> [mysqld]
jkraai> log-update = /usr/local/var/mysql.update
jkraai> set-variable = key_buffer=16M
jkraai> set-variable = table_cache=256
jkraai> set-variable = sort_buffer=8M
jkraai> set-variable = record_buffer=1M

jkraai> Now, when I do a top, mysqld's are using around 6.5M.

jkraai> Was I just seeing things before?  

jkraai> Thanks!

Hi!

I agree;  With a 16M key_buffer, your mysqld process should use a bit 
more than 16M;  Have you checked your current status with 'mysqladmin
variables' ?

I just checked this, and it works as expected for me on RH5.2

shell> mysqld-i686 -O key_buffer=64M &
shell> ps uagx | grep mysqld
monty      403  6.3 25.8 67976 66572  p3 S    12:29   0:00 mysqld-i686 -O key_bu
monty      408  0.0 25.8 67976 66572  p3 S    12:29   0:00 mysqld-i686 -O key_bu
monty      409  0.0 25.8 67976 66572  p3 S    12:29   0:00 mysqld-i686 -O key_bu
                         ^^^^^

Regards,
Monty

PS: You should decrease your sort_buffer, as the sort buffer is NOT shared 
    among threads, its very unlikely that you want a 8M sort_buffer.
Thread
DISTINCT and COUNT() SQL QueryMike Machado1 May
  • Re: DISTINCT and COUNT() SQL Queryjkraai1 May
    • Re: DISTINCT and COUNT() SQL QueryPaul DuBois1 May
  • RE: DISTINCT and COUNT() SQL QueryDon Read1 May
  • Re: DISTINCT and COUNT() SQL QueryMike Machado1 May
    • Re: DISTINCT and COUNT() SQL QueryThimble Smith1 May
  • Re: DISTINCT and COUNT() SQL QueryJim Faucette1 May
  • 3.22.21 RAM Usagejkraai2 May
    • 3.22.21 RAM UsageMichael Widenius2 May
  • Re: 3.22.21 RAM Usagejkraai2 May
  • a problemglen19 May
    • Re: a problem (The table 'SQL134597_0' is full)Pete Harlan20 May
      • Re: a problem (The table 'SQL134597_0' is full)glen20 May
        • Re: a problem (The table 'SQL134597_0' is full)Benjamin Pflugmann21 May
        • Re: a problem (The table 'SQL134597_0' is full)Michael Widenius24 May