NAV: SLTechnology News&Howtos > Database >

• 

  Understanding of several kinds of name in oracle

  Oracle several meanings of name db_name: database name: show parameter db_name,db_name also plays a very important role in dynamically registering listening, regardless of whether service_name is specified, or

  2022-06-01 21:19:08 Views: 242
• 

  MySQL full backup and recovery

  The importance of database backup: in a production environment, the security of data is critical, and any loss of data may have serious consequences. The importance of database backup is mainly reflected in: 1. Improve the high availability and disaster recoverability of the system, when the database system crashes, there is no database backup

  2022-06-01 21:18:08 Views: 306
• 

  Database MYSQL Learning Series 3

  Database MYSQL Learning Series 3 3. MySQL transaction and Storage engine 3.1-what is a database transaction? a series of orderly database operations: O either succeed or fall back to the state before the operation. Basic operation of transactions invisible to other connections: o intermediate state: |

  2022-06-01 21:18:07 Views: 295
• 

  Complete the comparison of MySQL database structure in 10 seconds

  In the production environment, we always cause master-slave synchronization for one reason or another, or the test environment needs to be synchronized with the production environment. Using the Navicat structure synchronization tool, we can not only find out the differences in library structure, but also aim at create, modify, drop and so on.

  2022-06-01 21:17:58 Views: 254
• 

  Detailed method of directory migration of mysql database under linux

  Today, Xiaobian shares with you the detailed method of mysql database directory migration under linux, which many people don't know very well. In order to let you know more about the method of mysql database directory migration under linux, Xiaobian summarized the following contents and looked down together. one

  2022-06-01 21:17:52 Views: 234
• 

  The use of percona toolkit tools

  -- View user rights pt-show-grants example: pt-show-grants-u "user"-p "password"-h IP-P PORT

  2022-06-01 21:17:52 Views: 244
• 

  The method of backing up mysql Database with xtrabackup

  Today, what the editor shares with you is the method of using xtrabackup to back up mysql database, which many people don't know very well. Today, in order to let you know more about how xtrabackup backs up mysql database, the editor summarizes the following contents and goes to

  2022-06-01 21:17:48 Views: 263
• 

  On the use of query limit in MySQL Database

  Today, the editor to share with you is about the use of MySQL database query limit, many people do not understand, today, in order to let you know more about the use of MySQL database query limit, so give you a summary of the following content, let's look down. I'm sure it will.

  2022-06-01 21:17:46 Views: 216
• 

  Detailed introduction of Index in MySQL Database

  Today, the editor to share with you is a detailed introduction of the index in the MySQL database, many people do not understand, today, in order to let you know more about the index in the MySQL database, so give you a summary of the following content, let's look down. I'm sure you'll get something. 1. Summary cable

  2022-06-01 21:17:35 Views: 232
• 

  Mysql master-slave replication and read-write separation

  Lab Topology: address assignment: Client 192.168.1.1Amoeba 192.168.1.2Mysql-Master 192.168.1.3Mysql-slave1 192.168.1.4 MySQL-

  2022-06-01 21:17:28 Views: 209
• 

  Explain in detail about the addition, deletion, modification and query of MySQL database

  With the development of the Internet, more and more people have entered the IT industry, so how much do you know about the addition, deletion, modification and query of the MySQL database? In order to let you know more about the additions, deletions, modifications and queries of the MySQL database, the editor summarizes the following, let's look down together. Create a database CR

  2022-06-01 21:17:24 Views: 284
• 

  What should be done to configure automatic backup of mysql database in centos

  What should I do to configure automatic backup of mysql database in centos? Many people do not know much about it. Today, in order to let you know more about the method of configuring automatic backup of mysql database in centos, I have summarized the following contents. Let's look down together. 1. View magnetism

  2022-06-01 21:17:21 Views: 259
• 

  Detailed explanation of database hash connection about the new features of MySQL

  This article mainly introduces the database hash connection detailed explanation of the new features of MySQL, the sample code is very detailed, has a certain reference value, interested friends can refer to. Overview for a long time, MySQL performed the only algorithm for the connection

  2022-06-01 21:17:15 Views: 218
• 

  Oracle console OEM failed to start

  Today, I opened the newly installed oracle console and found that it could not be opened. The message is: the database is closed. Please specify the host × × Ming to access the database restart and diagnostic tools. We have encountered this situation before, starting the service by starting listening: lsnrctl start

  2022-06-01 21:17:14 Views: 216
• 

  AD-Powershell for Active Direc

  Computer object commandsList all computer accounts in a domainGet-ADComputer-Filter {Name-Like "*"

  2022-06-01 21:17:14 Views: 237
• 

  Commands related to MongoDB database establishment, permissions, and roles

  1) create custom database use syntax: use database name example: use goodsdb / / execute instructions under Shell environment: if goodsdb database does not exist, Bay IJ newly established database; if goodsdb database exists

  2022-06-01 21:17:02 Views: 217
• 

  [Oracle] detailed description of Oracle Database 12c Release 2 installation

  Installation package oracle official website address please own Baidu oracle,51CTO content restrictions do not let me play! 1) Open the official website and find the download link, as shown in the figure. 2) Select more downloads. 3) Select the database version, which is the latest version 4)

  2022-06-01 21:16:32 Views: 287
• 

  MongDB replica set

  Official website: https://docs.mongodb.com/v3.4/reference/replication/ Chinese website: http://www.mongodb.org.cn/manual/metho

  2022-06-01 21:16:32 Views: 230
• 

  Share the thinking and solving process of mysql query interview questions

  What the editor shares with you today is the thinking and solving process of sharing mysql query interview questions a few days ago. When I encountered this question in the written test, I read it several times and was confused. "for at least N days in a period of time, the total score of every day in these N days is greater than M", easy to circle, and finally did not write correctly. Today I want to

  2022-06-01 21:16:29 Views: 305
• 

  What is the problem with Redis blocking?

  What is the problem with Redis blocking? Many people don't know much about it. Today, in order to give you a better understanding of the cause of Redis blocking, let's summarize the following. Let's take a look at it. Redis is a single-threaded architecture, and all operations are in one main thread.

  2022-06-01 21:16:25 Views: 296