[mapguide-users] bad performance with mysql or sql server

[Bruce Dechant]

The connections are not closed because the MapGuide server is caching them for performance. As a temporary workaround you can do the following, but this will cause a performance impact because the MySQL connections will no longer be cached.

 

Edit the serverconfig.ini file and add the MySQL provider to the list of excluded providers. (See below)

 

DataConnectionPoolExcludedProviders= OSGeo.SDF,OSGeo.SHP,OSGeo.MySQL

 

Bruce

 

  _____  

From: ARQUICAD-MATIAS [mailto:massigoge at arquicad.com] 
Sent: October 20, 2006 11:47 AM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] bad performance with mysql or sql server

 

I'm having problems with MySQL FDO Provider. The MapGuide OS 1.0.2 never close connections to MySQL  so the it reach the maximun connection number and the FDO stop working.

The DataConnectionTimeout in serverconfig.ini is set to 600 seconds but it doesn't work. 
Thanks. 

Matías Massigoge 
Ingeniero de Aplicación 
Departamento Infraestructura 
Arquicad SRL 
Tel (011)4811-1733/15-6204-7686 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide_users/attachments/20061023/c24932cd/attachment.html