Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU

[<s3t@xxxxxxxxxx>]

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