|
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] 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
|
 |
Lists.xenproject.org is hosted with RackSpace, monitoring our |