一、背景

验证系统调优对性能的影响，用sysbench做了一些简单的测试，具体调整方法可见官方文档

二、特殊说明

1.透明大页查看

# 查看透明大页是否开启，[]在always处表示开启，[]在never处表示关闭
cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]
1
2
3

2.io查看

io调度方式需要看磁盘类型是否支持，只有ssd和hdd的才能够支持noop的调度方式，具体可以看大佬的文章

三、结果对比

初步关闭了大页之后性能有5%左右的提升，但是因为测试环境比较差，测试内容不一定准确

 1:
    transactions:                        2428   (40.45 per sec.)
    queries:                             48560  (809.03 per sec.)

 2:
    transactions:                        3816   (63.57 per sec.)
    queries:                             76320  (1271.34 per sec.)

4:

    transactions:                        5851   (97.47 per sec.)
    queries:                             117020 (1949.30 per sec.)
 



8:   
    transactions:                        6918   (115.23 per sec.)
    queries:                             138360 (2304.62 per sec.)




16:
    transactions:                        8089   (134.54 per sec.)
    queries:                             161780 (2690.83 per sec.)


32:

    transactions:                        9120   (151.51 per sec.)
    queries:                             182400 (3030.21 per sec.)
    


64:


    transactions:                        9153   (151.65 per sec.)
    queries:                             183060 (3032.96 per sec.)
   






调整大页等参数后
1:
    transactions:                        2599   (43.30 per sec.)
    queries:                             51980  (865.99 per sec.)
   

2:

    transactions:                        4097   (68.24 per sec.)
    queries:                             81940  (1364.88 per sec.)
  
4:

    transactions:                        6166   (102.70 per sec.)
    queries:                             123320 (2054.04 per sec.)
 
8:

    transactions:                        8865   (147.62 per sec.)
    queries:                             177300 (2952.45 per sec.)
   


16:

    transactions:                        9705   (161.57 per sec.)
    queries:                             194100 (3231.44 per sec.)
   


32:

    transactions:                        9805   (163.09 per sec.)
    queries:                             196100 (3261.73 per sec.)


64:

    transactions:                        10055  (166.87 per sec.)
    queries:                             201100 (3337.38 per sec.)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87