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 AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Tools

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 SQLServer and MySQL so that they can perform at their best? Abstract: In today's database applications, SQLServer and MySQL are the two most common and popular relational database management systems (RDBMS). As the amount of data increases and business needs continue to change, optimizing database performance has become particularly important. This article will introduce some common methods and techniques for optimizing the performance of SQLServer and MySQL to help users take advantage of

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

In the MySQL database, indexing is a very important means of performance optimization. When the amount of data in the table increases, inappropriate indexes can cause queries to slow down or even cause database crashes. In order to improve database performance, indexes need to be used rationally when designing table structures and query statements. Composite index is a more advanced indexing technology that improves query efficiency by combining multiple fields as indexes. In this article, we will detail how to improve MySQL performance by using composite indexes. What is composite index composite

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

In MySQL, transaction isolation level is a very important concept, which determines how the database handles concurrent access to data when multiple transactions are executed at the same time. In practical applications, we need to choose the appropriate isolation level based on specific business needs to improve the performance of MySQL. First, we need to understand MySQL’s four transaction isolation levels: READ-UNCOMMITTED, READ-COMMITTED, REPEATABLE-READ and SERIALIZA

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

MySQL is a widely used open source relational database management system. Good performance is crucial when dealing with huge data volumes. MyISAM index cache is a very important feature of MySQL, which can greatly improve the speed and performance of data reading. In this article, we will take a deep dive into how the MyISAM index cache works and how to configure and optimize the index cache to improve MySQL performance. What is MyISAM index cache? MyISAM is a storage index in MySQL

How does index cardinality affect query performance in MySQL? How does index cardinality affect query performance in MySQL? Apr 03, 2025 am 12:09 AM

Index cardinality has a significant impact on MySQL query performance. High cardinality indexes can locate data faster and optimize queries; low cardinality indexes may lead to full table scanning. Query performance can be effectively improved by regularly updating statistics, selecting the appropriate index type, avoiding over-index and using over-index.

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

MySQL is a widely used relational database management system. Due to its high performance, scalability and open source nature, it has become the first choice for many enterprises and individuals. However, as the amount of data continues to increase and the complexity of the data continues to increase, MySQL's performance problems begin to emerge. One of the important performance issues is query time. Query time refers to the time it takes for a MySQL query. The shorter the query time, the higher the performance of MySQL and the ability to handle more query requests. To address this problem, we can analyze the query time

How to improve MySQL performance by optimizing PHP queries How to improve MySQL performance by optimizing PHP queries May 11, 2023 am 09:04 AM

With the continuous development of the Internet, a large amount of data needs to be stored and managed. Storing and managing data in the MySQL database has become a common operation. At the same time, using PHP language to query databases has become a common implementation method. However, as data continues to increase, the performance of the MySQL database gradually becomes important, and the performance of PHP when querying MySQL is also affected. Improving MySQL performance by optimizing PHP queries has become one of the problems that developers need to solve. PH

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

MySQL is one of the most widely used database servers today, and PHP, as a popular server-side programming language, its applications usually interact with MySQL. Under high load conditions, MySQL performance will be greatly affected. At this time, PHP configuration needs to be adjusted to improve MySQL performance and thereby increase the response speed of the application. This article will introduce how to improve MySQL performance through PHP configuration. To configure PHP.ini, you first need to open the PHP configuration file (PHP.ini), so that you can change

See all articles