mysqld creates a few threads at startup (3, I think) plus one thread per active connection. The manual explains it better than myself: http://www.mysql.com/doc/en/MySQL_threads.html Chances are that you have 8 clients connected.
Once again, your mysql server TOTAL memory usage is 40Mb. If this is too much, consider changing some parameters: http://www.mysql.com/doc/en/Server_parameters.html
Also, if you don't use InnoDB, make sure that you have skip-innodb option set in my.cnf. (There were a few mails on that topic a few hours ago, check mailing list archive).
Regards, Joseph Bueno
Gerald Fehringer wrote:
hi joseph,
thank you, but still where is defined that it should start 11 threads ?? i don't wanna allocate so much memory for a small server !
thanks
/geri
-----Ursprungliche Nachricht----- Von: Joseph Bueno [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 28. Marz 2003 15:44 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: multiple mysqld-max running ?
Hi,
ps,top,.. on Linux show threads as processes. What you see is ONE process (mysqld) with 11 threads sharing 40Mb of memory.
Check http://www.mysql.com/doc/en/Memory_use.html
Regards, Joseph Bueno
Gerald Fehringer wrote:
hi list fellows,
os: suse linux 8.1 myqld: mysql-max-4.0.12-pc-linux-i686
i'm using innoDB and a standard my.cnf (medium) config file. every time i start the mysqld, there are over 11 deamons running, each one with 40MB !
the same constellation on a freebsd 4.6.2, same mysqld version, same config file, runs only twice (like supposed to be, right ?)
how can i prevent this, is there any config value i could set ?
thanks in advance geri
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
