I have an innoDB MySql db ~80gb.
i want to change the name of one of the columns, can i do it without locking the table?
Asked
Active
Viewed 428 times
0
-
1Why? Do a column mapping in application won't be a better choice? – ajreal Dec 14 '11 at 12:11
-
If you're trying to leave things up and running - then other queries will either be referencing the old column name (and fail once the change goes through) or the new name (and be failing *until* the change goes through) – Damien_The_Unbeliever Dec 14 '11 at 12:12
-
unfortunately not at this case – Ran Dec 14 '11 at 12:13
-
i dont have problem with queries "asking" for the old name cause currently there are none of those. im only interested in changing the column name without locking the table, is it possible? – Ran Dec 14 '11 at 12:14
-
If the old name is not being used, I don't see why you have to rename. – ajreal Dec 14 '11 at 12:15
-
As well said [here](https://stackoverflow.com/questions/8172540/mysql-change-column-name-without-recreating-the-table), check this out: http://www.percona.com/doc/percona-toolkit/pt-online-schema-change.html – Jauzsika Dec 14 '11 at 12:13