On 11 Mar 2009, at 06:23, kristian wrote:
> when I had a look in the pool implementation of the connection, I > really missed quite a few options I am used to see for these kind of > connections pooling: > * minimum/maximum pool size, I agree that this option should be easier to set. Right now the only way is overriding a method that returns the number of pooled connections. > * test query for testing the connection, mysql_ping is used to test whether the connection is alive / needs to reconnect. If this fails it can't reconnect automatically. > * none-blocking connection retrieval (the blocking retrieval caused > already deadlocks with me). How would it be non-blocking? Return nil for example when nothing is available would create really annoying problems in the calling code that needs to be able to handle these cases. > I do not know how to reproduce the error BUT the frequency is NOT > acceptable for production. Well, if connections even drop during an active query, it would seems something way more serious is the problem. This would also mean that for example transactions could go wrong etc. I'm more on the fail early side here, so personally I'd try to isolate the exact problem and for example check whether a local setup experiences the same issues. > if I can help somehow please let me know, any hints are welcome. if > you want to see the pool patches I happy to contribute them. but if > things remains like they are right now I go back to my above > workaround (after fixing the conncetion leak ;-) I'd love to see how you solved the issues you mentioned here and to possibly add them to extlib if they good fixes. -- Regards, Dirkjan --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DataMapper" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/datamapper?hl=en -~----------~----~----~----~------~----~------~--~---
