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:
select format_bytes(sum(data_length)) DATA,
format_bytes(sum(index_length)) INDEXES,
format_bytes(sum(data_length + index_length)) 'TOTAL SIZE'
from information_schema.TABLES order by data_length + index_length;
+-----------+-----------+------------+
| DATA | INDEXES | TOTAL SIZE |
+-----------+-----------+------------+
| 21.89 GiB | 14.06 GiB | 35.95 GiB |
+-----------+-----------+------------+
1 …
[Read more]