Kevin Dangoor wrote:
On 12/29/05, Mike Orr <[EMAIL PROTECTED]> wrote:
Well, should TG make Innodb tables by default, even if it has to patch
SQLObject to do so?
I don't think so. To use innodb, you need to put the location of your
tablespace in my.cnf. (At least, you did with earlier mysql's. I don't
know if they've created a default tablespace location...)
I'm no MySQL expert, but at least on Gentoo Linux, everything is in
place for InnoDB, all you have to do is append 'engine=innodb' to your
create statement. You can also easily convert MyISAM tables to Inno
tables without much effort. I suspect it's similar elsewhere, but can't
swear to it since many vendors alter the upstream config files for their
packages (and this may, in fact, be something Gentoo added to their
package).
Regards,
Cliff
Kevin
--
Kevin Dangoor
Author of the Zesty News RSS newsreader
email: [EMAIL PROTECTED]
company: http://www.BlazingThings.com
blog: http://www.BlueSkyOnMars.com
