Configuring MySQL for a SSD based SAN

lixora

于 2023-05-23 11:30:01 发布

阅读量228

点赞数

分类专栏： MySql 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/lixora/article/details/130823745

版权

MySql 专栏收录该内容

83 篇文章 2 订阅

订阅专栏

在虚拟环境中使用基于SSD的SAN时，建议修改MySQL的配置参数，如将innodb_page_size减小到4k或8k，设置innodb_flush_neighbors为0，innodb_lru_scan_depth为512，并考虑增加innodb_io_capacity的值。此外，使用IO基准工具确定最佳IOPS值，并考虑在VMwareVM中禁用ballooning驱动器。

摘要由CSDN通过智能技术生成

Configuring MySQL for a SSD based SAN (Doc ID 2673662.1)

正在上传…重新上传取消To Bottom

In this Document

APPLIES TO:

MySQL Server - Version 5.6 and later
Information in this document applies to any platform.

GOAL

Considering a Virtualized environment with a SSD based SAN, what are the configuration parameters to be modified and their suggested values.

SOLUTION

Usually the SAN is not exposed to the VM directly. Instead VMs use the file system exposed by the VM Manager.
In such cases we would suggest you to consider using VM settings.

When using SSD you can look at the following configuration variables :

a. innodb_page_size

You can reduce the page size to 4k or 8k , reducing it from the default of 16k.

b. innodb_flush_neighbors=0

c. innodb_lru_scan_depth=512

This is especially beneficial if you have a large buffer pool with more than 8 instances.

d. innodb_io_capacity

Since SSD based SAN is being used, you can try increasing this value from default.
We would suggest using IO bench-marking tools to determine the optimal IOPS value to be used.

Most enterprise class SSD can provide high IOPS values, please check with the vendor as well.

Another thing that helps in most situations is to disable ballooning driver when using VMWare VM.

https://kb.vmware.com/s/article/1002586