Programmer Group

cp command backup is a warm, full backup, the backup process needs to maintain a global read lock, this lock is more lethal to the database, it is likely to make the database hang in production environment, so it is not recommended to use in production environment. 1. Backup 1. Add a global read lock to the backup library: fl ...

Learn from this In this article, I will share my other favorite DEBIAN system environment. It may be preferred by novices One click installation package , but this step installation is more clear about what you need to install, and it can save resources. Some components do not need to be installed, ...

When receiving business requirements, it is necessary to analyze the data comparison between current month and last month for each business type. During data query, one problem needs to be solved: all business types of current month and last month need to be displayed, but some business types of last mo ...

1. Design model We used to operate the database by writing sql statements. Can we operate the database without writing sql statements? Of course, it's time to use the ORM framework. 1.1 ORM framework O is object, which means class object, R is relation, translated into Chinese is relation, which means data table in relational database, M is map ...

In this paper, the actual example in CentOS 7.2 is used to illustrate how to store the relevant MQTT data through MySQL MySQL is a traditional relational database product. Its open architecture makes users highly selective. With the gradual maturity of technology, MySQL supports more and more functions, ...

1. The way of separating read from write in MySQL There are several ways for mysql to achieve read-write separation: The program modifies mysql operation, communicates with database directly, realizes load balance in a simple and quick way with separation of reading and writing and random way, and di ...

Pycharmlog in to MySQL 1. Create project 2. Click the Database button on the right3. Enter the user name and password of mysql in the pop-up edit boxIf Server returns invalid timezone. Go to 'Advanced' tab and set 'serverTimezone' profile error is prompted, please refer to: Problem solving Database ...

zabbix Foundation Chapter 1 about zabbix 1.1 why to use monitoring 1. Continuous real-time monitoring of the system2. Real time feedback system current status3. Ensure service reliability and safety4. Ensure the continuous and stable operation of business 1.2 how to monitor For example, we need to monitor disk utilization1. How to view disk u ...

stay MySQL How to get a list of all foreign key constraints to a specific table? Specific columns? This and The Oracle problem Same, but for MySQL. #1 building Post old answers to add some useful information. I have a similar problem, but I also want to look at constraint'u type and referred t ...

Preface "Delete library and run" is a topic that programmers often talk about. Today, I will teach you how to delete!Library!Run!Road! Just kidding, the topic of this article today is how to use Mysql's built-in Binlog log to recover mistakenly deleted data. After reading this article, you ...