NAV: SLTechnology News&Howtos > Database >

• 

  Understanding of the concepts of database index, view, trigger, stored procedure, cursor, etc.

  Understanding of indexes, views, cursors, stored procedures and triggers Index 1, Index 1-1, Overview of Indexes We combine one or more columns in a table and the physical addresses recorded in the table of the elements in the column into a new table. The record of this table is roughly

  2022-06-01 15:58:42 Views: 289
• 

  Comparison of TIDB Architecture and distributed protocols Paxos and Raft

  Recently, newsql is very hot, especially TIDB. Pingcap continues to polish TiDB. Now the version has been iterated to 3.0, and the product has basically matured. For TiDB, the overall architecture diagram is composed of four modules, TiDB Server,P, as shown in the following figure

  2022-06-01 15:58:38 Views: 269
• 

  Oracle Learning Notes-Database Import and Export

  1. Importing and exporting Oracle backups are common tasks in oracle operations. Common backup schemes include: 1. Logical backup (IMP&EXP command for backup) there are four modes: (1) tablespace backup (tablespace) (2) tabular backup (t)

  2022-06-01 15:58:30 Views: 298
• 

  Three-dsys

  The main content of today's work is that Oracle's AWR report generation command is as follows: ssh 172.16.4.33password: * root@localhost/: # su-oracleoracle@lo

  2022-06-01 15:58:30 Views: 208
• 

  Galera Cluster of MySQL High availability Architecture

  The Galera Cluster1, lab preparation, and topology of the MySQL high availability architecture require at least three nodes node1 192.168.150.137node2 192.168.150.138node3 192.168.15

  2022-06-01 15:58:29 Views: 226
• 

  Keepalived+ double host

  [root@mini1 ~] # setenforce 0 [root@mini1 ~] # systemctl stop firewalld.service [root@mini1 ~] # vim / etc

  2022-06-01 15:58:29 Views: 255
• 

  JOB_QUEUE_PROCESSES parameter

  JOB_QUEUE_PROCESSES specifies the maximum number of job slaves per instance that can be created for

  2022-06-01 15:58:29 Views: 233
• 

  Set the default character set for mysql

  Mysql > show global variables like'% charac%';-- View the character set mysql > show global variables like'% se used by the current mysql

  2022-06-01 15:58:29 Views: 233
• 

  # SQL beginner's Guide # Learning Notes (1)

  The Tip1:SQL sentence should be logically analogous to English (adverbial post). Is a nDML (Data Manipution Language) data manipulation language that focuses only on relational databases, that is, data manipulation; DDL (Data)

  2022-06-01 15:58:28 Views: 276
• 

  Mysql uses PHP scripts to create databases

  In some open source systems, database names and database data can be created dynamically. Mysql uses PHP scripts to create databases to briefly explain the principle of generation. 1, the function mysqli_connect () m used

  2022-06-01 15:58:28 Views: 301
• 

  Seconds_Behind_Mas Analytical ter solution to Seconds_Behind_Master inaccuracy problem

  Seconds_Behind_Master inaccurate problem Seconds_Behind_Mas analysis ter solution 1. Seconds_Behind_Master description: s found through show slave status

  2022-06-01 15:58:28 Views: 214
• 

  With the help of cloud computing, mobile phones can also play high-quality games.

  Many high-quality game masterpieces, so that players in the square inch, enjoy the sound dripping, at the same time, the requirements of the terminal configuration is also getting higher and higher, players need to wait for the download and loading time is also getting longer and longer, which is undoubtedly hindering more players to reach the fun of high-quality games. With the rapid development of cloud computing and 5G technology

  2022-06-01 15:58:22 Views: 282
• 

  How does mysql view the storage engine of the table

  1. Check the engine provided by mysql. MariaDB [(none)] > show engines;+--

  2022-06-01 15:58:22 Views: 238
• 

  Transaction and isolation levels of the database

  This article will explain in detail the transaction and isolation level of the database. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article. A transaction refers to a set of operations that satisfy the ACID feature, which can be done through Commit

  2022-06-01 15:58:13 Views: 222
• 

  SaltStck sets up Web Cluster-Job Management

  In SaltStack's default working mode, the minion side returns the data directly to the mysql database, and master is not required to participate in this process. By providing more flexible management, the execution result of the minion side can also be saved on the master side (j

  2022-06-01 15:58:03 Views: 263
• 

  What are the three modes of Redis

  What are the three modes of Redis? Many people may not have an in-depth understanding of this, so the editor summarized this article, through the explanation of this article, I hope you can gain more knowledge. Standaloan (stand-alone mode) standaloan is redis stand-alone mode

  2022-06-01 15:58:03 Views: 241
• 

  Encryption processing and Security measures of password in php

  Keeping plaintext passwords in the database is a very unwise choice, and its harm is self-evident. Instead of discussing the shortcomings of plaintext passwords, we will only talk about how to save passwords securely. Basic security measures are as follows: 1. Set the minimum number of password digits 2. Encrypt and save the user's password 3. By resetting the password once

  2022-06-01 15:57:36 Views: 298
• 

  Introduction to transaction Model of MySQL

  In this issue, the editor will introduce the transaction model of MySQL, analyze and describe it from a professional point of view. I hope you can get something after reading this article. MySQL transaction atomicity guarantees that transaction atomicity requires that a series of operations in the transaction either be completed or

  2022-06-01 15:57:36 Views: 216
• 

  How does redis configure remote connections

  How does redis configure remote connections? In fact, it is not difficult to solve this problem. This article gives the corresponding analysis and solution. Let's take a look at the solution. General steps to open a remote connection: 1. Block local binding information 2. Add requirepass3, restart.

  2022-06-01 15:57:24 Views: 228
• 

  The use of SQL_MODE in MySQL

  This article will explain in detail about the use of SQL_MODE in MySQL. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article. SQL_MODE is a system variable in MySQL (varia

  2022-06-01 15:57:20 Views: 269