NAV: SLTechnology News&Howtos > Database >

• 

  Index and transaction of MySQL, storage engine MyISA and InnoDB

  MySQL Index and transaction, View, Storage engine MylSAM and lnnoDB Index the index in the conceptual database is similar to the catalog in the book: 1. In a book, you can quickly find the required information by using the catalogue without reading the whole book. The catalogue in the book is a list of words, in which

  2022-06-01 22:26:19 Views: 270
• 

  Backup and restore of Dameng Database

  Backup and restore of Dameng database: physical backup restore and logical backup restore physical backup: cold backup: (when the dmap service is open, the database is closed) hot backup: (the dmap service must be open, the database is open, the database needs to be archived)

  2022-06-01 22:26:19 Views: 276
• 

  MongoDB start and shut down command

  1. Start the MongoDB command net start MongoDB2. Enter the MongoDB background command mongo3. View the current operation of the document command db4. Turn off the MongoDB service command net stop MongoDB

  2022-06-01 22:26:06 Views: 247
• 

  Mongodb related (single instance, replication set, sharding set)

  1. Build a single instance of mongodb 1, download package address 1, download address https://www.mongodb.org/downloads2 of each version, and install the latest version of 3.6.5wget https://fastdl in this article.

  2022-06-01 22:26:04 Views: 210
• 

  PXC Cluster Construction of MySQL5.7

  New pxc001 server: system: centos7 memory: 2G disk: 128GIP address: 192.168.0.201 (first node) 192.168.0.202192.168.0.203#vi / etc/selinux

  2022-06-01 22:26:03 Views: 236
• 

  5. Configure the mongo command line

  5. The latest content of the configuration mongo command line will be updated at the origin server. To reprint, please keep the original link: http://dashidan.com/article/mongodb/index.html ① .mongorc.js file Mongo

  2022-06-01 22:25:51 Views: 277
• 

  The Shell script deploys MongoDB with one click

  Shell script one-click deployment of MongoDB basic implementation ideas: install MongoDB → to create multiple instances (the number of instances can be customized according to the needs) → open all instances and show port #! / bin/bash# automatic installation MongoDB## check MongoDB

  2022-06-01 22:25:51 Views: 222
• 

  Oracle ASM fault data recovery

  1. Fault description: the ASM disk group is offline and the ASM instance cannot be mount. The ASM disk group is composed of four 500G disks, and the database and ASM software is 10.2.0.1. It is urgent to restore the oracle database. Fault Analysis and Analysis of the disks that make up the ASM disk Group

  2022-06-01 22:25:51 Views: 247
• 

  Full and incremental backup and recovery of MySQL

  The importance of data backup in the production environment, data security is very important, any loss of data may have serious consequences resulting in the cause of data loss. Program error 2. Human error 3. Computer failure 4. Disk failure 5.zai difficulty and stealing database backup classification physical backup

  2022-06-01 22:25:33 Views: 230
• 

  MongoDB Notes (3)

  1. MongoDB data query (1) MongoDB uses find function to query data, its function is the same as select function in SQL, and can provide many functions similar to relational database, including mapping, sorting and so on. Db. Collection name. Find (que

  2022-06-01 22:25:28 Views: 262
• 

  Summary of faults in unused field by GoldenGate

  Yesterday, the business department responded to the need to delete the fields of a table and thought about setting the fields to the state of unused, which is very convenient to restore if needed. This morning, it was found that there was a failure in OGG data replication, the main library EXTRACT process appeared ABENDED status, and the data was not synchronized. From OGG Day

  2022-06-01 22:25:28 Views: 244
• 

  Centos 6 Pinpoint environment built successfully

  Centos 6 Pinpoint environment set up and install jdk1.6, 1.7,1.8 Note: during installation, it is found that the latest pinpoint 1.5.2 does not seem to be compatible with the latest JDK1.8, so set system environment variables and jre with j

  2022-06-01 22:25:28 Views: 243
• 

  Today, the Amazon consumer business has completely abandoned the Oracle database

  Today, Jeff Barr, AWS's chief evangelist, revealed on his blog that the Amazon consumer business has officially completed the migration of the Oracle database, shutting down the final Oracle database. Amazon has nearly 7500 Oracle databases, 7

  2022-06-01 22:25:25 Views: 225
• 

  Query the actual size of DB table

  1. Query the actual size of the DB table (ensure large clob/blob/nclob lob fields) select round (sum (bytes/1024/1024/1024), 2) | |'G' from dba_segme

  2022-06-01 22:25:24 Views: 289
• 

  [MongoDB] manage command collection

  [TOC] slow query / / enable slow query record db.setProfilingLevel over 2000 milliseconds / / View the last 5 slow query show profile// query db.sy in reverse order according to the execution time of slow query

  2022-06-01 22:25:24 Views: 259
• 

  Redis-initial knowledge of installation

  Redis is an open source, BSD licensed, advanced key-value storage system. Can be used to store strings, hash structures, linked lists, collections are often used to provide data structure services. Compared with memcached, redis is unique: 1: redis can be used to

  2022-06-01 22:25:24 Views: 253
• 

  In-depth understanding of MDL metadata locks

  When you execute a SQL in MySQL, the statement is not completed within your expected time. At this time, we usually log in to the MySQL database to see if there is anything wrong. One of the commands we usually use is show processlist.

  2022-06-01 22:25:24 Views: 202
• 

  Install mongodb under linux

  1. Download the installation package wget http://fastdl.mongodb.org/linux/mongodb-linux-i686-3.0.6.tgz and unzip the tar zxf mongodb-l package after the download is complete

  2022-06-01 22:25:20 Views: 246
• 

  Oracle RAC manual rollback patch

  Stop the CRS managed resources running from DB homes.If this is a GI Home environment, as the databa

  2022-06-01 22:25:20 Views: 222
• 

  Talking about-- MySQL Storage engine

  Blog outline: first, MyISAM storage engine; second, InnoDB storage engine; third, Memory storage engine characteristics; fourth, how to choose the appropriate storage engine? Fifth, the default engine for viewing and modifying tables the database storage engine is the underlying software component of the database, the database management system

  2022-06-01 22:25:20 Views: 220