FLUSH TABLES WITH READ LOCK  is waiting for a commit lock. The thread is waiting for a transaction to commit versus other parts of query processing. The thread got a notification that the underlying structure for a table has changed and it needs to reopen the table to get the new structure. However, to reopen the table, it must wait until all other threads have closed the table in question. This notification takes place if another thread has used  FLUSH TABLES  or one of the following statements on the table in question:  FLUSH TABLES  tbl_name ,  ALTER TABLE ,  RENAME TABLE , REPAIR TABLE ,  ANALYZE TABLE , or  OPTIMIZE TABLE . The thread is executing  FLUSH TABLES  and is waiting for all threads to close their tables, or the thread got a notification that the underlying structure for a table has changed and it needs to reopen the table to get the new structure. However, to reopen the table, it must wait until all other threads have closed the table in question. This notification takes place if another thread has used  FLUSH TABLES  or one of the following statements on the table in question:  FLUSH TABLES  tbl_name ,  ALTER TABLE ,  RENAME TABLE , REPAIR TABLE ,  ANALYZE TABLE , or  OPTIMIZE TABLE . The server is waiting to acquire a  THR_LOCK  lock or a lock from the metadata locking subsystem, where lock_type  indicates the type of lock. This state indicates a wait for a  THR_LOCK : These states indicate a wait for a metadata lock: For information about table lock indicators, see Section 8.11.1, “Internal Locking Methods” . For information about metadata locking, see Section 8.11.4, “Metadata Locking” . To see which locks are blocking lock requests, use the Performance Schema lock tables described at Section 27.12.13, “Performance Schema Lock Tables” . 1853 General Thread States •  Waiting for commit lock •  waiting for handler commit •  Waiting for tables •  Waiting for table flush • Waiting for  lock_type  lock • Waiting for table level lock • Waiting for event metadata lock • Waiting for global read lock • Waiting for schema metadata lock • Waiting for stored function metadata lock • Waiting for stored procedure metadata lock • Waiting for table metadata lock • Waiting for trigger metadata lock