06

Nov/23

MariaDB/MySQL Database Size Sensor In Home Assistant

Filed Under Database, Home Automation at 6th November 2023 0:01 by

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 … Continue reading →

04

Sep/23

MySQL Consider increasing innodb_redo_log_capacity

Filed Under Database, Infrastructure at 4th September 2023 0:01 by

Overview I started getting the following warnings in the log from MySQL: 2023-03-18T05:12:59.566053Z 0 [Warning] [MY-013865] [InnoDB] Redo log writer is waiting for a new redo log file. Consider increasing innodb_redo_log_capacity. Redo logs are stored transactions that are used to … Continue reading →