does the "lock table" on MySQL (I'm using 5.0.22 or 5.0.45) works
even for a cached result?
this is my scenario, (I'm using MyIsam tables)
thread 1:
LOCK TABLE foo WRITE;
thread 2:
SELECT * FROM foo ;
(locked)
thread 1:
UNLOCK TABLES;
thread 2:
result of SELECT * ..
and that's is, IMHO, correct; btw, since the result of the select is
in the cache, it seems I'm unable to 'lock' again the table:
thread 1:
LOCK TABLE foo WRITE;
thread 2:
SELECT * FROM foo ;
I have the result of the select :(
the only way I found to avoid that is use the SQL_NO_CACHE (then
SELECT SQL_NO_CACHE FROM foo)
is that correct?! there is a way to avoid to specify "SQL_NO_CACHE" ?
or there is something wrong ?!
thank you in avance.
bye bye
marco
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]