SMP 2.4 kernel vs. SMP 2.2 kernel (fwd)

[sasha@xxxxxxxxx]

>
>I'm not sure if this is the right list to post to but,
>
>I have run some test on the newer kernel for Linux using supersmack.
>
>the test is a complete sale transaction.
>
>the results for kernel 2.2 are:
>
>sale_process starting with 100 clients
>Query Barrel Report for client sale_process
>connect: max=3458ms  min=3ms avg= 2132ms from 100 clients 
>Query_type num_queries max_time min_time q_per_s
>ins_address 100000  15  0  878.68
>ins_buyer 100000  22  0  878.68
>ins_order 100000  106  0  878.68
>ins_unlock 100000  23  0  878.68
>
>
>the results for 2.4 kernel are:
>
>sale_process starting with 100 clients
>Query Barrel Report for client sale_process
>connect: max=167ms  min=3ms avg= 47ms from 100 clients 
>Query_type num_queries max_time min_time q_per_s
>ins_address 100000  63  0  937.27
>ins_buyer 100000  87  0  937.27
>ins_order 100000  101  0  937.27
>ins_unlock 100000  88  0  937.27
>
>This was run on a Dual PIII 700 512 RAM VaLinux 6.2 and SCSI-RAID
>
>just to let others know about the improvements in the new kernels.
>I think I can talk my boss into using the 2.4 kernel.

Thanks for your post. We have seen similar results. The only problem we have run into with 2.4 kernel is kernel panic on a 4-way system, which by now may have already been fixed.

Note the difference in the max and avg connect times - 2.2 kernel overpenalized a thread for creating a child, which is fixed in 2.4 kernel.

What MySQL version did you use? If it is older than 3.23.25, you should try our newest binary - SMP performance on it is much better after we have started linking against patched LinuxThreads.
-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@xxxxxxxxx         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+


-- 
---------------------------------------------------------------------
Please check "http://www.mysql.com/documentation/manual.php"; before
posting. To request this thread, e-mail mysql-thread60320@xxxxxxxxxxxxxxx

To unsubscribe, send a message to:
    <mysql-unsubscribe-treed=ultraviolet.org@xxxxxxxxxxxxxxx>

If you have a broken mail client that cannot send a message to
the above address (Microsoft Outlook), you can use:
    http://lists.mysql.com/php/unsubscribe.php