RE: another INNODB vs MYISAM question

2008-08-16 Thread Martin Gainty
pient. Sender does not necessarily endorse content contained within this transmission. > From: [EMAIL PROTECTED] > To: [EMAIL PROTECTED] > Subject: Re: another INNODB vs MYISAM question > Date: Sat, 16 Aug 2008 08:52:51 -0400 > CC: mysql@lists.mysql.com > > First, database

Re: another INNODB vs MYISAM question

2008-08-16 Thread Brent Baisley
First, databases do not have a table type, they are mainly just a logical grouping of tables. Mixing table types in a database is quite alright and is what you are supposed to do. I generally use MYISAM, but if I have a table with lots of activity (inserts, deletes, selects) or needs transa

Re: another INNODB vs MYISAM question

2008-08-15 Thread Doug Bridgens
if you switch the default engine type any new tables would be created with that new engine type. it does not convert existing tables to your new format. if you have existing innodb tables you need to have the innodb settings active, in my.cnf On 15 Aug 2008, at 06:01, [EMAIL PROTECTED]