- Support Portal
- Troubleshooting
-
Getting Started
-
Docs
-
Product Overview Videos
-
Alerts
-
Product Tutorials
-
Features
- Getting started
- User Interface
- Discovery
- Monitoring
- Topology
- Configuration Management - Backup Restore, Firmware Deploy
- Alarms Events and Syslogs
- Automation and Event processing Rules
- Traffic Flow
- Reporting
- Server Management
- Systems Administration
- Actions
- Installation and Upgrade
- Hyper Converged Infrastructure
- Video Archive
- Cruz Edge Orchestrator
- Compliance
- Hierarchy Views
- User Roles and Permissions
-
Troubleshooting
-
Integration
-
Discovery
-
Performance Monitoring
-
System Administration
-
Services
-
Fabric
Show TOP-10 Largest Tables
This article outlines the command to provide the output of the Top-10 Largest Tables in your database.
This article is based on this error message found in the server.log file
Caused by: java.sql.SQLException: The table 'rc_notification_hist' is full in the server log.
MySQL Command to Show TOP-10 largest tables
1. Open up Putty or Command-line
2. cmd> oware (Win) or . /etc/.dsienv for (Linux)
3. Log in to MySql: cmd> mysql -u root --password=dorado
4. Two line Oware command to show TOP-10 largest tables
SELECT CONCAT(table_schema, '.', table_name),
CONCAT(ROUND(table_rows / 1000000, 2), 'M') rows,
CONCAT(ROUND(data_length / ( 1024 * 1024 * 1024 ), 2), 'G') DATA,
CONCAT(ROUND(index_length / ( 1024 * 1024 * 1024 ), 2), 'G') idx,
CONCAT(ROUND(( data_length + index_length ) / ( 1024 * 1024 * 1024 ), 2), 'G') total_size,
ROUND(index_length / data_length, 2) idxfrac
FROM information_schema.TABLES
ORDER BY data_length + index_length DESC
LIMIT 10;