<s3t@centrum.sk>
2010-Oct-23 13:11 UTC
[Xen-users] xen4 on debian squeeze, slow mysql in domU
hi,
i have a mysql server in guest domU on debian squeeze.
when i create test table and do INSERT INTO test (name, value) VALUES(RAND(),
RAND());
Query OK, 1 row affected (0.28 sec)
at other physical server with same configuration
Query OK, 1 row affected (0.00 sec)
i try this several time but on physical server max value never get over 0.05sec
and on VM lowest value was 0.13sec.
another tests:
sysbench
--num-threads=16 --max-requests=1000 --test=oltp --oltp-table-size=1000
--mysql-socket=/var/run/mysqld/mysqld.sock --mysql-user=root run
on physical server:
----------------------------------------------------------------
OLTP test statistics:
queries performed:
read: 15568
write: 5228
other: 2112
total: 22908
transactions: 1000 (436.65 per sec.)
deadlocks: 112 (48.91 per sec.)
read/write requests: 20796 (9080.65 per sec.)
other operations: 2112 (922.21 per sec.)
Test execution summary:
total time: 2.2901s
total number of events: 1000
total time taken by event execution: 35.0599
per-request statistics:
min: 2.51ms
avg: 35.06ms
max: 365.01ms
approx. 95 percentile: 73.80ms
Threads fairness:
events (avg/stddev): 62.5000/9.62
execution time (avg/stddev): 2.1912/0.14
----------------------------------------------------------------
on VM:
----------------------------------------------------------------
OLTP test statistics:
queries performed:
read: 14280
write: 5048
other: 2020
total: 21348
transactions: 1000 (177.26 per sec.)
deadlocks: 20 (3.55 per sec.)
read/write requests: 19328 (3426.02 per sec.)
other operations: 2020 (358.06 per sec.)
Test execution summary:
total time: 5.6415s
total number of events: 1000
total time taken by event execution: 89.6339
per-request statistics:
min: 35.81ms
avg: 89.63ms
max: 275.89ms
approx. 95 percentile: 115.18ms
Threads fairness:
events (avg/stddev): 62.5000/1.58
execution time (avg/stddev): 5.6021/0.03
----------------------------------------------------------------
can someone share his experience with using mysql server in xen domU?
what can be wrong?
dom0: Xeon E5520 2.27GHz, 8GB ram, debian squeeze, xen-hypervisor-4.0-amd64
Version: 4.0.1-1
domU: vcpus = ''8'',memory = ''4096'', debian
squeeze
physical server: core2quad Q9300 2.50GHz, 4GB, debian lenny
_______________________________________________
Xen-users mailing list
Xen-users@lists.xensource.com
http://lists.xensource.com/xen-users
Mike Viau
2010-Oct-23 14:17 UTC
RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU
> On Sat, 23 Oct 2010 15:11:52 +0200 <s3t@centrum.sk> wrote: > > hi,> i have a mysql server in guest domU on debian squeeze.> when i create test table and do INSERT INTO test (name, value) VALUES(RAND(), RAND());> Query OK, 1 row affected (0.28 sec)>> at other physical server with same configuration> Query OK, 1 row affected (0.00 sec)>> i try this several time but on physical server max value never get over 0.05sec and on VM lowest value was 0.13sec.> another tests:> sysbench--num-threads=16 --max-requests=1000 --test=oltp --oltp-table-size=1000 --mysql-socket=/var/run/mysqld/mysqld.sock --mysql-user=root run>> on physical server:> ----------------------------------------------------------------> OLTP test statistics:> queries performed: > read: 15568 > write: 5228 > other: 2112 > total: 22908 > transactions: 1000 (436.65 per sec.)>deadlocks: 112 (48.91 per sec.)>read/write requests: 20796 (9080.65 per sec.)>other operations: 2112 (922.21 per sec.)>> Test execution summary: >total time: 2.2901s>total number of events: 1000>total time taken by event execution: 35.0599>per-request statistics:>min: 2.51ms>avg: 35.06ms>max: 365.01ms>approx. 95 percentile: 73.80ms> >Threads fairness:>events (avg/stddev): 62.5000/9.62>execution time (avg/stddev): 2.1912/0.14>---------------------------------------------------------------->> >on VM:>---------------------------------------------------------------->OLTP test statistics:>queries performed:>read: 14280>write: 5048 > other: 2020 > total: 21348 > transactions: 1000 (177.26 per sec.) > deadlocks: 20 (3.55 per sec.) > read/write requests: 19328 (3426.02 per sec.) > other operations: 2020 (358.06 per sec.)>> Test execution summary:> total time: 5.6415s > total number of events: 1000 > total time taken by event execution: 89.6339 > per-request statistics: > min: 35.81ms > avg: 89.63ms > max: 275.89ms > approx. 95 percentile: 115.18ms>> Threads fairness:> events (avg/stddev): 62.5000/1.58 > execution time (avg/stddev): 5.6021/0.03> ---------------------------------------------------------------->> can someone share his experience with using mysql server in xen domU?> what can be wrong?Could you post your domU confing files. What kind of blk devices were you using? Images, Partitions, etc? -M _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
<s3t@centrum.sk>
2010-Oct-23 15:29 UTC
RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU
thanks for quick reply.. im using lvm to create domU patitions. domU config: ---------------------------------------------------------------- kernel = ''/boot/vmlinuz-2.6.32-5-xen-amd64'' ramdisk = ''/boot/initrd.img-2.6.32-5-xen-amd64'' vcpus = ''8'' memory = ''4096'' root = ''/dev/xvda2 ro'' disk = [ ''phy:/dev/Xen/mysql-data,xvda4,w'', ''phy:/dev/Xen/mysql-boot,xvda3,w'', ''phy:/dev/Xen/mysql-root,xvda2,w'', ''phy:/dev/Xen/mysql-swap,xvda1,w'', ] name = ''mysql'' vif = [ ''ip=x.x.x.172,mac=00:16:3E:F5:x:x'' ] on_poweroff = ''destroy'' on_reboot = ''restart'' on_crash = ''restart'' ---------------------------------------------------------------- partitions config: ---------------------------------------------------------------- [root] size=2G type=xfs mountpoint=/ options=defaults [boot] size=200M type=ext3 mountpoint=/boot options=errors=remount-ro [data] size=16G type=xfs mountpoint=/data options=noatime,logbsize=256k [swap] size=1G type=swap ---------------------------------------------------------------- database is on / xfs filesystem i make some tweaks just for testing and change mount option for / to: noatime,nodiratime,attr2,logbufs=8,logbsize=256k now is little bit better performance of disk but nothing change on mysql insert speed 0.13sec is the best result performance of disk write speed on VM is much better then physical dd if=/dev/zero of=test bs=1M count=1000 on VM: 114 MB/s, 121 MB/s, 123 MB/s on physical server: 56.5 MB/s, 73.9 MB/s, 66.5 MB/s i try create fullvirtualize machine: -------------------------------------------------- import os, re arch = os.uname()[4] kernel = ''/usr/lib/xen-4.0/boot/hvmloader'' device_model = ''/usr/lib/xen-4.0/bin/qemu-dm'' builder = ''hvm'' memory = 4096 shadow_memory = 8 #name = mysql vif = [ ''bridge=eth0'' ] disk = [''phy:/dev/Xen/mysql,xvda,w'',''file:/root/debian-testing-amd64-netinst.iso,xvdc:cdrom,r''] boot = ''c'' sdl=0 vnc=1 vnclisten="0.0.0.0" vncconsole=1 vncpasswd=''x'' stdvga=0 serial=''pty'' usbdevice=''tablet'' on_poweroff = ''destroy'' on_reboot = ''restart'' on_crash = ''restart'' -------------------------------------------------- performance of inserting is little bit better but.. -------------------------------------------------- mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.12 sec) mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.06 sec) mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.17 sec) mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.05 sec) mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.05 sec) -------------------------------------------------- i try also sysbench test with same parameter like before sysbench --num-threads=16 --max-requests=1000 --test=oltp --oltp-table-size=1000 --mysql-socket=/var/run/mysqld/mysqld.sock --mysql-user=root run -------------------------------------------------- OLTP test statistics: queries performed: read: 14616 write: 5096 other: 2044 total: 21756 transactions: 1000 (246.68 per sec.) deadlocks: 44 (10.85 per sec.) read/write requests: 19712 (4862.59 per sec.) other operations: 2044 (504.22 per sec.) Test execution summary: total time: 4.0538s total number of events: 1000 total time taken by event execution: 64.5168 per-request statistics: min: 8.17ms avg: 64.52ms max: 596.93ms approx. 95 percentile: 272.76ms Threads fairness: events (avg/stddev): 62.5000/1.32 execution time (avg/stddev): 4.0323/0.01 -------------------------------------------------- with full virtualization i get little bit better performance, but still test take 2x longer time then on physical server! i dont know what i can expect i never use xen and mysql together. ______________________________________________________________> Od: viaum@sheridanc.on.ca > Komu: <xen-users@lists.xensource.com> > Datum: 23.10.2010 16:19 > Předmět: RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU > > > ><!-- &gt;.hmmessage P &gt;{ &gt;margin:0px; &gt;padding:0px &gt;} &gt;body.hmmessage &gt;{ &gt;font-size: 10pt; &gt;font-family:Tahoma &gt;} &gt;--> >> >> On Sat, 23 Oct 2010 15:11:52 +0200 <s3t@centrum.sk> wrote: > > hi,>> i have a mysql server in guest domU on debian squeeze. >> when i create test table and do INSERT INTO test (name, value) VALUES(RAND(), RAND()); >> Query OK, 1 row affected (0.28 sec) >> >> at other physical server with same configuration >> Query OK, 1 row affected (0.00 sec) >> >> i try this several time but on physical server max value never get over 0.05sec and on VM lowest value was 0.13sec. >> another tests: >> sysbench > --num-threads=16 --max-requests=1000 --test=oltp --oltp-table-size=1000 > --mysql-socket=/var/run/mysqld/mysqld.sock --mysql-user=root run >> >> on physical server: >> ---------------------------------------------------------------- >> OLTP test statistics: > > queries performed: > > read: 15568 > > write: 5228 > > other: 2112 > > total: 22908 > > transactions: 1000 (436.65 per sec.)> > deadlocks: 112 (48.91 per sec.) > > read/write requests: 20796 (9080.65 per sec.) > > other operations: 2112 (922.21 per sec.)>> >> Test execution summary:> > total time: 2.2901s > > total number of events: 1000 > > total time taken by event execution: 35.0599 > > per-request statistics: > > min: 2.51ms > > avg: 35.06ms > > max: 365.01ms > > approx. 95 percentile: 73.80ms>>> >Threads fairness: > > events (avg/stddev): 62.5000/9.62 > > execution time (avg/stddev): 2.1912/0.14 > >---------------------------------------------------------------->> >>> >on VM: > >---------------------------------------------------------------- > >OLTP test statistics: > > queries performed: > > read: 14280 > > write: 5048> > other: 2020 > > total: 21348 > > transactions: 1000 (177.26 per sec.) > > deadlocks: 20 (3.55 per sec.) > > read/write requests: 19328 (3426.02 per sec.) > > other operations: 2020 (358.06 per sec.) >> >> Test execution summary: > > total time: 5.6415s > > total number of events: 1000 > > total time taken by event execution: 89.6339 > > per-request statistics: > > min: 35.81ms > > avg: 89.63ms > > max: 275.89ms > > approx. 95 percentile: 115.18ms >> >> Threads fairness: > > events (avg/stddev): 62.5000/1.58 > > execution time (avg/stddev): 5.6021/0.03 >> ---------------------------------------------------------------- >> >> can someone share his experience with using mysql server in xen domU? >> what can be wrong? > >Could you post your domU confing files. What kind of blk devices were you using? Images, Partitions, etc? -M >_______________________________________________ >Xen-users mailing list >Xen-users@lists.xensource.com >http://lists.xensource.com/xen-users > _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
Jeff Sturm
2010-Oct-23 15:47 UTC
RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU
> From: xen-users-bounces@lists.xensource.com [mailto:xen-users-bounces@lists.xensource.com] On Behalf Of s3t@centrum.sk > Sent: Saturday, October 23, 2010 11:29 AM > To: viaum@sheridanc.on.ca; xen-users@lists.xensource.com > Subject: RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU> vcpus = '8'How many physical cores do you have? Don't set vcpus larger than the number of cores available in your dom0. -Jeff _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
<s3t@centrum.sk>
2010-Oct-23 15:55 UTC
RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU
i think this is ok # cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5520 @ 2.27GHz stepping : 5 cpu MHz : 2261.034 cache size : 8192 KB fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu de tsc msr pae mce cx8 apic sep mtrr mca cmov pat clflush acpi mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nonstop_tsc aperfmperf pni est ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm bogomips : 4522.06 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 1 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5520 @ 2.27GHz stepping : 5 cpu MHz : 2261.034 cache size : 8192 KB fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu de tsc msr pae mce cx8 apic sep mtrr mca cmov pat clflush acpi mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nonstop_tsc aperfmperf pni est ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm bogomips : 4522.06 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 2 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5520 @ 2.27GHz stepping : 5 cpu MHz : 2261.034 cache size : 8192 KB fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu de tsc msr pae mce cx8 apic sep mtrr mca cmov pat clflush acpi mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nonstop_tsc aperfmperf pni est ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm bogomips : 4522.06 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 3 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5520 @ 2.27GHz stepping : 5 cpu MHz : 2261.034 cache size : 8192 KB fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu de tsc msr pae mce cx8 apic sep mtrr mca cmov pat clflush acpi mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nonstop_tsc aperfmperf pni est ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm bogomips : 4522.06 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 4 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5520 @ 2.27GHz stepping : 5 cpu MHz : 2261.034 cache size : 8192 KB fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu de tsc msr pae mce cx8 apic sep mtrr mca cmov pat clflush acpi mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nonstop_tsc aperfmperf pni est ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm bogomips : 4522.06 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 5 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5520 @ 2.27GHz stepping : 5 cpu MHz : 2261.034 cache size : 8192 KB fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu de tsc msr pae mce cx8 apic sep mtrr mca cmov pat clflush acpi mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nonstop_tsc aperfmperf pni est ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm bogomips : 4522.06 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 6 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5520 @ 2.27GHz stepping : 5 cpu MHz : 2261.034 cache size : 8192 KB fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu de tsc msr pae mce cx8 apic sep mtrr mca cmov pat clflush acpi mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nonstop_tsc aperfmperf pni est ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm bogomips : 4522.06 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: processor : 7 vendor_id : GenuineIntel cpu family : 6 model : 26 model name : Intel(R) Xeon(R) CPU E5520 @ 2.27GHz stepping : 5 cpu MHz : 2261.034 cache size : 8192 KB fpu : yes fpu_exception : yes cpuid level : 11 wp : yes flags : fpu de tsc msr pae mce cx8 apic sep mtrr mca cmov pat clflush acpi mmx fxsr sse sse2 ss ht syscall nx lm constant_tsc rep_good nonstop_tsc aperfmperf pni est ssse3 cx16 sse4_1 sse4_2 popcnt hypervisor lahf_lm bogomips : 4522.06 clflush size : 64 cache_alignment : 64 address sizes : 40 bits physical, 48 bits virtual power management: ______________________________________________________________> Od: jeff.sturm@eprize.com > Komu: <s3t@centrum.sk>, <viaum@sheridanc.on.ca>, <xen-users@lists.xensource.com> > Datum: 23.10.2010 17:52 > Předmět: RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU > >>> From: xen-users-bounces@lists.xensource.com [mailto:xen-users-bounces@lists.xensource.com] On Behalf Of s3t@centrum.sk >> Sent: Saturday, October 23, 2010 11:29 AM >> To: viaum@sheridanc.on.ca; xen-users@lists.xensource.com >> Subject: RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU > >> vcpus = ''8'' > >How many physical cores do you have? Don''t set vcpus larger than the number of cores available in your dom0. > >-Jeff > > _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
Mike Viau
2010-Oct-23 15:58 UTC
RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU
> On Sat, 23 Oct 2010 11:47:42 -0400 <jeff.sturm@eprize.com> wrote: > > > vcpus = ''8'' > > How many physical cores do you have? Don''t set vcpus larger than the number of cores available in your dom0. > > -Jeff >Indeed you are right Jeff, the OP mentioned he was using an Intel Xeon E5520 [1] CPU. # of Cores4# of Threads8 Which leads me to believe the system is using hyperthreading on each of the 4 cores. Unfortunatley I do not have hardware (Xeon CPU) to test for similar results. [1] - http://ark.intel.com/Product.aspx?id=40200 -M _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
<s3t@centrum.sk>
2010-Oct-23 16:35 UTC
RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU
i try change vcpus = ''4'' ,just in case. also i try change patition to image and change config from phy to file on root device. mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.17 sec) mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.15 sec) mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.15 sec) mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.15 sec) mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND()); Query OK, 1 row affected (0.17 sec) i think poblem maybe is on dom0, some delay in communication between domU and dom0. what about your results from mysql insert on your domU? ______________________________________________________________> Od: viaum@sheridanc.on.ca > Komu: <xen-users@lists.xensource.com> > Datum: 23.10.2010 18:02 > Předmět: RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU > > > ><!-- &gt;.hmmessage P &gt;{ &gt;margin:0px; &gt;padding:0px &gt;} &gt;body.hmmessage &gt;{ &gt;font-size: 10pt; &gt;font-family:Tahoma &gt;} &gt;--> >> >> On Sat, 23 Oct 2010 11:47:42 -0400 <jeff.sturm@eprize.com> wrote: > > > vcpus = ''8'' > > How many physical cores do you have? Don''t set vcpus larger than the number of cores available in your dom0. > > -Jeff >Indeed you are right Jeff, the OP mentioned he was using an Intel Xeon E5520 [1] CPU. # of Cores4odd"># of Threads8 Which leads me to believe the system is using hyperthreading on each of the 4 cores. Unfortunatley I do not have hardware (Xeon CPU) to test for similar results. [1] - http://ark.intel.com/Product.aspx?id=40200 -M >_______________________________________________ >Xen-users mailing list >Xen-users@lists.xensource.com >http://lists.xensource.com/xen-users > _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
Mark Pryor
2010-Oct-23 18:04 UTC
Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU
--- On Sat, 10/23/10, s3t@centrum.sk <s3t@centrum.sk> wrote:
From: s3t@centrum.sk <s3t@centrum.sk>
Subject: [Xen-users] xen4 on debian squeeze, slow mysql in domU
To: xen-users@lists.xensource.com
Date: Saturday, October 23, 2010, 6:11 AM
hi,
i have a mysql server in guest domU on debian squeeze.
--------------------------------------------------------
on VM:
----------------------------------------------------------------
OLTP test statistics:
queries performed:
read: 14280
write: 5048
other: 2020
total: 21348
transactions: 1000 (177.26 per sec.)
deadlocks: 20 (3.55 per sec.)
read/write requests: 19328 (3426.02 per sec.)
other operations: 2020 (358.06 per sec.)
Test execution summary:
total time: 5.6415s
total number of events: 1000
total time taken by event execution: 89.6339
per-request statistics:
min: 35.81ms
avg: 89.63ms
max: 275.89ms
approx. 95 percentile: 115.18ms
Threads fairness:
events (avg/stddev): 62.5000/1.58
execution time (avg/stddev): 5.6021/0.03
----------------------------------------------------------------
can someone share his experience with using mysql server in xen domU?
what can be wrong?
dom0: Xeon E5520 2.27GHz, 8GB ram, debian squeeze, xen-hypervisor-4.0-amd64
Version: 4.0.1-1
domU: vcpus = ''8'',memory = ''4096'', debian
squeeze
physical server: core2quad Q9300 2.50GHz, 4GB, debian lenny
----------------------- OP -----------------
My dom0 is squeeze and the domU is Lucid.
Forcing the table engine to myisam
sysbench --test=oltp --max-requests=1000 --num-threads=4
--mysql-table-engine=myisam --oltp-table-size=1000
--mysql-socket=/var/run/mysqld/mysqld.sock run
sysbench 0.4.10: multi-threaded system evaluation benchmark
No DB drivers specified, using mysql
WARNING: Preparing of "LOCK TABLES sbtest WRITE" is unsupported, using
emulation
WARNING: Preparing of "UNLOCK TABLES" is unsupported, using emulation
WARNING: Preparing of "LOCK TABLES sbtest WRITE" is unsupported, using
emulation
WARNING: Preparing of "UNLOCK TABLES" is unsupported, using emulation
WARNING: Preparing of "LOCK TABLES sbtest WRITE" is unsupported, using
emulation
WARNING: Preparing of "UNLOCK TABLES" is unsupported, using emulation
WARNING: Preparing of "LOCK TABLES sbtest WRITE" is unsupported, using
emulation
WARNING: Preparing of "UNLOCK TABLES" is unsupported, using emulation
Running the test with following options:
Number of threads: 4
Doing OLTP test.
Running mixed OLTP test
Using Special distribution (12 iterations, 1 pct of values are returned in 75
pct cases)
Using "LOCK TABLES WRITE" for starting transactions
Using auto_inc on the id column
Maximum number of requests for OLTP test is limited to 1000
Threads started!
Done.
OLTP test statistics:
queries performed:
read: 14000
write: 5000
other: 2000
total: 21000
transactions: 1000 (403.27 per sec.)
deadlocks: 0 (0.00 per sec.)
read/write requests: 19000 (7662.05 per sec.)
other operations: 2000 (806.53 per sec.)
Test execution summary:
total time: 2.4798s
total number of events: 1000
total time taken by event execution: 9.8993
per-request statistics:
min: 2.41ms
avg: 9.90ms
max: 234.23ms
approx. 95 percentile: 9.01ms
Threads fairness:
events (avg/stddev): 250.0000/0.00
execution time (avg/stddev): 2.4748/0.00
--
Mark
_______________________________________________
Xen-users mailing list
Xen-users@lists.xensource.com
http://lists.xensource.com/xen-users
<s3t@centrum.sk>
2010-Oct-23 19:03 UTC
Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU
hi Mark, thanks for reply! I make exactly same sysbench test (witch parameter like you) this is my result: OLTP test statistics: queries performed: read: 14196 write: 5030 other: 2014 total: 21240 transactions: 1000 (48.87 per sec.) deadlocks: 14 (0.68 per sec.) read/write requests: 19226 (939.66 per sec.) other operations: 2014 (98.43 per sec.) Test execution summary: total time: 20.4606s total number of events: 1000 total time taken by event execution: 81.6752 per-request statistics: min: 33.00ms avg: 81.68ms max: 243.64ms approx. 95 percentile: 140.42ms Threads fairness: events (avg/stddev): 250.0000/1.58 execution time (avg/stddev): 20.4188/0.03 --------------------------------------------------- this is insane.. i dont know maybe its some hw issue. I have 2server with squeeze and on both a have results like this. on dom0 i have installed: aptitude search ~i|grep xen i A libxenstore3.0 - Xenstore communications library for Xen i linux-image-2.6-xen-amd64 - Linux 2.6 for 64-bit PCs (meta-package), X i A linux-image-2.6.32-5-xen-amd64 - Linux 2.6.32 for 64-bit PCs, Xen dom0 supp i A xen-hypervisor-4.0-amd64 - The Xen Hypervisor on AMD64 i xen-linux-system-2.6.32-5-xen-a - Xen system with Linux 2.6.32 on 64-bit PCs i xen-qemu-dm-4.0 - Xen Qemu Device Model virtual machine hard i xen-tools - Tools to manage Xen virtual servers i xen-utils-4.0 - XEN administrative tools i A xen-utils-common - XEN administrative tools - common files i xenstore-utils - Xenstore utilities for Xen i xenwatch - Virtualization utilities, mostly for Xen this is my xend-config.sxp # sed -e ''/^#/d'' $1 /etc/xen/xend-config.sxp |grep -v ''^$'' (xend-http-server yes) (network-script network-bridge) (vif-script vif-bridge) (dom0-min-mem 1024) (enable-dom0-ballooning yes) (total_available_memory 0) (dom0-cpus 0) (vncpasswd '''') grub: # sed -e ''/^#/d'' $1 /etc/default/grub |grep -v ''^$'' GRUB_DEFAULT=4 GRUB_TIMEOUT=5 GRUB_DISTRIBUTOR=`lsb_release -i -s 2> /dev/null || echo Debian` GRUB_CMDLINE_LINUX_DEFAULT="" GRUB_CMDLINE_LINUX="" GRUB_DISABLE_OS_PROBER=true loop max_loop=64 is in /etc/modules # sed -e ''/^#/d'' $1 /etc/xen-tools/xen-tools.conf |grep -v ''^$'' lvm = Xen dist = squeeze # Default distribution to install. gateway = x.x.x.x netmask = x.x.x.x vcpus = 8 memory = 512 passwd = 1 kernel = /boot/vmlinuz-2.6.32-5-xen-amd64 initrd = /boot/initrd.img-2.6.32-5-xen-amd64 mirror = http://ftp.sk.debian.org/debian/ # lsmod Module Size Used by xfs 436925 0 exportfs 3170 1 xfs xt_tcpudp 2319 3 nf_conntrack_ipv4 9833 6 nf_defrag_ipv4 1139 1 nf_conntrack_ipv4 xt_state 1303 6 nf_conntrack 46519 2 nf_conntrack_ipv4,xt_state xt_physdev 1508 12 ip6table_filter 2384 0 ip6_tables 15075 1 ip6table_filter bridge 39662 0 stp 1440 1 bridge iptable_filter 2258 1 ip_tables 13899 1 iptable_filter x_tables 12845 5 xt_tcpudp,xt_state,xt_physdev,ip6_tables,ip_tables xen_evtchn 4339 4 xenfs 9600 1 fuse 50273 1 loop 11799 2 i2c_i801 7830 0 ioatdma 34876 48 joydev 8411 0 i2c_core 15712 1 i2c_i801 evdev 7352 3 snd_pcm 60551 0 snd_timer 15582 1 snd_pcm snd 46446 2 snd_pcm,snd_timer soundcore 4598 1 snd snd_page_alloc 6249 1 snd_pcm pcspkr 1699 0 psmouse 49777 0 serio_raw 3752 0 button 4650 0 processor 36149 0 acpi_processor 5087 1 processor,[permanent] ext3 106502 1 jbd 37085 1 ext3 mbcache 5050 1 ext3 dm_mod 53770 59 sd_mod 29761 4 crc_t10dif 1276 1 sd_mod usbhid 33276 0 hid 62857 1 usbhid uhci_hcd 18521 0 ata_generic 2983 0 ata_piix 21124 0 mpt2sas 87741 3 scsi_transport_sas 19865 1 mpt2sas libata 133600 2 ata_generic,ata_piix ehci_hcd 31135 0 usbcore 121938 4 usbhid,uhci_hcd,ehci_hcd nls_base 6377 1 usbcore scsi_mod 122101 4 sd_mod,mpt2sas,scsi_transport_sas,libata thermal 11674 0 igb 77975 0 dca 3761 2 ioatdma,igb thermal_sys 11942 2 processor,thermal no other things was set. i installing domU via xen-tools. you configure something alse? can you please post me config of that lucid VM? thanks ______________________________________________________________> Od: tlviewer@yahoo.com > Komu: s3t@centrum.sk > CC: xen-users@lists.xensource.com > Datum: 23.10.2010 20:04 > Předmět: Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU > >>--- On Sat, 10/23/10, s3t@centrum.sk <s3t@centrum.sk> wrote: > >From: s3t@centrum.sk <s3t@centrum.sk> >Subject: [Xen-users] xen4 on debian squeeze, slow mysql in domU >To: xen-users@lists.xensource.com >Date: Saturday, October 23, 2010, 6:11 AM > >hi, > >i have a mysql server in guest domU on debian squeeze. > >-------------------------------------------------------- > >on VM: > >---------------------------------------------------------------- > >OLTP test statistics: > > queries performed: > > read: 14280 > > write: 5048 > > other: 2020 > > total: 21348 > > transactions: 1000 (177.26 per sec.) > > deadlocks: 20 (3.55 per sec.) > > read/write requests: 19328 (3426.02 per sec.) > > other operations: 2020 (358.06 per sec.) > > > >Test execution summary: > > total time: 5.6415s > > total number of events: 1000 > > total time taken by event execution: 89.6339 > > per-request statistics: > > min: 35.81ms > > avg: 89.63ms > > max: 275.89ms > > approx. 95 percentile: 115.18ms > > > >Threads fairness: > > events (avg/stddev): 62.5000/1.58 > > execution time (avg/stddev): 5.6021/0.03 > >---------------------------------------------------------------- > > > >can someone share his experience with using mysql server in xen domU? > >what can be wrong? > > > > > >dom0: Xeon E5520 2.27GHz, 8GB ram, debian squeeze, xen-hypervisor-4.0-amd64 Version: 4.0.1-1 > >domU: vcpus = ''8'',memory = ''4096'', debian squeeze > >physical server: core2quad Q9300 2.50GHz, 4GB, debian lenny > >----------------------- OP ----------------- >My dom0 is squeeze and the domU is Lucid. >Forcing the table engine to myisam > >sysbench --test=oltp --max-requests=1000 --num-threads=4 --mysql-table-engine=myisam --oltp-table-size=1000 --mysql-socket=/var/run/mysqld/mysqld.sock run >sysbench 0.4.10: multi-threaded system evaluation benchmark > >No DB drivers specified, using mysql >WARNING: Preparing of "LOCK TABLES sbtest WRITE" is unsupported, using emulation >WARNING: Preparing of "UNLOCK TABLES" is unsupported, using emulation >WARNING: Preparing of "LOCK TABLES sbtest WRITE" is unsupported, using emulation >WARNING: Preparing of "UNLOCK TABLES" is unsupported, using emulation >WARNING: Preparing of "LOCK TABLES sbtest WRITE" is unsupported, using emulation >WARNING: Preparing of "UNLOCK TABLES" is unsupported, using emulation >WARNING: Preparing of "LOCK TABLES sbtest WRITE" is unsupported, using emulation >WARNING: Preparing of "UNLOCK TABLES" is unsupported, using emulation >Running the test with following options: >Number of threads: 4 > >Doing OLTP test. >Running mixed OLTP test >Using Special distribution (12 iterations, 1 pct of values are returned in 75 pct cases) >Using "LOCK TABLES WRITE" for starting transactions >Using auto_inc on the id column >Maximum number of requests for OLTP test is limited to 1000 >Threads started! >Done. > >OLTP test statistics: > queries performed: > read: 14000 > write: 5000 > other: 2000 > total: 21000 > transactions: 1000 (403.27 per sec.) > deadlocks: 0 (0.00 per sec.) > read/write requests: 19000 (7662.05 per sec.) > other operations: 2000 (806.53 per sec.) > >Test execution summary: > total time: 2.4798s > total number of events: 1000 > total time taken by event execution: 9.8993 > per-request statistics: > min: 2.41ms > avg: 9.90ms > max: 234.23ms > approx. 95 percentile: 9.01ms > >Threads fairness: > events (avg/stddev): 250.0000/0.00 > execution time (avg/stddev): 2.4748/0.00 > >-- >Mark > > > > _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users
<s3t@centrum.sk>
2010-Oct-24 03:30 UTC
Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU
i think this is some hw issue i have lsi raid on server 02:00.0 Serial Attached SCSI controller: LSI Logic / Symbios Logic SAS2008 PCI-Express Fusion-MPT SAS-2 [Falcon] (rev 02 in dmesg: [ 0.000000] ERROR: Unable to locate IOAPIC for GSI 2 [ 0.000000] ERROR: Unable to locate IOAPIC for GSI 9 [ 2.662825] ERROR: Unable to locate IOAPIC for GSI 9 i try create domU with pygrub http://wejn.org/stuff/how-to-boot-via-pygrub-on-lenny.html i try also lucid but didn''t success. results of bench test with your parameters is worst then before: OLTP test statistics: queries performed: read: 14000 write: 5000 other: 2000 total: 21000 transactions: 1000 (105.03 per sec.) deadlocks: 0 (0.00 per sec.) read/write requests: 19000 (1995.48 per sec.) other operations: 2000 (210.05 per sec.) Test execution summary: total time: 9.5215s total number of events: 1000 total time taken by event execution: 37.9919 per-request statistics: min: 15.74ms avg: 37.99ms max: 217.21ms approx. 95 percentile: 59.99ms Threads fairness: events (avg/stddev): 250.0000/6.00 execution time (avg/stddev): 9.4980/0.01 i need fix this ASAP but i don''t have clue how. ______________________________________________________________> Od: tlviewer@yahoo.com> Komu: s3t@centrum.sk> Datum: 23.10.2010 21:28> Předmět: Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU>>Here are some stats for the dom0 and the lucid domU config.>http://paste.ubuntu.com/518885/ > >-- >Mark >--- On Sat, 10/23/10, s3t@centrum.sk <s3t@centrum.sk> wrote: > >> From: s3t@centrum.sk <s3t@centrum.sk> >> Subject: Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU >> To: tlviewer@yahoo.com, xen-users@lists.xensource.com >> Date: Saturday, October 23, 2010, 12:03 PM >> >> hi Mark, >> thanks for reply! I make exactly same sysbench test (witch >> parameter like you) >> this is my result: >> >> OLTP test statistics: >> queries performed: >> >> read: >> 14196 >> >> write: >> 5030 >> >> other: >> 2014 >> >> total: >> 21240 >> >> transactions: >> 1000 (48.87 per sec.) >> >> deadlocks: >> 14 (0.68 per sec.) >> read/write requests: >> 19226 (939.66 per sec.) >> other >> operations: 2014 >> (98.43 per sec.) >> >> Test execution summary: >> total >> time: >> 20.4606s >> total number of events: >> 1000 >> total time taken by event execution: 81.6752 >> per-request statistics: >> >> min: >> 33.00ms >> >> avg: >> 81.68ms >> >> max: >> 243.64ms >> approx. 95 >> percentile: 140.42ms >> >> Threads fairness: >> events (avg/stddev): >> 250.0000/1.58 >> execution time (avg/stddev): 20.4188/0.03 >> --------------------------------------------------- >> >> this is insane.. >> i dont know maybe its some hw issue. I have 2server with >> squeeze and on both a have results like this. >> on dom0 i have installed: >> aptitude search ~i|grep xen >> i A libxenstore3.0 - >> Xenstore communications library for Xen >> i linux-image-2.6-xen-amd64 - Linux 2.6 for >> 64-bit PCs (meta-package), X >> i A linux-image-2.6.32-5-xen-amd64 - Linux 2.6.32 for >> 64-bit PCs, Xen dom0 supp >> i A xen-hypervisor-4.0-amd64 - The Xen >> Hypervisor on AMD64 >> i xen-linux-system-2.6.32-5-xen-a - Xen system with >> Linux 2.6.32 on 64-bit PCs >> i xen-qemu-dm-4.0 - Xen >> Qemu Device Model virtual machine hard >> i xen-tools >> - Tools to manage Xen virtual servers >> i xen-utils-4.0 - >> XEN administrative tools >> i A xen-utils-common - XEN >> administrative tools - common files >> i xenstore-utils - >> Xenstore utilities for Xen >> i >> xenwatch - >> Virtualization utilities, mostly for Xen >> >> this is my xend-config.sxp >> # sed -e ''/^#/d'' $1 /etc/xen/xend-config.sxp |grep -v ''^$'' >> (xend-http-server yes) >> (network-script network-bridge) >> (vif-script vif-bridge) >> (dom0-min-mem 1024) >> (enable-dom0-ballooning yes) >> (total_available_memory 0) >> (dom0-cpus 0) >> (vncpasswd '''') >> >> grub: >> # sed -e ''/^#/d'' $1 /etc/default/grub |grep -v ''^$'' >> GRUB_DEFAULT=4 >> GRUB_TIMEOUT=5 >> GRUB_DISTRIBUTOR=`lsb_release -i -s 2> /dev/null || echo >> Debian` >> GRUB_CMDLINE_LINUX_DEFAULT="" >> GRUB_CMDLINE_LINUX="" >> GRUB_DISABLE_OS_PROBER=true >> >> loop max_loop=64 is in /etc/modules >> >> # sed -e ''/^#/d'' $1 /etc/xen-tools/xen-tools.conf |grep -v >> ''^$'' >> lvm = Xen >> dist = squeeze # Default distribution to install. >> gateway = x.x.x.x >> netmask = x.x.x.x >> vcpus = 8 >> memory = 512 >> passwd = 1 >> kernel = /boot/vmlinuz-2.6.32-5-xen-amd64 >> initrd = /boot/initrd.img-2.6.32-5-xen-amd64 >> mirror = http://ftp.sk.debian.org/debian/ >> >> # lsmod >> Module Size Used by >> xfs 436925 0 >> exportfs 3170 1 xfs >> xt_tcpudp 2319 3 >> nf_conntrack_ipv4 9833 6 >> nf_defrag_ipv4 1139 1 >> nf_conntrack_ipv4 >> xt_state 1303 6 >> nf_conntrack 46519 2 >> nf_conntrack_ipv4,xt_state >> xt_physdev 1508 12 >> ip6table_filter 2384 0 >> ip6_tables 15075 1 >> ip6table_filter >> bridge 39662 0 >> stp 1440 1 >> bridge >> iptable_filter 2258 1 >> ip_tables 13899 1 >> iptable_filter >> x_tables 12845 5 >> xt_tcpudp,xt_state,xt_physdev,ip6_tables,ip_tables >> xen_evtchn 4339 4 >> xenfs 9600 1 >> fuse 50273 1 >> loop 11799 2 >> i2c_i801 7830 0 >> ioatdma 34876 48 >> joydev 8411 0 >> i2c_core 15712 1 i2c_i801 >> evdev 7352 3 >> snd_pcm 60551 0 >> snd_timer 15582 1 snd_pcm >> snd 46446 2 >> snd_pcm,snd_timer >> soundcore 4598 1 snd >> snd_page_alloc 6249 1 snd_pcm >> pcspkr 1699 0 >> psmouse 49777 0 >> serio_raw 3752 0 >> button 4650 0 >> processor 36149 0 >> acpi_processor 5087 1 >> processor,[permanent] >> ext3 106502 1 >> jbd 37085 1 ext3 >> mbcache 5050 1 ext3 >> dm_mod 53770 59 >> sd_mod 29761 4 >> crc_t10dif 1276 1 sd_mod >> usbhid 33276 0 >> hid 62857 1 usbhid >> uhci_hcd 18521 0 >> ata_generic 2983 0 >> ata_piix 21124 0 >> mpt2sas 87741 3 >> scsi_transport_sas 19865 1 mpt2sas >> libata 133600 2 >> ata_generic,ata_piix >> ehci_hcd 31135 0 >> usbcore 121938 4 >> usbhid,uhci_hcd,ehci_hcd >> nls_base 6377 1 usbcore >> scsi_mod 122101 4 >> sd_mod,mpt2sas,scsi_transport_sas,libata >> thermal 11674 0 >> igb 77975 0 >> dca 3761 2 >> ioatdma,igb >> thermal_sys 11942 2 >> processor,thermal >> >> >> no other things was set. >> i installing domU via xen-tools. >> you configure something alse? >> can you please post me config of that lucid VM? >> >> thanks >> >> ______________________________________________________________ >> > Od: tlviewer@yahoo.com >> > Komu: s3t@centrum.sk >> > CC: xen-users@lists.xensource.com >> > Datum: 23.10.2010 20:04 >> > Předmět: Re: [Xen-users] xen4 on debian squeeze, >> slow mysql in domU >> > >> > >> >--- On Sat, 10/23/10, s3t@centrum.sk >> <s3t@centrum.sk> >> wrote: >> > >> >From: s3t@centrum.sk >> <s3t@centrum.sk> >> >Subject: [Xen-users] xen4 on debian squeeze, slow >> mysql in domU >> >To: xen-users@lists.xensource.com >> >Date: Saturday, October 23, 2010, 6:11 AM >> > >> >hi, >> > >> >i have a mysql server in guest domU on debian >> squeeze. >> > >> >> >-------------------------------------------------------- >> > >> >on VM: >> > >> >> >---------------------------------------------------------------- >> > >> >OLTP test statistics: >> > >> > queries performed: >> > >> > read: >> 14280 >> > >> > write: >> 5048 >> > >> > other: >> 2020 >> > >> > total: >> 21348 >> > >> > transactions: >> 1000 (177.26 per sec.) >> > >> > deadlocks: >> 20 (3.55 per sec.) >> > >> > read/write requests: >> 19328 (3426.02 per sec.) >> > >> > other operations: >> 2020 (358.06 per sec.) >> > >> > >> > >> >Test execution summary: >> > >> > total time: >> 5.6415s >> > >> > total number of events: >> 1000 >> > >> > total time taken by event execution: 89.6339 >> > >> > per-request statistics: >> > >> > min: >> 35.81ms >> > >> > avg: >> 89.63ms >> > >> > max: >> 275.89ms >> > >> > approx. 95 percentile: >> 115.18ms >> > >> > >> > >> >Threads fairness: >> > >> > events (avg/stddev): >> 62.5000/1.58 >> > >> > execution time (avg/stddev): 5.6021/0.03 >> > >> >> >---------------------------------------------------------------- >> > >> > >> > >> >can someone share his experience with using mysql >> server in xen domU? >> > >> >what can be wrong? >> > >> > >> > >> > >> > >> >dom0: Xeon E5520 2.27GHz, 8GB ram, debian squeeze, >> xen-hypervisor-4.0-amd64 Version: 4.0.1-1 >> > >> >domU: vcpus = ''8'',memory = ''4096'', debian squeeze >> > >> >physical server: core2quad Q9300 2.50GHz, 4GB, debian >> lenny >> > >> >----------------------- OP ----------------- >> >My dom0 is squeeze and the domU is Lucid. >> >Forcing the table engine to myisam >> > >> >sysbench --test=oltp --max-requests=1000 >> --num-threads=4 --mysql-table-engine=myisam >> --oltp-table-size=1000 >> --mysql-socket=/var/run/mysqld/mysqld.sock run >> >sysbench 0.4.10: multi-threaded system evaluation >> benchmark >> > >> >No DB drivers specified, using mysql >> >WARNING: Preparing of "LOCK TABLES sbtest WRITE" is >> unsupported, using emulation >> >WARNING: Preparing of "UNLOCK TABLES" is unsupported, >> using emulation >> >WARNING: Preparing of "LOCK TABLES sbtest WRITE" is >> unsupported, using emulation >> >WARNING: Preparing of "UNLOCK TABLES" is unsupported, >> using emulation >> >WARNING: Preparing of "LOCK TABLES sbtest WRITE" is >> unsupported, using emulation >> >WARNING: Preparing of "UNLOCK TABLES" is unsupported, >> using emulation >> >WARNING: Preparing of "LOCK TABLES sbtest WRITE" is >> unsupported, using emulation >> >WARNING: Preparing of "UNLOCK TABLES" is unsupported, >> using emulation >> >Running the test with following options: >> >Number of threads: 4 >> > >> >Doing OLTP test. >> >Running mixed OLTP test >> >Using Special distribution (12 iterations, 1 pct of >> values are returned in 75 pct cases) >> >Using "LOCK TABLES WRITE" for starting transactions >> >Using auto_inc on the id column >> >Maximum number of requests for OLTP test is limited to >> 1000 >> >Threads started! >> >Done. >> > >> >OLTP test statistics: >> > queries performed: >> > read: >> 14000 >> > write: >> 5000 >> > other: >> 2000 >> > total: >> 21000 >> > transactions: >> 1000 (403.27 per sec.) >> > deadlocks: >> 0 (0.00 per sec.) >> > read/write requests: >> 19000 (7662.05 per sec.) >> > other operations: >> 2000 (806.53 per sec.) >> > >> >Test execution summary: >> > total time: >> 2.4798s >> > total number of events: >> 1000 >> > total time taken by event execution: 9.8993 >> > per-request statistics: >> > min: >> 2.41ms >> > avg: >> 9.90ms >> > max: >> 234.23ms >> > approx. 95 percentile: >> 9.01ms >> > >> >Threads fairness: >> > events (avg/stddev): >> 250.0000/0.00 >> > execution time (avg/stddev): 2.4748/0.00 >> > >> >-- >> >Mark >> > >> > >> > >> > >> >> >> _______________________________________________ >> Xen-users mailing list >> Xen-users@lists.xensource.com >> http://lists.xensource.com/xen-users >> > > > > _______________________________________________ Xen-users mailing list Xen-users@lists.xensource.com http://lists.xensource.com/xen-users