MySQL Database Logging

[Siong Po Sim]

Hi,

I understand that we can set the path in my.ini to enable the General Log for MySQL database which will log every event (data access from SQLyog or from application) into the file.

The problem is this log file will keep growing very fast to reach GB file size if my application is running within an hour.

I wish to know is there other way that i can split the file lets say based on file size or date???

Or is there any other setting to configure or limit the logging event or pattern so that it won't just log everything that have changed on database???


Thanks in advanced for any help or suggestion.