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

[<s3t@xxxxxxxxxx>]

i try change vcpus = '4' ,just in case. 
also i try change patition to image and change config from phy to file on root device.
  
mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND());
Query OK, 1 row affected (0.17 sec)

mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND());
Query OK, 1 row affected (0.15 sec)

mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND());
Query OK, 1 row affected (0.15 sec)

mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND());
Query OK, 1 row affected (0.15 sec)

mysql> INSERT INTO __test (name, value) VALUES(RAND(), RAND());
Query OK, 1 row affected (0.17 sec)

i think poblem maybe is on dom0, some delay in communication between domU and dom0.
what about your results from mysql  insert on your domU? 


______________________________________________________________
> Od: viaum@xxxxxxxxxxxxxxx
> Komu: <xen-users@xxxxxxxxxxxxxxxxxxx>
> Datum: 23.10.2010 18:02
> Předmět: RE: [Xen-users] xen4 on debian squeeze, slow mysql in domU
>
> > > >> >> On Sat, 23 Oct 2010 11:47:42 -0400 <jeff.sturm@xxxxxxxxxx> wrote:
> 
> > vcpus       = '8'
> 
> How many physical cores do you have?  Don't set vcpus larger than the number of cores available in your dom0.
> 
> -Jeff
> 

Indeed you are right Jeff, the OP mentioned he was using an Intel Xeon E5520 [1] CPU.

# of Cores	4
# of Threads	8

Which leads me to believe the system is using hyperthreading on each of the 4 cores.

Unfortunatley I do not have hardware (Xeon CPU) to test for similar results.


[1] - http://ark.intel.com/Product.aspx?id=40200


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