mysql - FLUSH TABLES don't work . -

why flush tables don't work ? can insert /select table.

mysql> flush tables; query ok, 0 rows affected (0.00 sec)  mysql> select count(*) big_table; +----------+ | count(*) | +----------+ |  1054155 | +----------+ 1 row in set (1.13 sec) mysql> insert exept values(1); query ok, 1 row affected (0.02 sec) 

i have privileges.

when use flush tables read lock can't insert can select queries:

mysql> flush tables read lock; query ok, 0 rows affected (0.00 sec)  mysql> insert exept values(1); error 1223 (hy000): can't execute query because have conflicting read lock mysql> select * exept; +----+ | id | +----+ |  1 | +----+ 1 row in set (0.03 sec) 

how disabled insert/select queries ?