Alter_mysql_table_name

October 6, 2022

In case we want to alter mysql table columns, we need to check how many rows there are. If rows are too many, alter table may cause issues to replications due to memory consumption.

if rows are millions, it’s better to not use alter table and use the following steps:

create new table as you need
use “insert into … from select …”
mysql> rename table current to current_old, new to current;