MySQL 5.1 - what's new?
At the end of November, a beta release of MySQL 5.1 took place. This is not a stable version yet, but it is already clear from it what innovations await us in the final release.
As the authors of the site whenpenguinsattack.com write , in version 5.1, among others, the following features appear:
* Splitting tables. Now, from the point of view of MySQL, one table can be broken up into parts that are physically stored in various places. For the DBMS user, such a table will remain unified and the breakdown will be transparent.
')
* API for plugins. Now, MySQL will load plugins (various components) during program execution, i.e. without restarting the server. The first step in this direction is the emergence of full-text parsing plug-ins, designed to write custom filters of indexed text (as an example - the implementation of full-text search in PDF).
* Event Scheduler. A new object appears in the database - an event. This is a set of SQL commands that will be executed regularly according to a specified schedule.
* Linear replication. Previously, replication was based on sending SQL expressions from the master machine to the slave machine, and now it will be possible to use the mechanism for writing events to a binary log, which describes how to handle specific rows.
original
As the authors of the site whenpenguinsattack.com write , in version 5.1, among others, the following features appear:
* Splitting tables. Now, from the point of view of MySQL, one table can be broken up into parts that are physically stored in various places. For the DBMS user, such a table will remain unified and the breakdown will be transparent.
')
* API for plugins. Now, MySQL will load plugins (various components) during program execution, i.e. without restarting the server. The first step in this direction is the emergence of full-text parsing plug-ins, designed to write custom filters of indexed text (as an example - the implementation of full-text search in PDF).
* Event Scheduler. A new object appears in the database - an event. This is a set of SQL commands that will be executed regularly according to a specified schedule.
* Linear replication. Previously, replication was based on sending SQL expressions from the master machine to the slave machine, and now it will be possible to use the mechanism for writing events to a binary log, which describes how to handle specific rows.
original
Source: https://habr.com/ru/post/873/
All Articles