On Thu, Nov 14, 2002 at 09:02:59AM -0500, Nicholas Elliott wrote: > Hey folks, > > I've looked around, but haven't seen anything similar to _quite_ the problem > I have. The symptoms are thus: memory usage for each mysqld process in top > creeps up to around 13%, 274MB, and stays there, no matter what I set my > config to. > > 79 processes: 76 sleeping, 3 running, 0 zombie, 0 stopped > CPU0 states: 100.0% user, 0.1% system, 0.0% nice, 0.0% idle > CPU1 states: 98.2% user, 1.2% system, 0.0% nice, 0.0% idle > CPU2 states: 1.1% user, 2.0% system, 0.0% nice, 96.2% idle > CPU3 states: 0.0% user, 0.1% system, 0.0% nice, 99.4% idle > Mem: 2064836K av, 2053068K used, 11768K free, 0K shrd, 15836K > buff > Swap: 2096440K av, 35312K used, 2061128K free 1429524K > cached > > PID USER PRI NI SIZE RSS SHARE STAT %CPU %MEM TIME COMMAND > 18339 hunt 25 0 267M 267M 696 R 99.9 13.2 64:53 framework > 985 mysql 15 0 274M 259M 14460 S 0.0 12.8 0:00 mysqld > 1015 mysql 15 0 274M 259M 14460 S 0.0 12.8 0:00 mysqld > 1016 mysql 18 0 274M 259M 14460 S 0.0 12.8 0:00 mysqld > 1017 mysql 16 0 274M 259M 14460 S 0.0 12.8 0:00 mysqld > 1018 mysql 17 0 274M 259M 14460 S 0.0 12.8 0:00 mysqld > 1019 mysql 20 0 274M 259M 14460 S 0.0 12.8 0:00 mysqld > 1044 mysql 15 0 274M 259M 14460 S 0.0 12.8 0:00 mysqld > 1045 mysql 15 0 274M 259M 14460 S 0.0 12.8 0:09 mysqld > 1046 mysql 15 0 274M 259M 14460 S 0.0 12.8 0:00 mysqld > 1047 mysql 15 0 274M 259M 14460 S 0.0 12.8 0:09 mysqld > 1196 mysql 15 0 274M 259M 14460 S 0.0 12.8 16:14 mysqld > 1288 mysql 25 0 274M 259M 14460 S 0.0 12.8 29:06 mysqld > 25425 mysql 25 0 274M 259M 14460 R 99.9 12.8 26:10 mysqld > 29645 mysql 15 0 274M 259M 14460 S 0.0 12.8 1:04 mysqld > > Now, I'm assuming some of that memory must be shared across > processes(threads?) since 14 processes * 12.8% is more than 100%, > and technically I still have 11.7M free.
Yes. > My config has this: > > >>>>>>>>>>> > set-variable = key_buffer=256M > set-variable = max_allowed_packet=1M > set-variable = table_cache=64 > set-variable = sort_buffer=1M > set-variable = record_buffer=1M > set-variable = myisam_sort_buffer_size=64M > set-variable = thread_cache=8 > # Try number of CPU's*2 for thread_concurrency > set-variable = thread_concurrency=8 > > >>>>>>>>>>> > > > Now, I've tried dropping all of the variables, cutting them in half, then > again, to no avail -- when I run a large query (via the DBI interface in > perl) the Mem usage jumps up to 13% (for all mysqld) and never comes back > down. Most notibly I've dropped the key_buffer to 64M and the table_cache > to 32. That tells me that you're my.cnf file isn't being read by MySQL. Or you're editing the wrong one. Or something similar. After you change the values and restart, run SHOW VARIABLES and make sure the values agree with what you expect. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 100 days, processed 2,122,549,010 queries (244/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php