Various debugging options (see below) are easy to turn on in [source:/trunk/server/php/reporter.php the reporter], but are cumbersome to turn off because one needs to find them buried in the mile-long query string to manually change them.

{{{

!php

        "sql"            => "SQL",
        "cgi"            => "Display input selections",
        "stats"          => "Display query statistics",
        'debug'          => "Debug",
        'explain'        => 'Use EXPLAIN',
        'analyze'        => 'Use ANALYZE',
        'no_cache'       => 'Turn off SQL caching',
        'no_cookies'     => 'Turn off cookies',
        'dynamic_view'   => 'Create the SQL VIEW dynamically',
        'use_speedy'     => 'SELECT only FROM "speedy" TABLEs',
        'use_archive'    => 'SELECT only FROM "archive" TABLEs',

}}}

open-mpi / mtt

Add debugging options to the web interface #234

!php