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:52] – [HA mysql] admin | smart-home:home-assistant [2025/06/01 05:38] (current) – [HA CCTV frigate / scrypted] admin | ||
|---|---|---|---|
| Line 27: | Line 27: | ||
| https:// | https:// | ||
| https:// | https:// | ||
| + | |||
| + | <code BASH> | ||
| + | # get video VOD | ||
| + | http:// | ||
| + | </ | ||
| + | Full reference config - https:// | ||
| + | good config example - https:// | ||
| ===== HA. configue ===== | ===== HA. configue ===== | ||
| Line 64: | Line 71: | ||
| ORDER BY (data_length + index_length) DESC | ORDER BY (data_length + index_length) DESC | ||
| limit 10; | limit 10; | ||
| + | |||
| + | -- optimize | ||
| + | OPTIMIZE TABLE homeassistant.states; | ||
| </ | </ | ||
| ++++ | ++++ | ||