Difference between revisions of "SQWareProduction:mysql:etc:sqwmys CreInst Jobs.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 9: | Line 9: | ||
IndicDba:$gvsqw_MysBin/sqwmys_GatherIndicators.ksh -I <MYSQL_SID> | IndicDba:$gvsqw_MysBin/sqwmys_GatherIndicators.ksh -I <MYSQL_SID> | ||
| − | #Dump: backup all databases with | + | #Dump: backup all databases with mysqlDump |
Dump:$gvsqw_MysBin/sqwmys_DumpAllDatabases.ksh -I <MYSQL_SID> -Exec | Dump:$gvsqw_MysBin/sqwmys_DumpAllDatabases.ksh -I <MYSQL_SID> -Exec | ||
Revision as of 18:33, 5 April 2014
Configuration file $gvsqw_MysBin/../etc/sqwmys_CreInst_Jobs.cfg:
File content:
#IndicDba: Gather DBAs indicators IndicDba:$gvsqw_MysBin/sqwmys_GatherIndicators.ksh -I <MYSQL_SID> #Dump: backup all databases with mysqlDump Dump:$gvsqw_MysBin/sqwmys_DumpAllDatabases.ksh -I <MYSQL_SID> -Exec #Optimize : optimize tables for all databases Optimize:$gvsqw_MysBin/sqwmys_OptimizeAllDatabases.ksh -I <MYSQL_SID> -Exec #Analyse : analyze tables for all databases Analyze:$gvsqw_MysBin/sqwmys_AnalyzeAllDatabases.ksh -I <MYSQL_SID> -Exec #SlowQuery: Rotate log slow query SlowQuery:$gvsqw_MysBin/sqwmys_RotateLogSlowQuery.ksh -I <MYSQL_SID> #PurgeAlert: Rotate error log PurgeAlert:$gvsqw_MysBin/sqwmys_PurgeAlert.ksh -I <MYSQL_SID>
