the font configuration . /VAR/LOG/FSCK-File System log/var/log/faillog-Contains user logon failure information. In addition, the error login command is also recorded in this file./var/log/hp//var/log/install//var/log/jokey.log/v
information to perform a write operation5: Write before dbwn a checkpoints executes.Dbwn the function of this process (write the information of redo log files back to datafiles)Must write redo log first, and then write to the data file.How the online Redo days file works:Use the loop to understand the definition of log
Linux Log view-head command usage introduction, linux Log head command
The head command is used to display content starting with a file. By default, the head command displays the first 10 lines of the file.
NAME (NAME) head-output the first part of files part of SYNOPSIS (summary, outline) head [OPTION]... [FILE]... DE
into the database:
Mysqlbinlog--start-date= "2012-10-15 16:30:00"--stop-date= "2012-10-15 17:00:00"
mysql_bin.000001 >d:\1.sql SOURCE D:\1.sql
(2). Specify the start \ End position, from the above view generated binary log we can know the beginning of a log to the end of the position, we can in the process of recovery to specify the response
If you are willing to spend some time on the Linux environment, you should first know where the log files are located and what they contain. Learning about these different log files while your system is working properly can help you find and solve problems in emergencies.The following is a description of the 20
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
permissions.2. The Cron job format is as follows:1 * * * * * command to be executed2 -----3 | | | | | 4 | | | | -----Day of Week (0-7) (sunday=0 or 7)5 | | | -------Month (1-12)6 | | ---------Day of month (1-31)7 | -----------Hour (0-23)8 -------------Minute (0-59)Refer to the usage of the Http://www.cyberciti.biz/faq/how-do-i-add-jobs-to-cron-under-linux-or-unix-oses/,Cron job for details. 3. How do I check the execution of cron jobs through the logs?The function of ">>/home/user/cron_job.log
log_reuse_wait_desc columns of the sys.database catalog view.
log_reuse_wait Value
Log_reuse_wait_desc Value
Description
0
Nothing
There is currently one or more reusable virtual log files.
1
CHECKPOINT
No checkpoint has occurred since the last log truncation,
log files are files used to record various running messages in a Linux system, and different log files record different types of information, which can be helpful in diagnosing and resolving problems in the system. Parsing log fil
[file_name] option to start it. If there is no value for the given file_name, the default name is Host_name.log. 3. Slow query logWhen started with the--log-slow-queries[=file_name] option, Mysqld writes a log file containing all SQL statements that have been executed for more than long_query_time seconds. If the file_name value is not given, the default hostname is not The suffix is-slow.log. If a filenam
) select "Viewddl Commands" menu, "tr Uncate table action Item, click Salvage, generate statement, Query Analyzer, execute------------------------------------------------------------------------Several issues that log Explorer uses-------------------- --------------------------------------------------1) Make a full/differential/log backup of the database if you choose to delete the inactive entries in the t
timely manner after a log file in the log group is corrupted, so the same group of log members generally has the same content information, but the storage location is different.Read Redo log file informationThe data dictionary view V$lo
system user logins. This log file can be used to view the user's logon records. The last Command obtains this information by accessing this file and displays the user's logon records in reverse order, last can also display corresponding records based on the user, terminal tty or time.
/Var/run/utmp
This log file records information about each user Currently logg
Linux log view 1. view all the hardware information of the machine: dmidecode | more dmesg | more commands contain a large amount of information. Therefore, we recommend that you use "| more" to view more information. method 1: CPU-related parameters in Linux are saved in the/proc/cpuinfo file cat/proc/cpuinfo | more M
view Dba_free_space, you can understand the idle partitioning of the tablespace. Select tablespace_name,file_id, block_id,bytes,blocks from
dba_free_space; ALTER DATABASE datafile ' F:\SQL\USE0101.DBF '
resize 100m; To modify the auto-extended properties of a data file Autoextend Table Space State Properties By setting the Tablespace state, you can limit the availability of data
Offline offline: Unable to access data in table space, this
the-l [file_name] option. If there is no value for the given file_name, the default name is Host_name.log.3. Slow query LogWhen started with the--log-slow-queries[=file_name] option, Mysqld writes a log file containing all SQL statements that have been executed for more than long_query_time seconds. If the file_name value is not given, the default hostname is not The suffix is-slow.log. If a filename is gi
Git log view commit record, parameters:-N (n is a positive integer) to view the last N commit information$ git log-2 See the last 2 commit history--filename filename for any file name to view the submission information for the specified file. (Note: The file name should be p
file records the FTP session and can show what files the user has copied to the FTP server or from the server. The file shows the malicious program that the user has copied to the server to invade the server, and what files the user has copied for him to use.The format of the file is: The first field is the date and time, the second domain is the number of seconds to download the file, the remote system na
A. Shrinking a data file to a specified target sizeThe following example shrinks the size of a data file named DataFile1 in the UserDB user database to 7 MB. CopyUse UserDB; GODBCC Shrinkfile (DataFile1, 7); GOB. Shrinking a log file to a specified target sizeThe following example shrinks the log file in the ADVENTUREWORKS2008R2 database to 1 MB. To allow the DBCC shrinkfile command to shrink a file, you fi
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.