Centos7 Optimized mysql5.6 Configuration

First, environmental parameters

[[email protected] mysql]# grep ' physical id '/proc/cpuinfo |sort-uphysical id:0physical id:1[[email protect Ed] mysql]# grep ' core ID '/proc/cpuinfo |sort-ucore id:0core id:1core id:2core id:3[[email protected] mysql]# g Rep ' core ID '/proc/cpuinfo |sort-u|wc-l4[[email protected] mysql]# grep ' processor '/proc/cpuinfo |sort-u|wc-l16 [[email protected] mysql]# dmidecode-s Processor-versionintel (R) Xeon (r) CPU L5520 @ 2.27GHz Intel (r) Xeo        N (R) CPU L5520 @ 2.27GHz [[email protected] mysql]# cat/proc/meminfo memtotal:16255584 kbmemfree: 10019880 kbmemavailable:14476360 kbbuffers:4 kbcached:3973604 kbswapcached:243 6 kbactive:3884260 kbinactive:828028 kbactive (anon): 731664 kbinactive (anon): 16936 kbactive (fil  E): 3152596 kbinactive (file): 811092 kbunevictable:0 kbmlocked:0 kbswaptotal:8257532 kbswapfree:82210kbdirty:0 kbwriteback:0 kbanonpages:739240 kbmapped:24844 kbshmem: 9904 kbslab:1120032 kbsreclaimable:830676 kbsunreclaim:289356 kbkernelstack:611 2 kbpagetables:12628 kbnfs_unstable:0 kbbounce:0 kbwritebacktmp:0 Kbcommitlimi t:16385324 kbcommitted_as:1443908 kbvmalloctotal:34359738367 kbvmallocused:115596 kbvmallocchunk:34351 046032 kbhardwarecorrupted:0 kbanonhugepages:589824 Kbhugepages_total:0hugepages_free:0hugepages_r svd:0hugepages_surp:0hugepagesize:2048 kbdirectmap4k:131208 kbdirectmap2m:16635904 KB

　　

Centos7 Optimized mysql5.6 Configuration