This article describes how to query logs and slow query logs in MySQL. It also describes how to use the Mysqldumpslow log analysis tool that comes with MySQL. For more information, see
I. query logs
Query all the queries in MySQL by using "-- log [= file_name. Because all the queries, including all the select statements, are recorded, and the size is relatively
RDIFramework. NET logs 9.13 system logs and system Exception management (IIS Web) Section,
RDIFramework. NET development. NET rapid information system development framework
9.13 system logs and system Exception management-Web Part
When a software is put into operation, it is impossible to have no exceptions. If any exceptions occur in the software, we can track t
Objective
Originally prepared to explain the Nginx and Apache logs, but the individual is not recommended Apache (purely personal hobby), here does not introduce the Apache log.
As a programmer, the code is more important than a little bit of the log analysis and query. Common logging and setting methods are listed below.
Configuration file
Nginx Sub-access_log and error_log two kinds of logs
Settin
Tags: deleting logical data. com update pos LEDs so outputThis article describes a log that is not a transaction log, but an error log for SQL Server logs and agents that divides the error log into SQL Server, SQL Server Agent, Database Mail, and Windows NT, according to the principal. SQL Server uses logging information generated during startup and operation of the database engine, which is not necessarily an "error" message, and is divided into thre
The size of Oracle archived logs is much smaller than that of online logs.
Some users may be confused about the size of archived logs smaller than those of online logs:First, check whether your archive log files are compressed:SELECT to_char (first_time, 'yyyy-mm-dd hh24: mi: ss'), blocks * block_size/1024/1024, compressed from v $ archived_log;If not, this issue
Log4j logs and log4j logs
First, AOP is required to process logs. it is inconvenient to process logs without using AOP.
Log processing is a very important part of each project. Without logs, the controllability of the system is lost. Without
Use Logcat to record logs to files and logcat logs
In some development stages, a small part of the product has been distributed out. In the case of problems, we hope that users can send the Logcat logs at that time to programmers for analysis, here we will introduce a clever way to use the logcat command line to record logs
1. Apache Access LogEnter command cat/usr/local/apache2.4/conf/extra/httpd-vhosts.conf, enter, see,The access log for this virtual machine is inside the/logs/111.com-access_log, enter the command ls/usr/local/apache2.4/logs/, you can see the access log file, see,You can use the command Cat/usr/local/apache2.4/logs/111.com-access_log to view the contents, enter, s
Label:MySQL has the following types of logs:Error log:-log-errQuery log:-logSlow query log:-log-slow-queriesUpdate log:-log-updateBinary log:-log-binWhether the log is enabledMysql>show variables like ' log_% ';How to know the current logMysql> Show master status;Show binary log EntriesMysql> show master logs;See binary log files with MysqlbinlogShell>mysqlbinlog mail-bin.000001or Shell>mysqlbinlog mail-bin.000001 | TailSpecify the output location of
Nginx splits logs by day, and nginx splits logs
#! /Bin/bash # Cut and compress nginx logs by day, add crontab to cut at every day # Author: fafu_li # Time: 2015.08.15source/etc/profile # load the system environment variable source ~ /. Bash_profile # load the user environment variable set-o nounset # reference the uninitialized variable and exit set-o errexit #
Use shell commands to analyze statistics logs and shell commands to collect statistics logs
When you need to collect user log information and analyze user behavior, you can use shell to conveniently retrieve a lot of data and place it in excel for statistics.
For example, for access with the address loadCustomProcess included in the statistics log, sort by access time consumption:Grep "loadCustomProcess"/ho
Describes how to obtain PHP error logs and how to obtain php logs.
There are many methods to obtain error logs in PHP. I will give you a brief introduction to how to solve these problems. The following code will show you how to help you.
For php errors, we must be clear about the types, when to trigger, and what is the returned value.
If you do not distinguish b
Python-filter Mysql slow logs and python-filter mysql logs
##=================================================== ======================================== ##
First joke:
My new girlfriend asked me to go to his house to play. I thought it was not good to be empty-handed, so I told her that I had to buy something. Who knows? She suddenly said, "Don't buy, There is a box at home!
##=============================
Python automatically logs on to Renren and accesses the nearest visitor instance. python automatically logs on to Renren.
This article describes how to use python to automatically log on to Renren and access the nearest visitor.
The specific method is as follows:
#-*-Coding: gbk-*-# In import OS from xml. dom import minidom import re import urllib import urllib2 import cookielib import datetime import time
Python records detailed call stack logs, and python calls stack logs.
This example describes how to record detailed call stack logs in Python. Share it with you for your reference. The specific implementation method is as follows:
Import sysimport osdef detailtrace (info): retStr = "" curindex = 0 f = sys. _ getframe () f = f. f_back # first frame is detailtrac
ASP. NET error logs and asp.net error logs
In this article, we will record errors and exceptions on our website through a simple process. In this way, when a program error occurs, the user is redirected to a separate page, and the error is recorded in a text file on the server. When an error occurs, we will record the log every day.
First, I will write a static method to record the Error information to a te
Asp.net Method for logging error logs, asp.net error logs
1. Description
Unexpected errors may occur in the asp.net project after debugging and release, but they cannot be displayed in a timely manner. This requires logging to track error information. Therefore, we have written a simple method to record information, which can also be used to record simple text information. This method is recorded by generat
configured. When the cycle log takes effect, the transaction data is written to the main Log File cyclically. When all records stored in a log file no longer need to be used for restoration, the log file will be reused and can become an active log file again later. This means that in the loop log mode, the log file content will eventually be overwritten by new log entries. Because the log file content is overwritten, we can only restore the database to the last complete database backup. You can
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.