mysql error log

Check the MySQL error log and send an email notification if error is found. The script does not process the error log, so repeated checks are sent, so you can handle the error log on your own.The code is as

Like most relational databases, log files are an important part of the MySQL database. MySQL has several different log files, usually including error log files, binary logs, generic logs, slow query logs, and so on. These logs can help us locate

Error log:By default, the error log probably records the following areas of information:1. Information during server startup and shutdown (not necessarily error messages, for example, how MySQL launches InnoDB tablespace files, how to initialize its

ObjectiveThe log of the database is a strong basis for helping the database administrator to track the various events that have occurred in the database before. MySQL provides error log, Binlog log (binary log), investigate log, slow query log. Here,

with most relationship types database, log files are an important part of the MySQL database. MySQL has several different log files, usually including error log files, binary logs, generic logs, slow query logs, and so on. These logs can help us

1) Start:Sudo/etc/init.d/mysql start2) Stop:Sudo/etc/init.d/mysql stop3) Reboot:Sudo/etc/init.d/mysql restart4) View log:Cat/var/log/mysql.errCat/var/log/mysql/error.log5) not supported in ChineseChange/ETC/MYSQL/MY.CNFAdd the following in

MySQL log Type: Error log:-log-err query log:-log slow query log:-log-slow-queries update log:-log-update BINARY log: -log-binMySQL error logs are stored in the data directory. You can use find-name [hostname]. err to find the datadir MySQL log

Like most relational databases, log files are an important part of MySQL databases. MySQL has several different log files, such as error log files, binary logs, common logs, and slow query logs. These logs can help us locate the internal

1509091: 59: 00 [Note] C: Warning: Normalshutdown1509091: 59: 00 [Note] eventsched.pdf: Purgingthequeue.1events1509091: 59: 00 InnoDB: Startingshutdown... 1509091: 59: 00 InnoDB: Shutdowncompleted; log... buffermysqlsocket backup initialization

1) Start:Sudo/etc/init.d/mysql start2) Stop:Sudo/etc/init.d/mysql stop3) Restart:Sudo/etc/init.d/mysql restart4) View log:Cat/var/log/mysql.errCat/var/log/mysql/error.log5) not supported in ChineseModify/ETC/MYSQL/MY.CNFUnder [client], add the

150210 10:29:16 InnoDB:Warning:trying to delete tablespace '/tmp/#sql2069_87b001_1d. IBD ',Innodb:but there is 1 flushes and 0 pending I/O ' s on itInnodb:loop 1016.150210 10:29:16 InnoDB:Warning:trying to delete tablespace '/tmp/#sql2069_87b001_1d.

A few days ago a customer database primary instance alarm, the diagnosis process was found to be caused by a slow SQL database failure, and after the investigation of the gradual depth of the discovery of this phenomenon is inconceivable.Problem

There are 4 types of logs in MySQL: error log, genaral query log, Binary Log, and Slow query log**, error log records error, Warning, note and other information during MySQL operation, system You can view the error log if something goes wrong or a

The concept of Dual-machine Hot Standby is simply to maintain automatic synchronization of the two databases. Operations on any database are automatically applied to another database, and data consistency is always maintained between the two

Simple introduction MySQL dual-machine, multi-machine remote hot standby simple principle of actual combat.The concept of dual-machine hot standby simply say, is to maintain the status of two databases automatically synchronized. Operations on any

Learn a little about mysql dual-host hot backup-quickly understand the principle and practice of mysql master/slave backup Thank you for learning Git in the previous article-quick start with git in 20 minutes. Here we will share the dry goods and

a good run before the program, today suddenly can not run, background error: illegal mix of collations (utf8_unicode_ci,implicit) and (utf8_general_ci,implicit) for Operation ' = ' After the check is the back of the colleagues backstage last night

This article "My MySQL Learning experience (15)" will explain the MySQL logThe logs in MySQL are divided into 4 categories, and using these log files, you can see what's happening inside MySQL.respectively is1, error log: Log the MySQL service start,

MySQL database Optimization How should we optimize the MySQL database? Next I will explain this problem from MySQL's hardware selection, MySQL installation, my. cnf optimization, MySQL architecture design, and data splitting. Optimization of server

MySQL Log System details All those who have done large systems know that the log function is not to be underestimated. In the middle and late stages of the project, the optimization and upgrade of the project are based on the log to make the upgrade