1. 24 Jun, 2014 3 commits
    • Sergei Petrunia's avatar
      06a87d77
    • Sergei Petrunia's avatar
      MDEV-406: ANALYZE $stmt: fix order_by.test · 1dd5d31c
      Sergei Petrunia authored
      In JOIN_TAB::update_explain_data(), take into account that
      - the table that may have pre-sorted is the first non-const table
      - Tables that are eliminated by table elimination are marked
        as const tables, but are not present in the Explain data structures
      1dd5d31c
    • Sergei Petrunia's avatar
      MDEV-406: ANALYZE $stmt: get ANALYZE work for subqueries · c08de062
      Sergei Petrunia authored
      - "ANALYZE $stmt" should discard select's output, but it should still
        evaluate the output columns (otherwise, subqueries in select list
        are not executed)
      - SHOW EXPLAIN's code practice of calling JOIN::save_explain_data()
        after JOIN::exec() is disastrous for ANALYZE, because it resets
        all counters after the first execution. It is stopped
        = "Late" test_if_skip_sort_order() calls explicitly update their part
          of the query plan.
        = Also, I had to rewrite I_S optimization to actually have optimization
          and execution stages.
      c08de062
  2. 16 Jun, 2014 1 commit
  3. 03 Jun, 2014 2 commits
  4. 27 May, 2014 2 commits
    • Sergei Petrunia's avatar
      MDEV-406: ANALYZE $stmt · 0925ab9d
      Sergei Petrunia authored
      -Add analyze_stmt.test/result
      0925ab9d
    • Sergei Petrunia's avatar
      Re-commit in git: · eaba1ba4
      Sergei Petrunia authored
      MDEV-406: ANALYZE $stmt
      - Ported the old patch to new explain code
      - New SQL syntax (ANALYZE $stmt)
      - ANALYZE UPDATE/DELETE is now supported (because EXPLAIN UPDATE/DELETE is supported)
      - Basic counters are calculated for basic kinds of queries
        (still need to see what happens with join buffer, ORDER BY...LIMIT queries, etc)
      eaba1ba4
  5. 26 May, 2014 8 commits
  6. 25 May, 2014 3 commits
  7. 24 May, 2014 7 commits
  8. 23 May, 2014 2 commits
  9. 22 May, 2014 6 commits
  10. 16 May, 2014 1 commit
  11. 13 May, 2014 2 commits
  12. 10 May, 2014 2 commits
  13. 09 May, 2014 1 commit