To summarize, the main new features of MariaDB (MySQL5.6 Enterprise Branch)

① supports 48-core CPUs, while 5.5 supports 24-core CPUs

② memory Thermal Data persistence, we know that when the system restarts or the MySQL process restarts, the InnoDB in the memory pool of the hot data are all emptied, need to re-cache the disk data, and then according to the most recent use of the LRU principle, keep the thermal data in memory, cold data kicked out to disk. The process is slow. This is improved in 5.6, which automatically exports the hot data from the memory to the disk, so that after MySQL restarts, the InnoDB memory pool is imported from disk immediately, reducing the interaction with disk IO.

③ Online DDL functionality. In version 5.5, modifying the table structure will cause the lock table, for example, the user's incoming pieces will get stuck, and if the table is large, the lock will take longer. So in version 5.6, the problem was solved, as the DBA modifies the table structure while the user is in, the InnoDB internal Row_log records the newly generated DML operations during the DDL change process and applies it to the new table at the end of the DDL execution to ensure data integrity.

④ Multi-threaded replication (implemented using group submissions), 5.5 version is a single-process serial replication, through the sql_thread thread to restore the main library push over Binlog, this will create a problem, the main library on a large number of write operations, from the library may be delayed. In MARIADB 10 through multi-threaded replication technology, if the main library has 10 transactions in 1 seconds, then merge an IO commit once, and add a cid = XX mark in Binlog, when the CID value is the same, you can do parallel replication, by setting multiple Sql_ Thread implementation.

⑤ semi-synchronous replication technology. The default is asynchronous replication technology, the main library commits transactions are immediately returned to the client, while the semi-synchronous replication technology is, the main library commits a transaction, to ensure that at least one from the library received Binlog, the request feedback to the client, so that the data security is greatly ensured.

⑥ recovery from vault security crash. DBAs often encounter 1032 (update/delete data not found) and 1062 errors (primary key conflicts), which is because Relay-log is written as a file, without the concept of a transaction, since the library is down. Principle: From the library to perform the Binlog recovery, will brush the disk relay-log, if the brush disk at the moment of downtime, Relay-log no record, then restart the MySQL process from the library, will execute two times the same SQL, resulting in synchronous replication error. 5.6 Is the Relay-log record a InnoDB table, when the transaction is finished, first update the Relay-log table, after the successful update commits the transaction.

⑦ is a joyous event for development. Many development like subqueries, benefits: intuitive, easy to implement business SQL, but in 5.5 is a nightmare, performance is very poor, in 5.6 solved this problem, through the optimizer automatic handle query into join associated SQL query statement, for development is completely transparent.

⑧MARIADB 10 provides the audit log functionality.

⑨MARIADB 10 provides a database-level connection pool. We know that PHP is a short connection, there is no connection pool, in high concurrency environment, it is easy to kill the data. And Java framework has a lot of excellent connection pool, just as we use Ali's Druid, C3p0 and so on.

⑩MARIADB 10 supports dynamic columns, which means that JSON objects can be stored and read as well as MongoDB.

Attach the benchmark test chart:

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/73/0A/wKioL1XynzPS2xSGAAGjAnXAwbs976.jpg "title=" Bench.png "alt=" Wkiol1xynzps2xsgaagjanxawbs976.jpg "/>

This article is from the "Spring Yang Technical column" blog, please be sure to keep this source http://hcymysql.blog.51cto.com/5223301/1693902

To summarize, the main new features of MariaDB (MySQL5.6 Enterprise Branch)