tidb-系统内核调优及对比

最新推荐文章于 2025-05-21 11:39:44 发布

与数据交流的路上

最新推荐文章于 2025-05-21 11:39:44 发布

阅读量220

点赞数

CC 4.0 BY-SA版权

分类专栏： TIDB 文章标签： tidb

本文链接：https://blog.youkuaiyun.com/line_on_database/article/details/126505823

TIDB 专栏收录该内容

63 篇文章

订阅专栏

通过Sysbench测试了系统调优对性能的影响，关闭透明大页后性能提升了约5%，尤其是在高并发场景下效果更为明显。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

一、背景

验证系统调优对性能的影响，用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.)