What am I doing wrong?
jharris
Apr 7, 2010
Hey Tim,
I'm trying the out of the box single-node configuration (ant server/ant client) on an HP DL580 G5 (24 x Xeon X7460 @ 2.66GHz) running CentOS 5.4 and am getting the following:
*************************************************************************
Voting Results
*************************************************************************
- Accepted votes = 3,929,581
- Rejected votes (invalid contestant) = 19,720
- Rejected votes (voter over limit) = 0
- Contestant Jessie Alloway received 550,467 vote(s)
- Contestant Kelly Clauss received 651,957 vote(s)
- Contestant Jessie Eichman received 223,113 vote(s)
- Contestant Alana Bregman received 651,864 vote(s)
- Contestant Tabatha Gehling received 223,597 vote(s)
- Contestant Edwina Burnam received 1,628,583 vote(s)
- Contestant Edwina Burnam was the winner with 1,628,583 vote(s)
*************************************************************************
System Statistics
*************************************************************************
- Ran for 120.70 seconds
- Performed 3,949,301 Stored Procedure calls
- At 32,721.06 calls per second
- Average Latency = 591.33 ms
- Latency 0ms - 25ms = 0
- Latency 25ms - 50ms = 0
- Latency 50ms - 75ms = 0
- Latency 75ms - 100ms = 0
- Latency 100ms - 125ms = 0
- Latency 125ms - 150ms = 0
- Latency 150ms - 175ms = 0
- Latency 175ms - 200ms = 0
- Latency 200ms+ = 3,889,210
I also tried it on a Dell R900 (16 x Xeon X7350 @ 2.93GHz) and got similar results:
*************************************************************************
Voting Results
*************************************************************************
- Accepted votes = 3,823,844
- Rejected votes (invalid contestant) = 19,157
- Rejected votes (voter over limit) = 0
- Contestant Jessie Alloway received 534,525 vote(s)
- Contestant Kelly Clauss received 635,048 vote(s)
- Contestant Jessie Eichman received 217,810 vote(s)
- Contestant Alana Bregman received 633,730 vote(s)
- Contestant Tabatha Gehling received 218,320 vote(s)
- Contestant Edwina Burnam received 1,584,411 vote(s)
- Contestant Edwina Burnam was the winner with 1,584,411 vote(s)
*************************************************************************
System Statistics
*************************************************************************
- Ran for 121.24 seconds
- Performed 3,843,001 Stored Procedure calls
- At 31,698.78 calls per second
- Average Latency = 1072.96 ms
- Latency 0ms - 25ms = 0
- Latency 25ms - 50ms = 0
- Latency 50ms - 75ms = 0
- Latency 75ms - 100ms = 0
- Latency 100ms - 125ms = 0
- Latency 125ms - 150ms = 0
- Latency 150ms - 175ms = 0
- Latency 175ms - 200ms = 0
- Latency 200ms+ = 3,780,377
Any ideas?
HP Info:
[jharris@dbXX voter]$ uname -a
Linux dbXX 2.6.18-164.2.1.el5 #1 SMP Mon Sep 21 04:37:42 EDT 2009 x86_64 x86_64 x86_64 GNU/Linux
[jharris@dbXX voter]$ cat /proc/cpuinfo | tail -n 24
processor : 23
vendor_id : GenuineIntel
cpu family : 6
model : 29
model name : Intel(R) Xeon(R) CPU X7460 @ 2.66GHz
stepping : 1
cpu MHz : 2666.759
cache size : 16384 KB
physical id : 3
siblings : 6
core id : 5
cpu cores : 6
apicid : 29
fpu : yes
fpu_exception : yes
cpuid level : 11
wp : yes
flags : fpu vme de pse tsc msr pae mce cx8 apic sep mtrr pge mca cmov pat pse36 clflush dts acpi mmx fxsr sse sse2 ss ht tm syscall lm constant_tsc pni monitor ds_cpl vmx est tm2 ssse3 cx16 xtpr sse4_1 lahf_lm
bogomips : 5333.64
clflush size : 64
cache_alignment : 64
address sizes : 40 bits physical, 48 bits virtual
power management:
[jharris@dbXX voter]$ cat /proc/meminfo
MemTotal: 132099200 kB
MemFree: 3354172 kB
Buffers: 356636 kB
Cached: 125556928 kB
SwapCached: 508 kB
Active: 64583160 kB
Inactive: 62275608 kB
HighTotal: 0 kB
HighFree: 0 kB
LowTotal: 132099200 kB
LowFree: 3354172 kB
SwapTotal: 16386292 kB
SwapFree: 13372252 kB
Dirty: 248 kB
Writeback: 0 kB
AnonPages: 944756 kB
Mapped: 62773948 kB
Slab: 758932 kB
PageTables: 716168 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
CommitLimit: 82435892 kB
Committed_AS: 67828364 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 390400 kB
VmallocChunk: 34359347939 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
Hugepagesize: 2048 kB
Min. processor for each line?
chbussler
Apr 12, 2010
I forgot that the 55xx's were Nehalem. I'll give this a try on one of my 8-core servers running with E5540s @ 2.53GHz.
Hi,
not sure if this question makes sense, but I'll give it a shot anyway. Intel has the different server processor lines (http://www.intel.com/p/en_US/products/server/processor). Do you have a 'starting' or 'minimal' processor per line that you would say supports VoltDBs structure 'properly'?
Like above, you said that the 55xx series is a lot better than the 54xx series. Do you have similar information for the other lines?
Or the other way around, what features should a processor have in order to support VoltDB's implementation best?
Thanks,
Christoph
PS Nobody discussed AMD yet, not sure if there is similar info on their processors. Thanks.
Code for 'traditional RDBMS'?
chbussler
Apr 12, 2010
Hey Tim,
I'm trying the out of the box single-node configuration (ant server/ant client) on an HP DL580 G5 (24 x Xeon X7460 @ 2.66GHz) running CentOS 5.4 and am getting the following:
*************************************************************************
Voting Results
*************************************************************************
- Accepted votes = 3,929,581
- Rejected votes (invalid contestant) = 19,720
- Rejected votes (voter over limit) = 0
- Contestant Jessie Alloway received 550,467 vote(s)
- Contestant Kelly Clauss received 651,957 vote(s)
- Contestant Jessie Eichman received 223,113 vote(s)
- Contestant Alana Bregman received 651,864 vote(s)
- Contestant Tabatha Gehling received 223,597 vote(s)
- Contestant Edwina Burnam received 1,628,583 vote(s)
- Contestant Edwina Burnam was the winner with 1,628,583 vote(s)...
Hi,
great example application! It allows easily to play around with various parameters.
Just curious, do you happen to have the same application implemented on a traditional RDBMS like MySql or Postgres? For 'fun' it would be nice to see the number on those systems on the same hardware on my machine.
Thanks,
Christoph
re: Code for 'traditional RDBMS'?
tcallaghan
Apr 12, 2010
Hi,
great example application! It allows easily to play around with various parameters.
Just curious, do you happen to have the same application implemented on a traditional RDBMS like MySql or Postgres? For 'fun' it would be nice to see the number on those systems on the same hardware on my machine.
Thanks,
Christoph
Christoph,
We don't currently have this implemented in another RDBMS. The trick to getting a decent number is dynamically creating enough client "applications" to get anything resembling a decent number, since they are operating synchronously between client and server.
I'd love to hear your ideas as to how we could create a client framework for these purposes. Or anyone else's ideas...
-Tim
TPC test implementations?
chbussler
Apr 13, 2010
Christoph,
We don't currently have this implemented in another RDBMS. The trick to getting a decent number is dynamically creating enough client "applications" to get anything resembling a decent number, since they are operating synchronously between client and server.
I'd love to hear your ideas as to how we could create a client framework for these purposes. Or anyone else's ideas...
-Tim
Hi Tim,
not sure if TPC test implementation are openly available (have not done a search), but don't they have the same issue of generating requests?
Thanks,
Christoph
re: TPC test implementation
tcallaghan
Apr 13, 2010
Hi Tim,
not sure if TPC test implementation are openly available (have not done a search), but don't they have the same issue of generating requests?
Thanks,
Christoph
Christoph,
We will be releasing our implementation at some point in the near future.
-Tim