MySQL Logs or What?

[PauGasol]

Hi,

Im not sure what are the files :

servername-bin.00000x

in /usr/lib/mysql (/home/mysql in debian) . This files dont rotate automatically and can occupid all the hdd because each file is around 1 giga...

I readed that was logs but the logs can be read and this files ara in binary. Also i think i readed that was for the cache .... Im not sure.

If i remove the line :

log-bin

in the my.cnf then this files not appear.

My question is . What make exactly this files. Do you recommend me disable it ?

Thanks and sorry for my english

 

[jmstacey]

You can disable it if you want, but as I understand it these log files contain the exact queries that are run on each database. This data provides for restores, replication and so on. You'd have to read the MySQL manual for more information. There may be a way to set the max size and/or age in your configurations besides the default.