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 <[email protected]>: > > 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 <[email protected]>: >> >> 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 <[email protected] >> > <mailto:[email protected]>>: >> > >> > 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: [email protected] >> Skype: emmanuel_cecchet >> >> _______________________________________________ >> Sequoia mailing list >> [email protected] >> http://forge.continuent.org/mailman/listinfo/sequoia >> > >
_______________________________________________ Sequoia mailing list [email protected] http://forge.continuent.org/mailman/listinfo/sequoia
