[MDEV-191] SHOW TABLES unnecessary opens frm files Created: 2012-03-21 Updated: 2012-03-21 Resolved: 2012-03-21 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | None |
| Affects Version/s: | 5.5.21, 5.3.3, 5.2.10, 5.1.41 |
| Fix Version/s: | 5.5.22, 5.3.6 |
| Type: | Bug | Priority: | Major |
| Reporter: | Sergei Golubchik | Assignee: | Sergei Golubchik |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
SHOW FULL TABLES opens every frm file to know the table type - whether it's a base table or a view. SHOW TABLES does the same, although the table type is not part of the result, it's ignored. This unnecessary work is reported to add a two orders of magnitude slowdown. |
| Comments |
| Comment by Sergei Golubchik [ 2012-03-21 ] |
|
pushed in 5.3 |