Recorder Commit interval is working?

My Recorder is connected to external mariadb server, everything works good, but, as I’ve a lot of entities number of writing is big. I’ve found the commit_interval option and I set to 1200 (should be seconds) for the commit. Anyway it seems that nothing changes and my external server write the Data Base as without the commit option. I’m quite sure of that because the server is writing the database on external dedicated harddrive and the it’s working in the same way, time interval for access to the states and events data base are the same as before (more or less, quite each second), memory usage on hassio is steady (it should increase to store data for dB). I’ve tried also to reboot and restart the hassio but nothing appended. Any suggestions? My system is Hassos on rpi4 with 4gb and the mariadb server is on rpi3 1gb with Ubuntu server the data base is written on usb external HDD of 50gb 4200rpm with external power

Please paste your config for the recorder.

sorry for the delay here my config for recoder

recorder:
purge_keep_days: 5
db_url: mysql://hassio:[email protected]/hassiodb?charset=utf8
commit_interval: 1200
exclude:
domains:
- automation
- updater
- input_select
- input_datetime
- input_number
entities:
- sensor.fritz_box_4040_b_received
- sensor.fritz_box_4040_b_sent
- sensor.fritz_box_4040_kib_s_received
- sensor.fritz_box_4040_kib_s_sent
- sensor.fritz_box_4040_packets_received
- sensor.fritz_box_4040_packets_sent
- sensor.date

Please format it correctly.

recorder:
  purge_keep_days: 5
  db_url: mysql://hassio:[email protected]/hassiodb?charset=utf8
  commit_interval: 1200
  exclude:
    domains:
      - automation
      - updater
      - input_select
      - input_datetime
      - input_number
    entities:
      - sensor.fritz_box_4040_b_received
      - sensor.fritz_box_4040_b_sent
      - sensor.fritz_box_4040_kib_s_received
      - sensor.fritz_box_4040_kib_s_sent
      - sensor.fritz_box_4040_packets_received
      - sensor.fritz_box_4040_packets_sent
      - sensor.date

Any news or information?

No, there’s nothing wrong there that I can see. Try a shorter interval?

I’ve already tried with 10, 30, 100 nothing is changed. I’ve tried to restart the home assistant, then I’ve rebooted the Hassos and at the end I’ve shuted down and restarted but nothing. So is the commit option is working?

Maybe not. You could open an issue:

Or,

try to edit mysql/mariadb variable directly which is sure.

  • install phpMyAdmin > show left panel > and server start
  • go to phpMyAdmin > ‘Variables’ on top menu > input innodb_flush_log_at_timeout in the small serch box > click the Edit > input any number you want.