Cover image by DALL-E: “a manometer with pipe with a dolphin on a background, 3d render”

What’s the best way to store binary data in MySQL? This is a question that has multiple answers, depending on what you want to achieve. For example, if you need to optimize for the storage size, you probably need to use some compression algorithm that compresses your data efficiently. In my case, I really need the best performance, meaning the fastest response time to fetch the entire blob from MySQL.

Let’s put aside the question of whether MySQL is a good fit for storing binary data. The question here, is how to store binary data so the reads from DB are as fast as possible?

The …

MySQL Document Store is a 'NoSQL' solution built on top of MySQL and using MySQL database tables. In this post, we show how to turn on logging so we can see the queried MySQL uses under the covers when we use the MySQL Document Store DRUC API.

Numerous fast-growing, cloud-native organizations have selected MySQL HeatWave as their data platform to effectively overcome their growing pains. See how four of them improved performance, scalability, security, and productivity while reducing costs by migrating to MySQL HeatWave.

This blog introduces a new recovery option available for MySQL Database Systems (DB Systems) that, once enabled, permits data recovery to a specific point in time.

MySQL Database Service supports easy live migrations from an on-premises MySQL 5.7 database to MySQL Database Service.

With so much content online today, how do you find the ‘good stuff’ for a certain topic? While I can’t answer for other niches, if you’re interested in MySQL, PHP, and the LAMP stack, well, you already know the answer. Thank you for reading 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.

In OpenLampTech issue #63, we are looking at great content covering:

• WordPress robots.txt file
• Preventing SQL injections
• 10 books for PHP developers
• Large MySQL tables
• And much much more

I …

Announcing MySQL Shell 8.0.32

While MySQL error codes are useful, understanding what they mean can be difficult. This article looks at common MySQL error codes, non-coded errors, and how to fix them. MySQL error code format Each MySQL error includes: An error number: A MySQL-specific number corresponding to a particular error. An SQLSTATE value: A five-character string that indicates the error condition. An error message: A textual description of the error. MySQL error example Here’s an example of what a MySQL error code looks like:ERROR 1146 (42S02): Table 'test.no_such_table' doesn't exist

In the error above: 1146 is the error number. 42S02 is the SQLSTATE value. Table test.no_such_table doesn't exist is the error message. Common MySQL error codes Let’s explore some common error codes, what they mean, and how to resolve them. Error 1040: Too many connections Error 1040 occurs when MySQL reaches the maximum number of client connections, forcing you to close …

An overview of some common MySQL error codes you may run into what they mean and how to solve them.

This blog post shows the benefits of using MySQL Shell for VS Code when working with a MySQL HeatWave instance.