active sync very slow

I use idm version 5 and database is mysql . I found the problem bottle neck in mysql database . There are many corrupt.

How do i increase the performance of IDM .

this is the debug page form Show_JDBC.jsp

Global connection pool:

Pool version 1

233 connections created.

233 connections active.

0 connections in the pool.

1435 requests serviced from the pool.

0 connections became corrupt.

Connections:

jdbc:oracle:thin:@10.202.1.13:1521:rsdue2m,idm has 0 connections.

Private connection pool:

Pool version 1

606 connections created.

4 connections active.

4 connections in the pool.

285894 requests serviced from the pool.

598 connections became corrupt.

[769 byte] By [nicecya] at [2007-11-27 11:40:12]
# 1

I am using IdM 7.0.

Yet ActiveSync with MySQL is very slow. Same configuration with IdM repository on Oracle is much more faster. I believe MySql is no more supported for production environment starting from IdM7.1.

scripetoa at 2007-7-29 17:30:33 > top of Java-index,Web & Directory Servers,Directory Servers...
# 2

I think so.

If i cann't leave this problem. Do you have any idea for mysql parameter tuning like this case.

nicecya at 2007-7-29 17:30:33 > top of Java-index,Web & Directory Servers,Directory Servers...
# 3

I tried to use my-innoodb-heavy-4G.cnf configuration file for MySql5 but I am not yet satisfied. In my case activesync/MySql is very slow due to the heavy use I did of organizationMemberRules. If I disable those rules, then activesync is much more faster. activesync/Oracle is fast even with those rules enabled.

scripetoa at 2007-7-29 17:30:33 > top of Java-index,Web & Directory Servers,Directory Servers...
# 4

This MySQL issue may be involved.

http://bugs.mysql.com/bug.php?id=9021

R1100SLAa at 2007-7-29 17:30:33 > top of Java-index,Web & Directory Servers,Directory Servers...
# 5

Yest, I agree. Thanks for the reference, I will check for a fix.

scripetoa at 2007-7-29 17:30:33 > top of Java-index,Web & Directory Servers,Directory Servers...
# 6

While I too thought that for a long time, adding memory in the config and tunning up mysql a little it then it was blindingly fast. Out of the box, mysql is only provisioned but for the smallest of uses.

dmander2a at 2007-7-29 17:30:33 > top of Java-index,Web & Directory Servers,Directory Servers...
# 7

if we change the repository type from MySQL (JDBC) to MySQL (Datasource), will this help us a better IDM MySQL repository transaction performance ?

athikom-la at 2007-7-29 17:30:33 > top of Java-index,Web & Directory Servers,Directory Servers...