Hi! InnoDB is a table type which adds transactions, row level locking, a non-free hot backup tool, and foreign key constraints to MySQL.
InnoDB is included in -Max downloads of the stable MySQL-3.23 branch and in all downloads of the beta MySQL-4.0. 3.23.53 is a bugfix release. Windows 95/98/ME users will find the fix of the startup problem useful. The changelog: * We again use unbuffered disk i/o to data files in Windows. Win XP and Win 2000 read performance seems to be very poor with normal i/o. * Tuned the SQL query range estimator so that index range scans are preferred over full index scans. * Allow dropping and creating a table even if innodb_force_recovery is set. One can use this to drop a table which would cause a crash in rollback or purge, or if a failed table import causes a runaway rollback in recovery. * Fixed a bug present in 3.23.52, 4.0.3, 4.0.4: InnoDB startup could take very long or even crash on some Win 95/98/ME computers. * Fixed a bug: fast shutdown (which is the default) sometimes was slowed down by purge and insert buffer merge. * Fixed a bug: doing a big SELECT from a table where no rows were visible in a consistent read could cause a very long (> 600 seconds) semaphore wait in btr0cur.c line 310. * Fixed a bug: the AUTO-INC lock was held to the end of the transaction if it was granted after a lock wait. This could cause unnecessary deadlocks. * Fixed a bug: if you created a temporary table inside LOCK TABLES, and used that temporary table, that caused an assertion failure in ha_innobase.cc. * Fixed a bug: if SHOW INNODB STATUS, innodb_monitor, or innodb_lock_monitor had to print several hundred transactions in one report, and the output became truncated, InnoDB would hang, printing to the error log many waits for a mutex created at srv0srv.c, line 1621. * Fixed a bug: SHOW INNODB STATUS on Unix always reported average file read size as 0 bytes. Best regards, Heikki Tuuri Innobase Oy http://www.innodb.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
