MySQL两项性能的基本测试浅谈-Mysql Tutorial-php.cn

Home

Database

Mysql Tutorial

MySQL两项性能的基本测试浅谈

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 04:11 PM

mysqlBasicperformanceustest

我们今天是要和大家一起讨论的是MySQL两项性能的基本测试，我前两天在一信誉度很好的网站看见MySQL两项性能的基本测试的资料，觉得挺好，就拿出来供大家分享。希望你在浏览之后会对其有更深的印象。以下的文章主要描述的是MySQL两项性能的基本测试，我们使

我们今天是要和大家一起讨论的是MySQL两项性能的基本测试，我前两天在一信誉度很好的网站看见MySQL两项性能的基本测试的资料，觉得挺好，就拿出来供大家分享。希望你在浏览之后会对其有更深的印象。

以下的文章主要描述的是 MySQL两项性能的基本测试，我们使用的是 212992条数据在同一台机器上来执行update的实际操作，采用的是 MySQL5.0版。主要目的是对两项性能进行测试，以下就是详细内容。

MySQL两项性能测试之一使用存储过程性能可以提升多少？

MySQL的存储过程从无到有，已经是很大的进步了，但网上有些人说，MySQL的存储过程性能没什么提升，甚至还不如不用存储过程比较快，耳听为虚，眼见为实，所以我就自己亲自做了一个测试，结果如下：

使用存储过程没有使用存储过程

1. 10985ms 14906ms

2. 11562ms 14828ms

3. 11890ms 14500ms

4. 11360ms 15047ms

5. 12407ms 14578ms

结论：我个人认为存储过程在数据量大的情况下，肯定性能上有更大的优势的，所以说MySQL存储过程没有什么效率的人明显是误人子弟！东西可以乱吃，话可不能乱说

MySQL两项性能测试之二分页测试

MySQL有了limit，使分页变得简单多了，但是听说limit还是存在性能问题，所以需要优化，这是根据我上一篇文字的优化方法，对其进行测试，看看这种是否有效

直接limit 10,10 先做offset 10，在选出10

1. 10ms 15ms

2. 10ms 15ms

3. 10ms 15ms

直接limit 100000，10 先做offset 100000，在选出10

1. 78ms 46ms

2. 78ms 47ms

3. 78ms 47ms

直接limit 200000，10 先做offset 200000，在选出10

1. 156ms 79ms

2. 188ms 78ms

3. 153ms 78ms

4. 141ms 94ms

5. 141ms 93ms

直接limit 200000，10000 先做offset 200000，在选出10000

1. 171ms 94ms

2. 140ms 78ms

3. 172ms 93ms

4. 156ms 93ms

5. 157ms 94ms

以上的相关内容就是对MySQL两项性能测试的介绍，望你能有所收获。

Statement

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

Adding Users to MySQL: The Complete TutorialMay 12, 2025 am 12:14 AM

Mastering the method of adding MySQL users is crucial for database administrators and developers because it ensures the security and access control of the database. 1) Create a new user using the CREATEUSER command, 2) Assign permissions through the GRANT command, 3) Use FLUSHPRIVILEGES to ensure permissions take effect, 4) Regularly audit and clean user accounts to maintain performance and security.

Mastering MySQL String Data Types: VARCHAR vs. TEXT vs. CHARMay 12, 2025 am 12:12 AM

ChooseCHARforfixed-lengthdata,VARCHARforvariable-lengthdata,andTEXTforlargetextfields.1)CHARisefficientforconsistent-lengthdatalikecodes.2)VARCHARsuitsvariable-lengthdatalikenames,balancingflexibilityandperformance.3)TEXTisidealforlargetextslikeartic

MySQL: String Data Types and Indexing: Best PracticesMay 12, 2025 am 12:11 AM

Best practices for handling string data types and indexes in MySQL include: 1) Selecting the appropriate string type, such as CHAR for fixed length, VARCHAR for variable length, and TEXT for large text; 2) Be cautious in indexing, avoid over-indexing, and create indexes for common queries; 3) Use prefix indexes and full-text indexes to optimize long string searches; 4) Regularly monitor and optimize indexes to keep indexes small and efficient. Through these methods, we can balance read and write performance and improve database efficiency.

MySQL: How to Add a User RemotelyMay 12, 2025 am 12:10 AM

ToaddauserremotelytoMySQL,followthesesteps:1)ConnecttoMySQLasroot,2)Createanewuserwithremoteaccess,3)Grantnecessaryprivileges,and4)Flushprivileges.BecautiousofsecurityrisksbylimitingprivilegesandaccesstospecificIPs,ensuringstrongpasswords,andmonitori

The Ultimate Guide to MySQL String Data Types: Efficient Data StorageMay 12, 2025 am 12:05 AM

TostorestringsefficientlyinMySQL,choosetherightdatatypebasedonyourneeds:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseTEXTforlong-formtextcontent.4)UseBLOBforbinarydatalikeimages.Considerstorageov

MySQL BLOB vs. TEXT: Choosing the Right Data Type for Large ObjectsMay 11, 2025 am 12:13 AM

When selecting MySQL's BLOB and TEXT data types, BLOB is suitable for storing binary data, and TEXT is suitable for storing text data. 1) BLOB is suitable for binary data such as pictures and audio, 2) TEXT is suitable for text data such as articles and comments. When choosing, data properties and performance optimization must be considered.

MySQL: Should I use root user for my product?May 11, 2025 am 12:11 AM

No,youshouldnotusetherootuserinMySQLforyourproduct.Instead,createspecificuserswithlimitedprivilegestoenhancesecurityandperformance:1)Createanewuserwithastrongpassword,2)Grantonlynecessarypermissionstothisuser,3)Regularlyreviewandupdateuserpermissions

MySQL String Data Types Explained: Choosing the Right Type for Your DataMay 11, 2025 am 12:10 AM

MySQLstringdatatypesshouldbechosenbasedondatacharacteristicsandusecases:1)UseCHARforfixed-lengthstringslikecountrycodes.2)UseVARCHARforvariable-lengthstringslikenames.3)UseBINARYorVARBINARYforbinarydatalikecryptographickeys.4)UseBLOBorTEXTforlargeuns

See all articles