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 …

We would like to share a short recaps from the several several MySQL meetups which were hold during October 2024 as follows: Garden State User Group Meetup with MySQL On October 8, in cooperation with the Garden State Java Users Group, we consulted with Scott Stroz, a MySQL Developer Advocate, on the topic of “Using […]

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.

In today’s fast-paced financial landscape, organizations must embrace digital transformation to stay competitive. MySQL Enterprise Edition has empowered over 700 financial services firms to navigate this shift effectively. With its proven performance and scalability, MySQL is uniquely positioned to support demanding applications while ensuring data protection and regulatory compliance.   Overview MySQL Enterprise Edition offers […]

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.