Bug #39990 | poor performace of "SHOW VARIABLES" | ||
---|---|---|---|
Submitted: | 12 Oct 2008 16:19 | Modified: | 13 Oct 2008 9:00 |
Reporter: | wang xiaolin | Email Updates: | |
Status: | Duplicate | Impact on me: | |
Category: | MySQL Server: Information schema | Severity: | S3 (Non-critical) |
Version: | 5.1.23, 5.1.28 | OS: | Any |
Assigned to: | Assigned Account | CPU Architecture: | Any |
Tags: | regression |
[12 Oct 2008 16:19]
wang xiaolin
[12 Oct 2008 17:05]
Valeriy Kravchuk
Thank you for a problem report. Indeed, I need 0.02 sec at most with 5.0.66a on Windows to get 229 variables, and 0.09 sec at bets on the same laptop to get 266 variables with 5.1.28.
[13 Oct 2008 9:00]
Sergei Glukhov
'SHOW VARIABLES' is based on I_S _VARIABLES tables, so it's duplicate of bug#39955.