Join us on Tuesday, October 25th, for the third and final part of our webinar trilogy on MySQL Query Tuning, in which we look at the query tuning process and tools to help with that. So far in this trilogy we’ve covered topics such as SQL tuning, indexing, the optimizer and how to leverage EXPLAIN to gain insight into execution plans.

For Part 3, Krzysztof Książek, Senior Support Engineer at Severalnines, will now take a look at working with the optimizer as well as SQL tuning. This will include a discussion on how execution plans are calculated and a closer look at InnoDB statistics, how to hint optimizer and finally, how to optimize SQL.

MySQL Query Tuning (III): Working with optimizer and SQL tuning

Tuesday, October 25th

Sign up for the webinar

…

The MySQL team at Oracle are excited to announce the immediate availability of the MySQL Cluster 7.5.4 GA release!

The development focus has been on improving overall performance and ease of use, combined with improved SQL support and the introduction of read optimized and fully replicated tables, all of which allow for better support of a variety of use cases. 

Use Case: Hadoop Performance Records Smashed by Hops and MySQLCluster--delivers over 1.2 million operations per second

The key enhancements delivered by MySQL Cluster 7.5 are summarized below:

Improved Performance: Improvements in index/range scan performance and internal thread handling will allow for better use of existing hardware and …

Pinterest Infrastructure engineers are the caretakers of more than 75 billion Pins–dynamic objects in an ever-growing database of people’s interests, ideas and intentions. A Pin is stored as a 1.2 KB JSON blob in sharded MySQL databases. A few years back, as we were growing quickly, we were running out of space on our sharded MySQL databases and had to make a change. One option was to scale up hardware (and our spend). The other option–which we chose–was using MySQL InnoDB page compression. This cost a bit of latency but saved disk space. However, we thought we could do better. As a result, we created a new form of MySQL compression which is now available to users of Percona MySQL Server 5.6.

JSON is efficient for developers, not machines

As a small start-up, Pinterest built and scaled its MySQL …

Percona announces the release of Percona Server 5.6.33-79.0 on October 18th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories.

Based on MySQL 5.6.33, including all the bug fixes in it, Percona Server 5.6.33-79.0 is the current GA release in the Percona Server 5.6 series. Percona Server is open-source and free – this is the …

Here is the second in a series of posts about CTEs, a new feature of MySQL 8.0, available in this Labs release. The first post ended with:

Inside the recursive CTE definition (the part in AS (…)), some syntax constraints must be respected […]

• a recursive SELECT mustn’t contain GROUP BY, aggregate functions
  (like SUM), ORDER BY, LIMIT, DISTINCT (this rule doesn’t apply to the non-recursive/anchor/seed SELECT)
• a recursive SELECT must reference the CTE only once and only in its
  FROM clause, not in any subquery.

…

MySQL Connector/Node.JS 1.0.4 was recently released as a development milestone release. This is the first version available via npmjs.com. npmjs.com is the central registry for Node.JS packages. This and potential future official MySQL packages can be found using the @mysql organisation. For this to work we had to change the package name to contain that prefix and have chosen the name @mysql/xdevapi as this package provides the implementation of our X DevAPI for Node.JS and we have a free namespace for potential future libraries as part of our Connector/Node.JS product.

Given an existing Node.JS project we can easily install the library:

$ npm install --save @mysql/xdevapi …

From our October NYC Meetup, Ronald Bradford gave a presentation on “MySQL Replication Smackdown – Evaluating current replication capabilites”. Some of the details of his presentation included:

Download PDF Presentation

• What are the common approaches to data replication?
• Why do you want to use data replication in your application?
• What MySQL offers with different replication types.
• What are the limitations of different MySQL replication.
• How to evaluate your architecture needs
• A new architecture mindset …

The Theory

Generated Columns is a feature released on MySQL 5.7. They can be used during CREATE TABLE or ALTER TABLE statements. It is a way of storing data without actually sending it through the INSERT or UPDATE clauses in SQL. The database resolves what the data will be.

There are two types of Generated Columns: Virtual and Stored. They work with:

• mathematical expressions (product_price * quantity)
• built-in functions (RIGHT(), CONCAT(), FROM_UNIXTIME(), JSON_EXTRACT())
• literals (“2”, “new”, 0)

Besides that, they can be indexed but they don’t allow …