Michael, ----- Alkuperäinen viesti ----- Lähettäjä: <[EMAIL PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]> Kopio: <[EMAIL PROTECTED]> Lähetetty: Monday, December 29, 2003 11:53 PM Aihe: Re: Foreign Keys in CREATE TABLEs produced by mysqldump
> "Heikki Tuuri" <[EMAIL PROTECTED]> wrote on 12/24/2003 01:53:07 PM: > > > Michael, > > > > this is the question where the valid answer is: upgrade! > > > > In which version was this corrected? I failed to mark it to the release notes :(. It was fixed in some 4.0.x version <= 4.0.12. > I'm hesitant to upgrade to the latest > and greatest without it being banged on by the masses first.. InnoDB-4.0.17 should be stabler than any of 3.23.xx. It contains more diagnostic code and more checks. > I have half a dozen or so business applications running w/ this mysql data > store, regression testing them would involve an amount of time I can not > afford to spend. The 3.23 branch works well for us right now and I have no > real need to use 4.0 (feature-wise.) So until 3.23.x is no longer > supported or there is a dire need to use 4.x functionality... I can't make > a business case justifying the regression test work. I believe 3.23.58 was the very last release from the 3.23 series. > > " > > MySQL/InnoDB-3.23.57, June 20, 2003 > > > > Changed the default value of innodb_flush_log_at_trx_commit from 0 > > to 1. If you have not specified it explicitly in your my.cnf, and your > > application runs much slower with this new release, it is because > > the value 1 causes a log flush to disk at each transaction commit. > > " > > Thats it! Thanks. > > -mike Best regards, Heikki Innobase Oy http://www.innodb.com InnoDB - transactions, row level locking, and foreign keys for MySQL InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables Order MySQL support from http://www.mysql.com/support/index.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
