lp:~maria-captains/maria/5.5-explain-analyze

Created by Sergey Petrunia on 2012-09-03 and last modified on 2012-09-03
Get this branch:
bzr branch lp:~maria-captains/maria/5.5-explain-analyze
Members of Maria-captains can upload to this branch. Log in for directions.

Branch merges

Related bugs

Related blueprints

Branch information

Owner:
Maria-captains
Project:
MariaDB
Status:
Development

Recent revisions

3465. By Sergey Petrunia on 2012-09-03

MDEV-406: EXPLAIN ANALYZE
- First code, it is possible to get the data for joins/unions
- Numbers for join buffering are likely to be incorrect
- Same for subqueries (what should 'loops' show?)

3464. By Sergey Petrunia on 2012-08-09

MWL#182: Explain running statements: address review feedback
- Add a testcase showing that queries specified in a charset that's different
  from the charset used for warnings, are converted.

3463. By Sergey Petrunia on 2012-08-08

MWL#182: Explain running statements: Address feedback:
- Use LEX::value_list instead of LEX::show_explain_for_thread
- Factor out common code into find_thread_by_id(ulong id)

3462. By Sergey Petrunia on 2012-08-02

Merge

3461. By Sergey Petrunia on 2012-08-01

MDEV-423: SHOW EXPLAIN: 'Using where' for a subquery is shown in EXPLAIN, but not in SHOW EXPLAIN
- Take into account that the optimizer may run the subquery, delete it,
  and then make a JOIN::optimize call again.

3460. By Sergey Petrunia on 2012-07-27

Post-merge fixes.

3459. By Sergey Petrunia on 2012-07-25

Merge 5.5-main -> 5.5-show-explain

3458. By Sergey Petrunia on 2012-07-25

MDEV-412: SHOW EXPLAIN: Server crashes in JOIN::print_explain on a query with inner join and ORDER BY the same column twice
- JOIN::print_explain should print pre_sort_join_tab instead of "first non-constant table".
  The code didn't take the "non-constant" part into account.

3457. By Sergey Petrunia on 2012-07-24

MDEV-408: SHOW EXPLAIN: Some values are chopped off in SHOW EXPLAIN output
- Fix I_S table definition for EXPLAIN output.

3456. By Sergey Petrunia on 2012-07-19

MDEV-298: SHOW EXPLAIN: Plan returned by SHOW EXPLAIN only contains 'Using temporary' ...
- Correct the way SHOW EXPLAIN code calculates 'need_order' parameter
  for JOIN::print_explain().
  The calculation is still an approximation (see MDEV entry for details) (even EXPLAIN itself
  is wrong in certain cases), but now it's a better approximation than before.

Branch metadata

Branch format:
Branch format 7
Repository format:
Bazaar repository format 2a (needs bzr 1.16 or later)
Stacked on:
lp:~maria-captains/maria/trunk
This branch contains Public information 
Everyone can see this information.

Subscribers