開源數據庫 MySQL 5.1.60 GA 發布下載
MySQL 5.1 發布最新的 5.1.60 GA 版本,下載地址:
主要改進記錄:
Functionality Added or Changed
-
Upgrading from an
Advanced GPLRPM package to anAdvancedRPM package did not work. Now on Linux it is possible to use rpm -U to replace any installed MySQL product by any other of the same release family. It is not necessary to remove the old produce with rpm -e first. (Bug #11886309) -
MEMORYtable creation time is now available in theCREATE_TIMEcolumn of theINFORMATION_SCHEMA.TABLEStable and theCreate_timecolumn ofSHOW TABLE STATUSoutput. (Bug #51655, Bug #11759349)
Bugs Fixed
-
InnoDB Storage Engine: This fix improves the performance of instrumentation code for
InnoDBbuffer pool operations. (Bug #12950803, Bug #62294) -
InnoDB Storage Engine: Data from BLOB columns could be lost if the server crashed at a precise moment when other columns were being updated in an
InnoDBtable. (Bug #12704861) -
InnoDB Storage Engine: Lookups using secondary indexes could give incorrect matches under a specific set of conditions. The conditions involve an index defined on a column prefix, for a BLOB or other long column stored outside the index page, with a table using the Barracuda file format. (Bug #12601439)
-
InnoDB Storage Engine: This fix corrects cases where the MySQL server could hang or abort with a
long semaphore waitmessage. (This is a different issue than when these symptoms occurred during aCHECK TABLEstatement.) (Bug #11766591, Bug #59733) -
Replication: Issuing the following statements, in the order shown, could cause a deadlock between the user thread and I/O thread:
START SLAVE; STOP SLAVE SQL_THREAD; START SLAVE;
(Bug #11878104)
See also Bug #44312, Bug #11752963, Bug #38715, Bug #38716.
-
Internal conversion of zero to binary and back could yield a result with incorrect precision. (Bug #12911710)
-
Valgrind warnings generated by
filesortoperations were fixed. (Bug #12856915) -
Several improvements were made to the
libeditlibrary bundled with MySQL distributions, and that is available for all platforms that MySQL supports except Windows.-
Navigation keys did not work for UTF-8 input.
-
Word navigation and delete operations did not work for UTF-8 input with Cyrillic characters.
-
Nonlatin characters were corrupted in overwrite mode for UTF-8 input.
-
Long queries caused the statement history file to become corrupted.
-
The Alt key caused history operations to fail.
(Bug #12605400, Bug #12613725, Bug #12618092, Bug #12624155, Bug #12617651, Bug #12605388)
</li> -
-
The help message for mysql_install_db did not indicate that it supports the
--defaults-file,--defaults-extra-fileand--no-defaultsoptions. (Bug #58898, Bug #11765888) -
An assertion designed to detect zero-length sort keys also was raised when the entire key set fit in memory. (Bug #58200, Bug #11765254)
-
myisampack could create corrupt
FULLTEXTindexes when compressing tables. (Bug #53646, Bug #11761180) -
OPTIMIZE TABLEcould corruptMyISAMtables ifmyisam_use_mmapwas enabled. (Bug #49030, Bug #11757032) -
If MySQL was configured with
--without-plugin-innobaseand--with-plugin-innodb_plugin, to suppress building the built-in InnoDB storage engine and build the InnoDB Plugin instead, the innochecksum utility was not built. (Bug #47337, Bug #11755544) -
A linking problem prevented the
FEDERATEDstorage engine plugin from loading. (Bug #40942, Bug #11750417) -
On Fedora, certain accesses to
/var/lib/mysql/HOSTNAME.errwere blocked by SELinux policy, which made the server fail at startup with the message:Manager of pid-file quit without updating file(Bug #37165, Bug #12927740) -
For
FEDERATEDtables, loss of connection to the remote table during some insert operations could cause a server crash. (Bug #34660, Bug #11747970)
</ul>
</div>
- 使用C和C++編寫,并使用了多種編譯器進行測試,保證源代碼的可移植性。
- 支持AIX、BSDi、FreeBSD、HP-UX、Linux、Mac OS、Novell Netware、NetBSD、OpenBSD、OS/2 Wrap、Solaris、SunOS、Windows等多種操作系統。
- 為多種編程語言提供了API。這些編程語言包括C、C++、C#、Delphi、Eiffel、Java、Perl、PHP、Python、Ruby和Tcl等。
- 支持多線程,充分利用CPU資源,支持多用戶。
- 優化的SQL查詢算法,有效地提高查詢速度。
- 既能夠作為一個單獨的應用程序應用在客戶端服務器網絡環境中,也能夠作為一個庫而嵌入到其他的軟件中。
- 提供多語言支持,常見的編碼如中文的GB 2312、BIG5,日文的Shift_JIS等都可以用作數據表名和數據列名。
- 提供TCP/IP、ODBC和JDBC等多種數據庫連接途徑。
- 提供用于管理、檢查、優化數據庫操作的管理工具。
- 可以處理擁有上千萬條記錄的大型數據庫。
MySQL是一個開放源碼的小型關聯式數據庫管理系統,開發者為瑞典MySQL AB公司。目前MySQL被廣泛地應用在Internet上的中小型網站中。由于其體積小、速度快、總體擁有成本低,尤其是開放源碼這一特點,許多中小型網站為了降低網站總體擁有成本而選擇了MySQL作為網站數據庫。