You may have come across numerous presentations showcasing MySQL HeatWave as a Query Accelerator for MySQL. However, if you have not yet had the opportunity to test it yourself (if you have, you already know the answer), allow us to conduct a test using actual data to determine the potential benefits of utilizing a MySQL HeatWave Cluster.

Data & Queries

The data is simple, some arduinos with a DHT22 sensor sending temperature and humidity.

So first let’s have a look at the amount of collected data:

Let’s run some queries to have a reference:

And another one:

HeatWave Cluster

Now let’s enable HeatWave Cluster on OCI Console:

When ready, we can verify that everything is fine and that the cluster is ready:

Then, we need to load the data to HeatWave:

Testing the queries with HeatWave

It took less than 3 minutes to load the data to HeatWave, now it’s time to test again our queries:

And the second one:

This is a huge improvement:

Could it be faster ?

We have increased the amount of HeatWave Cluster nodes:

We can verify it:

And let’s attempt the queries once more:

And for query 2:

Having more HeatWave nodes helps improving even more the query response time.

Conclusion

In conclusion, the answer to the question “Is MySQL HeatWave really faster?” is certainlt YES!

MySQL HeatWave exhibits remarkable speed and efficiency, surpassing expectations and delivering exceptional performance.

As we’ve seen, the HeatWave cluster can turbocharge all your queries. The more complex your query, the faster it’ll be! And guess what? Adding multiple HeatWave nodes can enhance your queries even more. So why wait? Go ahead and make your queries lightning-fast!

Enjoy fast queries on MySQL HeatWave !