Mailinglist Archive: opensuse-bugs (13459 mails)

[bugzilla_noreply@xxxxxxxxxx]

https://bugzilla.novell.com/show_bug.cgi?id=335584

           Summary: Bad MySQL performance
           Product: openSUSE 10.3
           Version: Final
          Platform: x86
        OS/Version: openSUSE 10.3
            Status: NEW
          Severity: Major
          Priority: P5 - None
         Component: Kernel
        AssignedTo: kernel-maintainers@xxxxxxxxxxxxxxxxxxxxxx
        ReportedBy: tretkowski@xxxxxxxxxxxxxx
         QAContact: qa@xxxxxxx
          Found By: ---


Created an attachment (id=179622)
 --> (https://bugzilla.novell.com/attachment.cgi?id=179622)
kernel config

When using the standard SuSE 10.3 kernel (2.6.22.5-31-default) I get a really
bad performance when running the test-create test from the mysql benchmark:

Testing server 'MySQL 5.0.45' at 2007-10-22 10:07:52

Testing the speed of creating and dropping tables
Testing with 10000 tables and 10000 loop count

Testing create of tables
Time for create_MANY_tables (10000): 616 wallclock secs ( 1.18 usr  0.17 sys + 
0.00 cusr  0.00 csys =  1.35 CPU)

Accessing tables
Time to select_group_when_MANY_tables (10000):  3 wallclock secs ( 0.36 usr 
0.06 sys +  0.00 cusr  0.00 csys =  0.42 CPU)

Testing drop
Time for drop_table_when_MANY_tables (10000):  1 wallclock secs ( 0.18 usr 
0.06 sys +  0.00 cusr  0.00 csys =  0.24 CPU)

Testing create+drop
Time for create+drop (10000): 546 wallclock secs ( 1.57 usr  0.23 sys +  0.00
cusr  0.00 csys =  1.80 CPU)
Time for create_key+drop (10000): 573 wallclock secs ( 1.88 usr  0.24 sys + 
0.00 cusr  0.00 csys =  2.12 CPU)
Total time: 1739 wallclock secs ( 5.17 usr  0.76 sys +  0.00 cusr  0.00 csys = 
5.93 CPU)


When using a self compiled 2.6.18 or 2.6.22 kernel, performance is much better:

Testing server 'MySQL 5.0.45' at 2007-10-22 11:09:12

Testing the speed of creating and dropping tables
Testing with 10000 tables and 10000 loop count

Testing create of tables
Time for create_MANY_tables (10000): 33 wallclock secs ( 0.80 usr  0.05 sys + 
0.00 cusr  0.00 csys =  0.85 CPU)

Accessing tables
Time to select_group_when_MANY_tables (10000):  2 wallclock secs ( 0.20 usr 
0.05 sys +  0.00 cusr  0.00 csys =  0.25 CPU)

Testing drop
Time for drop_table_when_MANY_tables (10000):  1 wallclock secs ( 0.14 usr 
0.04 sys +  0.00 cusr  0.00 csys =  0.18 CPU)

Testing create+drop
Time for create+drop (10000): 40 wallclock secs ( 0.94 usr  0.11 sys +  0.00
cusr  0.00 csys =  1.05 CPU)
Time for create_key+drop (10000): 41 wallclock secs ( 0.92 usr  0.12 sys + 
0.00 cusr  0.00 csys =  1.04 CPU)
Total time: 117 wallclock secs ( 3.00 usr  0.37 sys +  0.00 cusr  0.00 csys = 
3.37 CPU)

I'm able to reproduce this problem on different hardware, and also with
OpenSuSE 10.1 and 10.2. Replacing the default kernel always results in better
performance. I attached the kernel configuration of a 2.6.18 self compiled
kernel, which was used for the second test.


-- 
Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.