Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision | ||
| smart-home:home-assistant [2025/05/03 04:42] – [HA mysql] admin | smart-home:home-assistant [2025/05/03 05:04] (current) – [HA mysql] admin | ||
|---|---|---|---|
| Line 62: | Line 62: | ||
| ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)` | ROUND(((data_length + index_length) / 1024 / 1024), 2) `Size (MB)` | ||
| FROM information_schema.TABLES | FROM information_schema.TABLES | ||
| - | ORDER BY (data_length + index_length) DESC; | + | ORDER BY (data_length + index_length) DESC |
| + | limit 10; | ||
| + | |||
| + | -- optimize | ||
| + | OPTIMIZE TABLE homeassistant.states; | ||
| </ | </ | ||
| ++++ | ++++ | ||