PmaControl logo PmaControl
Resources › MySQL optimization center › MySQL Performance Parameters

MySQL Performance Parameters

Structured Markdown documentation to diagnose, measure, and optimize MySQL.

This page is original PmaControl documentation. It keeps a practical index structure for MySQL optimization work, without copying third-party content or depending on an external product.

Objective

MySQL parameters control memory, threads, caches, durability, and I/O. They should be documented by role rather than changed as a magic list.

Parameter Families

  1. Global memory: innodb_buffer_pool_size, key_buffer_size, table caches.
  2. Per-session memory: sort_buffer_size, join_buffer_size, read_rnd_buffer_size, tmp_table_size.
  3. InnoDB I/O: flush, redo log, page cleaners, read and write threads.
  4. Connections: max_connections, thread cache, file limits.
  5. Historical compatibility: query cache, MyISAM, and obsolete parameters.

Method

Start with SHOW VARIABLES and SHOW GLOBAL STATUS, then compare values with observed behavior. A high value can worsen total memory use when it is allocated per connection.

See also: Parameter Index.