<div dir="ltr"><div>I didn't "touch" the configuration of MySQL at all. I assume it's the normal/standard configuration that comes with it.....</div>
<div>I ran the program again for some time last night. I wrote one log.xxx then paused the thread for about 100ms then wrote another log.xxx</div>
<div>I managed to write 39,000 logs to MySQL without any problems. It looks to me then that the "speed" has something to do here.</div>
<div>If writting too fast (too many records at once) to the database (both MySQL and HSQLDB) they simply "choke"....<br>I don't know however if this is the problem; just my observations.....</div>
<div> Do you think this might cause it?</div>
<div>Greg.</div>
<div> </div>
<div><br> </div>
<div class="gmail_quote">On Tue, Sep 23, 2008 at 12:00 AM, Thorbjørn Ravn Andersen <span dir="ltr"><<a href="mailto:ravn@runjva.com">ravn@runjva.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Greg Flex skrev:<br>
<div class="Ih2E3d">> I've also noticed that when running the code with the config file I<br>> sent you, and writting to MySQL database, the system seems to loose<br>> connection after writting about 3900 logs. I can't connect to a<br>
> database anymore with myPHPAdmin. (for about 10 to 15 seconds, after<br>> that all is restored) The program doesn't execute anymore but<br>> something is locking the DB connection...<br>> Here is another observation.....<br>
> When running second, immediately after the first run and writting to<br>> an HSQLDB nothing get written.<br>> I still have to wait for about 10 to 15 seconds (for the first run to<br>> finish or something) then run it again.....<br>
> Hope thisi nfo will help ...<br></div>What is the configuration of the MySQL box? It sounds to me as MySQL<br>allocates more memory than is available and that it is basically<br>swapping to death.<br><br>Do you close your HSQLDB connection properly?<br>
<br>--<br><font color="#888888"> Thorbjørn<br></font>
<div>
<div></div>
<div class="Wj3C7c">_______________________________________________<br>Logback-user mailing list<br>Logback-user@qos.ch<br><a href="http://qos.ch/mailman/listinfo/logback-user" target="_blank">http://qos.ch/mailman/listinfo/logback-user</a><br>
</div></div></blockquote></div><br></div>