SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
03-17-2008, 06:13 AM
| ||||
| ||||
 write lock and sql_cache 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      |
Linear Mode
