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
how to empty old graphs from mysql?
Moderators: Developers, Moderators
Re: how to empty old graphs from 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
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
Re: how to empty old graphs from mysql?
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?
/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.
Re: how to empty old graphs from mysql?
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
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
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
Re: how to empty old graphs from mysql?
Thank you very much, you solved my problem!
Seek and you shall find, knock and it shall be opened, cry and you will find comfort, thirst and you shall be watered.
Who is online
Users browsing this forum: No registered users and 0 guests