diff options
author | serg@serg.mysql.com <> | 2002-02-20 12:03:43 +0000 |
---|---|---|
committer | serg@serg.mysql.com <> | 2002-02-20 12:03:43 +0000 |
commit | 26e0a5c5eb943d291a5fd69e1fadb8537b3ecdbc (patch) | |
tree | c048f9bdd321bb95a52264c12a1c5f89f283064f /Docs | |
parent | 6adc34bd0ad495e2b1a9134548c2b38bd207999a (diff) | |
parent | b0658731631a30b4c3f8123571f28df5cb780546 (diff) | |
download | mariadb-git-26e0a5c5eb943d291a5fd69e1fadb8537b3ecdbc.tar.gz |
Merge work:/home/bk/mysql into serg.mysql.com:/usr/home/serg/Abk/mysql
Diffstat (limited to 'Docs')
-rw-r--r-- | Docs/linuxthreads.txt | 15 | ||||
-rw-r--r-- | Docs/manual.texi | 64 |
2 files changed, 78 insertions, 1 deletions
diff --git a/Docs/linuxthreads.txt b/Docs/linuxthreads.txt new file mode 100644 index 00000000000..0989f8d3718 --- /dev/null +++ b/Docs/linuxthreads.txt @@ -0,0 +1,15 @@ +Notes on compiling glibc for the standard MySQL binary: + + - make sure you have gcc 2.95 and gmake 3.79 or newer + - wget ftp://ftp.gnu.org/pub/gnu/glibc/glibc-2.2.5.tar.gz + - wget ftp://ftp.gnu.org/pub/gnu/glibc/glibc-linuxthreads-2.2.5.tar.gz + - tar zxvf glibc-2.2.5.tar.gz ; cd glibc-2.2.5 ; + tar zxvf ../glibc-linuxthreads-2.2.5.tar.gz + - in linuxthreads/internals.h change STACK_SIZE to (128*1024) + - in linuxthreads/sysdeps/unix/sysv/linux/bits/local_lim.h change + PTHREAD_THREADS_MAX to 4096 + - ./configure --prefix=/usr/local/mysql-glibc --enable-static-nss --disable-shared --enable-add-ons=linuxthreads + - make + - possible problems - if compiler is not properly installed, one can get + "cpp: too many input" files error - easiest way to solve - SUSE RPM for gcc + 2.95 diff --git a/Docs/manual.texi b/Docs/manual.texi index 367591f6039..a93d5b2194b 100644 --- a/Docs/manual.texi +++ b/Docs/manual.texi @@ -46833,6 +46833,7 @@ users use this code as the rest of the code and because of this we are not yet 100% confident in this code. @menu +* News-3.23.49:: Changes in release 3.23.49 * News-3.23.48:: Changes in release 3.23.48 * News-3.23.47:: Changes in release 3.23.47 * News-3.23.46:: Changes in release 3.23.46 @@ -46885,13 +46886,74 @@ not yet 100% confident in this code. * News-3.23.0:: Changes in release 3.23.0 @end menu -@node News-3.23.48, News-3.23.47, News-3.23.x, News-3.23.x +@node News-3.23.49, News-3.23.48, News-3.23.x, News-3.23.x +@appendixsubsec Changes in release 3.23.49 +@itemize @bullet +@item +Don't give warning for statement that is only a comment; This is needed for +@code{mysqldump --disable-keys} to work. +@item +Fixed unlikely caching bug when doing a join without keys. In this case +the last used field for a table always returned @code{NULL}. +@item +Added options to make @code{LOAD DATA LOCAL INFILE} more secure. +@item +MySQL binary release 3.23.48 for Linux contained a new glibc library, which +has serious problems under high load and RedHat 7.2. The 3.23.49 binary +release doesn't have this problem. +@end itemize + +@node News-3.23.48, News-3.23.47, News-3.23.49, News-3.23.x @appendixsubsec Changes in release 3.23.48 @itemize @bullet @item +Changed to use @code{autoconf} 2.52 (from @code{autoconf} 2.13) +@item Fixed bug in complicated join with @code{const} tables. @item Added internal safety checks for InnoDB. +@item +Some InnoDB variables was always shown in @code{SHOW VARIABLES} as +@code{OFF} on high-byte-first systems (like sparc). +@item +Fixed problem with one thread using an InnoDB table and another +thread doing an @code{ALTER TABLE} on the same table. Before that, +mysqld could crash with an assertion failure in row0row.c, line 474. +@item +Tuned the InnoDB SQL optimizer to favor more often index searches +over table scans. +@item +Fixed a performance problem with InnoDB tables when several large SELECT +queries are run concurrently on a multiprocessor Linux computer. Large +CPU-bound SELECT queries will now also generally run faster on all +platforms. +@item +If MySQL binlogging is used, InnoDB now prints after crash recovery the +latest MySQL binlog name and the offset InnoDB was able to recover +to. This is useful, for example, when resynchronizing a master and a +slave database in replication. +@item +Added better error messages to help in installation problems of InnoDB tables. +@item +One can now recover also MySQL temporary tables which have become +orphaned inside the InnoDB tablespace. +@item +InnoDB now prevents a @code{FOREIGN KEY} declaration where the signedness +is not the same in the referencing and referenced integer columns. +@item +Calling @code{SHOW CREATE TABLE} or @code{SHOW TABLE STATUS} could cause +memory corruption and make mysqld to crash. Especially at risk was +@code{mysqldump}, because it calls frequently @code{SHOW CREATE TABLE}. +@item +If inserts to several tables containing an auto-inc column were wrapped +inside one @code{LOCK TABLES}, InnoDB asserted in lock0lock.c. +@item +In 3.23.47 we allowed several @code{NULLS} in a @code{UNIQUE} secondary +index for an InnoDB table. But @code{CHECK TABLE} was not relaxed: it +reports the table as corrupt. @code{CHECK TABLE} no longer complains in +this situation. +@item +@code{SHOW GRANTS} now shows @code{REFERENCES} instead of @code{REFERENCE}. @end itemize @node News-3.23.47, News-3.23.46, News-3.23.48, News-3.23.x |