MySQL 4.0.8-gamma
0 отговора
31 прегледа
MySQL 4.0.8-gamma
Поради промени в протокола заради max_allowed_packet са възможни проблеми с по-старите клиенти при работа с BLOB, TEXT! Т.е. трябва да се ъпгрейдват и клиентите.
Твърде е възможно 4.0.8 да е последната gamma т.е. 4.0.9 най-вероятно ще е стабилна.
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.
salle.online.bg/sig
Твърде е възможно 4.0.8 да е последната gamma т.е. 4.0.9 най-вероятно ще е стабилна.
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.
salle.online.bg/sig