WARNING - OLD ARCHIVES

This is an archived copy of the Xen.org mailing list, which we have preserved to ensure that existing links to archives are not broken. The live archive, which contains the latest emails, can be found at http://lists.xen.org/
   
 
 
Xen 
 
Home Products Support Community News
 
   
 

xen-users

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

To: <tlviewer@xxxxxxxxx>, <xen-users@xxxxxxxxxxxxxxxxxxx>
Subject: Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU
From: <s3t@xxxxxxxxxx>
Date: Sat, 23 Oct 2010 21:03:09 +0200
Cc:
Delivery-date: Sat, 23 Oct 2010 12:04:26 -0700
Envelope-to: www-data@xxxxxxxxxxxxxxxxxxx
In-reply-to: <654247.79828.qm@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
List-help: <mailto:xen-users-request@lists.xensource.com?subject=help>
List-id: Xen user discussion <xen-users.lists.xensource.com>
List-post: <mailto:xen-users@lists.xensource.com>
List-subscribe: <http://lists.xensource.com/mailman/listinfo/xen-users>, <mailto:xen-users-request@lists.xensource.com?subject=subscribe>
List-unsubscribe: <http://lists.xensource.com/mailman/listinfo/xen-users>, <mailto:xen-users-request@lists.xensource.com?subject=unsubscribe>
References: <654247.79828.qm@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
Sender: xen-users-bounces@xxxxxxxxxxxxxxxxxxx
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