Perhaps the InnoDB/MyISAM gurus can comment on this. I want to switch from MyISAM to Innodb, because we have database tables that have many updates, inserts, deletes and selects going on at the same time. My belief is that InnoDB's better locking semantics (as compared to MyISAM) will give me better overall performance in such a high contention environment. For example, each update won't block other updates or selects or deletes.
Is this a fair assumption? Honestly, the 'other' features of InnoDB (transactions and reliability) aren't as important to me as overall speed. Cheers. -Dana > -----Original Message----- > From: Thomas Seifert [SMTP:[EMAIL PROTECTED]] > Sent: Monday, September 23, 2002 2:14 AM > To: [EMAIL PROTECTED] > Subject: Re: transactions... > > On Mon, 23 Sep 2002 08:40:59 +0300 (EEST) Iikka Meriläinen > <[EMAIL PROTECTED]> wrote: > > > On Mon, 23 Sep 2002, Daniel Kiss wrote: > > > > > Hi! > > > > > > At 00:56 2002.09.23._ -0300, you wrote: > > > >Do I loose > > > >too much performance using InnoDB tables in autocommit mode instead > of > > > >using MyISAM tables? > > > > > > The real quiestion is: Why do you want to use InnoDB tables when you > don't > > > want to use its transaction safe features? > > > > The reason for prefering InnoDB over MyISAM? Performance. Most > benchmarks > > show InnoDB is slightly faster than MyISAM, and not to mention its some > > other benefits. > > > > But the performance could be a reason on its own to use InnoDB. I don't > > mean that MyISAM is bad, not at all. It's simpler to use, after all. But > > what I mean is that InnoDB can be used in all tasks MyISAM is suitable > > for, and some tasks will be done faster using InnoDB. > > But some tasks are really bad in InnoDB, at most selects and worst if it > comes to table-scans. > > > Thomas > > mysql, query > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the individual or entity to whom they are addressed. If you have received this email in error destroy it immediately. ********************************************************************** Wal-Mart Stores, Inc. Confidential ********************************************************************** --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
