-
Committer:
Mayank Prasad
-
Date:
2012-04-19 09:27:34 UTC
-
mto:
(2502.1194.1 mysql-5.1.64-release)
-
mto:
This revision was merged to the branch mainline in
revision
3152.
-
Revision ID:
mayank.prasad@oracle.com-20120419092734-r7zagrvqaf07bavy
BUG#12427262 : 60961: SHOW TABLES VERY SLOW WHEN NOT IN SYSTEM DISK CACHE
Reason:
This is a regression happened because of changes done in code refactoring
in 5.1 from 5.0.
Issue:
While doing "Show tables" lex->verbose was being checked to avoid opening
FRM files to get table type. In case of "Show full table", lex->verbose
is true to indicate table type is required. In 5.0, this check was
present which got missing in >=5.5.
Fix:
Added the required check to avoid opening FRM files unnecessarily in case
of "Show tables".