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
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
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
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:
and provide relevant evidence. A staff member will contact you within 5 working days.