Patrick, ----- Original Message ----- From: "Patrick Hsieh" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, April 06, 2002 10:43 AM Subject: Re: InnoDB is better than MyISAM ?
> Hello "Heikki Tuuri" <[EMAIL PROTECTED]>, > > Where can I find InnoDB Hot Backup product? you can join the InnoDB Hot Backup beta testing program at http://www.innodb.com/hotbackup.html Since no bugs have been reported from ibbackup-0.34 by any of the beta testers, Innobase Oy may declare ibbackup stable already during this month. Best regards, Heikki Tuuri Innobase Oy --- InnoDB - transactions, row level locking, and foreign key support for MySQL See http://www.innodb.com, download MySQL-Max from http://www.mysql.com > On Sat, 6 Apr 2002 10:35:33 +0300 > "Heikki Tuuri" <[EMAIL PROTECTED]> wrote: > > > Hi! > > > > ----- Original Message ----- > > From: "Eric S" <[EMAIL PROTECTED]> > > Newsgroups: mailing.database.mysql > > Sent: Saturday, April 06, 2002 2:10 AM > > Subject: Re: InnoDB is better than MyISAM ? > > > > > > > On Fri, 5 Apr 2002, BD wrote: > > > > > > > At 01:54 PM 4/5/2002, you wrote: > > > > >I have seen many people saying that InnoDB is a great deal, that InnoDB > > > > >rocks, etc. and I am concerced about how much better InnoDB is compared > > to > > > > >MyISAM tables. Can someone tells me wich one is better ? I know that > > InnoDB > > > > >have foreign keys support, but I deal very well without then since now. > > > > > > > > > >My interests are justified becaus eI got out of a very old struct ( DBM > > + > > > > >Text Files ) and jumped head first into MySQL - MyISAM tables, but my > > site > > > > >has a good deal of visitors ( about 30.000 unique visitors by day ) and > > speed > > > > >and reliability are my primary concerns. I plan to use replication in > > MySQL, > > > > >and I would like to know if InnoDB is better than MyISAM for this. > > > > MySQL replication works with InnoDB type tables, and is currently used at > > several sites. > > > > InnoDB Hot Backup (non-free software) makes it possible to set up a new > > slave without stopping the master or setting any locks on the master. This > > is a useful feature at sites requiring high availability. > > > > > One note here is that transactions aren't preserved for replication with > > > InnoDB, so you loose part of one of the major advantages of InnoDB. > > > Rollbacks are O.K., since I don't think that goes out to the slaves until > > > the commit, but if the master or slave goes down after part of a > > > transaction is sent to the slave, you get a partially committed > > > transaction on the slave. How critical this is depends on the > > > application, and still is no worse than MyISAM which has no transactions > > > to begin with. > > > > > > I think Heikki Tuuri has mentioned plans to get this fixed, though I think > > > I remember that he said that the problem was in MySQL, not in the actual > > > InnoDB code, which makes sense. > > > > A potential embedded license buyer is interested in getting this fixed. If > > the deal is closed, we may add the commit marks to the binlog rather soon. > > > > > > Have you ever heard the old saying, "If it ain't broke, don't fix > > it?".<bg> > > > > > > > > If your website is mainly for read access to your database then you're > > not > > > > going to need InnoDb. > > > > > > Agreed 100%, but it doesn't hurt too much (except for index sizes) on > > > readonly databases, so on our production system, we standardized on InnoDB > > > for all tables for consistency, though we will allow for exceptions for > > > tables that need features that aren't in InnoDB yet, such as full text > > > searching. > > > > > > > InnoDb inserts (for a single user) are much slower (for me it is > > > > around 10x slower) than MyISAM because InnoDb does a lot more work. > > > > > > This was not my experience. Without batching the commits, InnoDB lost out > > > to MyISAM on our initial testing by about 1.5x rather than 10x. > > > > > > However, when I committed every 100 or so inserts, InnoDB beat out MyISAM > > > by a small (25%) margin. This was with a single user hitting the > > > database, a perl program that read in a text file, split it into fields, > > > and stuffed it into the database one record at a time (identical programs > > > except for handling the commits()). > > > > > > Now, this wasn't normal database activity, pure inserts into a freshly > > > created table, but the results were still quite impressive. Also, I'm > > > dealing with single-user activity, so there may have been some > > > differences there as well. > > > > Best regards, > > > > Heikki Tuuri > > Innobase Oy > > --- > > InnoDB - transactions, row level locking, and foreign key support for MySQL > > See http://www.innodb.com, download MySQL-Max from http://www.mysql.com > > > > > > > > > > --------------------------------------------------------------------- > > 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 > > -- > Patrick Hsieh <[EMAIL PROTECTED]> > > GPG public key http://pahud.net/pubkeys/pahudatpahud.gpg > --------------------------------------------------------------------- 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