Database Analyzer
Database Analyzer is a tool that helps you analyze database storage usage and identify potential performance issues in your database.
How to Access the Tool?
You can access the Database Analyzer from the Frappe Cloud dashboard.
- Visit the Frappe Cloud dashboard.
- Navigate to Sidebar → Dev Tools → DB Analyzer.
- Open the Database Analyzer tool to start analyzing your database.
You can also directly access the tool from the Database Analyzer page.
Database Analyzer Features
The tool provides multiple features to monitor database usage and optimize performance.
Storage Breakdown
The Storage Breakdown feature helps you analyze disk usage by individual tables in your database.
By clicking on the Storage Bar, you can view the storage consumption details for each table and identify tables using excessive space.
Database Processes
The Database Processes section allows you to view all active database queries running on your system.
You can monitor running queries and terminate a query if it becomes stuck or causes performance issues.
Database Locks
The MariaDB Lock Report helps identify active locks on a specific database.
This information is useful when investigating issues such as lock timeout errors and understanding which processes are causing database locks.
Slow Queries
Slow queries can impact the overall performance of your site. The Slow Queries section provides details about queries that take longer to execute.
Analyzing these queries helps identify performance bottlenecks and optimize database operations.
Time Consuming Queries
Some queries may execute quickly but run frequently, consuming a significant amount of database CPU time over a period.
These queries may not always directly affect database performance, but analyzing them can help optimize application code and improve efficiency.
Full Table Scan Queries
Queries without proper indexing or with inefficient conditions can result in full table scans, which can significantly impact database performance.
Database Analyzer helps identify these queries so you can optimize them by improving query structure or adding appropriate indexes.
Index Analysis
The Suggest Indexes feature analyzes slow queries and provides recommendations for improving database indexing.
These suggestions can help optimize query execution and improve overall database performance.
