Complete Debian 7 configuration LAMP (Apache/MySQL/PHP) environment and building station - 2015
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
Mysql - get [this month, last month] data to compare sql
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
Django framework: design model
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
EMQ X plug-in persistence series MySQL MQTT data store
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
18 MySQL middleware proxysql realizes mysql read-write separation
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
MySQL learning - common database commands
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 ...
Posted by Giri J on Mon, 13 Jan 2020 19:51:16 -0800
ZABBIX 3.4 from entry to mastery
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 ...
Posted by PlasmaDragon on Mon, 13 Jan 2020 19:28:10 -0800
How do I view all foreign keys for a table or column?
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 ...
Posted by Bike Racer on Mon, 13 Jan 2020 18:04:15 -0800
Use Binlog logs to restore mistakenly deleted MySQL data
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 ...
Posted by m2babaey on Mon, 13 Jan 2020 16:54:40 -0800
In the face of 100 million data, in addition to database and table, you should also understand Mysql partition table
What is partition table
Partition is to decompose a table into smaller and more manageable parts according to certain rules. Logically, there is only one table, but in fact, the table may be composed of N physical partition objects. Each partition is an independent object, which can be processed independently and as a part of the table.
Smal ...
Posted by jeppers on Mon, 13 Jan 2020 04:57:57 -0800