रवींदर *ाकुर (ravinder thakur) wrote:
> Things do work with single connection. However as soon as i increase
> it, they stop working. Apparently this is due to the small lockout
> time for transaction in mysql (TransactionDeadLockDetectionTimeOut ).
> but i am not able to find out any way to increase it (i cannot even
> find out config.ini that people are talking about on net ) :(
As I have understood, the config.ini is used by mysql when setting up a
cluster environment and don't seem to be a default config file, so it has to
be created by the user manually.
http://dev.mysql.com/doc/refman/5.0/...nfig-file.html
I would urge you to look if you can't make your application to only use one
connection, at work we had an application that used quite many threads and a
new connection with each thread, and of course sooner or later it always run
out of connections and failed badly, requiring a restart (there was other bugs
too). I believe you will win on the long run, if you can reuse connections.
--
//Aho