[logback-user] Number of logs

[Greg Flex]

I didn't "touch" the configuration of MySQL at all. I assume it's the
normal/standard configuration that comes with it.....
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
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.
If writting too fast (too many records at once) to the database (both MySQL
and HSQLDB) they simply "choke"....
I don't know however if this is the problem; just my observations.....
 Do you think this might cause it?
Greg.



On Tue, Sep 23, 2008 at 12:00 AM, Thorbjørn Ravn Andersen
<ravn at runjva.com>wrote:

> Greg Flex skrev:
> > I've also noticed that when running the code with the config file I
> > sent you, and writting to MySQL database, the system seems to loose
> > connection after writting about 3900 logs. I can't connect to a
> > database anymore with myPHPAdmin. (for about 10 to 15 seconds, after
> > that all is restored) The program doesn't execute anymore but
> > something is locking the DB connection...
> > Here is another observation.....
> > When running second, immediately after the first run and writting to
> > an HSQLDB nothing get written.
> > I still have to wait for about 10 to 15 seconds (for the first run to
> > finish or something) then run it again.....
> > Hope thisi nfo will help  ...
> What is the configuration of the MySQL box?  It sounds to me as MySQL
> allocates more memory than is available and that it is basically
> swapping to death.
>
> Do you close your HSQLDB connection properly?
>
> --
>  Thorbjørn
>  _______________________________________________
> Logback-user mailing list
> Logback-user at qos.ch
> http://qos.ch/mailman/listinfo/logback-user
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://qos.ch/pipermail/logback-user/attachments/20080923/3db52207/attachment-0001.htm