MySQL对性能较为强劲的服务器利用率测试
可以看出,在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。下面是曲线图:
可以看出,在1/2/4/6个实例情况下tps还基本上是呈线性增长的,虽说这样不能有绝对的说服性,实际情况中很有可能还有其他需要考虑的因素,但基本上也可以做一个参考,加上前面测过的MySQL 5.5对cpu多核的利用率,随着MySQL功能越来越强,看样子以后买好点的机器跑多个实例,比买普通的机器每台机器上跑单个实例更适合。
另外附上一张MySQL 5.1测试结果图,性能整体比MySQL 5.5低个20%~30%左右,当然我测试过程中os很多参数没调,MySQL本身也很多没调,不过两者是同一个标准测试的:
从上图看出,不完全的线性增长,tps比5.5低了些。哈哈,找个稳定的5.5版本升了吧。

Hot AI Tools

Undresser.AI Undress
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

AI Hentai Generator
Generate AI Hentai for free.

Hot Article

Hot Tools

Notepad++7.3.1
Easy-to-use and free code editor

SublimeText3 Chinese version
Chinese version, very easy to use

Zend Studio 13.0.1
Powerful PHP integrated development environment

Dreamweaver CS6
Visual web development tools

SublimeText3 Mac version
God-level code editing software (SublimeText3)

Hot Topics



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

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

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

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

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.

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

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

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
