Basic test on two MySQL performance items

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.