hfm logs

Shell script batch export MYSQL database logs automatically export MYSQL binary logs locally, backed up by day Mysqlbinlog A tool that reads statements from binary logs. Logs of executed statements contained in the binary log file can be used to help recover from a crash. I. MYSQL database

Linux logsLinux logs are mostly stored in clear text, generally stored in the/var/log directory, Linux system mainly has three log subsystem: Connection time log, process statistics log, error log.Connection Time LogThe connection time log is executed by several programs, logging the log to/var/log/wtmp/var/run/utmp/var/log/lastlog three files, these three files record the user login system and the information about the exit, Utmp saves each user's in

# # # #系统日志默认分类 # #/var/log/messages # #系统服务及日志, including service information, error, etc./var/log/secure # #系统认证信息日志/var/log/maillog # #系统邮件服务信息/var/log/cron # #系统定时任务信息/var/log/boot.log # #系统启动信息# # # #2. Log Management Service rsyslog####1.rsyslog is responsible for collecting logs and classifying storage logs2.rsyslog Log Classificationvim/etc/rsyslog.conf # #主配置文件Service. Log level/storage file* */var/log/westosSystemctl Restart Rsyslog# # #格式 #

#!/bin/bashLogs_path= "/opt/nginx/logs/"Pid_path= "/opt/nginx/logs/nginx.pid"MV ${logs_path}access.log ${logs_path}access_$ (date-d "Yesterday" + "%y%m%d"). LogKILL-USR1 ' Cat ${pid_path} 'Crontab-eXX * * * * sh/opt/shell/cutnginx.shThe script cannot perform the possible causes:Script does not have X permissionA password is required when the non-root user is lowered, and is placed under the root user.This a

CauseIn general, if the test reports a problem during the development process, I usually do this:1. Retry the test operation in your own development environment to see if you can reproduce the problem. No. 22. Change the database connection pool to the address of the test library and retry the test operation in your own development environment to see if you can reproduce the problem. No. 33. Go to the test environment to view the logs. Analyze the pro

Linux development is often used in the log, this is very useful, can help us quickly locate the error, such as if we do lamp development, the page does not error, but also no debugging tools, we step by step wrong very good time, and this method is also very stupid, so it is very important to master the use of the log.To view the log commands:CatTail-fFor example, we may often look at the Apache log, can quickly locate the error of the Web project, Apache log my default directory under Var/log/h

Save the following command as a PS1 script and add to the Windows scheduled task to set the daily fixed time to execute:#delete logs in specify website, just save logs in eight days~ $TimeOutDays =8 $filePath = "C:\public\" $allFiles =ge T-childitem-path $filePath foreach ($files in $allFiles) { $daypan = ((get-date) – $files. LastWriteTime). Days if ($daypan-gt $TimeOutDays)

#################### #log4j. properties##################### ##### Global Log level (Fatal,error,warn,info,debug) #############Log4j.rootlogger=error# # DAO ########Log4j.logger.com.baidu.dao=info,dao##### Service #############Log4j.logger.com.baidu.service=error,service##### web#############Log4j.logger.com.baidu.web=info,web ###### DAO Logger ###############Log4j.appender.dao=org.apache.log4j.rollingfileappenderLog4j.appender.dao.file=d:/logs/dao.lo

/logbin.index /tmp/1.000001 /tmp/1.000002 Iv. managing binary Logs 1, to see if the function of the binary log file is turned on Mysql> Show variables like "%log_bin%"; +---------------------------------+-------+ | variable_name | Value | +---------------------------------+-------+ | Log_bin | On | | log_bin_trust_function_creators | Off | | log_bin_trust_routine_creators | Off | | Sql_log_bin | On | +---------------------------------+---

Tags: default art processing actions large view characters weight start databaseBecause when you insert, UPDATE, or delete a large amount of data, there are times when the transaction log is full, so resolve step 1. Connect to the current database to Uppdb2. View the database configuration file for uppdbThis command allows you to view database-related configurations, including character sets, log file sizes, and so onView the current database's log file size (LOGFILSIZ), number of primary

