BestHub
Sign in
Tag

INFORMATION_SCHEMA

1 views collected around this technical thread.

Aikesheng Open Source Community
Aikesheng Open Source Community
Mar 26, 2024 · Databases

MySQL 8.0.22 READ ONLY Database Feature: Overview, Usage, Query Methods, Limitations and Exceptions

This article explains the MySQL 8.0.22 READ ONLY option for individual databases, demonstrates how to enable and verify the read‑only state with ALTER DATABASE and SHOW CREATE DATABASE commands, shows the impact on DDL/DML operations, lists usage restrictions, and notes exceptional cases and backup considerations.

ALTER DATABASEDatabaseINFORMATION_SCHEMA
0 likes · 11 min read
MySQL 8.0.22 READ ONLY Database Feature: Overview, Usage, Query Methods, Limitations and Exceptions
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 2, 2023 · Databases

Real‑time Update of AUTO_INCREMENT in INFORMATION_SCHEMA.TABLES on MySQL 8.0

This article explains how MySQL 8.0 updates the AUTO_INCREMENT column in INFORMATION_SCHEMA.TABLES, describes the underlying statistics caching mechanism, shows how the information_schema_stats_expiry parameter controls refresh frequency, and provides step‑by‑step tests demonstrating real‑time behavior with code examples.

DatabaseINFORMATION_SCHEMAMySQL
0 likes · 10 min read
Real‑time Update of AUTO_INCREMENT in INFORMATION_SCHEMA.TABLES on MySQL 8.0
Tencent Database Technology
Tencent Database Technology
May 31, 2023 · Databases

MySQL Character Set Implementation: From System Tables to Source Code

This article explores MySQL character set implementation by analyzing system tables (CHARACTER_SETS and COLLATIONS) in information_schema and tracing internal source code structures like CHARSET_INFO, initialization logic, and client connection handling.

Client-Server ProtocolCollationDatabase Internals
0 likes · 6 min read
MySQL Character Set Implementation: From System Tables to Source Code
Aikesheng Open Source Community
Aikesheng Open Source Community
Jan 10, 2022 · Databases

Analysis of MySQL 8.0.26 Crash Caused by the terminology_use_previous Parameter and INFORMATION_SCHEMA.PROCESSLIST Access

The article investigates a MySQL 8.0.26 crash triggered by setting the terminology_use_previous parameter to BEFORE_8_0_26, analyzes stack traces and core dumps, compares processlist access methods, references related bugs, and offers mitigation recommendations for monitoring tools.

INFORMATION_SCHEMAMySQLPerformance Schema
0 likes · 12 min read
Analysis of MySQL 8.0.26 Crash Caused by the terminology_use_previous Parameter and INFORMATION_SCHEMA.PROCESSLIST Access
Aikesheng Open Source Community
Aikesheng Open Source Community
Nov 20, 2020 · Databases

Optimizing a Slow MySQL 5.7 Query for Detecting Tables Without Primary or Unique Keys

This article examines why a MySQL 5.7 query that finds tables lacking primary or unique keys runs extremely slowly, demonstrates an experiment reproducing the issue, analyzes the optimizer's subquery rewrite, and shows how adding hints and materialization reduces execution time from over 16 seconds to under one second.

INFORMATION_SCHEMAMySQLQuery Optimization
0 likes · 4 min read
Optimizing a Slow MySQL 5.7 Query for Detecting Tables Without Primary or Unique Keys
Aikesheng Open Source Community
Aikesheng Open Source Community
Aug 30, 2019 · Databases

Determining MySQL Table Disk Usage with INFORMATION_SCHEMA and INNODB_SYS_TABLESPACES

This article explains why retrieving a MySQL table's on‑disk size via INFORMATION_SCHEMA.TABLES is unreliable, describes the impact of storage engines and row formats, and shows how to obtain accurate sizes by querying INNODB_SYS_TABLESPACES, including considerations for compression and configuration settings.

Disk SpaceINFORMATION_SCHEMAInnoDB
0 likes · 6 min read
Determining MySQL Table Disk Usage with INFORMATION_SCHEMA and INNODB_SYS_TABLESPACES