djpriceAtl
asked on
Solaris 10 Admin & MySQL
I have a new Solaris 10 X86 server with a 2.8 GHz quad core processor and 10 GB memory that is having performance problems running MySQL. Java JDBC queries are slower than the old legacy Solaris 9 server. The new server CPU does not drop below 99% idle so this appears from what I have read a problem with resources. The disks are 15K RPM SAS drives that do not appear accessed much at all. In Solaris 9, I would adjust kernel resources in /etc/system, however, this appears to have changed in Solaris 10 to utilize projects? It looks like some OS resource is holding back MySQL.
Has anyone tuned Solaris 10 for MySQL using the new method and might have a guide to go by. I would imagine kernel entries should match the my.cnf INNODB settings to get full performance from the OS. Any help or suggestings would be appreciated.
Has anyone tuned Solaris 10 for MySQL using the new method and might have a guide to go by. I would imagine kernel entries should match the my.cnf INNODB settings to get full performance from the OS. Any help or suggestings would be appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://developers.sun.com/solaris/articles/mysql_perf_tune.html