Linux performance tuning tips for MySQL
来源:互联网 发布:网上打麻将软件 编辑:程序博客网 时间:2024/06/11 09:54
Linux performance tuning tips for MySQL
by Alexander Rubin, mysqlperformanceblog.com
December 7th 2013
Because most MySQL production systems probably run on Linux, I’ve decided to place the most important Linux tuning tips that will help improve MySQL performance. There is nothing new here, most of them are well known, however, I’ve decided to collect those Linux configuration tips into 1 blog post.
Filesystem
- – use deadline or noop
(For more info see Linux Schedulers in TPCC like benchmark)
Memory
If using Percona Server we can place it into mysqld_safe script, as Percona Server supports NUMA control.
Jeremy Cole blog contains excellent overview of NUMA as well as additional NUMA tools
(and do not forget about innodb_flush_method=O_DIRECT)
CPU
Make sure there is no powersave mode enabled:
Check /sys/devices/system/cpu/cpu0/cpufreq/scaling_governor
and make sure it is not ondemand
Check /proc/cpuinfo and compare cpu MHz number to what is listed under the “model name”
Disable the “ondemand” if it is running
Example: “ondemand” is running on all the servers
and we have this:
In this case we will need to disable “ondemand”.
These simple Linux tuning tips will increase MySQL performance and make it more stable (and avoid swapping). I’m am also interested in hearing about your experience with different Linux configurations and MySQL. Please share those in the comments.
- Linux performance tuning tips for MySQL
- performance tuning for linux
- http://wubx.net/linux-performance-tuning-tips-mysql/
- Performance tuning tips for database developers
- MySQL Performance Tuning: Tips, Scripts and Tools
- Java performance tuning tips
- Performance Tuning for Linux(R) Servers
- 25 Apache Performance Tuning Tips
- Linux system performance tuning
- Performance Tuning Tips for Running Spark Applications(重点:数据序列化)
- Tuning Nagios For Maximum Performance
- Ubuntu Hacks : Tips & Tools for Exploring, Using, and Tuning Linux
- Tips for ABAP Performance Tunning
- Performance tuning for Data Selection Statement
- Performance tuning for Data Selection Statement
- Client API - Best Practices for performance tuning
- SQL Server Performance Tuning for RML
- ZFS: Performance Tuning for Scrubs and Resilvers
- 500错误和404错误
- objective-C: NSString应该用initWithFormat? 还是 stringWithFormat?
- 在eclipse中如何输入命令行参数
- BoundsChecker 使用
- android之AndroidManifest.xml
- Linux performance tuning tips for MySQL
- Ubuntu Server 下的网络配置
- 归一化
- 打开子窗口的时候关闭父页面
- 在SQL SERVER 2005中调用Web Service
- Stack的三种含义
- VS2005 error: 'CWnd::SetWindowTextW' : cannot convert parameter 1 from 'const char [1]' to 'LPCTSTR'
- 织梦cms5.7首页调用问答模块内容方法[可用]
- Study PyQt from beginning 之 2