From: Döhr, Markus ICC-H (Markus.Doehrsiegenia-aubi.com)
Date: Thu Apr 15 2004 - 11:49:54 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

> > > 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: markus.doehrsiegenia-aubi.com
Internet: http://www.siegenia-aubi.com
  

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]