You don’t need pt-osc for adding indexes. ADD INDEX is already an online, non-blocking background operation. Adding the index with a normal ALTER TABLE will not block other writers.
You don’t need pt-osc for adding indexes. ADD INDEX is already an online, non-blocking background operation. Adding the index with a normal ALTER TABLE will not block other writers.
Unanswered | Unsolved | Solved
MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright © 2006 - 2024 Percona LLC. All rights reserved.