Hi! On Dec 06, Peter M. Perchansky wrote: > Greetings everyone: > > I've noticed that when mySQL runs on Sun Solaris (6, 7, and 8) there will > be two processes running (safe_mysqld and mysqld). > > And this number of processes running will very rarely change, if at all, > without concern over the number of connections or how heavily mySQL is > being utilized. > > On Linux there appears to be a correlation to the number of mysqld > processes and how heavily mySQL is being hit (connections, queries, etc.). > > Questions: > > 1. Are my observations correct?
Not 100% - see below > 2. Is there a way to compile mySQL on Linux so that it behaves like on Sun > where by there is the safe_mysqld and mysqld process only no matter the > activity? If so, how? MySQL behaves identically on Sun and Linux - that is it creates a new thread for every connection (not really, there's a cache for threads, and they can be reused, but it doesn't change the picture in general). ps in Solaris shows only one entry for mysqld - that's correct, there're only one process. In Linux, ps shows every _thread_ as a separate process - that's really misleading, as they are not different processes, they are different threads in the same process. Regards, Sergei -- MySQL Development Team __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany <___/ --------------------------------------------------------------------- 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