MySQL Forums
Forum List  »  Performance

Mysql 5.0 Performing less in Solaris 8
Posted by: Prabhu MK
Date: July 18, 2007 03:44AM

Hi,

I have Mysql 5.0.45 installed in Solaris 8 and RHEL 4.

Its been found the Mysql performance in Solaris 8 is less compared to RHEL 4, though the hardware configuration in Solaris is better than Linux.

The tables in our database of type MyISAM.

During the performance test of our application, IOSTAT of Solaris 8 showed very high percentage of %b in the mysql partition.

r/s w/s kr/s kw/s wait actv wsvc_t asvc_t %w %b device
0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c0t0d0
0.2 83.4 0.0 393.2 0.0 0.5 0.0 6.3 0 50 c1t0d0
0.2 83.4 0.0 393.2 0.0 0.5 0.0 6.6 0 53 c1t1d0
0.2 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0 0 c1t2d0

Sometimes it went to 70%.

Is there any specific Mysql version I can try in for Solaris 8?
Any specific tuning have to be made for reducing the Disk IO.

Below is my Solaris 8 Hardware details.

System Configuration: Sun Microsystems sun4u Sun Fire V440
System clock frequency: 177 MHZ
Memory size: 4GB

==================================== CPUs ====================================
E$ CPU CPU Temperature Fan
CPU Freq Size Impl. Mask Die Ambient Speed Unit
--- -------- ---------- ------ ---- -------- -------- ----- ----
0 1062 MHz 1MB US-IIIi 2.4 - -
1 1062 MHz 1MB US-IIIi 2.4 - -


Thanks in Advance

Prabhu M.K

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql 5.0 Performing less in Solaris 8
2314
July 18, 2007 03:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.