Optimize InnoDB

Moki Lv6
  2021-08-11 04:54 2021-08-11 04:54 Created   2021-08-11 04:54 2021-08-11 04:54 Updated   
1
2
3
4
5
6
7
8
9
innodb_flush_log_at_trx_commit = 2
innodb_buffer_pool_size = 4G
innodb_log_file_size = 4G
innodb_flush_method = O_DIRECT
innodb_file_per_table = 1
innodb_open_files = 800
innodb_io_capacity = 200
innodb_data_file_path = ibdata1:12M:autoextend:max:10G
innodb_temp_data_file_path = ibtmp1:12M:autoextend:max:10G
Recommendations
Backup to CD/DVD/BR/BLU-RAY Backup to CD/DVD/BR/BLU-RAY Docker-compose logs limits Docker-compose logs limits Trailer connector Trailer connector
Recommendations
Backup to CD/DVD/BR/BLU-RAY Backup to CD/DVD/BR/BLU-RAY Docker-compose logs limits Docker-compose logs limits
On this page
Optimize InnoDB