Too many sleeping mysql processes using codeigniter

[eluser]n0xie[/eluser]
It is a bug in the way Apache and MySQL work. Unless you set it up 'just' right, Apache will spawn a new process for each new request, which has a different ID, so a new MySQL thread is started. So yeah setting pconnect to FALSE solves this, although if you want to use pconnect you need to setup Apache and MySQL correctly.