Hi,
I am a new admin and I was recently ran into a problem -
When I execute the show processlist command I see locked( in state locked ) processes
and if I kill one all the other get locked and the db freezes.
When I kill all of them the problem is solved. This problem has been re
st
> Subject: Locked Processes Taking MySQL down
>
>
> Hello,
>
> I am seeing rather frequently our mySQL DB Freezes up. It runs
> the back end
> of a web site that gets decent traffic. When I check the process list for
> the DB, there is a bunch of processes all l
Hello,
I am seeing rather frequently our mySQL DB Freezes up. It runs the back end
of a web site that gets decent traffic. When I check the process list for
the DB, there is a bunch of processes all locking that table sitting there.
I normally disable connections from the Cold Fusion server, me