Yep, Switched to MariaDB, keeping 7 days as well, still slow 
But itâs faster than the default SQLite db at least (I think?) 
Yes, slightly faster but it should be way faster.
Not sure about your setup, but I am using my hosting servers to host the mysql database, and those are fastâŠ
I also checked connectivity, but 20Mbps even if are not that much, are quite enough for MySQL queriesâŠ
So, for now, I think my bottleneck is the raspberry itself, I will have to test other HW soon to make it a little more performant 
Iâm running HA and the database on the same server, and itâs pretty beefy, so should be fast imo 
So not a Raspberry but a server, and it is still slow?
If so, there is some serious design problem there 
Yes, database is located on a regular hdd though and not an ssd, not sure if that could make any difference.
No, not on an application that should work on a raspberry tho
Got hundreds of hosted websites and everything works smoothly, this is just too slow, not sure whatâs wrong tho⊠it might be db design or queries or even completely something different.
It might also be that the query response is fast but the âlookupâ process is slow.
You should have a look at the tables in there⊠kinda a mess 
Just did, my states table have 191700 lines in it and Iâve been using MariaDB not even for a week now
thereâs not any issue with mariadb and many lines as log as you donât need sql with joined tablesâŠ
I have mysql dbs with tables with more than 100 million lines running on low end machines
in HA on raspberry there are other problems:
- a small amount of ram
- micro sd
- probably a bad design with tables or queries
I donât run MariaDB on my Pi so 1 and 2 are off the list 
I never said MariaDB was the problem.
What I said is that probably there was a design issue or a data management (post-query results) that wasnât tweaked enough.
I do run MariaDB aswell on separated dedicated harware.
The HA issue might be by design or because of the raspberry, but those problems also appears on powerfull VMs, so it is probably somewhere in the design/implementations.
Can someone help me using this on a docker installation?
Where do I have to paste the âmini-graph-card-bundle.jsâ?
Thanks
The www folder⊠just follow the instructions. Itâs no different to any other custom-card
This is my first attempt to install a custom-card.
I canât find any www folder. I just found a config folder with a daemon.json file, but I canât paste anything there, itâs read-only folder and canât change to write.
You may need to create the www folder. Mine for example is here:
~/docker/homeassistant/www/
Is there a way to use this card (or another card) to show just the static value (no history, just what it is right now) of a percentage sensor in a bar chart? Iâm trying to do this for my disk usage sensor, but it seems to show at minimum two bars.
- type: custom:mini-graph-card
name: Disk usage
hours_to_show: 1
points_per_hour: 1
upper_bound: 100
lower_bound: 0
entities:
- sensor.disk_use_percent
show:
graph: bar
Even though Iâm specifying to show 1 hour and 1 point per hour, it still shows 2 bars.
Yes, thereâs a bug in the latest release where the bar chart will show an additional bar.
The fix will be in the next release, and you should only see one bar with your config.
The bar will not represent the current state exactly though, unless the sensor only updates once an hour, it will show an average of all history entries from the past hour.
1 Like
Cool. Showing an average is fine, as long as thereâs just one value.
Thanks!
I gave it some more thought, and I think the graph algorithm should be robust enough now to possibly let users specify floating values for hours_to_show.
Then you would be able to set something like hours_to_show: 0.00001 and get the desired result.
Iâll see if it can be made possible.
Just tried that. Anything less than 1, and it shows the default number of bars.