---
title: "Configuration"
manual: "MySQL Report"
version: "main"
source: "Configuration/Index.rst"
rendered: "2026-10-10T23:42:57+00:00"
---

# Configuration {#configuration}

## Extension Settings {#extension-settings}

Head over to the **Admin Tools > Settings** module of TYPO3 in the left menu of the TYPO3 backend
and choose **Configure Extensions**. Open the accordion for `mysqlreport`.

### enableFrontendLogging {#conf-enable-frontend-logging}

Activate logging for frontend requests.

`mysqlreport` will collect the queries with their execution times and
query type (SELECT/INSERT/UPDATE/DELETE).

### enableBackendLogging {#conf-enable-backend-logging}

Activate logging for backend requests.

`mysqlreport` will collect the queries with their execution times and
query type (SELECT/INSERT/UPDATE/DELETE).

### activateExplainQuery {#conf-activate-explain-query}

`mysqlreport` executes each query again
with a prefixed `EXPLAIN` to retrieve detailed index and performance
information. You will see this additional information in the backend module
of `mysqlreport` in section **Profiling** in the detail view of a selected query.

> [!NOTE]
> If this feature is activated it can slow down your TYPO3 system a lot.
> Please keep that in mind and activate that option for a few minutes or
> hours, but not days or weeks. The additional data can grow very fast
> and can exceed your DB storage very fast. A size of over 6 GB is not
> uncommon!

### slowQueryThreshold {#conf-slow-query-threshold}

`mysqlreport` cannot read the original queries from the Slow Query Log of your
server. However, as we already collect the duration of all queries, we can
show the first 100 queries with a duration higher than the configured value
here (default: 10.0 seconds).

If you want to see queries slower than `slowQueryThreshold`, you must activate one
of the logging options above (`enableFrontendLogging` or `enableBackendLogging`).