I need to lock tables (have to) on Mysql database (which is being accessed by a tons of users all the time) for the duration of
several mixed types of queries including deletes,insert and update executed from PHP
Will Lock Tables work from PHP ?
What makes me unsure is this,
mysql docs.."LOCK TABLES locks tables for the current thread"
Does this means CPU thread (like in multi-threaded OS) ? Then Linux is multi-threaded
and could execute php.exe on a different
threads in which case LOCK TABLES becomes pretty useless.
several mixed types of queries including deletes,insert and update executed from PHP
Will Lock Tables work from PHP ?
What makes me unsure is this,
mysql docs.."LOCK TABLES locks tables for the current thread"
Does this means CPU thread (like in multi-threaded OS) ? Then Linux is multi-threaded
and could execute php.exe on a different
threads in which case LOCK TABLES becomes pretty useless.