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@xxxxxxxxx
> Komu: s3t@xxxxxxxxxx
> 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@xxxxxxxxxx <s3t@xxxxxxxxxx> wrote:
>
>> From: s3t@xxxxxxxxxx <s3t@xxxxxxxxxx>
>> Subject: Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU
>> To: tlviewer@xxxxxxxxx, xen-users@xxxxxxxxxxxxxxxxxxx
>> 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@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
>>
>
>
>
>

_______________________________________________
Xen-users mailing list
Xen-users@xxxxxxxxxxxxxxxxxxx
http://lists.xensource.com/xen-users

WARNING - OLD ARCHIVES

xen-users

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