“”

MySQL Report MySQL Report

mysqlreport / stable

Analyze and profile your TYPO3 database queries

This version supports TYPO3

Older versions also support TYPO3

Composer support

composer req stefanfroemken/mysqlreport

Tags

#mysql #mariadb #database #Report #profile #sql #log #logging

Last upload comment

Log every exception into var/log
Make as much classes readonly as possible
Add some more tests
Add special param type casting for MySQL/MariaDB servers. Needed for quoting.

Downloads by month

Download 4.0.1 External Manual Found an Issue? Code Insights Packagist.org
Author
Stefan Froemken
Last update
09. Aug 2024
First upload
22. Aug 2016
Downloads
9,337
Category
Backend Modules
Dependencies
  • TYPO3 (13.0.0 - 13.4.99)

Installation

  1. Download ZIP file
  2. Log into your TYPO3 backend
  3. Go to Extension Manager module
  4. Press the upload button on the top bar
  5. Select the ZIP file and upload it. If you want to overwrite an existing extension installation, activate the checkbox.
  1. Go to your folder where the root composer.json file is located
  2. Type: composer req stefanfroemken/mysqlreport to get the latest version that runs on your TYPO3 version.
  1. Download T3X file
  2. Log into your TYPO3 backend
  3. Go to Extension Manager module
  4. Press the upload button on the top bar
  5. Select the T3X file and upload it. If you want to overwrite an existing extension installation, activate the checkbox.

Other extensions by this user (6)

Version history

Version Upload comment Works with TYPO3 Download
4.0.1 / stable
August 09, 2024 		Log every exception into var/log
Make as much classes readonly as possible
Add some more tests
Add special param type casting for MySQL/MariaDB servers. Needed for quoting.
13.0.0 - 13.4.99 Download
4.0.0 / stable
August 07, 2024 		Add TYPO3 13 compatibility
Remove TYPO3 12 compatibility
Remove TYPO3 11 compatibility
Complete new logger implementation
Please read upgrade notes in documentation
Query profiling happens now in separate view
13.0.0 - 13.4.99 Download
3.0.4 / stable
February 08, 2024 		Bugfix: Allow TYPO3 versions higher than 12.4.8
11.5.33 - 12.4.99 Download
3.0.3 / stable
November 15, 2023 		BUGFIX: Allow installation of mysqlreport without any error on systems without installed dashboard
Add dashboard as suggested extension to composer.json
Update dependencies to secure TYPO3 versions
11.5.33 - 12.4.99 Download
3.0.2 / stable
August 03, 2023 		DOCS: Add Screenshots to Introduction page
11.5.23 - 12.5.99 Download
3.0.1 / stable
April 08, 2023 		[DOCS] Reduce line length to 80 chars
[DOCS] Add a note to configuration section about problems with "Add EXPLAIN"
[DOCS] Add a note to known problems section about problems with "Add EXPLAIN"
[TASK] Add status report because of activated "Add EXPLAIN"
[TASK] Add new Toolbar Item because of activated "Add EXPLAIN"

Please use option "Add EXPLAIN" carefully. It breaks TYPO3 queries which are using insert_id and affected_rows information of mysqli. Please read instructions in docs. Any hints are welcome.
11.5.23 - 12.5.99 Download
3.0.0 / stable
March 23, 2023 		Add TYPO3 12 compatibility
Remove TYPO3 11 compatibility
Add a lot of dashboard widgets for MySQL/MariaDB
Bugfix FTS scan
Do not log our own profile table
11.5.23 - 12.5.99 Download
2.1.0 / stable
January 17, 2023 		FEATURE: Add download button for CSV/JSON
TASK: Remove AbstractController
10.4.33 - 11.5.99 Download
2.0.4 / stable
January 09, 2023 		[BUGFIX] Incompatible queries with mysql only-full-group-by
10.4.33 - 11.5.99 Download
2.0.3 / stable
November 21, 2022 		NOTE: Please deinstall mysqlreport on legacy installations before installing version 2.0.*

[DOCS] Use packagist package name as package name
[DOCS] Remove duplicate section
[DOCS] Use correct include in ChangeLog docs
[DOCS] Add space in admin manual to prevent broken parsing
[DOCS] Improve ChangeLog
10.4.32 - 11.5.99 Download
2.0.1 / stable
November 20, 2022 		Please remove mysqlreport on TYPO3 standalone installations before installing version 2.0!!!

Registration of InfoBoxes has moved from array syntax into Services.yaml
Please read upgrade notes how to migrate your own infoboxes

PageFinder has been migrated to Symfony Service Locator
Add new SqlViewHelper to format SQL statements (only composer)
Update documentation. Explain new API.
Update documentation. Add a note about using AdminPanel.
Remove all usages of GeneralUtility::makeInstance
Add infobox on empty results in Slow Query LOg, Queries using filesort and FTS
Add Event to modify profile records
Add EventListener to reduce precision of duration to 6
10.4.32 - 11.5.99 Download
1.1.5 / stable
November 10, 2022 		Use DBAL ->fetch() instead of ->fetchAssociative() for TYPO3 10 standalone compatibility
10.4.32 - 11.5.99 Download
1.1.4 / stable
November 10, 2022 		Allow TYPO3 versions higher than 11.5.16 for TYPO3 standalone installations
10.4.32 - 11.5.99 Download
1.1.3 / stable
November 09, 2022 		Prevent division by zero at several places
10.4.32 - 11.5.16 Download
1.1.2 / stable
November 09, 2022 		Prevent division by zero
Solve undefined array key cachecmd while storing records in BE
Add method to replace query questionmarks

 10.4.32 - 11.5.16 Download
1.1.0 / stable
October 27, 2022 		Do not log queries to our own profile table
Implement ConnectionHelper to prevent logging own queries
Implement SqlLoggerHelper for temporary deactivating the logger
Add infobox for max_allowed_packet
Add infobox for temporary tables
Update infobox for table cache
Update infobox for table definition cache
Add new module for slow queries
Add button for detail view instead of clicking on duration value
Add query profile view for filesort, notUsingIndex and slow query lists
10.4.32 - 11.5.16 Download
1.0.1 / stable
October 25, 2022 		Remove .github directory from TYPO3 standalone version
10.4.32 - 11.5.16 Download
1.0.0 / stable
October 24, 2022 		Remove TYPO3 9 compatibility
Add TYPO3 11 compatibility
Add an overview with various modules to the individual sections
Remove the module menu
Add ViewHelpers are removed
Each check has its own PHP class now
Completely rewritten API to add your own infoboxes
10.4.32 - 11.5.16 Download
0.4.3 / stable
November 08, 2022 		Update for TYPO3 9/10 compatible version
- Set default value of profile to array
- Set value to NULL where dbal type is NULL
- Update to version 0.4.3
9.5.20 - 10.4.99 Download
0.4.2 / stable
November 08, 2022 		Backport all new features from TYPO3 11 compatible version to TYPO3 9.5 compatible version
9.5.20 - 10.4.99 Download
0.4.1 / beta
February 18, 2021 		Remove TYPO3 6 and TYPO3 7 compatibility. Add TYPO3 9 compatibility
8.7.34 - 9.99.99 Download
0.3.0 / beta
August 22, 2016 		Analyze and profile your databases queries made via $GLOBALS['TYPO3_DB']
6.2.0 - 8.99.99 Download