My SQL Log/Bin

zohebnsr

I installed log cleaner and found some large files (check the screenshot). Can I find these files under Files option within AA Panel? If yes, where. Is it safe to delete these files or it has some use?

aapanel_sniper

zohebnsr

MySQL. Binlog is a binary log for MySQL.

It can be used for emergency recovery of data in the event of a loss of your database.
If you have sufficient disk space, it is recommended that you keep it.
If you wish to delete it, we recommend that you do a daily database backup.

zohebnsr

aapanel_sniper Thanks. I do have enough space and i also do daily backups. I will keep it then.

aaP_davi21steixeira

aapanel_sniper how do I install? of binlog in the database? I looked in several places, but none of them could do it.

zuantou

aaP_davi21steixeira
Hello, your server is not Binlog file? If you don't have a modified Storage location, And confirm below have opened this function,this file should be stored in/www/server/data directory, and begin with mysql-bin

lucius100

It feels like only aapanel keep mysql log ?
I don't know what's that for, don't know how to read, don't know how to troubleshoot/analyze the log, don't know wtf I am supposed to do with that log.
Does it better to turn off the binary log ?
I also have each file 1gb that come with 10 copies with the default aapanel setting.
My database backup only 2mb, and I saw on every thread, those people have 1gb log too. bug or something.

aapanel_power

lucius100 Hello, if you don't need the binary log MySQL-Binlog, you can fix him with the close button.
The MySQL binary log keeps information about your database operations and can be used for recovery in case of MySQL failure

lucius100

aapanel_power my log only contain this and I don't know how to fix it. It just looping the same problem over and over.

210810 2:10:10 InnoDB: ERROR: the age of the last checkpoint is 9434894,
InnoDB: which exceeds the log group capacity 9433498.
InnoDB: If you are using big BLOB or TEXT rows, you must set the
InnoDB: combined size of log files at least 10 times bigger than the
InnoDB: largest such row.

aaP_runqubit

How i can deactivate this logging?
Found it in DB Icon Settings