Bad performance of MySQL on Sun Solaris machine
Posted on 2009-04-18
I've got a problem with my new X4150 Server. This Server I use to run a MySQL Database, but the server has a poor performance, if I compare it to other systems I own.
The X4150 Server is a 2x X5460 (8x 3.16 GHz) System with 8GB RAM, the MySQL Data is on a 3 Drives RaidZ Pool. I use Solaris 10 and mysql 5.1.33.
My reference System is a noname Intel Dual Core @ 2.40GHz with 4GB RAM running gentoo linux. On that system I use mysql 5.0.60.
For my test I have two tables, one has 2k entries and the other 23k. I try to connect the two tables (no indexes for extra load), with a left join (SELECT * FROM `Artikelbeschreibungen 0_6004` besch left join unimet uni on besch.ArtNr = uni.ArtNr order by besch.ArtNr;).
On the X4150 the Query takes about 8min, on the other sys about 4min. So how can I improve the performance of the Solaris system?