Hi all, I have set up a few SQL - Home Assistant sensors that connects to another MYSQL database on my LAN to pull info, and am running into issues such as “Can’t reconnect until invalid transaction is rolled back” errors and I believe it to be because by default the SQL sensor polls every 30 seconds. Is there a way to change this poll interval for all my sensors or even turn it off altogether and just call the updates myself using the Home Assistant Core Integration: Update entity?
Yes, go to the configuration options in the SQL integration and turn off polling. But you’ll have to manually poll the device using an automation with the homeassistant.update_entity service.