mysql log

Scene Reproduction:--------------------------------------------------------------------------------------------------------------- ------------The first step:Find the cause of the error, run-to-EVENTVWR and see what's wrongThe path to this

By default, the MySQL binary log file is saved in the default data directory, such as:/usr/local/mysql/dataTo modify the log save Directory (/backup/mysqlbinlog/mysql-bin):Log-bin entries in the/etc/my.cnf file, such as

transactional engine relies on transaction logs to ensure acid (atomicity, consistency, isolation, persistence)Therefore, the transaction log, the most important thing is to ensure the transaction reliabilityHow the transaction log works: Each line

LogTransaction log: Transaction logTrunk log: Reley log error log: Error logfileGeneral log:Slow query log: Slow query logBinary logs: Binary logTransaction logTransaction log: Transactional storage engine self-managing and using The

MySQL will use the log when troubleshooting, optimizationError log, query log, slow query log, binary logFind log files First, Linux generally in/ETC/MY.CNFOpen to seelog-error=/webserver/logs/mysql/error.log#log=/webserver/logs/mysql/mysql.loglog-

One, the MySQL engineMySQL's two main engines: MyISAM and InnoDBTo view the MySQL engine:1. View the supported engines: show engines;2. View the engine of the table: Show table status from DATABASE [where name= ' |like '];Show create table table

1. Query log is turned onShow variables like "Log_";2. Which log file is used for the queryShow master status;3. What time is the position deleted by mistake?/usr/local/mysql/bin/mysqlbinlog/usr/local/mysql/var/mysql-bin.000075In other words, 610 is

First, error logWhen a database fails to work, the first time to view the log1, the server starts the shutdown process information2. Error messages during server operationLog storage path, which can be viewed by command:Log file naming format:

1) Error logThe error log logs the start, run, and shutdown processes of MySQL.Locate the file by show variables like ' Log_error '.Mysql> Show variables like ' log_error '; +---------------+---------------------------------+| variable_name | Value

The MySQL master-slave structure is based on mysql incremental logs, which is different from the master-slave replication structure. In the master-master replication structure, data inventory occurs on any of the two servers. The MySQL master-slave

Implementing automatic data backup for mysql Databases in CentOS is a very important data and often needs to be backed up. manual backup is troublesome every time. This script backs up the database and retains the backup files of the last 15 days in

We know thatMySQL databaseAfter the installation is completeMy. cnf configuration fileMake proper modifications to make full use of the functions of the MySQL database. However, it seems difficult for beginners to modify the my. cnf configuration

The MySQL master-slave structure is based on mysql incremental logs, which is different from the master-slave replication structure. In the master-master replication structure, any changes to the data inventory on one of the two servers will be

MySQL5.7 binary installation for windows and mysql5.7 binary InstallationIntroduction 1. Download and decompress : Http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.14-winx64.zip Decompress and rename the downloaded mysql to C: \ Program Files \

Test environment: 192.168.1.192 192.168.1.193  mysql5.2   Configuration 192 server:  /usr/local/mysql/bin /mysql-uroot-p Authorization:  grant replication Slave,file on * * to ' xm1 ' @ ' 192.168.1.193 ' identified by ' 100200 '; Refresh:  flu SH

Starting MySQL. error! The server quit without updating PID file (/usr/local/mysql/var/***.pid) Today, restart the server or LNMP service when the above prompts, groping for a long time, is the manual deleted the MySQL log file out of the problem,

The MySQL primary and standby architecture is based on the MySQL incremental log and differs from the master-slave replication structure. In the primary replication structure, changes to the data inventory on either of the two servers are

Enable slow Log There are two ways to enable: 1, in MY.CNF through Log-slow-queries[=file_name] 2, when the mysqld process is started, specify the--log-slow-queries[=file_name] option Five common tools for

##############################2017-08-08 notesFirst, optimize the part1. Tuning of operating system parameters2. Database Parameter tuning3. Firewall settings, etc.#############################Second, the installation part1. Create users and Groups#

1. Installation DependenciesYum install-y cmake Bison bison-devel libaio-devel gcc gcc-c++ git ncurses-develwget https://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.20.tar.gzwget