Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
RE: Configuration for better Performance?
From: Döhr, Markus ICC-H (Markus.Doehrsiegenia-aubi.com)
Date: Thu Apr 15 2004 - 11:49:54 CDT
> > > 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,
The other tool is the dbanalyzer. It will give you some hints where to look
at and what to change.
Tel.: +49 6503 917-152
Fax: +49 6503 917-7152
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb