#Hate Update: re prev toot ... today I hate #MySQL #information_schema because it tells great big dirty LIES. You need to `ANALYZE TABLE` on any table you're interested in immediately before you ask information_schema for its metadata.
【MySQL】知っておくと便利なinformation_schemaのクエリ集 - Qiita

はじめにINFORMATION_SCHEMAはデータベースのメタデータが格納されているデータベースです。以下、公式ドキュメントの解説になります。INFORMATION_SCHEMA では、データ…

Qiita

MySQL Database Service – find the info: part 4 – connections
As a MySQL DBA, you like to know who is connected on the system you manage. You also like to know who is trying to connect.

In this article, we will discover how we can retrieve the information and control who is using the MySQL DB instance we launched in OCI.

https://lefred.be/content/mysql-database-service-find-the-info-part-4-connections/
#8.0 #Cloud #Information_Schema #MDS #MySQL #MySQL8.0 #OCI #Performance_Schema

MySQL Database Service – find the info: part 4 – connections

As a MySQL DBA, you like to know who is connected on the system you manage. You also like to know who is trying to connect. In this article, we will discover how we can retrieve the information and…

lefred blog: tribulations of a MySQL Evangelist