一、背景

驗證系統調優對性能的影響，用sysbench做了一些簡單的測試，具體調整方法可見官方文檔

二、特殊說明

1.透明大頁查看

# 查看透明大頁是否開啟，[]在always處表示開啟，[]在never處表示關閉
cat /sys/kernel/mm/transparent_hugepage/enabled
always madvise [never]

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.)