Programming VIP

1, Demand analysis The following functions are required: 1) Basic addition, deletion, modification and query API 2) Query comments by article id 3) Comment like 2, Table structure analysis The data for storing article comments is stored in MongoDB. The data structure is as follows: Database: articledb Column comment Field nameField meaningF ...

Install MySQL using yum or up2date for Linux There are many ways to deploy MySQL database, including yum installation, RPM installation and compilation installation. Each installation method has its own advantages, so enterprises usually use rpm and binary installation. Download address of database official website: https://downloads.mysq ...

Recently, I was working on an openresty project. Every time I visit, I need to read redis through openresty to judge whether access can be allowed. Question: If you need to establish a connection with redis for each access, the number of connections will explode when the concurrency is large. Affect performance and system. Scheme I: In init ...

MySQL database optimization 1, Storage principle of Mysql Index correlation essence Index is help MySQL Ordered data structure for efficient data acquisition Build index to improve the efficiency of data retrieval and reduce the IO cost of database; Sorting data by index column reduces the cost of data sorting and CPU consumption. ...

Confirmation before installation Operating system: host name, IP address, hairstyle version, kernel version [root@localhost ~]# hostname localhost.localdomain [root@localhost ~]# [root@localhost ~]# ip -4 a 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 65536 qdisc noqueue state UNKNOWN inet 127.0.0.1/8 scope host lo valid_lft forever p ...

1: Download mysql source mysql8.0 Introduction: Performance: MySQL 8.0 is 2 times faster than MySQL 5.7. MySQL 8.0 brings better performance in the following aspects: read / write workload, IO intensive workload, and high competition ("hot spot") workload. NoSQL: MySQL has provided NoSQL storage function since version 5.7. At pre ...

MySQL Master-Slave Copy and Read-Write Separation Summary In enterprise applications, mature business usually has a large amount of dataSingle MySQL does not meet practical requirements in terms of security, high availability, and high concurrencyConfigure multiple master-slave database servers for read-write separation 1. Principle of m ...

The implementation here is based on MySQL 8. catalogue 1. Meaning and understanding of window function 2. Syntax of window function 2.1 understanding of window name syntax 2.2 understanding of sorting statements in Windows 2.3 understanding of window subset 2.4 window function 1. Meaning and understanding of window function Window fun ...

1 delayed loading concept Delayed loading: Data is loaded only when it is needed. Data is not loaded when it is not needed. Lazy loading is also called lazy loading. Benefits: query from a single table first, and then associate the query from the associated table when necessary, which greatly improves the database performance, because querying ...

Database front-end and back-end interaction from back-end to front-end tutorial II preface It is divided into two blogs, taking the student management system as an example to realize the front-end and back-end interaction (it is not designed here, but focuses on the operation process!) Some software involved in the following will be intro ...