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

Partition performance optimization

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

          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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-30191 SIGSEGV & heap-use-after-free in spider_db_print_item_type, SIGABRT in __cxa_pure_virtual/spider_db_print_item_type, Got error 128 "Out of memory in engine", 56/112 memory not freed, and Assertion `fixed()' failed in Item_sp_variable::val_str on SP call

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

          Bug - A problem which impairs or prevents the functions of the product. MDEV-31996 Segfault when setting spider_delete_all_rows to 0 and delete all rows of a spider table, ASAN heap-use-after-free in spider_db_delete_all_rows

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

          New Feature - A new feature of the product, which has yet to be developed. MDEV-20250 Implement early partition pruning before statement start

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

          Activity

            Transition Time In Source Status Execution Times
            Kentoku Shiba (Inactive) made transition -
            Open In Progress
            		43d 10h 12m 1
            Kentoku Shiba (Inactive) made transition -
            In Progress In Review
            		16d 18h 56m 1
            Roel Van de Paar made transition -
            In Review Closed
            		851d 8h 52m 1
            Roel Van de Paar made transition -
            Closed Stalled
            		5s 1

            People

              holyfoot Alexey Botchkov
              willhan willhan
              Votes:
              0 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.