We’re excited to announce that InfluxDB 0.11.0 – rc1 is released. It has huge improvements to the query engine to improve performance, stability, and solve some of the out of memory issues that some users were seeing on larger queries. The new query engine is anywhere from 1.4x to 3.8x faster for many queries. By popular request, we’ve also started creating ARM builds! This release has many other improvements including 21 Features and 40 bug fixes.
The new query engine is important because it lays the foundation for many exciting new query features. New functions and ways to transform and combine series will be in the upcoming releases as a result of this effort. We’ll also give administrators the ability to see and even kill long running queries along with other controls limiting resource utilization.
Now let’s take a look at some of the performance gains from this query engine work. I ran a few basic tests. The first has a 10,000 unique series each with 1,000 points. I then ran queries to count all of the points in these series. With this query we saw a 29% decrease in the query response time!
The next test I ran was to query the count on a single series that contained 10 million data points. For this query we saw a 74% decrease in the query response time.
We’re very excited about the work behind the query engine and it should give us a solid foundation to build future query functionality on top of.
For anyone running on version 0.9.6.1 or below, it’s important to note that this release has all of the huge performance gains for write throughput and compression that we put out in 0.10.0. If you’ve been on the fence about upgrading, now’s the time to do it.
Breaking changes and deprecations
The other important thing to note about this release are that there are a few breaking changes to the API and some older things that have been removed or deprecated. The release notes give the details:
- SHOW SERIES output has changed. See new output in this test diff.
- SHOW TAG VALUES output has changed
- JSON write endpoint is now disabled by default and will be officially removed in the next release. If you need to, you still can turn it back on for this release, but please plan to migrate to the line protocol soon.
- b1/bz1 shards are no longer supported. You must migrate all old shards to TSM using the migration tool.
- On queries to create databases, retention policies, and users, the default behavior has changed to create IF NOT EXISTS. If they already exist, no error will be returned.
- On queries with a selector like min, max, first, and last the time returned will be the time for the bucket of the group by window. Selectors for the time for the specific point will be added later.
- Download 0.11 RC and let us know what kinds of query performance you observe either @InfluxDB, the InfluxDB Google Group or drop us a line at email@example.com.
- Get started with InfluxDB here.
- Need help migrating from 0.8x or 0.9x to 0.11? We are here to help! Drop us a line at firstname.lastname@example.org to get your migration project started.
- Looking to level up your InfluxDB knowledge? Check out our economically priced virtual and public trainings.