Database Health
Monitor database performance, connections, and optimize queries
Healthy
Overall Status
45/100
Active Connections
2.3ms
Avg Query Time
234GB
Database Size
Performance Metrics
1,247
Queries/sec
78%
Cache Hit Rate
12MB
Buffer Pool
0.02%
Lock Wait Ratio
Memory Usage
CPU Usage
Disk I/O
Database Tables
| Table Name | Rows | Size | Index Size | Health | Last Optimized | Actions |
|---|---|---|---|---|---|---|
| users | 12,847 | 45.2MB | 8.7MB | Good | 2024-01-14 | |
| orders | 45,923 | 123.8MB | 23.4MB | Warning | 2024-01-10 | |
| products | 8,234 | 67.3MB | 12.1MB | Good | 2024-01-13 | |
| logs | 234,567 | 456.7MB | 89.2MB | Critical | 2024-01-05 |
Database Actions
Slow Query Log
2024-01-15 14:32:15
Duration: 5.23s
SELECT * FROM orders o JOIN users u ON o.user_id = u.id WHERE o.created_at > '2024-01-01' ORDER BY o.total DESC
2024-01-15 14:28:42
Duration: 3.87s
SELECT COUNT(*) FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE p.status = 'active'
2024-01-15 14:25:18
Duration: 2.45s
UPDATE users SET last_login = NOW() WHERE id IN (SELECT user_id FROM sessions WHERE active = 1)