----- Original Message ----- From: "Dan Nelson" <[EMAIL PROTECTED]> Sent: Saturday, January 12, 2002 11:23 PM
> In the last episode (Jan 12), Carsten Gehling said: > > Maybe it's just me, but I find that my mysqld proccesses consume > > quite a lot of memory. 7584 KB each to be exact. > > 7 MB is nothing. I'm amazed you get any performace at all out of that, > since it can't have any cache. Is this reported from ps, or top? SIZE > or RSS? It's reported from "top" > > Can I do anything about it? It's a bit annoying, since the machine > > runs approx. 29 mysqld processes at any time. > > Are you sure you mean 29 separate mysqld instances, each started in a > different datadir and listening on a different port/socket, or are you > just confused by Linuxes pthreads implementation? Ehm... Heh heh... You're absolutely right. After sending this mail, I did a calculation on the number of processes, and the memory consumed by "each" process. It didn't match up with the total amount of memory used. It was then that I realized, it's just threads which of course is also the reason why all of them use the same amount. :-) Sorry for that :-) Then maybe you can tell me how I should tune the server? You know make it use more memory, and thereby performing better? It's probably a FAQ, if so just post a URL to a guide. Thanks, - Carsten --------------------------------------------------------------------- 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
