Tablespace | BestHub

Aikesheng Open Source Community

Feb 7, 2024 · Databases

Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques

This article explains how DBA engineers can speed up MySQL data recovery using Xtrabackup by covering three scenarios—full backup with binlog, single-database restore, and single-table restore—detailing steps such as SQL thread replay, parallel replication, and transportable tablespace techniques with practical command examples.

BackupMySQLRecovery

0 likes · 21 min read

Accelerating MySQL Data Recovery with Xtrabackup: Scenarios and Techniques

Tongcheng Travel Technology Center

Jul 19, 2023 · Databases

InnoDB Storage Model Overview and Internal Structures

This article explains how InnoDB stores data on disk, describing tablespaces, segments, extents, pages, row formats, record headers, page directories, B+‑tree indexes, and the differences between clustered and secondary indexes, with examples and diagrams to illustrate each component.

B-TreeIndexInnoDB

0 likes · 26 min read

InnoDB Storage Model Overview and Internal Structures

Aikesheng Open Source Community

Jun 15, 2023 · Databases

How to Shrink the InnoDB System Tablespace (ibdata1) in MySQL

This article explains the different types of InnoDB tablespaces, why the ibdata1 file can grow uncontrollably, and provides a step‑by‑step procedure—including full backup, instance recreation, and configuration of UNDO and file‑per‑table settings—to safely reduce its size in MySQL environments.

BackupInnoDBMySQL

0 likes · 13 min read

How to Shrink the InnoDB System Tablespace (ibdata1) in MySQL

Wukong Talks Architecture

Oct 17, 2021 · Databases

Understanding MySQL InnoDB Undo Log: Concepts, Storage, and Practical Scenarios

This article explains the MySQL InnoDB undo log—its definition, role in transaction rollback and MVCC, when it is created, where and how it is stored across different MySQL versions, the internal tablespace and rollback‑segment structures, log types, and real‑world examples of its usage.

Database InternalsInnoDBMVCC

0 likes · 15 min read

Understanding MySQL InnoDB Undo Log: Concepts, Storage, and Practical Scenarios

Aikesheng Open Source Community

Sep 27, 2021 · Databases

Troubleshooting MySQL 5.6→5.7→8.0 Upgrade Failure Caused by Orphan Tablespaces and Data Dictionary Inconsistency

This article details the background, error analysis, and step‑by‑step solutions—including logical dump/restore and tablespace transfer—for fixing a MySQL 5.6 to 8.0 in‑place upgrade failure caused by missing #sql‑ib orphan files and data‑dictionary mismatches in a large Zabbix deployment.

Data DictionaryIn-PlaceMySQL

0 likes · 10 min read

Troubleshooting MySQL 5.6→5.7→8.0 Upgrade Failure Caused by Orphan Tablespaces and Data Dictionary Inconsistency

Aikesheng Open Source Community

Sep 6, 2021 · Databases

Limiting Table Row Count in MySQL: Trigger, Partition, and Tablespace Solutions

This article explores multiple MySQL techniques—triggers with a counter table, range partitioning, general tablespace limits, and application‑side buffering—to enforce a hard cap of 10,000 rows per table, discussing implementation steps, code examples, and the trade‑offs of each method.

Database DesignMySQLRow Limit

0 likes · 11 min read

Limiting Table Row Count in MySQL: Trigger, Partition, and Tablespace Solutions

Aikesheng Open Source Community

Jul 14, 2021 · Databases

Recovering a Deleted InnoDB .ibd File and Detecting Missing Tablespace in MySQL

This article demonstrates how to simulate accidental deletion of a MySQL InnoDB .ibd file, observe the impact on queries, recover the file using the file descriptor in /proc, restart MySQL, and verify that various DDL operations can detect the missing tablespace.

Database TroubleshootingInnoDBMySQL

0 likes · 12 min read

Recovering a Deleted InnoDB .ibd File and Detecting Missing Tablespace in MySQL

Aikesheng Open Source Community

Aug 5, 2020 · Databases

Understanding MySQL Tablespaces: System, Single, and General

This article explains the three types of MySQL InnoDB tablespaces—system, single, and general—detailing their structures, configuration options, advantages, disadvantages, and practical procedures for creation, migration, optimization, and removal, with concrete command‑line examples.

Database StorageInnoDBMySQL

0 likes · 13 min read

Understanding MySQL Tablespaces: System, Single, and General

Aikesheng Open Source Community

Jul 28, 2020 · Databases

Recovering MySQL Data from Corrupted Files Using mysqlfrm and Tablespace Import

This guide explains how to restore MySQL databases when the server cannot start by generating table definitions with mysqlfrm, discarding damaged InnoDB tablespaces, copying old .ibd files, and importing them back, followed by verification using mysqlcheck.

Data recoveryDatabaseInnoDB

0 likes · 5 min read

Recovering MySQL Data from Corrupted Files Using mysqlfrm and Tablespace Import

Aikesheng Open Source Community

Apr 20, 2020 · Databases

Understanding and Managing Undo Tablespaces in MySQL 8.0

This article explains the concept of MySQL Undo Log, traces its evolution from version 5.5 to 8.0, and provides step‑by‑step instructions with examples for creating, viewing, configuring, deleting, and moving undo tablespaces, highlighting the new parameters and defaults introduced in MySQL 8.0.

Database AdministrationInnoDBMySQL

0 likes · 9 min read

Understanding and Managing Undo Tablespaces in MySQL 8.0

Aikesheng Open Source Community

Nov 14, 2019 · Databases

Understanding InnoDB Tablespace Space Management

This article explains how InnoDB stores user tables and indexes in .ibd files, describes the structure of tablespaces, pages, extents, header pages, XDES entries, INODE pages, and file segments, and shows how indexes allocate and free these internal structures as they grow and shrink.

Database InternalsInnoDBMySQL

0 likes · 10 min read

Understanding InnoDB Tablespace Space Management

Tencent Database Technology

Jul 25, 2019 · Databases

InnoDB File Structure: Physical and Logical Organization

This article provides a comprehensive overview of InnoDB's file structure, covering physical organization from pages to tablespaces, logical structure including segments and indexes, and file management processes.

B-TreeDatabase ManagementInnoDB

0 likes · 22 min read

InnoDB File Structure: Physical and Logical Organization

360 Zhihui Cloud Developer

Sep 28, 2017 · Databases

Mastering MySQL 5.7 InnoDB Tablespaces: Architecture, Encryption, and Configuration

This article explains the structure and components of MySQL 5.7 InnoDB tablespaces—including system, undo, temporary, and general tablespaces—covers double‑write buffering, redo logs, encryption with keyring, and provides practical configuration examples and command‑line demonstrations.

Database ConfigurationInnoDBMySQL

0 likes · 14 min read

Mastering MySQL 5.7 InnoDB Tablespaces: Architecture, Encryption, and Configuration