SQWareProduction:mysql:etc:sqwmys GlobalVar.cfg

From Wiki_dbSQWare
Revision as of 19:36, 14 July 2010 by Exploit (talk | contribs) (Updated by Expdbtools)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Fichier de configuration $gvsqw_MysBin/../etc/sqwmys_GlobalVar.cfg:
Global var
Il contient les variables de fonctionnement de SQWareProduction.

gvsqw_ConnectDb =>  [par défaut: Enable
gvsqw_ConsistentInnoDb =>  [par défaut: "--single-transaction"
gvsqw_ConsistentOthers =>  [par défaut: "--lock-tables"
gvsqw_DumpNbGeneration =>  [par défaut: 2
gvsqw_EgrepIvFs =>  [par défaut: 'Filesystem|Disponible'
gvsqw_GzipLogsHisto =>  [par défaut: 7
gvsqw_Hostname =>  [par défaut: $(hostname|cut -d '.' -f1)
gvsqw_InitInstanceSourceCommand =>  [par défaut: '. ./.profile'
gvsqw_MailMsg_mysql =>  [par défaut: 'TrtMysAuto'
gvsqw_Mail_mysql =>  [par défaut: 'dba'
gvsqw_MysqlDumpOpt =>  [par défaut: '-S $gvsqw_MysqlSock -u $gvsqw_UserExec --create-options -f --max_allowed_packet=1000000000 --net_buffer_length=16M ${lfsqw_SqlOpt} -R -q --databases ${lvsqw_DbName}'
gvsqw_MysqlErrorMsg =>  [par défaut: "^ERROR|^FAILED"
gvsqw_MysqlSock =>  [par défaut: '$MYSQL_HOME/tmp/$MYSQL_SID.sock'
gvsqw_NbDaysFull =>  [par défaut: 7
gvsqw_NbThread =>  [par défaut: 2
gvsqw_NbThreadAnalyze =>  [par défaut: 2
gvsqw_NbThreadDump =>  [par défaut: 2
gvsqw_NbThreadOptimize =>  [par défaut: 2
gvsqw_RootAdmin =>  [par défaut: '$HOME/${MYSQL_SID}'
gvsqw_RootCfg =>  [par défaut: '$HOME/${MYSQL_SID}/edtConfig'
gvsqw_RootDbf =>  [par défaut: '/$(echo ${HOME}|cut -d/ -f2)/data/${MYSQL_SID}'
gvsqw_RootDump =>  [par défaut: '/$(echo ${HOME}|cut -d/ -f2)/mys_dump/$MYSQL_SID'
gvsqw_SuppArchAlert =>  [par défaut: 30
gvsqw_SuppArchSlow =>  [par défaut: 30
gvsqw_SuppLogsHisto =>  [par défaut: 30
  1. gvsqw_WebDbaDirSlowQuery => [par défaut: 'Directory to store SlowQuery files'
  2. gvsqw_WebDbaUserConn => [par défaut: 'Connection string ssh user@hostname'

[ -r $gvsqw_MysBin/../etc_cust/sqwmys_GlobalVar.cfg ] && . $gvsqw_MysBin/../etc_cust/sqwmys_GlobalVar.cfg [ -r $gvsqw_RootCfg/sqwmys_GlobalVar.cfg ] && . $gvsqw_RootCfg/sqwmys_GlobalVar.cfg

Note:
You can overload variables contain in $gvsqw_MysBin/../etc/sqwmys_GlobalVar.cfg

by the same variables in $gvsqw_MysBin/../etc_cust/sqwmys_GlobalVar.cfg for all your environnement
or in $HOME/sqwConfig/sqwmys_GlobalVar.cfg specifically for this user.


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