|
xen-users
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
|
|
|
Home