Senior Backend Engineer Tanner Record discusses PHP, WordPress, and SQL in this developer interview for OpenLampTech.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Tanner Record writes WordPress and PHP content in his Systematic WordPress Development newsletter, which I’m a recent fan of and highly recommend.

Be sure you’re subscribed to OpenLampTech to receive these posts (and more) directly I’m your inbox at publishing.

Grab your free subscription today.

…

Let's check is MySQL HeatWave improves query response time.

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 row …

MySQL HeatWave enables users to process and query hundreds of terabytes of data in the object store—in a variety of file formats, such as CSV, Parquet, and Aurora/Redshift export files. This ability to store data on Object Storage and retrieve it dynamically when necessary is a notable advantage of Lakehouse when managing MySQL historical data […]

For the last year, we have been producing a series of short-form videos titled “MySQL Shorts”. Each video focusses on a specific topic and are typically less than 5 minutes long. For our Advent Calendar of Content for 2024, we will be counting down the top 5 MySQL Shorts vidoes based on views as of […]

MySQL Shorts is a short-format video series dedicated to all things MySQL. This post is one in a series where we will count down the top 5 MySQL Shorts videos based on views.

MySQL Shorts is a short-format video series dedicated to all things MySQL. Check out the latest video where we discuss how to use a CASE operator in a JOIN.

MySQL binlog | Laravel exception handling | WordPress plugin context | MySQL GUIs. OpenLampTech is a media and content source for MySQL, PHP, and the LAMP stack.

The Newsletter for PHP and MySQL Developers

Receive a copy of my ebook, “10 MySQL Tips For Everyone”, absolutely free when you subscribe to the OpenLampTech newsletter.

Thanks for reading OpenLampTech. If you are not yet subscribed, please consider grabbing a free subscription today.

Thank you for reading this post. Please share it with someone else who would enjoy it as well.

Josh …

GitHub Actions allows DevOps to handle automated deployments. IN this post we talk about how you can use GitHub Actions in conjunction with Knex.js to apply database changes as part of the CI/CD pipeline.

MySQL Shorts is a short-format video series dedicated to all things MySQL. This post is one in a series where we will count down the top 5 MySQL Shorts videos based on views.