Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19002

Partition performance optimization

    XMLWordPrintable

    Details

      Description

      Add the partition options of the following function for batch call instead of each partition

      • store_lock
      • external_lock
      • start_stmt
      • extra
      • cond_push
      • info_push
      • top_table

      original description:
      Partition performance optimization: improve the select/insert/delete/update/replace performance of the partition table under multiple partitions by executing prune_partition before the lock table

        Attachments

        1. gmon_del_with_1024_partitions.zip
          485 kB
        2. gmon_del_without_partition.zip
          471 kB
        3. gmon_ins_with_1024_partitions.zip
          485 kB
        4. gmon_ins_without_partition.zip
          460 kB
        5. gmon_sel_with_1024_partitions.zip
          502 kB
        6. gmon_sel_without_partition.zip
          474 kB
        7. gmon_spider_del_with_1024_partitions_after.zip
          433 kB
        8. gmon_spider_del_with_1024_partitions_before.zip
          436 kB
        9. gmon_spider_del_without_partition.zip
          393 kB
        10. gmon_spider_ins_with_1024_partitions_after.zip
          407 kB
        11. gmon_spider_ins_with_1024_partitions_before.zip
          409 kB
        12. gmon_spider_ins_without_partition.zip
          375 kB
        13. gmon_spider_sel_with_1024_partitions_after.zip
          446 kB
        14. gmon_spider_sel_with_1024_partitions_before.zip
          452 kB
        15. gmon_spider_sel_without_partition.zip
          407 kB
        16. gmon_spider_upd_with_1024_partitions_after.zip
          448 kB
        17. gmon_spider_upd_with_1024_partitions_before.zip
          452 kB
        18. gmon_spider_upd_without_partition.zip
          399 kB
        19. gmon_upd_with_1024_partitions.zip
          490 kB
        20. gmon_upd_without_partition.zip
          470 kB
        21. Test_procedures_delete.txt
          1 kB
        22. Test_procedures_insert.txt
          1 kB
        23. Test_procedures_select.txt
          1 kB
        24. Test_procedures_update.txt
          1 kB
        25. test_results_of_spider.txt
          7 kB

          Issue Links

          causes

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26158 SIGSEGV in spider_free_mem from ha_spider::open on INSERT

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26539 SIGSEGV in spider_check_and_set_trx_isolation and I_P_List_iterator from THD::drop_temporary_table (10.5.3 opt only) on ALTER

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-26582 SIGSEGV in spider_db_bulk_insert and spider_db_connect and spider_db_before_query, and hang in "End of update loop" / "Reset for next command" query states

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27171 Spider: SIGSEGV in spider_set_direct_limit_offset on INSERT

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27239 Spider: Assertion `thd->transaction->stmt.ha_list == __null || trans == &thd->transaction->stmt' failed in ha_commit_trans on BEGIN WORK after FTWRL

          • Critical - Crashes, loss of data, severe memory leak.
          • In Review

          Bug - A problem which impairs or prevents the functions of the product. MDEV-27240 SIGSEGV in ha_spider::store_lock on LOCK TABLE

          • Critical - Crashes, loss of data, severe memory leak.
          • Closed
          relates to

          Task - A task that needs to be done. MDEV-20250 do not open partitions excluded by automatic partition pruning

          • Critical - Crashes, loss of data, severe memory leak.
          • Stalled

            Activity

              People

              Assignee:
              holyfoot Alexey Botchkov
              Reporter:
              willhan willhan
              Votes:
              0 Vote for this issue
              Watchers:
              9 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration