I am attempting to create a new index on an existing table with 44,485 records in it.
I am using this query to create my new index
CREATE INDEX index_name ON table_name (field_name);
Whenever I run this I get this timeout error:
1205 - Lock wait timeout exceeded; try restarting transaction
This is only on my local dev machine so there arent any other processes taking up the DB.
Is there a preferred method of adding new indexes to existing tables?
Thanks