3072
MySQLERRORNotableSchemaHIGH confidence
Wrong structure for native performance schema table
Production Risk
High — performance monitoring may be unavailable until resolved.
What this means
The structure of a native Performance Schema table does not match the expected structure, usually because the table was manually altered or corrupted.
Why it happens
- 1Manual ALTER TABLE on a performance_schema table.
- 2Schema mismatch after an in-place upgrade.
How to reproduce
trigger — this will error
trigger — this will error
-- Triggered on server start or when accessing performance_schema
expected output
ERROR 3072 (HY000): Native table 'performance_schema'.'<table>' has the wrong structure.
Fix
Run mysql_upgrade to repair schema mismatches
Run mysql_upgrade to repair schema mismatches
mysql_upgrade -u root -p
Why this works
Rebuilds system tables to match the expected server version structure.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3072 ER_WRONG_NATIVE_TABLE_STRUCTURE2
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev