Skip navigation links
MySQL Enterprise Backup
MySQL APT Repository
MySQL Fabric

MySQL Community Server

New Releases RSS Feed for new product releases

MySQL Quickpoll

What InnoDB specific options are you most eager to see made dynamic?

Take the Quickpoll »

Contact Sales

USA: +1-866-221-0634
Canada: +1-866-221-0634

Germany: +49 89 143 01280
France: +33 1 57 60 83 57
Italy: +39 02 249 59 120
UK: +44 207 553 8447

Japan: 0120-065556
China: 10800-811-0823
India: 0008001005870

More Countries »

Contact Us Online »

MySQL Engineering Blogs

Improvements to STRICT MODE in MySQL
As a part of improving the error handling, in MySQL 5.7.5 we have re-implemented STRICT sql mode. STRICT mode in MySQL affects the errors that arise from invalid, missing, or out of range values in DML statements such as INSERT, UPDATE, and DELETE. The new implementation aims to make the behavior...

Improvements to the MySQL `IGNORE` Implementation
In 5.7.5, as a part of the larger effort to improve error handling, we re-implemented the IGNORE clause (WL#6614). The IGNORE clause is a MySQL extension to the SQL standard. It affects the errors which occur for each row. The new implementation aims to make the behavior of the IGNORE clause more...

MySQL 5.7.5- More variables in replication performance_schema tables
At MySQL, replication usability is of utmost importance to us. Replication information has long been part of SHOW commands, SHOW SLAVE STATUS occupying a major chunk of it. The other sources of replication information being: SHOW MASTER STATUS, SHOW BINLOG EVENTS, SHOW RELAYLOG EVENTS, SHOW...

MySQL 5.7.5-labs: Multi-source Replication
Multi-source replication for MySQL has been released as a part of 5.7.5-labs-preview downloadable from labs.mysql.com. It is one among the several features that are cooking in the replication technologies at MySQL.  (For a birds eye view of all replication features introduced in 5.7 and labs, look...

InnoDB: Supporting Page Sizes of 32k and 64k
In the new InnoDB lab release we support page sizes of 32k and 64k. This gives users even more choices on the page size, allowing you to further customize InnoDB for your particular workload. There are some things worthy of note related to this new feature: The extent size changes when the...

InnoDB General Tablespaces – Preview
The new InnoDB Labs release contains the ability to create and use independent multi-table general tablespaces. This feature will provide a way to group tables together into tablespaces at a location and filename of your choosing.  Tables using row formats of Redundant, Compact, and Dynamic can...

High-Availability at MySQL Central
This year’s MySQL Central at Oracle Open World was an exhilarating experience. In contrast to the previous year’s MySQL Connect events, MySQL have now got their own Central at the main Oracle Open World. In the previous years, we were always short on time and trying to get a lot of...

Creating PivotTables when importing MySQL data using MySQL for Excel
In a previous blog post (Importing related MySQL tables into an Excel Data Model using MySQL for Excel) we covered in detail how an Excel Data Model can be created containing tables and their relationships so the data can be analyzed in Excel via a PivotTable. In this blog post we are going to...

Removing Scalability Bottlenecks in the Metadata Locking and THR_LOCK Subsystems in MySQL 5.7
The MySQL Server 5.7.5 Development Milestone Release, which was published recently, contains some significant changes to the metadata locking (MDL) subsystem and to the usage of the THR_LOCK manager for InnoDB tables. This post provides more information about these changes, which resulted in nice...

New InnoDB Memcached Functionality in 5.7 Lab Release
InnoDB Memcached’s read only query performance in 5.7 has already achieved a remarkable 1.1 million QPS record. Now, the read only query bottleneck shifts to the memcached client itself. Thus anything that can batch the queries and shorten the query strings helps. Multiple Get In the new 5.7...

Back home from MySQL Central @ OpenWorld
Back home after an excellent week at MySQL Central  in San Francisco. I want to thank the MySQL Community for all your questions, suggestions, and discussions. Your knowledge about – and passion for MySQL is stunning. Thank you! It was also good fun, see pictures and comments...

"The Documents contained within this site may include statements about Oracle's product development plans. Many factors can materially affect Oracle's product development plans and the nature and timing of future product releases. Accordingly, this Information is provided to you solely for information only, is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle.

THIS INFORMATION MAY NOT BE INCORPORATED INTO ANY CONTRACTUAL AGREEMENT WITH ORACLE OR ITS SUBSIDIARIES OR AFFILIATES. ORACLE SPECIFICALLY DISCLAIMS ANY LIABILITY WITH RESPECT TO THIS INFORMATION. Refer to the LEGAL NOTICES AND TERMS OF USE for further information."