Gentoo + MySQL + InnoDB

pedro · Posted: Tue Jan 13, 2004 11:12 am Post subject: Gentoo + MySQL + InnoDB

What is the best "my.cnf" configuration to set a InnoDB enviroment in a MySQL installed on Gentoo.

I mean where to save the data files and the log generated?

Thanks

gautamg · n00b Joined: 23 Feb 2004 Posts: 27 Location: New York, NY

searched for "my.cnf innodb" in these fine forums and this thread came up. hope this helps

https://forums.gentoo.org/viewtopic.php?t=37243&highlight=cnf+innodb

CheshireCat · Guru Joined: 25 Aug 2002 Posts: 572

You also have to indicate that you want new tables to be InnoDB, or they'll be created as MyISAM (see the last post in that link - if you explicitly make a MyISAM table, it won't be InnoDB).

You can also use ALTER TABLE to change existing tables to InnoDB. This is useful when an application creates its own tables, and you'd like to change them to InnoDB.