Create Database hufangOn Primary -- by default, it belongs to the primary main file group, which can be omitted(/* -- Specific description of the data file --*/Name = 'hufang _ data', -- physical name of the primary databaseFilename = 'f: \ project \ hufang_data.mdf ', -- physical name of the primary databaseSize = 5 MB, -- initial size of the primary databaseMaxsize = 100 MB, -- maximum file growth for the master databaseFilegrowth = 15%)
Log On(/* -- The specific description of the log file is
Microsoft ole db provider for SQL Server Error '80040e14'
The log of database 'mis1' is full. Back up the transaction logs of the database to release some log space.
A simple method is used to contract logs:
1. backup log... with no_log2. shrink the database
OK, synchronization is in progress again ....
Answer:
Check whether the log mode of the database is full? This mode generates a huge amount of
Tags: blog HTTP, ar file data, art, Problem C
Redo log file is written by the lgwr process from the redo log buffer in the Oracle instance and is recycled. That is to say, a redo log file (group) is written to the next one only after it is fully written.Archive log: When the database is running in archive mode, when a redo log file (group) is full, the arcn process backs up the redo log content to the archive log file, then the redo log file (Group) can be used for the next time.
Whether or not
Analysis of linux logs and linux logs
In linux, the connection time logs are generally recorded by the/var/log/wtmp and/var/run/utmp files. However, these two files cannot be directly viewed by cat, the file is automatically updated by the system. You can view the file by using the w, who, finger, id, last, lastlog, and ac commands.
For process monitoring
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
How to deal with the rapid growth of oracle archive logs, oracle archive logs
Oracle archive logs are generally generated by dml statements, so the increase speed should be too frequent by dml.
First, query the generation of the following daily archives:
Select trunc (FIRST_TIME) "TIME ",SUM (BLOCK_SIZE * BLOCKS)/1024/1024/1024 "SIZE (GB )"From v $ ARCHIVED_LOGGr
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
Comparison between LOGMNR mining logs and DUMP logs many people know that LOGMNR is used to analyze logs, but few people use DUMP to analyze logs. This is because the information analyzed by LOGMNR is easy to read and understand. but sometimes we still need to DUMP to analyze the log file, because it records more detai
A basic tutorial on querying logs and slow query logs in MySQL,
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 large, it also has a great impact on the performance after enabling them. Therefore, please use this function with caution
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
:30 21 * * * means 21:30 per night45 4 1,10,22 * * = 4:45 per month for 1, 10, 22ndnow is the official code that compresses the logs for one months and deletes them .Create a new. sh file under Logs's sibling directory for example: logzip.shContent:Echo"Please wait ..."m= ' date-d"1 months ago"+%y-%m ' #获取上个月的yyyy-date string in mm format m2= ' date-d"1months ago"+%y%m ' Index=0F= ' Ls/home/hls/apache-tomcat-7.0.61/
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
Let's talk about MySQL deadlocks and logs in detail, and talk about mysql logs in detail.
Recently, several successive data exceptions occurred in MySQL in the early morning. Due to the typical data warehouse-type application in business scenarios, the daily stress is low and cannot be reproduced. Even some exceptions are quite strange, and the root cause analysis is very costly. In practice, how can we qui
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.