<div>
THanks for pointing to binary logs. Also you can set the database for which you need the logs for. This is helpful in case you have multiple database in your mysql server.
</div>


THanks for pointing to binary logs. Also you can set the database for which you need the logs for. This is helpful in case you have multiple database in your mysql server.

<div>
<div class="content wysiwyg-content">
I know how to enable log for mysql:<br />
i insert the following line in /etc/my.cnf:<br />
log=/datalogs/mysql.log<br />
<br />
But how to configure mysql for log rotation and to set the max size for the same?<br />
<br />
Is it possible to set that only teh update,insert and delete commands be logged ... i dont want to log select queries.
</div>
</div>


I know how to enable log for mysql:
i insert the following line in /etc/my.cnf:
log=/datalogs/mysql.log

But how to configure mysql for log rotation and to set the max size for the same?

Is it possible to set that only teh update,insert and delete commands be logged ... i dont want to log select queries.

How to do Log rotation and set max log file size policy in mysql ?

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Linux is a UNIX-like open source operating system with hundreds of distinct distributions, including: Fedora, openSUSE, Ubuntu, Debian, Slackware, Gentoo, CentOS, and Arch Linux. Linux is generally associated with web and database servers, but has become popular in many niche industries and applications.