Am running below query
Alter table dbname.tablename add column column1 varchar(50), add column column2 text , ALGORITHM=INPLACE, LOCK=NONE;
It takes more time to execute.
Ideally running this without
ALGORITHM=INPLACE, LOCK=NONE takes 30mins to execute.
Query am running for table size=24.4G and records-count=97lkahs.
Any suggestions on why does it take more time to execute?
Is there any way that i could achieve better on the same?
Version= 5.6.40 , Engine = Innodb , Buffer pool size = 44.8 GB