Home Database Mysql Tutorial MySQL对性能较为强劲的服务器利用率测试

MySQL对性能较为强劲的服务器利用率测试

Jun 07, 2016 pm 05:19 PM
mysql performance

可以看出,在1/2/4/6个实例情况下tps还基本上是呈线性增长的,虽说这样不能有绝对的说服性,实际情况中很有可能还有其他需要考虑

前面一篇文章记录的MySQL 5.5对多核cpu的利用率,点击这里()。其实当初测试的主要目的是今天所说的:一台性能较强劲的服务器,跑多个实例对整机的利用率大概会怎么样呢?

测试的机器是DELL R720XD,24核cpu,96G内存,挂了24个SAS盘。测试之前对这24个盘做了2个raid10盘阵,然后对每个raid10盘阵利用GPT做6个逻辑分区,然后做了ext3文件系统。测试工具sysbench,test-mode=complex,每个MySQL 实例 buffer=12G,,测试过程中初始化36G左右数据。在分别跑1/2/4/6个实例的情况下,利用sysbench生成的统计数据求出总的tps,以及rw request /s。下面是曲线图:

MySQL对性能较为强劲的服务器利用率测试

可以看出,在1/2/4/6个实例情况下tps还基本上是呈线性增长的,虽说这样不能有绝对的说服性,实际情况中很有可能还有其他需要考虑的因素,但基本上也可以做一个参考,加上前面测过的MySQL 5.5对cpu多核的利用率,随着MySQL功能越来越强,看样子以后买好点的机器跑多个实例,比买普通的机器每台机器上跑单个实例更适合。

另外附上一张MySQL 5.1测试结果图,性能整体比MySQL 5.5低个20%~30%左右,当然我测试过程中os很多参数没调,MySQL本身也很多没调,不过两者是同一个标准测试的:

MySQL对性能较为强劲的服务器利用率测试

从上图看出,不完全的线性增长,tps比5.5低了些。哈哈,找个稳定的5.5版本升了吧。

linux

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

How to optimize the performance of SQL Server and MySQL so that they can perform at their best? How to optimize the performance of SQL Server and MySQL so that they can perform at their best? Sep 11, 2023 pm 01:40 PM

How to optimize the performance of SQL Server and MySQL so that they can perform at their best?

How to improve MySQL performance by using composite indexes How to improve MySQL performance by using composite indexes May 11, 2023 am 11:10 AM

How to improve MySQL performance by using composite indexes

How to improve MySQL performance with transaction isolation levels How to improve MySQL performance with transaction isolation levels May 11, 2023 am 09:33 AM

How to improve MySQL performance with transaction isolation levels

How to improve MySQL performance with Query Time Analyzer How to improve MySQL performance with Query Time Analyzer May 11, 2023 am 09:25 AM

How to improve MySQL performance with Query Time Analyzer

How to improve MySQL performance with MyISAM index caching How to improve MySQL performance with MyISAM index caching May 11, 2023 pm 07:31 PM

How to improve MySQL performance with MyISAM index caching

How to improve MySQL performance with PHP caching How to improve MySQL performance with PHP caching May 11, 2023 pm 06:31 PM

How to improve MySQL performance with PHP caching

Operating system optimization for MySql: How to optimize the operating system to improve MySQL performance Operating system optimization for MySql: How to optimize the operating system to improve MySQL performance Jun 16, 2023 am 08:42 AM

Operating system optimization for MySql: How to optimize the operating system to improve MySQL performance

How to improve MySQL performance through PHP configuration How to improve MySQL performance through PHP configuration May 11, 2023 am 09:19 AM

How to improve MySQL performance through PHP configuration

See all articles