MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:<sinisa Date:August 19 1999 2:01pm
Subject:drive performance
View as plain text  
Tiberio, David writes:
 > I want to get maximum performance from mysql, and am building a dedicated
 > machine
 > 
 > I have an extra dual pentium II 300, with 128mb RAM and UW-SCSI2 and UDMA
 > drives
 > running linux 2.2.6
 > 
 > I realize I need more RAM and will get more, however my main concerns are:
 > 
 > 1. does mysql perform much better on a dual processor machine as 
 > compared to a single 300mhz processor machine? I do have SMP running
 > but my recent benchmark tests did not show improvement
 > 

I am now logged to one extremely heavy loades  dual processor machine
and I do assure you that difference is very well recognized.

Do take more memory, much more memory.
x

 > 2. is there an easy way to arrange my drives for max performance? can it be
 > done automatically?
 > 

There is only one way. Make them into RAID 1+0. That is a fastest
way. Buy smaller drives but make it into 1+0.

Sinisa

+----------------------------------------------------------------------+
| TcX  ____  __     _____   _____  ___     ==  mysql@stripped            |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sinisa Milivojevic          |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     mailto:sinisa@stripped|
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Larnaka, Cyprus             |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                             |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                            |
|             /*/             \*\                Developers Team       |
+----------------------------------------------------------------------+


Thread
drive performanceDavid Tiberio18 Aug
  • Re: drive performanceaaron abelard18 Aug
  • drive performancesinisa19 Aug
  • drive performanceMichael Widenius23 Aug