Re: ULE 2.0

From: Massimo Lusetti <massimo_at_cedoc.mo.it>
Date: Sun, 7 Jan 2007 17:14:08 +0100
On Sat, 6 Jan 2007 04:15:13 -0800 (PST)
Jeff Roberson <jroberson_at_chesapeake.net> wrote:

> On Sat, 6 Jan 2007, David Xu wrote:
> 
> > On Saturday 06 January 2007 19:38, Jeff Roberson wrote:
> >
> >>
> >> Can you tell me what you are doing?  I have a dual core opteron that works
> >> fine here running normal things.
> >
> > It is mysql super-smack, I am trying to get a performance result.
> 
> What threading library and what arguments? select-key?  How many threads?

I step in just to show some results i got with super-smack.

This is -CURRENT as of yesterday (06/01) with mysql 5.1.12 from
packages and super-smack 1.13 from ports.
I built two kernels, the GENERIC and a GENERIC with ULE instead of 4BSD
which i named GENEULE. I got dmesg from both if you're interested.

The test box is my laptop which is seens as:

Copyright (c) 1992-2007 The FreeBSD Project.
Copyright (c) 1979, 1980, 1983, 1986, 1988, 1989, 1991, 1992, 1993, 1994
        The Regents of the University of California. All rights
reserved. FreeBSD is a registered trademark of The FreeBSD Foundation.
FreeBSD 7.0-CURRENT #0: Sun Jan  7 13:19:24 CET 2007
    root_at_intanto.datacode.it:/usr/obj/usr/src/sys/GENEULE
WARNING: WITNESS option enabled, expect reduced performance.
ACPI APIC Table: <Acer   Grape   >
Timecounter "i8254" frequency 1193182 Hz quality 0
CPU: Genuine Intel(R) CPU           T2300  _at_ 1.66GHz (1662.52-MHz
686-class CPU) Origin = "GenuineIntel"  Id = 0x6e8  Stepping = 8
  Features=0xbfe9fbff<FPU,VME,DE,PSE,TSC,MSR,PAE,MCE,CX8,APIC,SEP,MTRR,PGE,MCA,CMOV,PAT,CLFLUSH,DTS,ACPI,MMX,FXSR,SSE,SSE2,SS,HTT,TM,PBE>
  Features2=0xc1a9<SSE3,MON,VMX,EST,TM2,XTPR,<b15>>
  AMD Features=0x100000<NX>
  Cores per package: 2
real memory  = 1072168960 (1022 MB)
avail memory = 1035640832 (987 MB)
FreeBSD/SMP: Multiprocessor System Detected: 2 CPUs
 cpu0 (BSP): APIC ID:  0
 cpu1 (AP): APIC ID:  1



During the test the machine was completely idle, expect for super-smack
and mysqld of course.

The tests cases where select-key and update-select always
with 10 clients and 10000 queries each executed 5 times.
On every threading library switch the server were restarted.

Here the results in order as they were executed.




Query_type      num_queries     max_time        min_time        q_per_s

4BSD libpthread

select_index    200000          2               0                4817.59
select_index    200000          2               0                4793.25
select_index    200000          3               0                4814.93
select_index    200000          2               0                4770.63
select_index    200000          2               0                4819.42
--
update_index    100000          2               0                2131.67
update_index    100000          2               0                2168.52
update_index    100000          3               0                2170.03
update_index    100000          2               0                2169.04
update_index    100000          3               0                2166.57


4BSD libthr

select_index    200000          1               0                5079.52
select_index    200000          3               0                4728.71
select_index    200000          3               0                4707.58
select_index    200000          1               0                4682.04
select_index    200000          1               0                4687.51
--
update_index    100000          1               0                2323.26
update_index    100000          2               0                2315.49
update_index    100000          2               0                2365.37
update_index    100000          2               0                2324.08
update_index    100000          2               0                2323.27


ULE libpthread

select_index    200000          3               0                4487.76
select_index    200000          0               0                4419.15
select_index    200000          3               0                4104.53
select_index    200000          3               0                4083.51
select_index    200000          4               0                4063.64
--
update_index    100000          3               0                1525.89
update_index    100000          3               0                1532.17
update_index    100000          4               0                1531.36
update_index    100000          4               0                1530.10
update_index    100000          4               0                1520.19


ULE libthr
select_index    200000          3               0                4318.65
select_index    200000          8               0                4347.53
select_index    200000          13              0                4327.46
select_index    200000          2               0                4312.92
select_index    200000          3               0                4349.71
--
update_index    100000          3               0                1710.85
update_index    100000          2               0                1731.89
update_index    100000          3               0                1716.59
update_index    100000          3               0                1711.15
update_index    100000          3               0                1697.40



Thanks to all your work and for reading this till the end ;) now i wait
to read you further

Regards
-- 
Massimo.run();
THE DAILY PLANET SUPERMAN SAVES DESSERT! Plans to "Eat it later"
Received on Sun Jan 07 2007 - 15:25:24 UTC

This archive was generated by hypermail 2.4.0 : Wed May 19 2021 - 11:39:04 UTC