Skip to content

Optimize

Improving PMM Performance with Table Statistics Options

If a MySQL instance has a lot of schemas or tables, there are two options to help improve the performance of PMM when adding instances with pmm-admin add:

  • --disable-tablestats, or,
  • --disable-tablestats-limit.

Important

  • These settings are only for adding an instance. To change them, you must remove and re-add the instances.
  • Only one of these options can be used when adding an instance.

Disable per-table statistics for an instance

When adding an instance with pmm-admin add, the --disable-tablestats option disables table statistics collection when there are more than the default number (1000) of tables in the instance.

USAGE

pmm-admin add mysql --disable-tablestats

Change the number of tables beyond which per-table statistics is disabled

When adding an instance with pmm-admin add, the --disable-tablestats-limit option changes the number of tables (from the default of 1000) beyond which per-table statistics collection is disabled.

USAGE

pmm-admin add mysql --disable-tablestats-limit=<LIMIT>

EXAMPLE

Add a MySQL instance, disabling per-table statistics collection when the number of tables in the instance reaches 2000.

pmm-admin add mysql --disable-tablestats-limit=2000

Get expert help

If you need assistance, visit the community forum for comprehensive and free database knowledge, or contact our Percona Database Experts for professional support and services.


Last update: 2024-03-11