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. Add a global read lock to the backup library: fl ...
Posted by djopie on Thu, 16 Jan 2020 09:39:26 -0800
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, ...
Posted by l3asturd on Thu, 16 Jan 2020 09:27:57 -0800
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 ...
Posted by rockroka on Thu, 16 Jan 2020 06:40:42 -0800
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 ...
Posted by pocobueno1388 on Wed, 15 Jan 2020 03:06:21 -0800
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, ...
Posted by bob on Wed, 15 Jan 2020 01:36:11 -0800
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 ...
Posted by palace on Tue, 14 Jan 2020 21:33:23 -0800
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
Posted by Giri J on Mon, 13 Jan 2020 19:51:16 -0800
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 ...
Posted by PlasmaDragon on Mon, 13 Jan 2020 19:28:10 -0800
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.
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 ...
Posted by Bike Racer on Mon, 13 Jan 2020 18:04:15 -0800
"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 ...
Posted by m2babaey on Mon, 13 Jan 2020 16:54:40 -0800