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, […]

PyCon & HKCE 2023

Introduction In this article, we are going to see how Index Selectivity works in relational database systems and why the database Optimizer might choose to avoid using an index if the number of matching records is large. Index selectivity is inversely proportional to the number of index entries matched by a given value. So, a unique index has the highest selectivity because only a single entry can be matched by any given value. On the other hand, if column values are skewed, then a column value matching a large number of table... Read More

The post Index Selectivity appeared first on Vlad Mihalcea.

We already have a tutorial on how to connect to the MySQL database using Node.js. Well, you can read it if you want to know, but it only allows you to interact with the database, what if you want to insert some new records directly from Node.js? You can also easily do this by executing […]