Cette page est une documentation originale PmaControl. Elle reprend une structure d'index pratique pour travailler sur l'optimisation MySQL, sans copier de contenu tiers ni dépendre d'un produit externe.
Variables documentées
- 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
- open_files_limit
- optimizer_search_depth
- 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