Hello.
> How to force to kill process which make lock of table ? since PHP make
> many persistent connection to MySQL and i don't know
> which one is locking the table :(
You may get information about processes on your MySQL server using SHOW
PROCESSLIST
and kill the weird process with th
I have an PHP that do application
$sql = "SET AUTOCOMMIT=0";
$db->execQuery($sql);
$sql = "DELETE FROM TABLE X WHERE...";
if($db->execQuery($sql)){
print "ERROR ";
exit(0);
}
$sql = "INSERT INTO TABLE ";
if($db->execQuery($sql)){
print "ERROR ";
exit(0);
}
I have a persistent conne
