[MDEV-108] Slow query log should show what kind of temp.tables were used. Created: 2012-01-23 Updated: 2012-07-11 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Minor |
| Reporter: | Sergei Petrunia | Assignee: | Sergei Petrunia |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | None | ||
| Description |
|
With log_slow_verbosity=Query_plan (http://kb.askmonty.org/en/slow-query-log-extended-statistics),
it is a common "conventional wisdom" that use of temp.table = bad query plan. New optimizations in 5.3 create temporary tables, so it will become harder to see which tables does the slow query log refers to. The suggested solution is to extend slow query log information to show what kinds of temptables were used. Note: Percona Server 5.5 shows total temp. table sizes in the slow query log |