RE: How to tune for better performance?

Hi Jarle

> -----Original Message-----
> From: Jarle Aase [mailto:jgaa@xxxxxxxx]
> Sent: Montag, 21. März 2005 04:54
> To: maxdb@xxxxxxxxxxxxxxx
> Subject: How to tune for better performance?
> 
> 
> Hi list,
> 
> I've looked at maxdb, and it looks pretty sexy ;) I am however not
> getting the performance I expected.

[details snipped]

> The test-machine is a P4 3GHz machine with 1G RAM and a 320GB ATA disk
> running Debian GNU/Linux "testing" and Linux kernel 2.6.8 with support
> for hyperthreading. The database has 4 x 500 GB raw devices + 1 60 GB
> raw device for the log (maxdb refused to accept one 200 GB 
> raw device).

If 4 x 500 is a typo and you mean 4 x 50 (what would meet the 200 mentioned):

Do I understand right, that the machine has a single hard disk?

Maybe not so crucial for your described load process, but separating
data volumnes from log volumes is an important performance issue.

Another point is, only count the physical CPU cores for the MAXCPU parameter
of MaxDB.


Regards  Thomas


----------------------------------------------
Dr. Thomas Kötter
SAP AG, Berlin
NW DT MaxDB

MaxDB: all you need!                   
www.mysql.com/products/maxdb  www.sapdb.org 


 







--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx