I am currently playing around with MySQL and PHP, and I was wondering about table locks. From the MySQL documentation I know that MySQL applies table wide read locks, which can cause other queries to wait until the select query finishes.
When I am using PHP to query data like in this example:
$dbConnection = mysql_connect($dbHost, $dbUser, $dbPass)
mysql_select_db($dbName, $dbConnection)
$qry = "select * from bigTable";
$result = mysql_query($qry, $dbConnection);
//Read Data
mysql_close($dbConnection);
When, from the perspective of the PHP code, will the read lock get removed from "bigTable"?
Thank you, Emi