how to empty old graphs from mysql?

Post support questions that directly relate to Linux/Unix operating systems.

Moderators: Developers, Moderators

Rno
Cacti Pro User
Posts: 704
Joined: Wed Dec 07, 2011 9:19 am

Re: how to empty old graphs from mysql?

Post by Rno »

First you have to find which files is growing
du -h --max-depth=1

that will give you in Kb the space used, and only 1 level, then go down 1 level at time to find out which files (directory) grow
Test
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
majedz
Posts: 39
Joined: Fri Aug 07, 2015 8:15 am

Re: how to empty old graphs from mysql?

Post by majedz »

Very much thanks,
/var/lib/mysql is 17G
there are a bunch of mysqld-bin files which are large
mysqld-bin.000043 is 805MB and date changed today.
can these bin files be deleted? or do they control the graphs and messing with them would mess the graphs?
Seek and you shall find, knock and it shall be opened, cry and you will find comfort, thirst and you shall be watered.
Rno
Cacti Pro User
Posts: 704
Joined: Wed Dec 07, 2011 9:19 am

Re: how to empty old graphs from mysql?

Post by Rno »

it's the database log.
take a look at this link
http://dba.stackexchange.com/questions/ ... -bin-files

I'm not an expert of mysql
Test
Almalinux
php 8.2.14
mariadb 10.6.16
Cacti 1.2.27
Spine 1.2.27
RRD 1.7.2
thold 1.8
monitor 2.5
syslog 3.2
flowview: 3.3
weathermap 1.0 Beta
majedz
Posts: 39
Joined: Fri Aug 07, 2015 8:15 am

Re: how to empty old graphs from mysql?

Post by majedz »

Thank you very much, you solved my problem! :D
Seek and you shall find, knock and it shall be opened, cry and you will find comfort, thirst and you shall be watered.
Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests