Bug #48153 Slowdown in test-connect
Submitted: 19 Oct 2009 15:09 Modified: 13 Mar 2014 18:38
Reporter: Alexey Stroganov Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: MyISAM storage engine Severity:S3 (Non-critical)
Version:5.1.40, 5.6.17 OS:Any
Assigned to: CPU Architecture:Any

[19 Oct 2009 15:09] Alexey Stroganov
Description:
Results of test-connect scenario from mysql-bench suite for 5.1.40/MyISAM showed
some performance degradation:                                         
                                             5.1.39       |      5.1.40
                                        run1   run2  run3 | run1  run2  run3
-----------------------------------------------------------------------------
Time to connect (10000):                3.082 3.086 3.108 | 3.538 3.522 3.535
Time for connect+select_simple (10000): 3.409 3.404 3.431 | 3.991 3.971 3.991
Time for select_simple (100000):        3.100 3.109 3.109 | 4.325 4.286 4.271
Time for select_simple_cache (100000):  3.038 3.025 3.039 | 4.251 4.218 4.206
Time to connect+select_1_row (10000):   3.687 3.679 3.952 | 4.295 4.277 4.286
Time to select_1_row (100000):          5.144 5.173 5.912 | 6.526 6.472 6.499
Time to select_1_row_cache (100000):    4.811 4.820 5.546 | 6.145 6.115 6.126
Time to select_2_rows (100000):         5.631 5.664 6.571 | 6.995 6.930 6.967
Time for select_column+column (100000): 5.588 5.626 6.360 | 6.939 6.886 6.908
Time to select_big_str (10000):         2.310 2.314 2.793 | 2.863 2.857 2.868
-----------------------------------------------------------------------------
Total:                                  39.81 39.91 43.83 | 49.88 49.54 49.66

How to repeat:
Run test-connect from mysql-bench for 5.1.39/5.1.40
[13 Mar 2014 18:38] Sveta Smirnova
Still repeatable.

            5.0.97 | 5.1.74 | 5.5.37 | 5.6.17

Total time: 110    | 123    | 118    | 142  (wallclock secs)