rebecca_white every time i am getting this MySQL-bin and it decreases my disk space, how to get rid of it automatically to stop to being generate every time
aaPanel_Kern Hello, what is the version of mysql? if mysql8 [mysqld] Add the following configuration 10 days expire_logs_days=10 binlog_expire_logs_seconds = 600000 rebecca_white
rebecca_white aaPanel_Kern i am using 5.7, do i need to change it to 8? will it affect my current running live website
rebecca_white thanks i did it, let see how it goes... can i increase the ram usage, as it use only 11 gb
aaPanel_Kern rebecca_white Hello, if the server only has the mysql program, it can be added. If there is php or the like, it is not recommended to add it.
rebecca_white please reply still i am getting mysql.bin log even i set it to off, image above aaPanel_Kern
aaPanel_Kern rebecca_white mysql8 close binary log Added in the configuration： skip-log-bin=1 #log-bin=mysql-bin #binlog_format=mixed
aaPanel_Kern Hello, it will cause an error you cannot delete it directly. You can adjust the retention date.
