Binary log files contains data about modification’s make by MySQL server. You can see there are multiple binary files will be available on your MySQL server and there will be one .index file which contains names of all binary files to keep track of them. Step 1. List Binary Files First list binary log...
This article is second part of the article Setup Rsyslog with MySQL and LogAnalyzer on CentOS/RHEL systems. In the first part we have integrated Rsyslog with MySQL database server, and all the logs are now saving in database. For recalling below is few configuration details which we used in part-1 to setup it. Rsyslog...
Some times SQL Server log files acquire a large space on disk. In that case we need to reduce the size of log file to claim some space. But truncating or reducing database log file in SQL Server 2008 can be quite difficult. It also have its own issues. This article contains a set...