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