stefanfroemken/mysqlreport

Analyze and profile your TYPO3 databases queries

4.0.1 2024-08-09 01:33 UTC

Requires

• doctrine/sql-formatter: ^1.1
• typo3/cms-backend: ^13.2
• typo3/cms-core: ^13.2
• typo3/cms-extbase: ^13.2
• typo3/cms-fluid: ^13.2

Requires (Dev)

• ergebnis/composer-normalize: ~2.42.0
• friendsofphp/php-cs-fixer: ^3.52
• phpstan/phpstan: ^1.10
• phpunit/phpunit: ^11.0.3
• typo3/cms-dashboard: ^13.2
• typo3/cms-install: ^13.2
• typo3/cms-reports: ^13.2
• typo3/testing-framework: dev-main

Suggests

• typo3/cms-dashboard: MySQL Report comes with some pretty cool widgets for TYPO3 Dashboard.

Replaces

• typo3-ter/mysqlreport: 4.0.1

GPL-2.0-or-later

• Stefan Froemken

• mysql
• profiling
• report
• typo3
• mariadb
• TYPO3 CMS
• mysqlreport

README

With mysqlreport you can analyze and profile all SQL queries created by ConnectionPool and Doctrine QueryBuilder.

After installation, you should visit the extension configuration in extension manager. Here you can activate logging for FE and/or BE queries. With an additional checkbox you can activate on-detail profiling for each query. Be careful with this last checkbox. It may slow down your system drastically.

After saving extension configuration you will find a new TYPO3 module in Backend. Switch between the different reports via selecting them with selectbox at top.

Happy reading and analyzing

Please deactivate logging after analyzing. Else you will flood your database with a really huge amount of analyzing data. I have added you a new entry in Clear-Cache menu to truncate all profiling data.

Sponsors

Big THX goes to Blackfire.io