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

Branch merges

Propose for merging

No branches dependent on this one.

Related source package recipes

No recipes using this branch. (?)

Create packaging recipe

Related snap packages

Related bugs

Related blueprints

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.