MySQL parameter configuration optimization

1 data files and binary log files are guaranteed to be stored on separate disks to protect against disk failures

2 Set the InnoDB engine on, Default-storage-engine=innodb

3 Set the Innodb_file_per_tablecan parameter so that each INNODB table uses a separate IBD file

4 Set Flexible tablespace Innodb_data_home_dir =/home/mysql/data Innodb_data_file_path

5 set innodb_log_file_size size to 512M; not less than 256M

6 set Innodb_open_files to 1000; not less than 500

7 set Thread_cache_size to 500; not less than 200

8 Set Innodb_buffer_pool_size size 50G, generally guaranteed not less than 25% of physical memory, no higher than 75%

9 Setting Max_connection 5000

10 Setting Max_connection_error 100000

11 Setting Open_files_limit 50000

12 Setting Table_open_cache 50000

13 Setting Table_definition_cache 50000

14 set the Skip_name_resolve parameter to force the use of IP to connect to the database

15 Set close Query cache query_cache_size=0;query_cache_type=0

This article is from the "Practical Linux knowledge and Skills sharing" blog, please be sure to keep this source http://superleedo.blog.51cto.com/12164670/1892232

MySQL parameter configuration optimization