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

A few days ago, Oracle released three new MySQL GA versions: 8.2.0, 8.0.35 and 5.7.44.  I skimmed the release notes (8.2.0, 8.0.35 and 5.7.44), and I am not impressed.  I guess that I would be even less impressed / more disappointed if I had checked in greater detail, and if I had reviewed the 8.1.0, 8.0.34 and 5.7.43 release notes.  The subject of my disappointment is Oracle not

PHP developer and Laravel content creator Marian Pop shares a fantastic developer interview with the OpenLampTech newsletter readers.

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.

Welcome to this OpenLampTech text-based developer interview.

PHP developer Marian Pop is very active in the Laravel community.

Marian writes a daily blog, and a newsletter, and has a podcast – all covering Laravel.

Subscribe to OpenLampTech to read this interview and more.