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
  - Vendor Publish
  - Accessing the Plugin
FAQs
Contributing
Security Vulnerabilities
License
Testing
Support

Features:

Real-time MySQL Performance Monitoring – Track live database performance and query execution.
Database Connection Insights – View connection details, active users, and session statistics.
Table & Index Analysis – Monitor table sizes, row counts, indexes, and schema details.
Slow Query Detection – Identify and optimize slow-running queries for better efficiency.
Query Execution Logging – Log executed queries, their execution time, and performance impact.
Storage & Fragmentation Optimization – Detect fragmented tables and optimize storage.
InnoDB Buffer & Cache Analysis – Monitor buffer pool usage and cache efficiency.
Query Load Monitoring – Analyze query load in real-time and track database stress.
Laravel Log Integration – Store query performance logs for historical analysis.
Security & Access Control – Restrict access to database insights for admin use only.

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

FAQs

1️. What does this package do?

This package provides real-time insights into your MySQL database, including connection details, table sizes, row counts, indexes, query performance, and server status. It helps monitor and optimize database performance.

2. How do I install the package?

📦 Installing is simple! Run the following command in your terminal:

composer require itpathsolutions/mysqlinfo

3. Which Laravel versions are supported?

This package supports Laravel 9, 10, and 11 with PHP 8+ compatibility.

4. How do I access MySQL insights?

You can access MySQL performance insights via:
👉 localhost:8000/mysql-info

5. How do I update the package to the latest version?

Run the following command to update:

composer update itpathsolutions/mysqlinfo

6. Can I contribute to this package?

🤝 Absolutely! Contributions are welcome. See the CONTRIBUTING guidelines for details.

7. Where can I get support?

For any support or queries, contact us via IT Path Solutions.

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 🚀
AUTH Info Package 🚀
Role Wise Session Manager Package 🚀
Chatbot Package 🚀
Redis Info Package 🚀

itpathsolutions / mysqlinfo

Maintainers

Details