Oops, sorry, few mistakes here Mike Blazer wrote: > > Hello guys, > I'm runing mysql 4.0.0 under apache and mod_perl on solaris 2.28 - we > are in a kinda testing/adjusting period. So, yesterday I've wrote an > utility on top of > `ps -o vsz,rss -e` to monitor the memory usage by my processes and also > added mysqld to the list. > So, here's what I saw > virtual memory:295504K > RAM: 241276K > > So, almost all mysqld was in RAM, at that time it was running for about > a week without restarts. > Then a little later that day I had a disk-full and had to delete some > olde records, after long DELETE and optimize table I saw: > virtual: 358428K > RAM: 327080K
This happened after the disk-full, so apache forked more childs and the number of threads at this point should be much more. > Then I restarted mysqld and server and after few minutes of work I saw: > virtual: 281712K > RAM: 23160K > > So, you see - the fresh mysqld takes only ~ 10% RAM of the one that run > for a week. > After that I run my utility few times every 5 minutes, and the number of > threads was always 15-17 but the amount of RAM was growing by ~ 1K per 5 > min. Not 1K but ~1M !!! Just forgot that the units are Kb themselves. > Now it is up for about 16 hours: > virt: 281928K > RAM: 143920K Again, 5 min later virt:281928K RAM: 145152K Anyway (145152K-23160K)/16hours =~ 7 additional MB per hour > See, something wrong happens, it's back 50% in RAM. It's a memory leak, > isn't it? Thanks, any input is much appreciated -- ================================== Mike Blazer [EMAIL PROTECTED] ================================== --------------------------------------------------------------------- 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
