config.php.example

<?php
// Settings

// Change to a string for a customized title for this instance
$settings['title'] = null;

// Syntax highlight queries?
$settings['sqlColor'] = true;

// Sometime in the past, percona changed the format
// that slow queries dumped out
// This causes the tmp disk table/disk filesort
// fields to be named incorrectly. The old names were

// Disk_tmp_table_cnt Disk_tmp_table_sum
// Disk_filesort_cnt Disk_filesort_sum

// and the new names are

// Tmp_table_on_disk_cnt Tmp_table_on_disk_sum
// Filesort_on_disk_cnt Filesort_on_disk_sum

// You can use this setting to swap between the column names
$settings['oldSlowQueryFormat'] = false;

// What columns are visible by default
/*
$settings['defaultColumnVis']['Checksum']      = true;
$settings['defaultColumnVis']['Count']         = true;
$settings['defaultColumnVis']['TotalMS']       = true;
$settings['defaultColumnVis']['AvgMS']         = true;
$settings['defaultColumnVis']['tmpDisk']       = false;
$settings['defaultColumnVis']['tmpTbl']        = false;
$settings['defaultColumnVis']['FirstSeen']     = true;
$settings['defaultColumnVis']['LastSeen']      = true;
$settings['defaultColumnVis']['Fingerprint']   = true;
$settings['defaultColumnVis']['ReviewedOn']    = true;
$settings['defaultColumnVis']['ReviewedBy']    = true;
$settings['defaultColumnVis']['Comments']      = true;
*/

$reviewhost = array(
// Replace hostname and database in this setting
// use host=hostname;port=portnum if not the default port
    'dsn'           => 'mysql:host=hostname;port=3306;dbname=percona',
    'user'          => 'user',
    'password'      => 'password',
// See http://www.percona.com/doc/percona-toolkit/2.1/pt-query-digest.html#cmdoption-pt-query-digest--review
    'review_table'  => 'review',
// This table is optional. You don't need it, but you lose detailed stats
// Set to a blank string to disable
// See http://www.percona.com/doc/percona-toolkit/2.1/pt-query-digest.html#cmdoption-pt-query-digest--review-history
    'history_table' => 'review_history',
);

$explainhosts = array(
    'label1'   => array(
        'dsn'       => 'mysql:host=hostname1;port=3306',
        'user'      => 'user',
        'password'  => 'password',
    // By default we scan the host to see what databases we can run a
    // explain on. To disable this behavour, set an array here
        'databases' => array(
            'database1',
            'database2',
            'database4'
        ),
    ),
    'label2'   => array(
        'dsn'       => 'mysql:host=hostname2;port=3306',
        'user'      => 'user',
        'password'  => 'password',
    // You can also just set the field and keep it empty. We will scan for valid databases
        'databases' => array(),
    ),
    // ad nauseum...
);