how can I stop this cache from consuming my VPS storage? bin file cache

Hello, I suggest you check why it is generated so frequently? You can use phpmyadmin to check if the contents are the same aaP_ngbaze100

how can I stop this cache from consuming my VPS storage?

aaP_ngbaze100

Alright, i will check now

aaP_ngbaze100

I have found the Path storage, can I remove the path storage to avoid consuming my storage?

or do you alternative, solution
?

aaPanel_Kern

Hello, try adding in mysql configuration
Set expiration time

expire_logs_days=3
binlog_expire_logs_seconds = 600000

It is not recommended to turn off the log, it can be used for restores and incremental backups

skip-log-bin=1
#log-bin=mysql-bin
#binlog_format=mixed

You need to restart mysql after adding

aaP_ngbaze100

Where can add this code?

expire_logs_days=3
binlog_expire_logs_seconds = 600000

aaPanel_Kern

aaP_ngbaze100
[mysqld]

aaP_ngbaze100

I have added the code in the below [mysqld] line

am I doing it correctly?

aaPanel_Kern

Yes, need to restart mysql after adding

aaP_ngbaze100

after I added it the plugin stopped working.

until I deleted the code

aaPanel_Kern

Hello, please check the Mysql log and check its specific error log
cat /www/server/data/*.err|grep -i -C 10 error

aaP_ngbaze100

here is the log result, but yet am facing that issue.

aaPanel_Kern

aaP_ngbaze100
Hello, the log shows normal operation, what problem did you encounter?

Stealth

aaPanel_Kern

Not always help. In few days we get 300-400GB from unnecessary logs... I don´t know what you make there guys...

aaPanel_Kern

Hello, log related is your website program to do the operation, I suggest you check the relevant log is what content?
The panel does database operations only when you are working with the database and does nothing outside of this

Stealth

aaP_ngbaze100

I am still facing storage issues as the SQL keeps consuming space. I have to keep deleting it frequently.

aaPanel_Kern

Hello, it is recommended that you use phpmyadmin to check the content of the relevant logs?
Or upgrade aapanel to the test version and then close the log. This is not recommended.

aaP_ngbaze100

i have turned off the log ?

i hope there are no issues doing that.?

aaP_ngbaze100

is there any solution?

aaPanel_Kern

Turn off the log, can't solve it?
aaP_ngbaze100

Stealth

aaPanel_Kern

I saying this problem very much months, but nobody repair it... 2 day = 350GB logs.

aaPanel_Kern

This is a problem caused by the frequent operation of the database by your website program. You need to check by yourself what its content is and what causes it to be frequently generated.
If the database is not in use, it will only be generated when restarting.

Stealth