Re: MySQL: Moving to InnoDB
Re: MySQL: Moving to InnoDB
- Subject: Re: MySQL: Moving to InnoDB
- From: Chuck Hill <email@hidden>
- Date: Wed, 13 Jan 2010 15:51:07 -0800
On Jan 13, 2010, at 3:11 PM, Travis Britt wrote:
Yeah I'm doing this, everything is InnoDB except for a read-mostly
(as in, write once in a blue moon) table that's MyISAM due to
InnoDB's row size limit
Row size limit? Oooh, tell me more! ;-)
and the fact that it's currently got a ton of varchar(255) columns.
On Jan 13, 2010, at 4:01 PM, David LeBer wrote:
I know it's ugly, but you can mix InnoDB and MyISAM tables in the
same database.
If the FULL TEXT indexes are only on a single/few tables/columns
that may be an option.
Keep MyISAM for the FT tables, move everything else to InnoDB.
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden