Discover logstash log file location, include the articles, news, trends, analysis and practical advice about logstash log file location on alibabacloud.com
block all writes to this database, this is the lesson of blood)
2. Delete or rename log files
3. Attach database, you will be prompted not to find the log file
4. Remove (remove) This can not find the log file, and then click OK for Attach,sql server will automatically
Change to Blog Park layout problem, the original is here: http://xubenbenhit.github.io/LogStructureFileSystem.htmllog-structured File systems2014-12-26 #systemFirst of all, this blog is about LFS, previously written hard disk and disk redundancy array is actually the first article, and this should be considered the third, the middle of a file system to introduce the blog, originally intended to go back to w
third step: the corresponding modification of the attributes, before the change must know what these are doing, in the second part of the explanation.
Step Fourth: Add the relevant statement to the class where you want to output the log:
Define attributes: Protected final log = Logfactory.getlog (GetClass ());
In the appropriate method:
if (log.isdebugenabled ()) {
Log.debug ("System ...");
}
Ii. Descript
1: Binary logThe binary log records all DDL(data definition Language) statements and DML(Data Manipulation language) statements, but does not record statements that include data queries. Statements are saved as "events," which describe the process of changing the data, which plays an extremely important role in recovering data during a disaster.2: Location and format of the logWhen started with the -
"Log" is a record of the data we generate when using the terminal emulator software, which includes: Usage time, Xshell connection status, and so on, so it is very important to log in at all times, we can review the previous log records to find the data we want. So how to set up Xshell log
) "This primary record of the client's browser information2). Error_log Error_log is the error log, recording any error processing request, its location and content by the errorlog instruction control, usually the server what error, first check it, is one of the most important log filesTail Error_log, pick a record at random
Copy Code code as follows:
='oracle@szdb.com'# ----------------------------------------------# check the database is running, if not exit# ----------------------------------------------db_stat=`ps -ef | grep pmon_$ORACLE_SID | grep -v grep| cut -f3 -d_`if [ -z "$db_stat" ]; then date >/tmp/db_${ORACLE_SID}_stauts.log echo " $ORACLE_SID is not available on ${MACHINE} !!!" >>/tmp/db_${ORACLE_SID}_stauts.log MAIL_SUB=" $ORACLE_SID is not available on ${MACHINE} !!!" $MAIL_DIR/sendEmail -u $MAIL_SUB -f $MAIL_FM -
Log file format
Log file Cutting
Manual Cutting
Automatic cutting
Log file format
Open nginx default configuration file nginx.conf
We use the LOG_FORMAT di
LoCatIon ~ . * \. (Gif | jpg | jpeg | png | bmp | swf) ${
ExPires 30d; access_log off; // adding this line will not record these file types}
Location ~ . * \. (Js | css )? $ {Expires 12 h; access_log off; // records are not allowed}
Location ~ . * \. (Html | htm) $ // This part is not originally available. We only re
options in the Mysqlbinlog statement. For example, suppose that at 10:00 today (today is April 20, 2006), execute the SQL statement to delete a large table. To recover the tables and data, you can restore the previous night's backup and enter:Mysqlbinlog--stop-date= "2005-04-20 9:59:59"/var/log/mysql/bin.123456 \| Mysql-u root-pmypwdThis command restores all data up to the date and time given in datetime format in the--stop-date option. If you do not
the minimum number of files during the inactivity period of the instruction parameter in Open_file_cache. OPEN_FILE_CACHE_ERRORS Specifies whether to cache error messages when searching for a file, including configuringTo add files to the. We also include server modules, which are defined in different files. If your server module is not in these locations, you will have to modify this line to specify the correct
the increment log, read from the increment point, and the record increment position is the file name. seek files
6 scheduled Delete tasks, every three o'clock in the evening (according to the time in log.time) delete log files (TXT) and file names in the log. Seek (statisti
%p: Output log information priority, i.e. Debug,info,warn,error,fatal,%d: the date or time of the output log point-in-time, the default format is ISO8601, or the format can be specified thereafter, for example:%d{yyy MMM dd hh:mm:ss,sss}, Output is similar: October 18, 2002 22:10:28,921%r: The number of milliseconds to output from the application boot to the output of this
Daemon.*-/var/log/daemon.log
Copy CodeDefines the location where logs generated by Daemon are saved, where daemon is the log type, and "*" means that all levels of logs are placed in the file. The format is: facility. Level-the path where log files are saved, such
Nginx logging and formatting, configured in the master configuration fileVim/usr/local/nginx/conf/nginx.confIn this lineLog_format combined_realip ' $remote _addr $http _x_forwarded_for [$time _local] '' $host ' $request _uri "$status"' "$http _referer" "$http _user_agent";Combined_realip is the name of the log and can be customized. such as: WYP$remote _addr Remote IP$http IP for _x_forwarded_for proxy[$time _local] Time$host Domain Name$request _uri
command format is as follows:
Alter system dump logfile 'filename' dba min fileno. blockno dba max fileno. blockno;
If it is Oracle 10 Gb, You need to omit '.', that is, the format is as follows:
Alter system dump logfile 'filename' dba min fileno blockno dba max fileno blockno;
Otherwise, the ORA-01963: Must specify a block number error is reported.
For example:
SYS @ anqing1 (rac1)> select * fromv $ version where rownum = 1;
BANNER
---------------------------------------------------------
;
--Verifying that the archive log for DB is the file at the specified location of the Log_archive_dest parameter, and that when the archive log is manually deleted, the Rman backup detects that the log is missing and cannot proceed further. So at this point you need to m
Show parameter recover -- view the path for storing archived log files
Alter database archive -- change the database to archive Mode
Archive log list/SQL> select name, log_mode from v $ database; view the current status of the database
Modify the path of an archived Log File
[Oracle @ localhost 2010_06_07] $ mkdir/home
Recently, encountered the MySQL master and slave library synchronization problem, mainly because the computer broke a bit of electricity, toss AH.Error from library log: Last_io_error:got fatal error 1236 from master, reading data from binary log: ' could ' Name in binary log index file '
Solution:
1. First stop sync
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.