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
MySQL uses binary logs to recover data two ways
If the MySQL server has binary logs enabled, you can use the MySQL tutorial Binlog tool to recover data starting at a specified point in time (for example, from your last backup) until now or another
In order to ensure data security, the data needs to be backed up regularly. There are a number of ways to backup, and the effect is different. Once there is an error in the data in the database, you need to use the backed-up data for restore
MYSQL binary solves mysql data case sensitivity problem bitsCN.com
MYSQL binary solves the case sensitivity problem of mysql data.
BINARY is not a function, but a type conversion operator. it is used to force a string after it to be a BINARY
Guide
In general, the development of small and medium-sized web sites have chosen MySQL as the site database, because of its community edition of Performance Excellence, with PHP, Linux and Apache can form a good development environment, after
MySQL binary log (binary log) Summary, mysqlbinary
Source: http://www.cnblogs.com/wy123/p/7182356.html(The Source retained is not the right of original works. My work is far from reaching this level, just to link to the original article, because
MySQL performance tuning and Architecture Design-Chapter 1 Performance Design-MySQL Replication and replication Optimization
Chapter 1 scalability design-MySQL Replication
Preface:
MySQL Replication is a unique feature of MySQL. It can completely
First, prefaceMySQL is a relational database management system, is the most popular relational database management system, because of its small size, fast, low total cost of ownership, and was completely open source, so popular. But since MySQL was
The source of this article: http://www.cnblogs.com/wy123/p/7182356.html(It is not the original works right to retain the source, I my book still far to reach, just to link to the original text, because the following may exist some errors to amend or
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
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.