read sql log file

ASP reads the IIS log file code, which you can write to implement an IIS log browsing program, can read the IIS log access time, client IP, request target, protocol status, etc., if you want to read more

Configuration and startupMkdir/usr/local/mysql-proxy/confMkdir/var/log/mysql-proxyCd/usr/local/mysql-proxy/confVim mysql-proxy.conf[Mysql-proxy]Daemon=truePid-file=/usr/local/mysql-proxy/mysql-proxy.pidLog-file=/var/log/mysql-proxy/mysql.logLog-level=debugLua_path= "/usr/local/src//usr/local/src/mysql-proxy-0.8.3/lib/

SQL statements with the most queries Open General LogMysql> Show variables like '%general% ';+------------------+-------------------------------------+| variable_name | Value |+------------------+-------------------------------------+| General_log | Off || General_log_file | /usr/local/mysql/data/localhost.log |+------------------+-------------------------------------+mysql> Set Global General_log = "on"; analysis-general-log.py Script#!/usr/bin/pyth

Over time, you will find that the log files for the database will be up to 20G or more, and you will need the following methods.--first change the recovery model of the database to SimpleALTER DATABASE [Database] SETRECOVERY Simple;GO--to reduce the log file to 1M, the logical name can be obtained by sp_helpfileDBCCShrinkfile ([Database

'log _ bin '; 2. if you want to know the details of the file that records binary data, you can use the following statement to see which file is being recorded and the current location of the record: SQL code Mysql> show master status; 3. you need to use the program mysqlbinlog to view the binary data and use it as nee

operation is temporarily primarily logged for errors. For example, the error is logged in App/log/logerror.txt by default. If configured in the configuration file, log information is written to the directory specified in the configuration item Log Ideas: Step 1: Make Log Cl

operations are sent to the currently available writehost. 0 "　　writetype= "0" dbtype= "MySQL" dbdriver= "native" switchtype= "2" slavethreshold= ">"show slave status3 Basic SQL Operation validationLook directly at the insert operation of the log, the current data is directly into the 3306 port of the host.01/17 10:53:58.596 DEBUG [$_NIOREACTOR-1-RW] (serverqueryhandler.java:56)-serverconnection [Id=1, Sche

information does not specify a file name extension, because even if you specify it on the extension it is not used. When MySQL creates binary log files, first create a file with a name of "Mysql_log_bin" and a ". Index" suffix, and then create a "mysql_log_bin" name to". 000001" is the suffix of the file. When the MyS

Most of the questions are as follows: 1: Write some content to a file, in another process/thread/subsequent operation to read the contents of the file when the report exception, prompt System.IO.IOException: The file "XXX" is being used by another process, so the process cannot access this

On the weekend, I helped a buddy find a tool to view SQL Server redo logs, which is quite good. I do not dare to enjoy it exclusively. I recommend it to you. I have successfully installed SQL server on the machine and can connect to use it, but cannot connect to a remote database. The error is: a proxy. cpp file is missing. Use its servermanager to connect to a

read and collect the user's upper and lower line information on the server, and * to be paired and sent to the service-side rollup. * @author Administrator */public class Dmsclient {//attribute definition//First step: Parse Log Required properties//unix System log file Private fil