Categories
Database Development

Methods for tracking processing time for long running ADD INDEX call in MySQL

I’ve set off index creation on a very large table in MySQL and while I expected it to take a long time, I’m 5 days in and wondering if there’s any way to debug potential issues or simply let it run. I don’t have a precise row count but to estimate, it’s in the 100s […]

Categories
Development

concerns about adding a new index over a big table

I have a table with 100± millions rows. During a day over one million new rows are inserted. I want to add a new index on a string column. ALTER TABLE `TABLE_NAME` ADD INDEX `INDEX_NAME`(`COLUMN_NAME`), ALGORITHM=INPLACE, LOCK=NONE; I have a few concerns because this will happen on production: Can indexing lock the table? (even though […]