Showing entries 1 to 1
Displaying posts with tag: system configurations (reset)
Jun
02
2023
Enhancing Performance with Parallel Index Rebuild in MySQL 8.0.31
Posted by MyDBOPS on Fri 02 Jun 2023 10:07 UTC
Tags:

Learn how the parallel index rebuild feature in MySQL 8.0.31 improves performance by optimizing index and column additions. Explore the multithreaded insert phase, sort index build process, and system configurations for enhanced efficiency.

  1. Understanding Sorted Index Build
    1. When does InnoDB use a sort index build approach?
  2. Phases of Sort …
[Read more]
Showing entries 1 to 1