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

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

Emmanuel,

I get what has happenned...

The thing is that I am doing only SELECT commands, nor transactional
comands, and SELECT commands are not saved in recovery log.

Do you know how can I know the time spent in this SELECT commands...

It seems that some commands get stuck a take more that 2 segs to answer,
when we are doing LoadTests....

Toni.


2009/5/29, Toni Menendez Lopez <ton...@gm...>:
>
> No way master,
>
> localhost:1090 > admin cdpdb
> Virtual database Administrator Login > admin
> Virtual database Administrator Password >
> Ready to administrate virtual database cdpdb
> cdpdb(admin) > debug on
> Debug mode on
>
> Now I execute some commands !!!!
>
> cdpdb(admin) > dump recoverylog
> Recovery Log is empty
>
>
> 2009/5/29, Emmanuel Cecchet <ma...@fr...>:
>>
>> Toni,
>>
>> When you start the Sequoia admin console, use 'admin myvdb' with your
>> login and password and then use 'debug on'. You will be able to use the
>> 'dump recoverylog' command of the console.
>>
>> Let me know if you can't get it working.
>> Emmanuel
>>
>> >
>> > Where I have to setup the DEBUG ?
>> >
>> > Now I have the table empty :
>> >
>> > mysql> select * from cdpdb_logtable;
>> > Empty set (0.00 sec)
>> >
>> >
>> > 2009/5/29, Emmanuel Cecchet <ma...@fr...
>> > <mailto:ma...@fr...>>:
>> >
>> >     Toni,
>> >     > I am not able to get the recovery logs, I have done this in the
>> >     > log4j.properties :
>> >     The recovery log is stored in a database that you configure in your
>> >     virtual database configuration file. You can directly look at the
>> >     content of the table by connecting to the database or use the
>> Sequoia
>> >     admin console using the 'dump recoverylog' command (note that you
>> have
>> >     to set the debug mode to on first).
>> >
>> >     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
>>
>
>