Programming VIP

Advanced chapter of Lesson 8_ Indexes I MySQL Linux Installation 1. Prepare Linux server CentOS 7.0 Final shell connection server 2. Download MySQL installation package for Linux www.mysql.com Download Community Edition (free) 3. Upload MySQL installation package 4. Create a directory and unzip it mkdir mysql tar -xvf mysql-8.0.rpm-bu ...

4. Performance analysis 4.1 common performance bottlenecks of MySQL ① CPU: when the CPU runs at full load, it usually occurs when the data is loaded into the memory or read from the disk; ② IO: the disk IO bottleneck occurs when the loaded data is much larger than the memory capacity; ③ Server hardware bottleneck: check the performance an ...

MySQL index type Original link: https://www.cnblogs.com/luyucheng/p/6289714.html 1, Introduction MySQL currently has the following index types: 1. General index 2. Unique index 3. Primary key index 4. Combined index 5. Full text index 2, Statement CREATE TABLE table_name[col_name data type] [unique|fulltext][index|key][index_name](col_name ...

Lesson 4 Basic _ constraint 1. Summary 1. Concepts Rules that act on fields in a table to restrict data stored in the table. 2. Purpose Ensure that the data is correct, valid and complete. 3. Classification constraintdescribeKeywordNon-empty constraintRestrict the field to data that cannot be nullNOT NULLUnique ConstraintEnsure that all ...

View ifconfig of docker server docker network principle Docker uses Linux bridging. A docker container bridge (docker0) is virtualized in the host. When docker starts a container, it will assign an IP address to the container according to the network segment of docker bridge, which is called container IP. At the same time, docker bridge ...

Lesson 5 Basic _ multi-table query 1. Multi-table relations In project development, when designing database table structure, the table structure will be analyzed and designed according to the business requirements and the relationship between business modules. Because business is related to each other, there are also various connections among ...

1, View View is a virtual table (non real). Its essence is to obtain a dynamic data set according to SQL statements and name it. When using, users only need to use the name to obtain the result set, which can be used as a table. Using the view, we can pick out the temporary table in the query process and implement it with the view. In t ...

sql common pit + optimization How many of the eight common SQL misuses did you get? Alibaba cloud RDS expert delegation Java 2022-02-28 09:09 Introduction: Alibaba cloud RDS expert service team has helped cloud customers solve many urgent problems. Some common SQL problems in ApsaraDB expert diagnosis report are summarized as follows for your ...

Original link https://cloud.tencent.com/developer/article/1582434 1. Preface We often use timed tasks in daily project development. For example, make statistics and settlement in the early morning, start planning activities, automatically change the unpaid orders that exceed 24 hours to cancelled status, and automatically change the orde ...

I summary What is RPC? Remote service callOfficial: the idea of requesting services from remote computer programs through the network without understanding the underlying network technologyA little more popular: without knowing the details of the call, the client calls an object that exists on the remote computer, just like calling an objec ...