Re: [Sequoiadb-discuss] [Sequoia] Problems with sequoia in Loadtests

[Toni M. L. <ton...@gm...>]

Emmanuel,

I am not able to get the recovery logs, I have done this in the
log4j.properties :

log4j.logger.org.continuent.sequoia.controller.recoverylog=INFO,
Console,Filetrace
log4j.additivity.org.continuent.sequoia.controller.recoverylog=true

Where :

# Filetrace is used for Sequoia log files, this appender is removed from the
log4j system
# if the parameter setFileLogging is set to false in the controller xml
configuration file.
log4j.appender.Filetrace=org.apache.log4j.RollingFileAppender
log4j.appender.Filetrace.File=${sequoia.log}/full_cluster.log
log4j.appender.Filetrace.MaxFileSize=10MB
log4j.appender.Filetrace.MaxBackupIndex=5
log4j.appender.Filetrace.layout=org.apache.log4j.PatternLayout
log4j.appender.Filetrace.layout.ConversionPattern=%d %-5p %c{3} %m\n
log4j.appender.Filetrace.immediateFlush=true

But I am not able to get any info related to recovery log.

Is it needed any special config ?



2009/5/29, Emmanuel Cecchet <ma...@fr...>:
>
> Hi Toni,
>
> The Sequoia mailing list has moved to
> seq...@li....
> > We are doing LoadTests of our product which is based in Sequoia +
> > mysql with 2 BE´s.
> >
> > And the thing is that some SQL comands get stuck from time to time
> > spending more that 1seg to answer, I have donr a trace in MYSQL and
> > response in MYSQL is quite quickly ( 1mseg ). So, I suspect that we
> > have some problems in sequoia.
> >
> > Is there any possiblity to traduce the messages from a TCPDUMP, in
> > order to see when sequoia response the the SQL sent from hibernate ?
> >
> > We are working with jboss-4.0.3SP1, sequoia-2.10.10 and mysql 4.1.20
> > in a RHEL environment !
> The delays you are observing might be due to retransmissions in the
> group communication. Are you using JGroups?
>
> To sample the request arrival time, you can activate the following in
> log4j.properties:
> # To trace requests #
>
> log4j.logger.org.continuent.sequoia.controller.virtualdatabase.request=INFO,
> Requests
> # To trace distributed requests #
>
> log4j.logger.org.continuent.sequoia.controller.distributedvirtualdatabase.request=INFO,
> DistributedRequests
>
> This will give you the request arrival time at each controller (look for
> the results in log/request.log and log/distributed_request.log).
>
> For the request response time, the write request response times are
> logged in the recovery log. You can also use the SQLMonitoring element
> in your virtual database configuration file (look for more info in
> sequoia.dtd) to profile request execution time.
>
> Hope this helps,
> Emmanuel
>
> --
> Emmanuel Cecchet
> FTO @ Frog Thinker
> Open Source Development & Consulting
> --
> Web: http://www.frogthinker.org
> email: ma...@fr...
> Skype: emmanuel_cecchet
>
> _______________________________________________
> Sequoia mailing list
> Se...@li...
> http://forge.continuent.org/mailman/listinfo/sequoia
>