Programmer Think

1, Installing YUM Repo 1. Download command: wget https://dev.mysql.com/get/mysql57-community-release-el7-9.noarch.rpm 2, To install repo: rpm -ivh mysql57-community-release-el7-9.noarch.rpm [root@VM-0-10-centos server]# rpm -ivh mysql57-community-release-el7-9.noarch.rpm warning: mysql57-community-release-el7-9.noarch.rpm: He ...

1, Data security control 1. Access rights in relational database system 2. Authorization: Grant and withdrawal ① GRANT (GRANT permission) Grant < < Permission > [< Permission >] On < object type > < object name > [< object type > < object name >] To < user > [< user >] [WITH GRANT ...

MySQL lock 1. Concept of lock Lock mechanism: a rule designed by a database to ensure the consistency of data and use various shared resources to become orderly when accessed concurrently. For example, when purchasing goods on e-commerce websites, there is only one commodity in the commodity table, and at this time, two people buy at the sa ...

1. Overview of constraints 1.1 why constraints are needed Data Integrity refers to the Accuracy and Reliability of data. It is proposed to prevent the existence of data that does not comply with the semantic provisions in the database and to prevent invalid operation or error information caused by the input and output of error information. I ...

redis pipeline Beer theory, for example, there are 24 bottles of beer in the store. You can't take one bottle home and drink another. You need to find a box to carry the beer home together The buffer mechanism can also be understood in this way to avoid calling back and forth A request / response server can handle new requests even ...

preface How should we troubleshoot and analyze Mysql deadlock? There is an insert on duplicate deadlock problem on the front line of. Based on this deadlock problem, this paper will share the troubleshooting and analysis process, hoping to be helpful to you. Deadlock Case recovery Table structure: CREATE TABLE `song_rank` ( `id` int(11) NO ...

I BIND domain name service foundation In daily life, people are used to using domain names to access servers, but machines only recognize IP addresses. There is a many-to-one relationship between domain names and IP addresses. An IP address does not necessarily correspond to only one domain name, and a complete domain name can only corres ...

Mysql million data import 1. Method Import directly from the source sql file (not recommended)Load data infile command for import (recommended)Replace the engine, change the InnoDB engine of the table to MyISAM, and then import the data (not recommended)Import a single SQL statement of imported data into multiple SQL statements (recommended)O ...

1, Overview of relational database and non relational database 1. Relational database Relational database is a structured database, which is created on the basis of relational model (two-dimensional table model) and is generally record oriented. SQL statement (standard data query language) is a language based on relational database, whic ...

Introduction and comparison of a common redis client Jedis api online web address: http://tool.oschina.net/uploads/apidocs/redis/clients/jedis/Jedis.html Redisson website address: https://redisson.org/ redisson git project address: https://github.com/redisson/redisson Letuce website address: https://lettuce.io/ Letuce git project ad ...