centos mysql优化配置_centos7优化mysql5.6配置

[root@hn mysql]# grep 'physical id' /proc/cpuinfo |sort -u

physical id: 0

physical id: 1

[root@hn mysql]# grep 'core id' /proc/cpuinfo |sort -u

core id: 0

core id: 1

core id: 2

core id: 3

[root@hn mysql]# grep 'core id' /proc/cpuinfo |sort -u|wc -l

4

[root@hn mysql]# grep 'processor' /proc/cpuinfo |sort -u|wc -l

16

[root@hn mysql]# dmidecode -s processor-version

Intel(R) Xeon(R) CPU L5520 @ 2.27GHz

Intel(R) Xeon(R) CPU L5520 @ 2.27GHz

[root@hn mysql]# cat /proc/meminfo

MemTotal: 16255584 kB

MemFree: 10019880 kB

MemAvailable: 14476360 kB

Buffers: 4 kB

Cached: 3973604 kB

SwapCached: 2436 kB

Active: 3884260 kB

Inactive: 828028 kB

Active(anon): 731664 kB

Inactive(anon): 16936 kB

Active(file): 3152596 kB

Inactive(file): 811092 kB

Unevictable: 0 kB

Mlocked: 0 kB

SwapTotal: 8257532 kB

SwapFree: 8221048 kB

Dirty: 0 kB

Writeback: 0 kB

AnonPages: 739240 kB

Mapped: 24844 kB

Shmem: 9904 kB

Slab: 1120032 kB

SReclaimable: 830676 kB

SUnreclaim: 289356 kB

KernelStack: 6112 kB

PageTables: 12628 kB

NFS_Unstable: 0 kB

Bounce: 0 kB

WritebackTmp: 0 kB

CommitLimit: 16385324 kB

Committed_AS: 1443908 kB

VmallocTotal: 34359738367 kB

VmallocUsed: 115596 kB

VmallocChunk: 34351046032 kB

HardwareCorrupted: 0 kB

AnonHugePages: 589824 kB

HugePages_Total: 0

HugePages_Free: 0

HugePages_Rsvd: 0

HugePages_Surp: 0

Hugepagesize: 2048 kB

DirectMap4k: 131208 kB

DirectMap2M: 16635904 kB