How to control the number of sql dameons?
Hi All, Could you please explain why some one needs multiple sql daemons and how to control the number of dameons. Thanks, Prem
Re: How to control the number of sql dameons?
At 9:09 AM +0530 7/26/06, Prem wrote: Hi All, Could you please explain why some one needs multiple sql daemons and how to control the number of dameons. Do you believe that you have multiple daemons? If so, why? If you're looking at the output of ps or top and you see a bunch of mysqld processes, that doesn't necessarily indicate that you have multiple multiple daemons. For example, on Linux, you're see one mysqld per thread, but there is still just one mysqld. -- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to control the number of sql dameons?
Prem wrote: Hi All, Could you please explain why some one needs multiple sql daemons and how to control the number of dameons. It forks so it can handle multiple queries at the same time. The main process (mysqld_safe) handles starting up the other processes and various other things (I assume user authentication), shutting down the service and so on. I'm not sure if you can control the number though, maybe it has something to do with max_connections? Does the manual say anything? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]