This message was deleted.
# k3sa
adamant-kite-43734
12/15/2024, 12:46 PMThis message was deleted.
c
creamy-pencil-82913
12/15/2024, 8:18 PMcheck the k3s server log for compact log messages
creamy-pencil-82913
12/15/2024, 8:18 PMwhat metric are you using for db growth? if all you’re looking at is disk space, you may need to do something on the mariadb size to reclaim unused storage. trim the binlog or something like that.
q
quick-dentist-45681
12/15/2024, 8:22 PMI'm a developer and not usually a DBA so not that advanced with my database knowledge 😅.
The metric I'm looking at first is disk usage, which is currently at 30 GB, and growing slowly but surely. Also, in Adminer, the database is identified as having a size of 166,182,912, but I don't know what that actually means. 🤷
I'll scan the logs for compaction messages, and see if I can find some mariadb resources on reclaiming diskspace, thanks. 🙂
c
creamy-pencil-82913
12/15/2024, 8:28 PMprobably the binlog
q
quick-dentist-45681
12/15/2024, 10:19 PMI tried "Optimize table", which according to some sources online should "defragment" a table and reclaim some unused disk. The result is that the number grew from 166 million to 6.9 billion, and the database server is now using 45GB disk 😬
c
creamy-pencil-82913
12/15/2024, 10:42 PMcheck what you’re doing with the binlog
5 Views