Hello.


MySQL has not only per-connection threads. See:

  http://dev.mysql.com/doc/internals/en/threads.html



Maxim Nechaev wrote:

> After my MySQL server start i see this processes:

> 

> [EMAIL PROTECTED]:/ps -HC mysqld -o pid,command

>   PID COMMAND

>  3116 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql

>  3117   /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mys

>  3118     /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/m

>  3119     /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/m

>  3120     /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/m

>  3121     /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/m

>  3122     /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/m

>  3123     /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/m

>  3124     /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/m

>  3125     /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/m

> 

> If i understand, processes with pids 3118-3125 is a child processes,

> that waiting client connections.

> I don't need so many client connections at the same time. It is

> possible to limit their count?

> 

> I try to set this options in my.cnf but without result:

> max_connections = 1

> max_user_connections = 1

> max_delayed_threads = 1

> 

> Thanks.

> 

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to