Programming VIP

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. ...

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 ...

Firstly, the mybatis framework encapsulates sql statements and executes them through tag and attribute parsing in the form of xml. We know that the sql statements inserted into the table are: INSERT INTO table name (column 1, column 2,...) VALUES (value 1, value 2,...) During the insertion process, the database will add transactions by d ...

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 ...

affair What is a transaction Transaction is to execute a group of SQL statements in the same batchIf an SQL statement fails, all SQL statements in the batch will be cancelledMySQL transaction processing only supports InnoDB and BerkeleyDB Data table type Transactional ACID principle Atomicity All operations in the whole transaction are ...

Principle of master-slave replication The Master records the data changes in the binary log, that is, the file specified in the configuration file log bin, These records are called binary log eventsSlave reads binary log events in the Master through I/O threads and writes them to its relay logSlave redoes the events in the relay log and execut ...

Author: Zhang Yongli 1, Environment description of this example JDK 1.8CAS 5.3apache-maven-3.6.0mysql-5.6.32SuperMap iServer 10.1.3SuperMap iPortal 10.1.3 2, CAS 5.3 basic environment construction and verification Need reference CAS 5.3 server setup Set up the environment, and use the system default user name and password to verify. 3, C ...

In an article CentOS7 installation of MySQL (full version) , explain the process of offline installation of mysql database. This article will explain the master-slave configuration method of mysql database. After the master-slave configuration of mysql database, the backup of database and the separation of read and write can be realized, so as ...