Aikesheng Open Source Community
Nov 27, 2023 · Databases
Is ANALYZE TABLE Safe on a Busy MySQL Database Server?
Running ANALYZE TABLE on MySQL, Percona Server, or MariaDB can block queries in older versions, but from MySQL 8.0.24, Percona Server 5.6.38+, 5.7.20+, and MariaDB 10.5.4+, the operation is safe and no longer causes disruptive locks.
ANALYZE TABLEDatabase PerformanceMariaDB
0 likes · 8 min read