On Tue, Oct 20, 2009 at 9:59 AM, Artem Kuchin <mat...@itlegion.ru> wrote: > > however, whe i do in mysql > > show processlist; > > I see many connection hanging in sleep state and they grow and grow slowly! > Any idea why this happens?
Could be many things. Maybe multiple hits to different Apache children are opening new DB connections before anyone of them finish. If your experiencing slow page load as time goes on you may also have table locking or row locking issues. Or it could be that some code other than yours brings in Apache DBI. I suggest turning on DBI debugging for a short while. -wjt
