mysql sleep process

[stayeronglass]

PHP Version 5.2.12

System FreeBSD m3serv.m3club.ru 7.2-RELEASE-p4 FreeBSD 7.2-RELEASE-p4 #0: Thu Dec 3 22:46:33 MSK 2009 [email protected]:/usr/obj/usr/src/sys/M3CLUB amd64

mysql

MySQL Support  enabled

Active Persistent Links    0

Active Links    0

Client API version    5.1.42

MYSQL_MODULE_TYPE    external

MYSQL_SOCKET    /tmp/mysql.sock

MYSQL_INCLUDE    -I/usr/local/include/mysql

MYSQL_LIBS    -L/usr/local/lib/mysql -lmysqlclient

 

Directive  Local Value  Master Value

mysql.allow_persistent  Off  Off

mysql.connect_timeout  60  60

mysql.default_host  no value  no value

mysql.default_password  no value  no value

mysql.default_port  no value  no value

mysql.default_socket  no value  no value

mysql.default_user  no value  no value

mysql.max_links  5  5

mysql.max_persistent  0  0

mysql.trace_mode  Off  Off

 

mysqli

MysqlI Support  enabled

Client API library version    5.1.42

Client API header version    5.1.42

MYSQLI_SOCKET    /tmp/mysql.sock

 

Directive  Local Value  Master Value

mysqli.default_host  no value  no value

mysqli.default_port  3306  3306

mysqli.default_pw  no value  no value

mysqli.default_socket  no value  no value

mysqli.default_user  no value  no value

mysqli.max_links  Unlimited  Unlimited

mysqli.reconnect  Off  Off

 

 

pache2handler

Apache Version Apache

Apache API Version 20051115

Server Administrator [email protected]

Hostname:Port www.m3club.ru:0

User/Group peruser(65520)/65520

Max Requests Per Child: 10000 - Keep Alive: off - Max Per Connection: 30

Timeouts Connection: 30 - Keep-Alive: 5

Virtual Server Yes

Server Root /etc/httpd

Loaded Modules core mod_authn_file mod_authn_default mod_authz_host mod_authz_groupfile mod_authz_user mod_authz_default mod_auth_basic mod_include mod_filter mod_deflate mod_log_config mod_logio mod_env mod_headers mod_unique_id mod_setenvif mod_version mod_ssl prefork http_core mod_mime mod_dav mod_status mod_autoindex mod_asis mod_cgi mod_dav_fs mod_dav_lock mod_negotiation mod_dir mod_actions mod_userdir mod_alias mod_rewrite mod_so mod_peruser mod_php5

 

Завершить 913501 m3club_danuser localhost m3club_danneo Sleep 1 --- ---

Завершить 913546 m3club_danuser localhost m3club_danneo Sleep 1 --- ---

Завершить 913549 m3club_danuser localhost m3club_danneo Sleep 1 --- ---

Завершить 913554 m3club_danuser localhost m3club_danneo Sleep 1 --- ---

Завершить 913556 m3club_danuser localhost m3club_danneo Sleep 1 --- ---

Завершить 913557 m3club_danuser localhost Нет Query 0 --- SHOW PROCESSLIST

 

 

50 apache process running.

there is NO persistent connection. Mysql connection are NOT closed in sorce code.

i see many mysq process in sleep state. WHY ? and how can i close it?

why PHP not closed that damned connection automaticly?

[fenway]

What is your wait_timeout set to?