MariaDB/MySQL Database Size Sensor In Home Assistant
A quick little tip to get the size of your database into Home Assistant.
The example below will get the Home Assistant database size from MySQL. This should also work for MariaDB using the Recorder integration.
Assuming the database schema is called homeassistant, the select query:
SELECT table_schema "homeassistant", Round(Sum(data_length + index_length) / POWER(1024,2), 1) "value" FROM information_schema.tables WHERE table_schema="homeassistant" GROUP BY table_schema;
Optimize Your Home Assistant Database
About Danny
I.T software professional always studying and applying the knowledge gained and one way of doing this is to blog.
Danny also has participates in a part time project called Energy@Home [http://code.google.com/p/energyathome/] for monitoring energy usage on a premise.
Dedicated to I.T since studying pure Information Technology since the age of 16, Danny Tsang working in the field that he has aimed for since leaving school.
View all posts by Danny →
This entry was posted in
Database,
Home Automation and tagged
database,
Disk,
homeassistant,
mariadb,
mysql. Bookmark the
permalink.
