Database size rapid fluctations. Is this normal?

🛎️ Get Help Devices
1

Information from @thebearmay's Hub Information Driver shows rapid and significant up and down fluctuations of the database size on a C4 running 2.3.5.138.

Is this normal or is something odd going on?

|dbSize|3|MB||DEVICE||Hub info V3|2023-05-13 09:34:16.452 EDT|
|dbSize|9|MB||DEVICE||Hub info V3|2023-05-13 09:25:15.566 EDT|
|dbSize|3|MB||DEVICE||Hub info V3|2023-05-13 09:16:13.384 EDT|
|dbSize|5|MB||DEVICE||Hub info V3|2023-05-13 09:07:12.574 EDT|
|dbSize|9|MB||DEVICE||Hub info V3|2023-05-13 08:58:11.668 EDT|
|dbSize|5|MB||DEVICE||Hub info V3|2023-05-13 08:49:10.088 EDT|
|dbSize|7|MB||DEVICE||Hub info V3|2023-05-13 08:40:09.044 EDT|
|dbSize|3|MB||DEVICE||Hub info V3|2023-05-13 08:31:08.353 EDT|
|dbSize|4|MB||DEVICE||Hub info V3|2023-05-13 08:22:07.059 EDT|
|dbSize|7|MB||DEVICE||Hub info V3|2023-05-13 08:13:06.265 EDT|

2

Normal.

Screenshot_20230513-095117
Screenshot_20230513-0951172340×1080 104 KB

3 Likes
3

Thanks for letting me know, but I have to say that I find it hard to believe or understand.

1 Like
4

Changes in variables, data, logs contribute to the fluctuations..

4 Likes
5

Yep and the periodic cleanup job to remove stale data.

1 Like
6

So perhaps one could relate this to defragging a hard drive?

7

Wow - I haven't heard that term in a long while.

8

I would say if you are not making any changes the majority of the size are the logs. If you want to reduce the size try disabling most logging.

9

Logs are not stored the hub database, so that is unlikely to affect this at all. Most changes are likely related stored device events, then either pruning according to your settings or regular database maintenance, plus other data stored in the database like app or driver state. I wouldn't worry about regular, periodic changes like the ones graphed above myself.

3 Likes
10

I considered the events part of logging.

11

Hmm I always thought the logs were part of the overall database... Good to know it's not.

1 Like