Summary: We are using SAP DB 7.4.3, are unhappy with its performance, and would greatly appreciate any hints and help leading to a better configuration.
We have a SAP DB 7.4.3 database on Debian Linux, accessed by a Java web application in a cluster setup. The database is running on a 4 x 2.5Ghz Xeon machine with 2 GB RAM and separate disks for log volume, data volume and os / db.
falk, just a few comments from my point of view
load (average:) of the run queue or load (user%) of the CPUs?The problem is, we are not quite happy with the performance of our setup yet. When a not-too-high number of users tries to access the application, the database comes under load pretty quickly (as measured by the Unix "top" command), and normally fast queries start to take several seconds.
-> 800MB Cache, you should double the chache size on a 2GB machineOur current configuration parameters are: . CACHE_SIZE = 100000
The data and log volumes are plain files (not raw devices) sitting on anassure data journals on ext3 are disabled
ext3 (journaled) file system.
Henrik
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
