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 , , , , . Bookmark the permalink.

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.