[logback-user] Number of logs

[Greg Flex]

ok guys,
I figured this out. It works beatifully now!
All I had to do is download (per instructions on the logback website) the
c3po pooling library
and modify the appender's xml file to:

<appender name="DB" class="ch.qos.logback.classic.db.DBAppender">
    <connectionSource
class="ch.qos.logback.core.db.DataSourceConnectionSource">
      <dataSource class="com.mchange.v2.c3p0.ComboPooledDataSource">
         <driverClass>com.mysql.jdbc.Driver</driverClass>
          <jdbcUrl>jdbc:mysql://localhost:3306/Greg</jdbcUrl>
         <user>greg</user>
         <password>greg</password>
      </dataSource>
    </connectionSource>
  </appender>

In my case the database name is: Greg, password and username: greg
It works great and it is in fact very fast now. I just loaded it with 50,000
records without any problems whatsoever.
I guess is safe to say  "read the documentation first man...!"  :-)
Cheers,
Greg



On Tue, Sep 23, 2008 at 9:38 AM, Greg Flex <greg.flex at gmail.com> wrote:

>  Ok no problem.
> I'm running the program and the database on just one computer.
> It's all local and no one is connecting to it....
> It's a Xeon 2.66 GHz machine with 4 cores and 3GB of ram.
> I'm running Windows XP. (the newest service pack)
> I'm looking at the Task Manager right now and I see that over 2GB of memory
> is available.
> I just ran my program again but this time I've reduced the Thread.sleep to
> just 10ms.
> Instead of 40,000 records just about 8,000 got written.
> This means 10-ms is too fast and MySQL can't handle it or something.
> I'm not sure but from the documentation on line looks like the connection
> pooling is the way out...
> I don't know and I guess I don't understand that well the notion of
> "connection pooling" so I don't know
> how to set it up/create one.
> Any suggestions?
> Thanks a lot
> Greg.
>
>
>
>
> On Tue, Sep 23, 2008 at 9:06 AM, Thorbjørn Ravn Andersen <ravn at runjva.com>wrote:
>
>> Greg Flex skrev:
>> > 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.
>> I am not thinking of the configuration of the database software as such
>> but of the configuration of the computer which runs the database software.
>>
>> I suspect that you have less physical memory available to the database
>> than they think they can use, hence the operating system starts swapping
>> which kills performance.
>>
>> Can you please describe your setup in detail so we can replicate the
>> scenario?  I.e. number of computers involved, connections between them,
>> network performance, memory assigned, operating systems used, etc.
>>
>> /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/54e8ef1d/attachment.htm