อะไรใหม่ ใน MySQL 5.1

MySQL 5.1 ตอนนี้ยังเป็น Beta อยู่  คาดว่าใกล้ Release เร็วๆ นี้   มีอะไรใหม่?

1.6.1. What's New in MySQL 5.1

The following features have been added to MySQL 5.1.

• Partitioning: This capability enables distributing portions of individual tables across a filesystem, according to rules which can be set when the table is created. In effect, different portions of a table are stored as separate tables in different locations, but from the user point of view, the partitioned table is still a single table. Syntactically, this implements a number of new extensions to the CREATE TABLE, ALTER TABLE, and EXPLAIN ... SELECT statements. As of MySQL 5.1.6, queries against partitioned tables can take advantage of partition pruning. In some cases, this can result in query execution that is an order of magnitude faster than the same query against a non-partitioned version of the same table. See Chapter 18, Partitioning, for further information on this functionality. (Author: Mikael Ronström)

• Row-based replication: Replication capabilities in MySQL originally were based on propagation of SQL statements from master to slave. This is called statement-based replication. As of MySQL 5.1.5, another basis for replication is available. This is called row-based replication. Instead of sending SQL statements to the slave, the master writes events to its binary log that indicate how individual table rows are effected. As of MySQL 5.1.8, a third option is available: mixed. This will use statement-based replication by default, and only switch to row-based replication in particular cases. See Section 6.3, “Row-Based Replication”. (Authors: Lars Thalmann, Guilhem Bichot, Mats Kindahl)

• Plugin API: MySQL 5.1 adds support for a very flexible plugin API that enables loading and unloading of various components at runtime, without restarting the server. Although the work on this is not finished yet, plugin full-text parsers are a first step in this direction. This allows users to implement their own input filter on the indexed text, enabling full-text search capability on arbitrary data such as PDF files or other document formats. A pre-parser full-text plugin performs the actual parsing and extraction of the text and hands it over to the built-in MySQL full-text search. See Section 28.2, “The MySQL Plugin Interface”. (Author: Sergey Vojtovich)

• Event scheduler: MySQL Events are tasks that run according to a schedule. When you create an event, you are creating a named database object containing one or more SQL statements to be executed at one or more regular intervals, beginning and ending at a specific date and time. Conceptually, this is similar to the idea of the Unix crontab (also known as a “cron job”) or the Windows Task Scheduler. See Chapter 22, Event Scheduler. (Author: Andrey Hristov)

• Server log tables: Before MySQL 5.1, the server writes general query log and slow query log entries to log files. As of MySQL 5.1, the server's logging capabilities for these logs are more flexible. Log entries can be written to log files (as before) or to the general_log and slow_log tables in the mysql database. If logging is enabled, either or both destinations can be selected. The --log-output option controls the destination or destinations of log output. See Section 5.12.1, “Server Log Tables”. (Author: Petr Chardin)

• The Instance Manager (IM) now has some additional functionality: SHOW instance_name LOG FILES provides a listing of all log files, SHOW instance_name LOG {ERROR | SLOW | GENERAL} size retrieves a part of the specified log file, and SET instance_name.option_name=option_value sets an option to the specified value and writes it to the configuration file. See Section 5.5, “mysqlmanager — The MySQL Instance Manager”. (Author: Petr Chardin)

• Upgrade program: The mysql_upgrade program (available as of MySQL 5.1.7) checks all existing tables for incompatibilities with the current version of MySQL Server and repairs them if necessary. This program should be run for each MySQL upgrade. See Section 5.6.2, “mysql_upgrade — Check Tables for MySQL Upgrade”. (Authors: Alexey Botchkov, Mikael Widenius)

• Replication between MySQL Clusters is now supported. It is now also possible to replicate between a MySQL Cluster and a non-cluster database. See Section 17.8, “MySQL Cluster Replication”.

• MySQL Cluster Disk Data: In MySQL versions previous to 5.1.6, the NDBCluster storage engine was strictly in-memory; beginning with MySQL 5.1.6, it is possible to store Cluster data (but not indexes) on disk. This allows MySQL Cluster to scale upward with fewer hardware (RAM) requirements than previously. See Section 17.9, “MySQL Cluster Disk Data Storage”.

  The Disk Data implementation includes a new “no-steal” restoration algorithm for fast node restarts when storing very large amounts of data (terabyte range).

• Backup of tablespaces: The mysqldump utility now supports an option for dumping tablespaces. Use -Y or --all-tablespaces to enable this functionality.

• INFORMATION_SCHEMA: MySQL 5.1 provides much more information in its metadata database. New tables in that database include FILES, EVENTS, PARTITIONS, PROCESSLIST, ENGINES, and PLUGINS.

• XML functions: ExtractValue() returns the content of a fragment of XML matching a given XPath expression. UpdateXML() replaces the element selected from a fragment of XML by an XPath expression supplied by the user with a second XML fragment (also user-supplied), and returns the modified XML. See Section 12.9, “XML Functions”. (Author: Alexander Barkov)

• Load emulator: The mysqlslap program is designed to emulate client load for a MySQL server and report the timing of each stage. It works as if multiple clients were accessing the server. See Section 8.15, “mysqlslap — Load Emulation Client”. (Authors: Patrick Galbraith, Brian Aker)

ที่มา : http://dev.mysql.com/doc/refman/5.1/en/mysql-5-1-nutshell.html

 

 

5.1 Stable ยังไม่ออกเลย  แต่มี To do list สำหรับ 5.2 แล้ว

1.6.2. What's Planned for MySQL 5.2

The following features will be added to MySQL 5.2, or change in MySQL 5.2. This section is subject to change as long as MySQL 5.2 development is in its early stages.

• The following constructs will become deprecated in MySQL 5.2, or even disappear:

  • The table_type variable

  • The log_bin_trust_routine_creators variable

  • TIMESTAMP(N): The ability to specify N

  • TYPE to specify the storage engine

  • The RESTORE TABLE SQL statement

  • The BACKUP TABLE SQL statement

  • The SHOW TABLE TYPES SQL statement

  • The SHOW INNODB STATUS SQL statement

  • The SHOW MUTEX STATUS SQL statement

  • The SHOW LOGS SQL statement

  • The SHOW BDB LOGS SQL statement

  • The LOAD TABLE FROM MASTER SQL statement

Links

MySQL 5.1 Document