An error occurred fetching the project authors.
  1. 24 Jan, 2011 1 commit
  2. 23 Jan, 2011 2 commits
  3. 22 Jan, 2011 3 commits
  4. 21 Jan, 2011 1 commit
  5. 14 Jan, 2011 10 commits
    • Sergei Golubchik's avatar
      ec85f1b7
    • Sergei Golubchik's avatar
    • Sergei Golubchik's avatar
      Optimize use of SEARCH_SAVE_BUFF in Aria · 4106db3e
      Sergei Golubchik authored
      (less not-needed copies of key pages)
      
      storage/maria/ma_rkey.c:
        Fixed wrong test if SEARCH_SAVE_BUFF should be set.
        Now we assume that if we are doing HA_READ_KEY_EXACT,
        we don't have to copy the last key buffer
        (in other words, it's not likely this will be followed
        by a read-next call)
      4106db3e
    • Sergei Golubchik's avatar
      use bulk insert and repair by sort for unique keys in · 53ef653f
      Sergei Golubchik authored
      Aria and MyISAM in create_internal_tmp_table_from_heap()
      (safe, as duplicates are impossible).
      This gives a HUGE speed boost!
      
      sql/opt_subselect.cc:
        Fixed problem with wrong recinfo in create_duplicate_weedout_tmp_tabl()
        Tagged the table with 'no_rows' so that when we create the table on disk,
        we only store the index data. This gave us a major speedup!
      sql/sql_select.cc:
        create_tmp_table_from_heap() now uses bulk_insert + repair_by_sort
        when creating Aria/MyISAM tables from HEAP tables.
        This gives a HUGE speed boost!
      storage/maria/ha_maria.cc:
        Extended bulk_insert() to recreate UNIQUE keys for
        internal temporary tables
      storage/maria/ma_open.c:
        Initialize m_info->lock.type properly for temporarly tables
        (needed for start_bulk_insert())
      storage/maria/ma_write.c:
        Don't check uniques that are disabled
      storage/myisam/ha_myisam.cc:
        Extended bulk_insert() to recreate UNIQUE keys for
        internal temporary tables.
      53ef653f
    • Sergei Golubchik's avatar
      Added ha_write_tmp_row() for slightly faster write_row for internal temp tables. · d33bb9e4
      Sergei Golubchik authored
      This will also enable us in the future to collect statistics for
      writes to internal tmp tables.
      
      sql/handler.h:
        Added ha_write_tmp_row()
      sql/opt_subselect.cc:
        ha_write_row -> ha_write_tmp_row
      sql/sql_class.h:
        Added ha_write_tmp_row()
      sql/sql_select.cc:
        ha_write_row -> ha_write_tmp_row
      d33bb9e4
    • Sergei Golubchik's avatar
      Added support for NO_RECORD record format (don't store any row data) for Aria. · 60c791d9
      Sergei Golubchik authored
      This makes the keys smaller (no row pointer) and gives us proper errors if we
      use the table wrongly.
      
      sql/sql_select.cc:
        Use NO_RECORD for tables that doesn't need row data.
      storage/maria/Makefile.am:
        Added ma_norec.c
      storage/maria/ma_check.c:
        Added support for NO_RECORD record format (don't store any row data)
      storage/maria/ma_norec.c:
        Added support for NO_RECORD record format
      storage/maria/ma_open.c:
        Added support for NO_RECORD record format
      storage/maria/ma_search.c:
        Added support for 0 size row pointers (used with NO_RECORD)
      storage/maria/ma_test1.c:
        Added testing of NO_RECORD record format.
      storage/maria/maria_chk.c:
        Added support for NO_RECORD
      storage/maria/maria_def.h:
        Added support for NO_RECORD
      storage/maria/unittest/ma_test_all-t:
        Added testing of NO_RECORD record format
      60c791d9
    • Sergei Golubchik's avatar
      use normal unique (HA_NOSAME) keys for expression cache · 3880896c
      Sergei Golubchik authored
      temptables, not "uniques", that are hash-based keys.
      
      sql/sql_expression_cache.cc:
        Don't set uniques (we don't want or need an unique
        constraint on this table)
      3880896c
    • Sergei Golubchik's avatar
      Added to Aria better hash for packed numeric data for unique handling. · ef6e25b2
      Sergei Golubchik authored
      This was needed as the old code caused us to have LOTS of duplicate
      hash values when used by optimizer.
      
      include/m_ctype.h:
        Made my_hash_sort_bin() exernal
      storage/maria/ma_unique.c:
        Better hash for packed numeric data for unique handling.
        This was needed as the old code caused us to have LOTS
        of duplicate hash values when used by optimizer.
      ef6e25b2
    • Sergei Golubchik's avatar
    • Sergei Golubchik's avatar
      Removed some old comments. · 9f8a5370
      Sergei Golubchik authored
      mysys/my_handler.c:
        Fixed typo
      9f8a5370
  6. 17 Jan, 2011 2 commits
  7. 16 Jan, 2011 1 commit
  8. 15 Jan, 2011 4 commits
    • Igor Babaev's avatar
      Merge · 28b86c18
      Igor Babaev authored
      28b86c18
    • Igor Babaev's avatar
      Fixed LP bug #698882. · 6aeae1dd
      Igor Babaev authored
      Made sure that the optimal fields are used by TABLE_REF objects
      when building index access keys to joined tables.
      Fixed a bug in the template function that sorts the elements of
      a list using the bubble sort algorithm. The bug caused poor
      performance of the function. Also added an optimization that
      skips comparison with the most heavy elements that has been 
      already properly placed in the list.
      Made the comparison of the fields belonging to the same Item_equal
      more granular: fields belonging to the same table are also ordered
      according to some rules.
      6aeae1dd
    • Igor Babaev's avatar
      Merge · 0cef7431
      Igor Babaev authored
      0cef7431
    • Igor Babaev's avatar
      Ported the fix for LP bug #702310 / bug #59493. · 5407e665
      Igor Babaev authored
      An assertion failure was triggered for a 6-way join query that used two
      join buffers.
      The failure happened because every call of JOIN_CACHE::join_matching_records
      saved and restored status of all tables that were accessed before the table
      join_tab. It must do it only for those of them that follow the last table 
      using a join buffer.
      5407e665
  9. 14 Jan, 2011 8 commits
  10. 13 Jan, 2011 4 commits
  11. 12 Jan, 2011 1 commit
    • Sergey Petrunya's avatar
      BUG#665669: Result differences on query re-execution · d64cf60f
      Sergey Petrunya authored
      - Cause: handler::in_range_check_pushed_down was not reset when a 
        command would call handler->idx_cond_push() without later calling
        handler->index_end().
      - Fix: reset the variable in handler->reset(), too (like we do with other
        Index Condition Pushdown members).
      d64cf60f
  12. 06 Jan, 2011 1 commit
  13. 05 Jan, 2011 2 commits