Recap of DOAG 2023

The latest Episode of MySQL Shorts is now available! Check out Episode 047 on the MySQL YouTube Channel. In this video we talk about how you can use a CASE operator in a JOIN to dynamically determine which column should be matched in an ON clause.   

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 2023, we will be counting down the top 5 MySQL Shorts videos based on views as of […]

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 2023, we will be counting down the top 5 MySQL Shorts videos based on views as of […]

MySQL Invisible Columns | Lightweight Linux distros | 10 PHP libraries for 2023 | New WooCommerce install default blocks. OpenLampTech is a media and content source for PHP, MySQL, 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.

Thank you for reading OpenLampTech. If you are not yet subscribed, be sure and grab a free subscription today.

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

…

Performance Improvements in MySQL 8.0.35 The MySQL team has recently implemented changes that significantly improve the performance of the 8.0.35 version of MySQL Enterprise Edition over the Community Edition.   Benchmarks sysbench is a tool that is widely used for database benchmarks, especially for MySQL An adaptation of  sysbench was used to run various OLTP […]

This blog post highlights the significant performance improvement made in the latest 8.0 version of MySQL Enterprise Edition

In MySQL 8.1 and 8.2 we introduced EXPLAIN INTO and EXPLAIN FOR SCHEMA respectively, two extensions to the EXPLAIN query that can help doing most of your query optimization in the server, rather than a client program. These two features lay the groundwork for automatically running multiple EXPLAINs over multiple schemas without having to manually USE each schema or reenter the EXPLAIN output.

As a follow up to the previous blog from Aug 15, we are happy to announce a list of events and conferences where you can find MySQL Community and/or MySQL Team at. Please see the updated list below, with past events at the end of the report below: Past Events:

In November 2023,  we were invited by “Hong Kong Association for Computer Education” HKACE to deliver a Database Workshop with a large group of secondary school teachers. It was a great time to meet up with over 100+ teachers in a very big computer hall in Hong Kong City University. In HK secondary school education, […]