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 …

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 …

Most of us are lucky that software bugs are a small part of our lives. The ‘things just work’ attitude works for most situations, but occasionally something appears that may seem trivial at first glance may be catastrophic.

A bug appeared in MySQL’s recently released 8.0.32 that really caught my attention. This is a prime example of how a minor bug could have a significant impact on your life and a detrimental impact on your company or project.

The title Wrong result for AVG() OVER(ROWS BETWEEN 1 FOLLOWING AND UNBOUNDED FOLLOWING) is the first thing that caught my eye. A lot of developers heavily use the AVG() function. My first thought was, ‘ut-oh, AVG() being broken is a terrible thing,’ but then I realized it was thankfully not that drastic.

The OVER() clause indicates this is a problem in a Window Function. And odds are, if you are using OVER() for …

The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community. I would like to thank all contributors on behalf of the entire Oracle MySQL team ! MySQL 8.0.32 contains patches from Facebook/Meta, Alexander Reinert, […]

The latest MySQL release has been published on January 17th, 2023. MySQL 8.0.32 contains some new features and bug fixes. As usual, it also contains contributions from our great MySQL Community.

I would like to thank all contributors on behalf of the entire Oracle MySQL team !

MySQL 8.0.32 contains patches from Facebook/Meta, Alexander Reinert, Luke Weber, Vilnis Termanis, Naoki Someya, Maxim Masiutin, Casa Zhang from Tencent, Jared Lundell, Zhe Huang, Rahul Malik from Percona, Andrey Turbanov, Dimitry Kudryavtsev, Marcelo Altmann from Percona, Sander van de Graaf, Kamil Holubicki from Percona, Laurynas Biveinis, Seongman Yang, Yamasaki Tadashi, Octavio Valle, Zhao Rong, Henning Pöttker, Gabrielle Gervasi and Nico Pay.

Here is the …

Recently Jack asked me for a Sysbench package for OL9.

In this post, you can find the RPM packages of Sysbench 1.1.0 build for Oracle Linux 9, RedHat Enterprise 9 and any RPM compatible system.

Sysbench’s binary is linked with libmysqlclient.so.21 and libssl.so.3.

Here are the two files, one for x86_64 and one for aarch64 (ARM):

sysbench-1.1.0-2.el9.x86_64Download

…

SQL is foundational in web and application programming. There are many websites and resources online to learn SQL. I like these 5 websites and think you will too…

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.

Read the article: 5 Websites To Learn More SQL

Support the OpenLampTech publication with your free subscription. Thank you!

Thank you for reading this post. Please share it …

MySQL Shell 8.0.32 was released last week and includes several bugfixes as well as some new features. Let's look into what was added in this new release. New Features $ cat ~/.my.cnf [client] user=root host=lefred password=lefreptwasswort $ mysqlsh MySQL Shell 8.0.32-commercial Copyright (c) 2016, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of […]

Last year, in March 2022, our MySQL Operator for Kubernetes became Generally Available. Since then, several new features were added to our operator and along with the release of MySQL Server 8.0.32 comes a new release of our MySQL Operator for Kubernetes 8.0.32-2.0.8.  The goal of the MySQL Operator for Kubernetes is to provide an easy way […]

On January 17 2023, MySQL Server 8.0.32 was released. It is the latest release of our MySQL 8.0 General Availability Release. The new release introduces a few new features alongside with some deprecations, as well as bugfixes and security fixes. Let’s dive into some detail on these new features and changes MySQL Enterprise Optimizer mysql> […]