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 18272 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 18272
MySQL 4.0.8 Released !
작성자
허정수(wertyu)
작성일
2003-01-09 09:09
조회수
8,786

Monty로부터 온 메일입니다.

(물론 개인적으로 온 것은 아니구요 ^^)

 

중요한 것은 max_allowed_packet_size 가 1Gb로 늘었다는 것이죠....

 

그럼

 

#############################################################

 

 

Hi,

 

MySQL 4.0.8, a new version of the world's most popular Open Source Database,

has been released. It is now available in source and binary form for a number

of platforms from our download pages at http://www.mysql.com/downloads/ and

mirror sites.

 

Note that all mirrors may not be up to date; If you can't find this

version on some mirror, please retry later or try another mirror.

 

This is a new gamma release, fixing some recently discovered bugs.

If this release doesn't have any major problems, we will release 4.0.9

as a stable release.

 

>From the ChangeLog:

-------------------

 

 

Functionality added or changed:

* Default `max_packet_length' for libmysqld.c is now 1024*1024*1024.

 

* One can now specify `max_allowed_packet' in a file ready by

`mysql_options(MYSQL_READ_DEFAULT_FILE)'. for clients.

 

* When sending a too big packet to the server with the not compressed

protocol, the client now gets an error message instead of a lost

connection.

 

* We now send big queries/result rows in bigger hunks, which should

give a small speed improvement.

 

* Fixed some bugs with the compressed protocol for rows > 16M.

 

 

Bugs fixed:

* Fixed bug in `ALTER TABLE' with BDB tables.

 

* Fixed core dump bug in `QUOTE()' function.

 

* Fixed a bug in handling communication packets bigger than 16M.

Unfortunately this required a protocol change; If you upgrade the

server to 4.0.8 and above and have clients that uses packets >=

255*255*255 bytes (=16581375) you must also upgrade your clients

to at least 4.0.8. If you don't upgrade, the clients will hang

when sending a big packet.

 

* Fixed bug when sending blobs longer than 16M to client.

 

* Fixed bug in `GROUP BY' when used on BLOB column with `NULL'

values.

 

* Fixed a bug in handling `NULL's in `CASE' ... WHEN ...

 

 

InnoDB changes:

 

* InnoDB now supports also FOREIGN KEY (...) REFERENCES ...(...)

[ON UPDATE CASCADE | ON UPDATE SET NULL | ON UPDATE RESTRICT | ON

UPDATE NO ACTION].

 

* Tables and indexes now reserve 4 % less space in the tablespace.

Also existing tables reserve less space. By upgrading to 4.0.8 you

will see more free space in "InnoDB free" in SHOW TABLE STATUS.

 

* Fixed bugs: updating the PRIMARY KEY of a row would generate a

foreign key error on all FOREIGN KEYs which referenced secondary

keys of the row to be updated. Also, if a referencing FOREIGN KEY

constraint only referenced the first columns in an index, and

there were more columns in that index, updating the additional

columns generated a foreign key error.

 

* Fixed a bug: if an index contains some column twice, and that

column is updated, the table will become corrupt. From now on

InnoDB prevents creation of such indexes.

 

* Fixed a bug: removed superfluous error 149 and 150 printouts from

the .err log when a locking SELECT caused a deadlock or a lock

wait timeout.

 

Regards,

Monty

 

--

MySQL 2003 Users Conference -> http://www.mysql.com/events/uc2003/

__ ___ ___ ____ __

/ |/ /_ __/ __/ __ \/ / Mr. Michael Widenius <monty@mysql.com>

/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO

/_/ /_/\_, /___/\___\_\___/ Helsinki, Finland

<___/ www.mysql.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 <mysql-thread129275@lists.mysql.com>

To unsubscribe, e-mail <mysql-unsubscribe-jsheo=simplexi.com@lists.mysql.com>

Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

이 글에 대한 댓글이 총 3건 있습니다.

binary든 뭐든 datadir 옵션으로 Data directory만 변경해서 지정해 주면 되죠.

 

>> 또한 기존에 사용하던 mysql을 다시 컴파일해서 설치해도 make_install_db를 실행해야 하는가요?

 

안 하셔도 됩니다. ^^

허정수(wertyu)님이 2003-01-06 18:56에 작성한 댓글입니다.

제가 궁금한건..그 datadir을 설정해주는 방법인데요.

바이너리 설치는 압축해제하구선, make_install_db를 해주고 사용하는데, 그냥하게되면 디폴트로 설치될것이고, 해서 혹시나해서 make_install_db 뒤에 옵션으로 주어도 안되고, ./configure에 주어도 안되더군요..^.^

무식하니 용감하게 해야죠...

어떻게 해야하는지...좀....

스페이스님이 2003-01-06 19:22에 작성한 댓글입니다.

MySQL에서 최신 GlibC 버전을 사용하는 경우, remote connection 시 MySQL 데몬이 죽는 경우가 있습니다.

 

이 경우, "--skip-name-resolve" 옵션으로 데몬을 실행시켜 주시기 바랍니다.

 

이 문제는 4.0.9에서 해결될 예정입니다.

허정수(wertyu)님이 2003-01-10 09:43에 작성한 댓글입니다.
[Top]
No.
제목
작성자
작성일
조회
18818MySQL 4.0.12 has been Released [1]
정동철
2003-03-19
9738
18799MySQL/InnoDB-3.23.56 Released
정동철
2003-03-17
7670
18330MySQL 4.0.9 Released
허정수
2003-01-15
7476
18272MySQL 4.0.8 Released ! [3]
허정수
2003-01-09
8786
18143Multiple MySQL vulnerabilities
허정수
2002-12-20
7011
17300MySQL 4.1이 공개 되었습니다. [1]
허정수
2002-10-09
7963
17105MySQL 4.0.X의 기능 추가가 종료되고, 4.1로 넘어 갔습니다.
허정수
2002-09-13
6285
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2024 DSN, All rights reserved.
작업시간: 0.016초, 이곳 서비스는
	PostgreSQL v16.2로 자료를 관리합니다