Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


Solaris 10 update 8 upgrade slow mysql performance

Solaris 10 update 8 upgrade slow mysql performance

Solaris 10 update 8 upgrade slow mysql performance

Current Configuration:

- T5120 running Solaris 10 update 4 8/7 with LDOM 1.3
- T5120 has 4 146G disks and has raid 1 (1 & 2, 3 & 4)
- Primary has 4 VCPUs and 4G memory
- Primary control has 8 ldoms, 2nd ldom is database server
- database server has two virtual disks, 1st for OS and 2nd for database
- 2nd LDOM (database server) has 12 VCPUs and 8G memory
- MySQL server 5.5.8 Community Server (GPL), OS solaris 10 update 8
- MySQL server virtual disks are on disk 3 & 4 which are raid one

primray ldm configruation:

ldm add-vdsdev /ldomdb/ldom2 vol2@primary-vds0
ldm add-vdsdev /ldomdb/ldom2-db vol2a@primary-vds0

ldm add-vdisk vdisk2 vol2@primary-vds0 ldom2
ldm add-vdisk vdisk2a vol2a@primary-vds0 ldom2

My problem is once I upgrade the primary control ldom to solaris 10 update 8
then mysql store procedure performance reduced:

old: Primary Control Solaris 10 update 4 8/7, store procedure takes only 0.87 secs to finish
new: Primary Control solaris 10 update 8 10/09, store procedure takes about 45 secs to finish

Firmware on the system are current

Seems to me some paramaters on update 8 has changed, but I don't know how to find it out.
If any one know or how to trouble shoot this issue please let me know
Thanks for you help!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close