`sync_frm`

WARNING

Rule IDs: mi_009

Overview

Purpose: Legacy .frm sync behavior; removed in MySQL 8.0.
Dynamic (MySQL 8.4 reference): Not applicable on MySQL 8.0+.
Default value: N/A on 8.0+
Version and product notes: Removed in MySQL 8.0; relevant only on older branches if still in use.
Documentation: Primary reference depends on product (MySQL, MariaDB, Percona, or OS documentation).

What is checked

Rules that reference this variable, with their severity and what each rule detects:

WARNING mi_009: Set sync_frm=OFF to improve performance of metadata operations. Note: this variable is deprecated and removed in MySQL 8.0.

Tuning guidance

Recommended actions:
- Set sync_frm=OFF to improve performance of metadata operations. Note: this variable is deprecated and removed in MySQL 8.0.
Trade-offs: Validate recommendations against monitoring, workload profiles, and vendor documentation before making changes.

Example

Upgrade planning: move to supported versions and InnoDB-centric schema.

Generated from the MySQL Advisor documentation build. Dynamic Yes/No reflects the excerpt aligned with Oracle MySQL 8.4 reference material consumed by this project.