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 [2026/10/02 20:36] (current) – [Home assistant] admin | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Home assistant ====== | ====== Home assistant ====== | ||
| + | https:// | ||
| + | |||
| https:// | https:// | ||
| https:// | https:// | ||
| Line 27: | Line 29: | ||
| https:// | https:// | ||
| https:// | https:// | ||
| + | |||
| + | <code BASH> | ||
| + | # get video VOD | ||
| + | http:// | ||
| + | </ | ||
| + | Full reference config - https:// | ||
| + | good config example - https:// | ||
| ===== HA. configue ===== | ===== HA. configue ===== | ||
| Line 62: | Line 71: | ||
| 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; | ||
| </ | </ | ||
| ++++ | ++++ | ||