FLOWH TABLES don't work.

WHY Flush Tables don't bother you? I can INSERT / SELECT into TABLE.

mysql> FLUSH TABLES;
Query OK, 0 rows affected (0.00 sec)

mysql> SELECT COUNT(*) FROM big_table;
+----------+
| COUNT(*) |
+----------+
|  1054155 |
+----------+
1 row in set (1.13 sec)
mysql> INSERT INTO exept VALUES(1);
Query OK, 1 row affected (0.02 sec)

      

        
        
        
      

    

I have all the privileges.

When I use FLUSH TABLES WITH READ LOCK, I cannot insert, but you can select queries:

mysql> FLUSH TABLES WITH READ LOCK;
Query OK, 0 rows affected (0.00 sec)

mysql> INSERT INTO exept VALUES(1);
ERROR 1223 (HY000): Can't execute the query because you have a conflicting read lock
mysql> SELECT * FROM exept;
+----+
| id |
+----+
|  1 |
+----+
1 row in set (0.03 sec)

      

        
        
        
      

    

How do I disable INSERT / SELECT queries?