Modèle:SQWareProduction sqwmys GlobalVar.cfg explanation : Différence entre versions
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Ligne 5 : | Ligne 5 : | ||
gvsqw_SqwVersion => SQWare Production version | gvsqw_SqwVersion => SQWare Production version | ||
gvsqw_MysqlSock => Path to MySQL sock file | gvsqw_MysqlSock => Path to MySQL sock file | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
gvsqw_SuppArchSlow => number of days to delete archives of slow query files | gvsqw_SuppArchSlow => number of days to delete archives of slow query files | ||
gvsqw_RootAdmin => admin directory | gvsqw_RootAdmin => admin directory | ||
gvsqw_RootCfg => configuration directory | gvsqw_RootCfg => configuration directory | ||
gvsqw_RootDbf => datafiles directory | gvsqw_RootDbf => datafiles directory | ||
| − | |||
gvsqw_NbThread => default number of thread for parallelism | gvsqw_NbThread => default number of thread for parallelism | ||
gvsqw_MysqlErrorMsg => format of MySQL errors | 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 | #for Dump scripts | ||
| Ligne 52 : | Ligne 32 : | ||
gvsqw_ConsistentOthers => command to make mysqlDump consistent where engine != InnoDb | gvsqw_ConsistentOthers => command to make mysqlDump consistent where engine != InnoDb | ||
gvsqw_MysqlDumpOpt => mysql Dump command | 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 | #for optimize scripts | ||
| Ligne 66 : | Ligne 65 : | ||
#for SQWare Web | #for SQWare Web | ||
| − | |||
gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web | gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web | ||
gvsqw_WebDbaDirSlowQuery => Directory to store SlowQuery files on SQWare Web | gvsqw_WebDbaDirSlowQuery => Directory to store SlowQuery files on SQWare Web | ||
</pre> | </pre> | ||
Version actuelle datée du 28 décembre 2021 à 16:24
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
