MySQL Optimization Center

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.

Main Paths

• MySQL Performance Tuning
• MySQL Health Checks
• MySQL Schema Checks
• MySQL Security Checks
• MySQL Performance Parameters
• Performance Evaluation Page

Performance Metrics

• Metrics Overview
• MySQL Latency
• Throughput and QPS
• Slow Queries
• Aborted Clients

MySQL Parameters

• Parameter Index
• Status Variables
• my.cnf Configuration
• bulk_insert_buffer_size
• innodb_buffer_pool_chunk_size
• innodb_buffer_pool_instances
• innodb_buffer_pool_size
• innodb_change_buffering
• innodb_file_per_table
• innodb_flush_log_at_trx_commit
• innodb_flush_method
• innodb_log_buffer_size
• innodb_log_file_size
• innodb_max_dirty_pages_pct
• innodb_page_cleaners
• innodb_purge_threads
• innodb_read_io_threads
• innodb_redo_log_capacity
• innodb_thread_concurrency
• innodb_write_io_threads
• join_buffer_size
• key_buffer_size
• max_allowed_packet
• max_connections
• max_heap_table_size
• myisam_sort_buffer_size
• optimizer_search_depth
• query cache
• read_rnd_buffer_size
• sort_buffer_size
• table_definition_cache
• table_open_cache
• thread_cache_size
• thread_handling
• thread_pool_size
• thread_stack
• tmp_table_size
• transaction_prealloc_size
• open_files_limit

Common Incidents

• Frequent Restarts
• Identify the MySQL Port
• General Query Log
• Long-Running Queries
• High CPU
• Deadlocks

Practical Guides

• InnoDB Tuning
• Database Optimization
• Proactive Optimization
• Optimization Pitfalls
• Index Creation
• Top Queries vs Slow Queries
• MySQL Variables
• MySQL Memory Usage
• PHP/MySQL Slow Queries

Benchmarks and Tools

• MySQL 5.7 Benchmark
• MySQL 8 Benchmark
• Configuration Impact on Web Applications
• Maintaining a High-Performance Configuration
• MySQL Memory Calculator
• Memory Calculator Comparison
• MySQL Query Optimizer
• MySQL Monitoring Tools