Re: Is it best practice to lock table for every Mysql query?

[Craig Liu]

Thank Peter. Because it is still difficult for us to convince others that lock tables are necessary for even pure SELECT query.

For example, we have a simple query:
SELECT * FROM t1 LEFT JOIN (t2 CROSS JOIN t3 CROSS JOIN t4) ON (t2.a = t1.a AND t3.b = t1.b AND t4.c = t1.c)

Why we have to use this:
lock tables t1,t2,t3,t4 READ;
SELECT * FROM t1 LEFT JOIN (t2 CROSS JOIN t3 CROSS JOIN t4) ON (t2.a = t1.a AND t3.b = t1.b AND t4.c = t1.c);
unlock tables;

Is it a best practice for lock tables (MyISAM) before run a Select query?