Re: InnoDB vs. other storage engines

2012-09-22 Thread Michael Widenius
Hi! > "Manuel" == Manuel Arostegui writes: Manuel> 2012/9/19 Mark Haney >> I hope this doesn't end in some kind of flame war. I'm looking to >> optimize my tables (and performance in general) of the DB my web app is >> using. I'm tweaking things a little at a time, but I'm curious as to

RE: InnoDB vs. other storage engines

2012-09-20 Thread hsv
2012/09/19 13:44 -0700, Rick James http://mysql.rjweb.org/doc.php/myisam2innodb Also, InnoDB enforces foreign-key constraints, MyISAM not. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

RE: InnoDB vs. other storage engines

2012-09-19 Thread Rick James
; From: Manuel Arostegui [mailto:man...@tuenti.com] > Sent: Wednesday, September 19, 2012 12:51 PM > To: Mark Haney > Cc: mysql mailing list > Subject: Re: InnoDB vs. other storage engines > > 2012/9/19 Mark Haney > > > I hope this doesn't end in some kind of flam

Re: InnoDB vs. other storage engines

2012-09-19 Thread Manuel Arostegui
2012/9/19 Mark Haney > I hope this doesn't end in some kind of flame war. I'm looking to > optimize my tables (and performance in general) of the DB my web app is > using. I'm tweaking things a little at a time, but I'm curious as to what > the rest of the MySQL list thinks about changing my st

InnoDB vs. other storage engines

2012-09-19 Thread Mark Haney
I hope this doesn't end in some kind of flame war. I'm looking to optimize my tables (and performance in general) of the DB my web app is using. I'm tweaking things a little at a time, but I'm curious as to what the rest of the MySQL list thinks about changing my storage engine from InnoDB to