README

The mysqlinfo package provides valuable insights into your MySQL database, such as connection details, table sizes, row counts, indexes, and query performance. This package is designed to help you monitor and troubleshoot database issues by logging queries, execution times, and analyzing server status. Additionally, it tracks schema details like table collations and supported character sets to ensure efficient database management and query execution.

⚠️ Security Warning

This package does not include any built-in security measures and is intended for admin use only. It exposes sensitive database details and query execution data, which could pose a security risk if accessed by unauthorized users.Ensure that this package is only used in a secure environment and not exposed to public or unauthorized access.

🏷️ #MySQL #Database #PerformanceMonitoring #Laravel #PHP #QueryOptimization #MySQLAdmin #ServerMonitoring #DevOps #DatabaseManagement

Documentation

Features
Supported Versions
Installation
- Commands
  - Composer Require
  - Vendor Publish
Accessing the Plugin

Features:

Real-time MySQL database performance monitoring.
View database connection details, table sizes, row counts, and indexes.
Track query performance and execution times.
Analyze server status and database schema details, including table collations and supported character sets.

Supported Versions:

PHP: ^8.0
Illuminate Support: ^9.0 | ^10.0 | ^11.0

Installation

To install the package Open the terminal and run the following command:

composer require itpathsolutions/mysqlinfo

Commands

Vendor Publish

Run the following command to publish the vendor files:

php artisan vendor:publish

Accessing the Plugin

Once installed, open the following URL in your browser to check the plugin:

localhost:8000/mysql-info

Contributing

We welcome contributions from the community! Feel free to Fork the repository and contribute to this module. You can also create a pull request, and we will merge your changes into the main branch. See CONTRIBUTING for details.

Security Vulnerabilities

Please review our Security Policy on how to report security vulnerabilities.

License

This package is open-source and available under the MIT License. See the LICENSE file for details.

Testing

To test this package, run the following test command:

composer test

Get Support

Feel free to contact us if you have any questions.
If you find this project helpful, please give us a ⭐ Star.

You may also find our other useful package:

PHP Info Package 🚀{:target="_blank" rel="noopener noreferrer"}
AUTH Info Package 🚀{:target="_blank" rel="noopener noreferrer"}

itpathsolutions / mysqlinfo

Maintainers

Details