Template:SQWareProduction sqwmys GlobalVar.cfg explanation
Variables explanation:
#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
