mysqlcheck -u app -p --analyze appdb

Category: Databases & SQL

mysqlcheck -u app -p --analyze appdb

Update table statistics

Runs ANALYZE TABLE so the optimizer's row estimates stay fresh after heavy changes. Cheap and non-blocking. Equivalent to ANALYZE TABLE appdb.users for one table.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.