Too many sleeping mysql processes using codeigniter

[eluser]Christophe28[/eluser]
Hi,

Yesterday my database server crashed. When checking the list of mysql processes I noticed there where only processes started by the dbuser of my codeigniter website (in developing)

Each time I make a request by the codeigniter website, mysql starts a new process and set the command to sleep. Also there is a busy website (phpbb forum) on the same dbserver, and that works fine, so the mysql.conf is probably set correctly.

After searching the internet I found this post claiming I had to set the $db['default']['pconnect'] value in application/config/database.php to FALSE ... and it works!

I'm new in codeigniter so I'm not sure this is the correct solution? Can anybody explain how come there is a 'sleeping' process started?

Thx!