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: s3t@xxxxxxxxxx
Subject: Re: [Xen-users] xen4 on debian squeeze, slow mysql in domU
From: Mark Pryor <tlviewer@xxxxxxxxx>
Date: Sat, 23 Oct 2010 11:04:24 -0700 (PDT)
Cc: xen-users@xxxxxxxxxxxxxxxxxxx
Delivery-date: Sat, 23 Oct 2010 11:05:48 -0700
Dkim-signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s1024; t=1287857064; bh=K/NRBQea8o1aPNXv/j8MAbdQPZNj0vUUDppR/OA7Zhs=; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=Ro/JJlQxA+hS4sw7pEYRZ1QZkAeAKSRya0Bgk+VR5u0PzsZiWUtQ/B/DPcDECz9KznSFRNTG8hpKM2xnTIRW77VAH0tvwKGee4OY3BkZK/vamjQWVe7FxxVMdoooC/jDOChfF/gqd3jrKOP2MV/jj8xVCclXyHrhx9kg+4Le+NM=
Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:X-YMail-OSG:Received:X-Mailer:Date:From:Subject:To:Cc:MIME-Version:Content-Type; b=DVjYl91+KVjR3JbpNzfRJyw0+Lw9ObhGZkRI5KPxmWHVyF1rP75+RJ6Jl73cdkVhWH/j9lDbJ/Kwq9cSg/2Tj3lSR+jjEIMgSxkSrAYX1G17JpN1I+KMC43oJ4SmkCDNxD4gLtlzH/Y53YcLCgv5F/mkW90uNHpyRJQnV9GLAew=;
Envelope-to: www-data@xxxxxxxxxxxxxxxxxxx
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>
Sender: xen-users-bounces@xxxxxxxxxxxxxxxxxxx
--- 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