관리-도구

편집 파일: check_logfiles_innodbcounter.conf

# where the state information will be saved.
$seekfilesdir = '/tmp/check_logfiles';

$options = 'smartpostscript,logfilemissing=warning';

@searches = (
  {
    tag => 'mysqld',
    logfile => '/var/lib/mysql/mysqld-err.log',
    rotation => 'centos',
    criticalpatterns => [
        'Got error \d+ when reading table',
        'Table .* is marked as crashed and (last $automatic\?$ repair failed|should be repaired)',
        'Index for table .* is corrupt;'
    ],
    options => 'criticalthreshold=1000,logfilemissing=warning,noperfdata,allyoucaneat,noprotocol',
  },
);

# where scripts will be searched for.
$scriptpath = '/root/bin/check_innodb';

$postscript = 'check_innodb.pl';
$postscriptparams = '--file /var/lib/mysql/mysqld-err.log \
                     --threshold 20 \
                      --excludes-file /root/bin/check_innodb/excluded_tables.txt \
                      --previously-matched /root/bin/check_innodb/previously_matched.txt \
                      --write-previous'