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@xxxxxxxxx
> Komu: s3t@xxxxxxxxxx
> CC: xen-users@xxxxxxxxxxxxxxxxxxx
> 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@xxxxxxxxxx <s3t@xxxxxxxxxx> wrote:
>
>From: s3t@xxxxxxxxxx <s3t@xxxxxxxxxx>
>Subject: [Xen-users] xen4 on debian squeeze, slow mysql in domU
>To: xen-users@xxxxxxxxxxxxxxxxxxx
>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@xxxxxxxxxxxxxxxxxxx
http://lists.xensource.com/xen-users
|
Home