Modèle:SQWareProduction sqwmys GlobalVar.cfg explanation

Explication de variables:

#General variables
gvsqw_SqwVersion => SQWare Production version
gvsqw_MysqlSock => Path to MySQL sock file
gvsqw_SuppArchSlow => number of days to delete archives of slow query files
gvsqw_RootAdmin => admin directory
gvsqw_RootCfg => configuration directory
gvsqw_RootDbf => datafiles directory
gvsqw_NbThread => default number of thread for parallelism
gvsqw_MysqlErrorMsg => format of MySQL errors
gvsqw_DbaUser => User Dba
gvsqw_DistConnectString => XXXXX
gvsqw_GenExcludeDatabasesWhereClause => XXXXX
gvsqw_NbThreadCopyDump => XXXXX
gvsqw_NbThreadRestore => default number of thread for parallelism for restore
gvsqw_NbThreadCheck => default number of thread for parallelism for Checkstorage
gvsqw_NotMysqlErrorMsg => XXXXX
#To ignore mysqldump errors, example : gvsqw_NotMysqldumpErrorMsg="mysqldump: Error 1412" to ignore "mysqldump: Error 1412: Table definition has changed, please retry transaction when dumping table ..."
gvsqw_NotMysqldumpErrorMsg => XXXXX

#for indicators
gvsqw_GenExcludeDatabasesObjects => XXXXX
gvsqw_GenExcludeDatabasesObjectsExtra => XXXXX

#for Dump scripts
gvsqw_NbThreadDump => default number of thread for parallelism for mysqlDump
gvsqw_RootDump => default mysqlDump directory
gvsqw_DumpNbGeneration => default number generation of mysqlDump to keep online
gvsqw_ConsistentInnoDb => command to make mysqlDump consistent where engine = InnoDb
gvsqw_ConsistentOthers => command to make mysqlDump consistent where engine != InnoDb
gvsqw_MysqlDumpOpt => mysql Dump command
gvsqw_RootDumpSource => unLoad directory for source
gvsqw_ExcludeDatabasesCopy => XXXXX
gvsqw_DumpCompressorExt => XXXXX
gvsqw_DefCopyDumpNbGeneration => XXXXX
gvsqw_DropDb => XXXXX
gvsqw_CreateDb => XXXXX

#for XtraBackup scripts
gvsqw_RootXtraBackup => XXXXX
gvsqw_RootXtraBackupSource => XXXXX
gvsqw_XtraBackupNbGeneration => XXXXX
gvsqw_XtraBackupWaitTimeOut => XXXXX

#for MariaBackup scripts
gvsqw_RootMariaBackup => XXXXX
gvsqw_RootMariaBackupSource => XXXXX
gvsqw_MariaBackupNbGeneration => XXXXX
gvsqw_MariaBackupWaitTimeOut => XXXXX

#for rotate slowquery (put yes to no copy to webdba)
gvsqw_LocalSlowQuery => XXXXX

#for optimize scripts
gvsqw_NbThreadOptimize => default number of thread for parallelism for optimize

#for analyse scripts
gvsqw_NbThreadAnalyze => default number of thread for parallelism for analyse

##Globaly forcing return code for scripts
gvsqw_ForcedReturnCodeScript_sqwmys_DumpDatabase => To force return code of sqwmys_DumpDatabase.ksh
...

#for SQWare Web
gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web
gvsqw_WebDbaDirSlowQuery => Directory to store SlowQuery files on SQWare Web