Programmer Think

1, Network communication and service Network communication is the basic service of MySQL, including other related services derived from it, which constitutes the main way for MySQL client and server to complete interaction. The main functions include: 1. Network initialization and service initialization: including parameters, server and listen ...

The storage engine is a MySQL component that handles SQL operations of different table types. InnoDB is the default and most common storage engine. (the CREATE TABLE statement in MySQL 8.0 creates InnoDB tables by default.)To determine which storage engines your server supports, use the SHOW ENGINES statement. The value in the Support column in ...

1, Overview Stored procedures can be understood as a collection of SQL statements (equivalent to a function method in PHP to implement business logic). They are compiled in advance and stored in the database. Calling stored procedures has the same effect as directly executing SQL statements, but one advantage of stored procedures is that the ...

Original article publishing address: https://www.jianshu.com/p/d0e8b605c4ce Click "read the original text" or visit https://linkis.apache.org/#/ Learn more about Apache links Community developer: Maria Carrie GitHub : mindflow94   This article is mainly used to guide users to install and deploy Linkis and datasphere studio, and t ...

>* the original content of greatsql community cannot be used without authorization. For reprint, please contact the editor and indicate the source.1. Installation Preparation2. Initialize MySQL Server3. Initialize the first MGR node4. Continue to set the other two nodes5. Write data to MGR clusterReferences, documentsDisclaimersThis paper in ...

The server: Hardware server (personal computer, server in computer room -- blade server)ECS: (Alibaba cloud, Tencent cloud, Huawei cloud, etc.) Software server: You open a service on your PC or (cloud server). (software server). ftp server: default port: 21http server: default port: 80 (Apache, Nginx)https server: default port: 443mysql se ...

NOSQL NOSQL(Not Only Sql) is not only sql, but also refers to non relational database There is a very important type of database in non relational database: cache database Function: deal with data processing problems based on massive users and massive data. Relational database advantage: It is a disk database, and the data is ...

What is the architecture of master-slave replication? One master and one slave, write from the master library and read from the library The slave library can only be set as read-only, otherwise it will be messy to synchronize the writing of both the master library and the client. What is the role of master-slave replication? The function of ...

This article is from WeChat official account GitHub: From getting started to getting into the ground: a complete learning guide to MySQL, including teaching and learning! 1. Introduction to SQL SQL(Structured Query Language), whose semantics is a structured language, is an ANSI standard computer language. 2. Introduction to database 1. Data ...

If we only need a specified number of rows in the result set, use the LIMIT clause in the query instead of getting the entire result set and discarding additional data. MySQL sometimes optimizes rows with limit_ Query with count clause and no HAVING clause: If you use LIMIT to select only a few rows, MySQL will use indexes in some cases, but ...