> > > 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.
To find our reasons I would try to find out if it's I/O-relatet or what's the reason for it. If you have such situation try # x_cons <DBNAME> show active 1 This will show you the active threads and their states (I/O wait, Vwait etc.). Then you could eventually see, if there are locks hold, I/O-bottlenecks etc. The other tool is the dbanalyzer. It will give you some hints where to look at and what to change. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus D�hr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
