SQWareProduction:mysql:etc:sqwmys CreInst Jobs.cfg

From Wiki_dbSQWare
Revision as of 17:33, 5 April 2014 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

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>


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:mysql:etc:sqwmys_CreInst_Jobs.cfg&oldid=4129"