We all know the information about every archivelog in the controlfile, of course, after we delete these physical files under OS, in ourThese archivelog are still recorded in the Controlfile, and the visual logs in Oracle's OEM manager show that when we manually clear the files in the archive directory, the records are not erased from the controlfile. That is, Oracle does not know that these files are no longer in existence! This time we have to do the

Tags: ons att lib definition-name framework style--ringXml------------------------------------------------------------------- Context-param> Param-name>Log4jconfiglocationParam-name> Param-value>Classpath:log4j.propertiesParam-value> Context-param> Context-param> Param-name>Log4jrefreshintervalParam-name> Param-value>60000Param-value> Context-param> Listener> Listener-class>Org.springframework.web.util.Log4jConfigListenerListener-class> Listener> Log4j.properties----------

Tags: mongodb slow query Analysis script1 IntroductionThis is used in the production environment of a MongoDB slow query log automatic collection of scripts, the original idea to write this script is to facilitate the collection of slow query logs and facilitate analysis. Because the company's mognodb is not many, 4 units, so this small script is only applicable to ordinary production environment.The main use of the page bootstrap for the front-end di

the system, and if you do not need to install the Logminer tool, you must first run one of the following two scripts:A. $ORACLE _home/rdbms/admin/dbmslm.sqlB. $ORACLE _home/rdbms/admin/dbmslmd.sqlBoth scripts must be run as DBA users. The first of these scripts is used to create a DBMS_LOGMNR package that parses the log file. The second script is used to create a dbms_logmnr_d package that is used to create a data dictionary file.2. Modify Database Parameters--Database version [emailprotected]>

Oracle uses redo log files to record operations on the database, but redo log filegroups are recycled, when all log files are filled, the system automatically switches to the first set of log files, and of course the database administratorYou can also switch manually using commands. Log files that already exist in the log file when the log file is used for recyclingcontent will be overwritten. In order to fully record the operation of the database, Orale proposed the concept of archive

Here are two main:(1) Windows Event Log(2) SQL Server errorlog1. Windows Event LogAs a windows open and Managed service program, Windows logs in its own syslog system logSQL Server This service start, normal shutdown, abnormal shutdown and other information.SQL Server will also record some of its own profile information in the Windows Application Log application logAnd the Windows log itself can reflect the health of the operating system, whether ther

by recovering the redo log to its pre-outage state. LOG filegroup: 1. There are at least 1 redo log filegroups per InnoDB storage engine, and each group contains at least 2 redo log files (ib_logfile0,ib_logfile1). 2. You can increase the high availability of redo logs by setting up multiple mirrored log groups (mirrored log groups) and placing different groups on different disks. 3. The file size in the log group is consistent and runs in

Label:Java development process generally use LOG4J to log the program's running logs to the file, in the Oracle stored procedures also need to log, I will work in a log of my own package to share out, in fact, very simple, I hope that we have more comments.First, table structureIn order to be able to view the relevant logs for operations personnel, the log is best recorded in the table, the table informatio

The fast refresh mechanism for Oracle materialized views is done through materialized view logs. How Oracle can support a fast refresh of multiple materialized views through a materialized view log, this article simply describes how the refresh works.First, consider the structure of the materialized view:Sql> CREATE TABLE T (ID number, name VARCHAR2 (), num number);The table is created.Sql> create materialized view Log on T with ROWID, sequence (ID, n

Tags: rysnc sync linux system logs via service Screen toolfirst, RYSNC through the service synchronizationRsync is synchronized by serviceTo edit a configuration file/etc/rsyncd.confStart Service rsync--daemonFormat: Rsync-av test1/192.168.127.133::module/dir/ vim /etc/rsyncd.confRsyncd.conf Sample Exampleport=873log file=/var/log/rsync.logpid file=/var/run/rsyncd.pidaddress=192.168.127.133[test]path=/tmprsyncuse chroot=truemax connections=4read only=