Sergei Skarupo wrote:
Hi Donny,
Thanks for your reply. This table only uses ints and floats, but the
floats are allowed to be null, which means, as far as I understand,
that it's not a fixed row length...
What makes you think that? VARCHAR, TEXT, and BLOB are the variable-length
column types
Hi all,
Started a conversion from MyISAM to InnoDB; it's been almost two days and the
statement is still executing...
The (MyISAM) data table size is almost 4G. There were two reasons for this conversion:
to start supporting transactions and to avoid the 4G limit of MyISAM tables; this
:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 8:36 PM
To: Mysql List (E-mail)
Subject: table conversion problems
Hi all,
Started a conversion from MyISAM to InnoDB; it's been almost two days and
the statement is still executing...
The (MyISAM) data table size is almost 4G. There were
:[EMAIL PROTECTED]
Sent: Thursday, August 26, 2004 6:37 PM
To: Sergei Skarupo; 'Mysql List (E-mail)'
Subject: RE: table conversion problems
Sergei,
I don't know much about innodb, but myisam doesn't have a 4 gig limit unless
you are using a dynamic type of table. If you are using a fixed table