database.sarang.net
UserID
Passwd
Database
DBMS
ㆍMySQL
PostgreSQL
Firebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
MySQL News 20076 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 20076
MySQL 4.0.15 has been released
작성자
강병기(asfreeas)
작성일
2003-09-23 13:54
조회수
8,547

2003년 9월 10일

 

MySQL 4.0.15가 새로 나왔습니다. 다운 받으시려거든
http://www.mysql.com/downloads/ 나 미러 사이트에서 하시면 됩니다.

이번 판은 현 버전에 대한 bugfix release입니다.


Please refer to our bug database at http://bugs.mysql.com/ for more
details about the individual bugs fixed in this version.

News from the ChangeLog:

변경되거나 추가된 기능:

* `mysqldump' now correctly quotes all identifiers when communicating
   with the server. This assures that during the dump process,
   `mysqldump' will never send queries to the server that result in a
   syntax error.  This problem is *not* related to the `mysqldump'
   program's output, which was not changed. (Bug #1148)

* Change result set metadata information so that `MIN()' and `MAX()'
   report that they can return `NULL' (this is true because an empty
   set will return `NULL'). (Bug #324)

* Produce an error message on Windows if a second `mysqld' server is
   started on the same TCP/IP port as an already running `mysqld'
   server.

* The `mysqld' server variables `wait_timeout', `net_read_timeout'
   and `net_write_timeout' now work on Windows.

* Added option `--sql-mode=NO_DIR_IN_CREATE' to make it possible for
   slaves to ignore `INDEX DIRECTORY' and `DATA DIRECTORY' options
   given to `CREATE TABLE'.  When this is mode is on, `SHOW CREATE
   TABLE' will not show the given directories.

* `SHOW CREATE TABLE' now shows the `INDEX DIRECTORY' and `DATA
   DIRECTORY' options, if they were specified when the table was
   created.

* The `open_files_limit' server variable now shows the real open
   files limit.

* `MATCH ... AGAINST()' in natural language mode now treats words
   that are present in more than 2,000,000 rows as stopwords.

* The Mac OS X installation disk images now include an additional
   `MySQLStartupItem.pkg' package that enables the automatic startup
   of MySQL on system bootup.  *Note Mac OS X installation::.

* Most of the documentation included in the binary tarball
   distributions (`.tar.gz') has been moved into a subdirectory
   `docs'.  *Note Installation layouts::.

* The manual is now included as an additional `info' file in the
   binary distributions. (Bug #1019)

* Many binary distributions now include the embedded server library
   (`libmysqld') by default.  *Note Nutshell Embedded MySQL::.

* MySQL can now use range optimisation for `BETWEEN' with
   non-constant limits. (Bug #991)

* Replication error messages now include the default database, so
   that users can check which database the failing query was run for.

* Now the slave does not replicate `SET PASSWORD' if it is
   configured to exclude the `mysql' database from replication (using
   for example `replicate-wild-ignore-table=mysql.%'). This was
   already the case for `GRANT' and `REVOKE' since version 4.0.13
   (though there was Bug #980 in 4.0.13 & 4.0.14, which has been
   fixed in 4.0.15).

* Rewrote the information shown in the `State' column of `SHOW
   PROCESSLIST' for replication threads and for `MASTER_POS_WAIT()'
   and added the most common states for these threads to the
   documentation, *note Replication Implementation Details::.

* Added a test in replication to detect the case where the master
   died in the middle of writing a transaction to the binlog; such
   unfinished transactions now trigger an error message on the slave.

* A `GRANT' command that creates an anonymous user (that is, an
   account with an empty username) no longer requires `FLUSH
   PRIVILEGES' for the account to be recognized by the server.  (Bug
   #473)

* `CHANGE MASTER' now flushes `relay-log.info'. Previously this was
   deferred to the next run of `START SLAVE', so if `mysqld' was
   shutdown on the slave after `CHANGE MASTER' without having run
   `START SLAVE', the relay log's name and position were lost. At
   restart they were reloaded from `relay-log.info', thus reverting
   to their old (incorrect) values from before `CHANGE MASTER' and
   leading to error messages (as the old relay log did not exist any
   more) and the slave threads refusing to start. (Bug #858)

MySQL 4.0.15 is now available on the following additional platforms:

* HP-UX 11i for Itanium
* OpenBSD 3.4 x86

The binaries for Linux/s390 are currently missing - they will be made
available as soon as possible.

[Top]
No.
제목
작성자
작성일
조회
20582MySQL 4.1.1 has been released. [1]
허정수
2003-12-07
9048
20472MySQL release MaxDB
정재익
2003-11-21
7877
20316MySQL 4.0.16 has been released
강병기
2003-10-29
9704
20076MySQL 4.0.15 has been released
강병기
2003-09-23
8547
18818MySQL 4.0.12 has been Released [1]
정동철
2003-03-19
9700
18799MySQL/InnoDB-3.23.56 Released
정동철
2003-03-17
7630
18330MySQL 4.0.9 Released
허정수
2003-01-15
7433
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.030초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다