List:General Discussion« Previous MessageNext Message »
From:Filip Rachunek Date:October 18 2004 9:31am
Subject:Varchar and InnoDB
View as plain text  
Hello,
I have a big table in my InnoDB database (more than 10 million rows)
and it contains a column of varchar(40) type. For some reason I need
to extend this column to varchar(160) but I don't expect to use the
whole capacity of this column, except for several rare cases.
My question is, after I make this "alter table" action, can it have a
negative impact on MySQL performance or required disk space? It is
just an ordinary non-indexed column, not used in where or sort by
conditions.

Thank you.
Filip Rachunek
Thread
Varchar and InnoDBFilip Rachunek18 Oct
Re: Varchar and InnoDBHeikki Tuuri19 Oct