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