Programmer Group

The general principle of mysqldump and the influence of DDL operation in the backup process of mysqldumpThe general principle of mysqldumpThe first caseThe second case The general principle of mysqldump and the influence of DDL operation in the backup process of mysqldump MySQL Version: 5.7.18 Isolation level: REPEATABLE-READ If th ...

I have always felt the shortcomings of the blog, but recently I found it difficult to find a blog I wrote before when it grew up. As a back-end developer, the owner felt he had enough clothes and clothes to eat, so he had the full-text search function of the blog, Elasticsearch, and thanks to a server sponsored by Phigo. Selection of Full Text ...

1. View disk space: Since it is a regular backup, we should choose a disk space with sufficient space to avoid the consequences of backup failure and data loss caused by insufficient space! __________ Storing on the current disk is the simplest, but it is the least recommended; servers have multiple hard disks, it is best to store backups o ...

This paper mainly introduces mysqldump and cron command of Linux to realize database backup every day. Mysqldump is often used for logical backup of MySQL database, and cron is the planned task of linux, which is to perform the planned work at the agreed time. 1. Creating shell scripts #!/bin/bash #The database backup path needs to be creat ...

MySQL Master-Slave Replication Practice-Log Point-Based Replication Log-point-based replication Establishment of special duplicate accounts on master and slave Libraries MariaDB [employees]> create user 'repl'@'172.%' identified by '123456'; Note that passwords in production must be in accordance with the relevant specifications to ...

-- select * from information_schema.processlist show processlist; -- View the user link show full processlist; kill id; /** View state Connections, the number of connections attempted to connect to (whether successful or not) MySQL servers. Max_used_connections, the maximum number of connections that have been used concurrently sin ...

mysql, mysqldump, mysqldump, php connection mysql service often prompts the following error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) There are generally two reasons for this problem: 1. The mysql service is not functioning properly: Since mysql's socket file is created when m ...