did big table lock remove from MySQL BDB table while updating?
Regards
David
----- Original Message -----
From: "Michael Widenius" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, January 19, 2001 6:45 AM
Subject: MySQL 3.23.31 is released
>
> Hi!
>
> First: Note that it will take a short while until SourceForge and all
> mirrors have the new version; Don't email us for a couple of days if
> you can't find the 3.23.31 version on a mirror!
>
> MySQL 3.23 is now finally released as a production release.
>
> The 3.23 release has several major new features that are not
> present in the 3.22 or 3.21 releases. We have added two new
> table types: MyISAM, a new ISAM library which is tuned for SQL
> and supports large files; and BerkeleyDB which uses the Berkeley
> DB library from Sleepycat Software to implement transaction-safe
> tables. The 3.23 release also includes support for database
> replication between a master and many slaves.
>
> We are in the future aiming to only provide bug fixes for 3.23 and
> instead concentrate on the 4.0 version.
>
> The replication code and BerkeleyDB code is still not as tested and as
> the rest of the code, so we will probably need to do a couple of future
> releases of 3.23 with small fixes for this part of the code. As long as
> you don't use these features, you should be quite safe with MySQL 3.23!
>
> Note that the above doesn't mean that replication or Berkeley DB doesn't
> work; We have done a lot of testing of all code, including replication
> and BDB without finding any problems. It only means that not as many
> users uses this code as the rest of the code and because of this we are
> not yet 100 % confident in this code.
>
> We will within a few days start building binaries with BDB table
> support; We will do a separate announcement when these are available.
>
> Changes in release 3.23.31
> --------------------------
>
> * The test suite now tests all reachable BDB interface code. During
> testing we found and fixed a lot of errors in the interface code.
>
> * Using `HAVING' on an empty table could produce one result row when
> it shouldn't.
>
> * Fixed that the *MySQL* RPM is not depending on perl5 anymore.
>
> * Fixed some problems with `HEAP' tables on windows.
>
> * `SHOW TABLE STATUS' didn't show correct average row length for
> tables bigger than 4G.
>
> * `CHECK TABLE .. EXTENED' didn't check row links for fixed size
> tables.
>
> * Added option `MEDIUM' to `CHECK TABLE'.
>
> * Fixed problem when using `DECIMAL()' keys on negative numbers.
>
> * `HOUR()' (and some other `TIME' functions) on a `CHAR' column
> always returned `NULL'.
> * Fixed security bug in something (please upgrade if you are using a
> earlier MySQL 3.23 version).
>
> * Fixed buffer overflow bug when writing a certain error message.
>
> * Added usage of `getrlimit()' on Linux to get `-O
> --open-files-limit=#' to work on Linux.
>
> * Added new mysqld variable: bdb_version.
>
> * Fixed bug when using expression of type `SELECT ... FROM t1 left
> join t2 on (t1.a=t2.a) WHERE t1.a=t2.a'. In this case the test in
> the `WHERE' clause was wrongly optimized away.
>
> * Fixed bug in `MyISAM' when deleting keys with possible `NULL'
> values, but the first key-column was not a prefix-compressed text
> column.
>
> * Fixed that `mysql.server' reads the `mysql.server' option section
> instead of `mysql_server'.
>
> * Fixed that `safe_mysqld' and `mysql.server' also reads the
> `server' option section.
>
> * Added `Threads_created' status variable to `mysqld'.
>
>
> For a complete changelog for 3.23:
>
> http://www.mysql.com/documentation/mysql/bychapter/manual_News.html#News-3.23.x
>
> For upgrading from 3.22:
>
> http://www.mysql.com/doc/U/p/Upgrading-from-3.22.html
>
> Regards,
> Monty
>
> PS: We plan to provide patches to MySQL 3.23 for important new features
> like a new faster key cache, but to keep the 3.23 code stable, we
> will probably not incorporate these in the standard version 3.23
> version.
>
> ---------------------------------------------------------------------
> 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