Basic test on two MySQL performance items

Source: Internet
Author: User
Today we are going to discuss with you the basic test of two MySQL performance items. I saw the basic test materials for two MySQL performance items on a reputable website two days ago, I think it's good. I just want to share it with you. I hope you will have a deeper impression after browsing. The following articles mainly describe the basic test of MySQL performance.

Today we are going to discuss with you the basic test of two MySQL performance items. I saw the basic test materials for two MySQL performance items on a reputable website two days ago, I think it's good. I just want to share it with you. I hope you will have a deeper impression after browsing. The following articles mainly describe the basic test of MySQL performance.

Today we are going to discuss with you the basic test of two MySQL performance items. I saw the basic test materials for two MySQL performance items on a reputable website two days ago, I think it's good. I just want to share it with you. I hope you will have a deeper impression after browsing.

The following articles mainly describe the basic test of MySQL performance. We use 212992 pieces of data to perform update operations on the same machine, using MySQL. The main purpose is to test the two performance items. The following is a detailed description.

How much can I improve the performance of using stored procedures in one of the two MySQL performance tests?

MySQL stored procedures have been greatly improved since the beginning, but some people on the Internet say that the performance of MySQL stored procedures has not improved, it is even better not to use stored procedures quickly, but to be heard and desired. So I did a test myself. The results are as follows:

Stored Procedure is not used

1. 10985 ms 14906 ms

2. 11562 ms 14828 ms

3. 11890 ms 14500 ms

4. 11360 ms 15047 ms

12407 ms 14578 ms

Conclusion: I personally think that the stored procedure has a greater performance advantage when there is a large amount of data. Therefore, it is obvious that there is no efficiency in the MySQL stored procedure! Something can be messed up.

MySQL two performance tests 2 paging Test

MySQL has limit, which makes paging much easier. However, I heard that limit still has performance problems, so we need to optimize it. This is based on the Optimization Method of the previous article and tests it, check whether this is valid

Directly limit 10, 10 first offset 10, and then select 10

1. 10 ms 15 ms

2. 10 ms 15 ms

3. 10 ms 15 ms

Directly limit 100000,10 first offset 100000, then select 10

1. 78 ms 46 ms

2. 78 ms 47 ms

3. 78 ms 47 ms

Directly limit 200000, 10 first offset, then select 10

1. 156 ms 79 ms

2. 188 ms 78 ms

3. 153 ms 78 ms

4. 141 ms 94 ms

141 ms 93 ms

Directly limit 200000, 10000 first offset, in the selected

1. 171 ms 94 ms

2. 140 ms 78 ms

3. 172 ms 93 ms

4. 156 ms 93 ms

157 ms 94 ms

The above content is an introduction to the two MySQL performance tests.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.