Hi,
we're currently having strange performance problems with sapdb 7.3.0.48
on linux.
The amount of vserver processes is about 100 and this leads to
unacceptable response times to our application.
During the lunch time (12.00-13.00) this number decreases to 20-30 (and
then we have acceptable performance).
It seems like the database cannot handle the heavy traffic with
acceptable performance, so we don't know how to get the performance
boost.....
The dbm-gui activity overview shows a high number of table locks (my
thought that this is high).
The lock section of this overview:
Available entries: 21150
maximum: 1650
average: 5
Row locks: 38359
Table locks: 27046
lock collisions: 140
I think the number of entries cannot be the problem, is there a
parameter to adjust, so that we can avoid generating unnecessary table
locks caused by this lock collisions...?
the environment:
Data cache: 1.8GB => 100% hit rate
converter cache: 100% hit rate
catalog cache: 91,46% hit rate
=> cache cannot be the bottleneck, ...?!?
Connections to the database are established from a apache module. Each
request from a customer is handled by a apache process, which itself
connects to the database, and after all work is done the connection is
closed.
the execution time of the sql-statements fired to the database looks
good (98% of them has exec.time < 1 sec.)
My thoughts are that probably the amount of requests could lead to our
performance problems. Currently we have about 20 requests per second,
and each request produces several sql statements.
any hint/help appreciated
--GERD--
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
