In IRC libera:#mysql somebody asked about the performance of SHOW TABLES LIKE 'name' in MySQL 8.0, which was slow for them, but fast in 5.7. They pointed to a forum article from 2022

that had a similar problem with a select-statement on I_S.TABLES.

Both cases had in common a large number of tables in a single schema. The person in IRC had around 40k tables, the person in the forum article 500k tables.

I wrote about the Million Challenge

in 2021, but was unable to follow through for personal reasons. This question prompted me to pick this up.

…

Account password rotation is often a regulatory requirement. For that very reason, MySQL allows you to have multiple passwords on a single account.

I have written about this in Rotating Accounts or Passwords?

.

Of course, if something is a regulatory requirement, you also need to prove that you are meeting it.

So Percona has a nice article Tracking Dual Passwords in MySQL

which shows how can (not) track dual password usage.

While it is somewhat possible to generate a report that shows you which accounts have dual passwords, other things are hard. Finding out which accounts have used what password last, or if an old account password is still being used (and from what machine) is either painful or …

Oct 2024 Meetups Recap

This blog post describes work that landed in MySQL v9.0 and implements generic mechanism to attach key/value attributes to a global system variable, used to improve error messages related to "offline mode".

MySQL Enterprise Edition enables financial services organizations to thrive in a complex and ever-changing environment. By harnessing its capabilities, these institutions can modernize their operations, protect their data, and unlock new opportunities for growth. Modernize your applications and embrace the future of financial services with MySQL Enterprise Edition.

Learn how to enable TLS in MySQL NDB Cluster 8.4 with MySQL NDB Cluster Manager 8.4

With MySQL 9.1 we introduce support for OpenID Connect, making secure authentication easier for developers and enterprises alike.

One of the standout features of dbForge Studio is its ability to import data from various sources, including ODBC data. This significantly expands your capabilities, both for direct conversion of data stored on different platforms and for the convenient development of database-related objects such as ETL procedures, reports, and more.

The post How to Migrate From SQL Server to MySQL appeared first on Devart Blog.

MySQL 8.0 and newer change and improve how we measure and monitor replication lag. Even though multi-threaded replication (MTR) has been on by default for the last three years (since v8.0.27 released October 2021), the industry has been steeped in single-threaded replication for nearly 30 years. As a result, replication lag with MTR is a complicated topic because it depends on version, configuration, and more. This three-part series provides a detailed understanding, starting from what was originally an unrelated feature: binary log group commit.

It’s very difficult explaining to students new to relational databases how SQL works. There are many parts that seem intuitive and then there are others that confuse and confound.

For beginners, the idea that a SQL statement is simply a text string that you must dispatch to a SQL statement processing engine is new. That’s because they use an Integrated Development Environment (IDE) that hides, or abstracts the complexity, of how SQL executes.

I start my core SQL class by demonstrating how to run a text literal query without a FROM clause in MySQL Workbench, like this:

SELECT 'Hello World!' AS "Output";

After writing the query, I highlight everything except the semicolon and click the lightening bolt that dispatches the static string to the SQL statement engine. They see this result:

Then, I launch a mysql Monitor session and write the query with a semicolon to dispatch the SQL …