Mysql Object 조회

SELECT T.*, EVENTS.EVENT_CNT, ROUTINES.ROUTINE_CNT, TRIGGERS.TRIGGER_CNT
FROM 
(
SELECT TABLE_SCHEMA, COUNT(TABLE_NAME) AS TABLE_CNT
FROM INFORMATION_SCHEMA.TABLES
GROUP BY TABLE_SCHEMA
) T
LEFT JOIN
(
SELECT TABLE_SCHEMA, COUNT(TRIGGER_NAME) AS TRIGGER_CNT
FROM INFORMATION_SCHEMA.TRIGGERS
GROUP BY TABLE_SCHEMA
) TRIGGERS ON T.TABLE_SCHEMA = TRIGGERS.TRIGGER_NAME
LEFT JOIN(
SELECT EVENT_SCHEMA, COUNT(EVENT_SCHEMA) AS EVENT_CNT
FROM INFORMATION_SCHEMA.EVENTS
GROUP BY EVENT_SCHEMA
) EVENTS ON T.TABLE_SCHEMA = EVENTS.EVENT_SCHEMA
LEFT JOIN(
SELECT ROUTINE_SCHEMA, ROUTINES(ROUTINE_NAME) AS ROUTINE_CNT
FROM INFORMATION_SCHEMA.EVENTS
GROUP BY ROUTINE_SCHEMA
) ROUTINES ON T.TABLE_SCHEMA = ROUTINES.ROUTINE_SCHEMA
WHERE T.TABLE_SCHEMA NOT IN 
(
'INFORMATION_SCHEMA','MYSQL','PERFORMANCE_schema','sys'
);