Oracle doubles the speed of MySQL query handling

Joab Jackson

Beyond performance, Oracle is also enhancing MySQL in a number of other ways.

The company has expanded the software's performance schema, which defines the metrics used to gauge the performance of the database. The database collects performance on itself through various internal probes. The schema can be used to extract and summarize that information through the database or with external tools, which can be handy for diagnosing performance issues.

The schema now offers a lot more information about what is happening within the server's memory. It can be used to pinpoint problems around metadata locking and other elusive issues. A user, for instance, can use SQL to extract all the memory performance metrics around a specific database table.

MySQL Workbench 6.1, which Oracle also released on Monday, includes a set of new graphical diagnostic tools based on these new memory probes.

One change that users may not immediately notice is that Oracle has started rearchitecting the MySQL code, making it a lot more modular. The software's parser, optimizer and replication capabilities are being rewritten in a modular format.

"MySQL is a codebase that stems back, in some parts, to the 1980s," Ulin said, noting that MySQL grew in a piecemeal fashion as more and more features were added over time. "To be frank, the whole architecture wasn't well thought out for the end-product," Ulin said.

A more modular MySQL will help third-party developers extend MySQL a lot more easily, since each specific set of functionality will have a clean interface, distinct from other parts of the program.

The company is also cooking up a number of other new functions that aren't yet mature enough for this milestone release, but might be part of version 5.7. One feature would be the first to have multi-master replication.

Until now, each backup server could only be assigned to replicate data from a single master server. Now a backup server can have multiple master servers. This would allow an office, for instance, to run a single backup database for multiple primary databases.

In addition to previewing MySQL 5.7, the company has also released a number of number of companion or adjunct MySQL tools.

The company has issued a release candidate of MySQL Fabric, which allows an organization to shard, or slice up, a very large database to it can run across multiple servers. MySQL Fabric is part of the MySQL Utilities 1.4.2 package. It has also issued a preview of the next version of MySQL Cluster, version 7.4.

 

Previous Page  1  2