create table ... select is metadata locking information_schema

When issuing a CREATE TABLE .... SELECT, the information schema becomes unusable because it gets metadata-locked. This is creating issues to monitoring systems that normally query information_schema for monitoring purposes (queries stack up in processlist waiting for metadata lock).

How to reproduce:

In terminal 1:

create table test (id int not null primary key default 0) select 1, sleep(100);

In termninal 2:

SELECT SUM((DATA_LENGTH+INDEX_LENGTH)) FROM INFORMATION_SCHEMA.TABLES;