watch out, "running 10 hours" != "idling 10 seconds" and trying again. Those are different cases.
It is not dropping *used* connections (good to know it works that good, thanks for reporting!), just not reusing connections more than 10 seconds idle On Fri, Sep 2, 2011 at 10:26 PM, Gora Mohanty <g...@mimirtech.com> wrote: > On Sat, Sep 3, 2011 at 1:38 AM, Shawn Heisey <s...@elyograg.org> wrote: > [...] >> I use DIH with MySQL. When things are going well, a full rebuild will leave >> connections open and active for over two hours. This is the case with >> 1.4.0, 1.4.1, 3.1.0, and 3.2.0. Due to some kind of problem on the database >> server, last night I had a rebuild going for more than 11 hours with no >> problems, verified from the processlist on the server. > > Will second that. Have had DIH connections open to both > mysql, and MS-SQL for 8-10h. Dropped connections could > be traced to network issues, or some other exception. > > Regards, > Gora >
