Hi! The following essential change was forgotten from the changelog of 3.23.57 below, though it is listed in the MySQL-3.23.57 changelog:
* 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. Best regards, Heikki ----- Original Message ----- From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 20, 2003 10:49 AM Subject: MySQL/InnoDB-3.23.57 is released > Hi! > > InnoDB is a MySQL table type which supports transactions, foreign keys, and > a non-free hot backup tool. InnoDB is included in MySQL-Max-3.23 and in all > downloads of MySQL-4.0 and MySQL-4.1. You can download all of these from > http://www.mysql.com. > > 3.23.57 is a bugfix release of the old stable 3.23 branch. For production > use I consider 4.0.13 already better than 3.23 branch versions. See > http://www.innodb.com/ibman.html. > > Changelog: > > * Fixed a bug: InnoDB forgot to call pthread_mutex_destroy() when a table > was dropped. That could cause memory leakage on FreeBSD and other non-Linux > Unixes. > > * Fixed a bug: MySQL could erroneously return 'Empty set' if InnoDB > estimated an index range size to 0 records though the range was not empty; > MySQL also failed to do the next-key locking in the case of an empty index > range. > > * Fixed a bug: GROUP BY and DISTINCT could treat NULL values inequal. > > > The following bug fixes did not make it to 3.23.57 but will appear in > 3.23.58: > > * An outstanding bug: InnoDB could make the index page directory corrupt in > the first B-tree page splits after mysqld startup. A symptom would be an > assertion in page0page.c, in function page_dir_find_slot(). > > * An outstanding bug: InnoDB could in rare cases return an extraneous row if > a rollback, purge, and a SELECT coincided. > > Best regards, > > Heikki Tuuri > Innobase Oy > http://www.innodb.com > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
