Not 100% what you are looking for but there is a session about MaxDB performance optimization next week: http://www.mysql.de/news-and-events/web-seminars/maxdb-performance.php
And there is also documentation online that may help you http://dev.mysql.com/tech-resources/articles/maxdb-performance-primer.html Kind regards robert 2006/4/12, Gerd König <[EMAIL PROTECTED]>: > 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] > > -- Have a look: http://www.flickr.com/photos/fussel-foto/ -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
