Database lock table? Don't panic. This article teaches you how to solve it

introduction As developers, we often deal with databases. When we modify the database, such as adding fields and updating records, we do not correctly evaluate the frequency of use of the table at this time, so we directly modify it, resulting in a long time of unresponsiveness to the modification operation and locking the table. In mysql, if ...

Added by drewbie on Mon, 22 Nov 2021 12:59:04 +0200

A script for automatically backing up MySQL

Students of background development and operation and maintenance are certainly familiar with MySQL backup. Regular online database backup is necessary, and this process is generally automatic. This paper will introduce a shell script, which has the function of automatically backing up MySQL and automatically clearing expired backup data Back ...

Added by shan111 on Thu, 04 Nov 2021 03:08:22 +0200

Day 04 ssl encrypted connection and password plug-in

Connect MySQL instance Connect via local socket mysql -S /tmp/mysql.sock -u root -pConnect via TCP/IP mysql -u tbs -pTbs_SOft!Connect through my.cnf configuration file -- Production view socket Where are the files tbs@localhost:[(none)]>show variables like "socket%"; +---------------+-----------------------------+ | Variable_name | Value ...

Added by capitala on Sun, 24 Oct 2021 17:39:50 +0300