AFAIK MySQL is in release 5.5.x. Are you using the Community or Enterprise release?
In each case are you using ZFS? How have you setyp the virtual disk for LDOM? What (meta)devices LDOM root on? ----- Original Message ----- From: [email protected] <[email protected]> To: [email protected] <[email protected]> Sent: Mon Feb 07 17:48:13 2011 Subject: [ldoms-discuss] MySQL store procedure running slow in LDOM environment Hi, We have MySQL store procedure basically doing deleting tables and insert. The same procedure runs about 0.86 seconds in stand alone server (w/o any virtualization). However this same store procedure runs over 10 seconds in ldom environment. Here is the configuration: - Solaris 10 (10/09 s10s_u8wos Sparc) on primary and guest ldom - primary controller runs ldom mgr 1.3 - Guest ldom same version of solaris 10 as primary the guest ldom has both OS and MySQL database 5.8. I export virtual disk as full disk from primary to guest ldom. I had older version of solaris 10 (8/7 so10s_u4wos) and older ldom mgr 1.0.3, same setup as above the store procedure only takes under 1 seconds. Seems like to me right now is way how to export the virtual disk that makes different how long does the store procedure take to finish execute. Any one has the same issue before or how to fix this issue. thanks! -- This message posted from opensolaris.org _______________________________________________ ldoms-discuss mailing list [email protected] http://mail.opensolaris.org/mailman/listinfo/ldoms-discuss _______________________________________________ ldoms-discuss mailing list [email protected] http://mail.opensolaris.org/mailman/listinfo/ldoms-discuss
