Product Knowledge Base

Space shortcuts

Page tree

Versions Compared

Old Version 5

changes.mady.by.user Uwe Risse

Saved on

compared with

New Version 6

changes.mady.by.user Uwe Risse

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Code Block
 prompt:~>./mysql --host=<host> --port=<port> --user=<user> -p scheduler_archive < scheduler_history.dmp

5.Optional drop the archived tables (DO NOT DROP SCHEDULER_VARIABLES!!!!!!!!!!!!!!!!!)Delete old records

Code Block
  prompt:~> ./mysql --host=<host> --port=<port> --user=<user> -p scheduler 
  mysql> dropdelete tablefrom SCHEDULER_HISTORY where start_time < '2012-01-01';
  mysql> dropdelete tablefrom SCHEDULER_ORDER_HISTORY where start_time < '2012-01-01';
  mysql> dropdelete tablefrom SCHEDULER_ORDER_STEP_HISTORY where start_time < '2012-01-01';
  mysql> exit

6.Recreate the tablesOptimize table

Code Block
  prompt:~> ./opt/sos-berlin/..../install/scheduler_install_tables.shmysql --host=<host> --port=<port> --user=<user> -p scheduler 
 mysql> OPTIMIZE TABLE SCHEDULER_HISTORY,SCHEDULER_ORDER_HISTORY,SCHEDULER_ORDER_STEP_HISTORY;
 mysql> exit

How to access logs from the archive by id

...