Recently we upgraded the following and found out that MySQL store procedure takes more than 40 times longer to run:
- Hardware T5120
- Solaris 10_u4 8/7
- MySQL 5.1.30
- Primary service domain has 8 ldoms, primary has 4 cpus and 2G mem
- Ldom mgr 1.0.3
- Database server sits on LDOM2 with 12 vcpus and 8G mem, two image file disk export from primary, basically the whole 2nd disk raid 1 for LDOM2, one 15G for OS and other 100G for database
- Store procedure only takes 0.87 seconds to finish
- everything is same as above, except I patched the primary to kernel patch 142900-02, then the mysql store procedure in LDOM2 takes about 35 seconds to finish
I have tried all different kind of combinations, from the above configuration I think there might be some kernel parameters settings changed since the upgrade but not sure what are they. If any one know or has some kind issues please let me know. Any help would be appreciated.
I actually did downloaded the newest Solaris 10u9 and install on primary with new ldom 2.0 and performance still not close to 0.87 seconds, but improve to 13 seconds from 35 seconds.
I still think there something which I can not find messed up.