Bug #32837 I_S Querys take too long
Submitted: 29 Nov 2007 5:33 Modified: 29 Nov 2007 12:00
Reporter: Jared S (Silver Quality Contributor) Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Information schema Severity:S5 (Performance)
Version:5.0.50 OS:Microsoft Windows (Vista)
Assigned to: CPU Architecture:Any
Tags: hit, information_schema, performance, qc, slow

[29 Nov 2007 5:33] Jared S
Description:
Hi,

I_S table is displaying disgusting performance.  Please investigate the 600MS delay EVERY single time this following query is run..

How to repeat:
SELECT             information_schema.columns.column_name, information_schema.columns.data_type, information_schema.key_column_usage.referenced_table_name
FROM               information_schema.columns
LEFT OUTER JOIN  information_schema.key_column_usage ON information_schema.key_column_usage.table_schema = information_schema.columns.table_schema AND information_schema.key_column_usage.table_name = information_schema.columns.table_name AND information_schema.key_column_usage.column_name = information_schema.columns.column_name
[29 Nov 2007 12:00] Sergei Golubchik
This is fixed in 5.1, see bug#19588