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

[Mark Pryor <tlviewer@xxxxxxxxx>]

--- 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