smart-home:home-assistant

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
smart-home:home-assistant [2025/05/03 04:52] – [HA mysql] adminsmart-home:home-assistant [2025/05/03 05:04] (current) – [HA mysql] admin
Line 64: Line 64:
   ORDER BY (data_length + index_length) DESC   ORDER BY (data_length + index_length) DESC
   limit 10;   limit 10;
 +
 +-- optimize
 +OPTIMIZE TABLE homeassistant.states;
 </code> </code>
 ++++ ++++
  • smart-home/home-assistant.1746247960.txt.gz
  • Last modified: 2025/05/03 04:52
  • by admin