NAV: SLTechnology News&Howtos > Database >

• 

  Commands commonly used in MongoDB

  If you want to see which database the current connection is under, you can directly type db > dbAdmin to switch to the test database > use testswitched to db test > dbTest to see which tables or called

  2022-06-01 16:03:13 Views: 260
• 

  Detailed explanation of oracle11g installation

  1, installation options: select "create and configure database" (oracle itself is only a platform, there can be several databases on this platform) 2, system class: selected for the "server class" (desktop class-this kind of installation is generally suitable for desktops and laptops. It contains a minimum number.

  2022-06-01 16:03:13 Views: 223
• 

  How to set up and access redis database

  Redis is a high-performance key-value database. The emergence of redis makes up for the deficiency of key/value storage such as memcached to a great extent, and can play a good complementary role to relational database in partial situations. It provides Jav

  2022-06-01 16:03:04 Views: 225
• 

  How the redis cluster allocates hash slots

  Redistribute hash Cao: ip:port is the current redis cluster any node ip and portredis-cli-- cluster reshard ip:port operation as shown in the figure: there are two ways to allocate hash slots: 1. Take out the right amount in other nodes.

  2022-06-01 16:02:54 Views: 217
• 

  How to shut down a redis Cluster cluster

  A Redis cluster is a facility (installation) that can share data among multiple Redis nodes. Redis clusters do not support Redis commands that need to process multiple keys at the same time, because the execution of these commands requires multiple R

  2022-06-01 16:02:54 Views: 218
• 

  The method of preventing data loss by message queue in redis

  Preface: redis is a key-value storage system. Similar to Memcached, it supports relatively more value types for storage, including string (string), list (linked list), set (collection), zset (sorted s)

  2022-06-01 16:02:54 Views: 277
• 

  Oracle event Packaging Service (Incident Packaging Service,IPS)

  A powerful tool for packaging incidents (packaging events) oracle 11g is packaging events. Use the support that this compressed folder of packaged events is submitted to oracle to help solve the analysis problem. Once you create an event package, you will add

  2022-06-01 16:02:54 Views: 241
• 

  Installation of mongo

  Mongo operation refer to this article http://wiki.jikexueyuan.com/project/mongodb/ the version here can modify wget http://downloads.mongodb at will

  2022-06-01 16:02:53 Views: 303
• 

  Some implied parameters changing after oracle 11.2.0.2

  1 query implicit parameters SELECT x.ksppinm NAME, y.ksppstvl VALUE, x.ksppdesc describFROM SYS.x$ksppi x, SYS.x$ksppcv

  2022-06-01 16:02:50 Views: 215
• 

  Mssql stored procedure calls method sharing of results in another stored procedure

  Summary: the following will share how to call "the return result of another stored procedure" in "one stored procedure" and apply it to its own operations. we often encounter the return results of calling another stored procedure in one stored procedure (stored procedures apply to each other).

  2022-06-01 16:02:50 Views: 297
• 

  The solution to the failure to restart the redis Cluster

  Redis uses cluster deployment, and if there is a power outage or server restart, sometimes it will not start when it starts again. You need to use the fix command of trib to fix it. If the repair still does not work, you can erase the node data and then re-build the cluster, as long as the backup is done. one

  2022-06-01 16:02:50 Views: 255
• 

  Rac 11.0.2.4 add Node

  The new node does not need to copy the software, the system environment configuration is the same as rac1, manually add mutual trust with rac1 and rac2, and change the hosts file. Then start: the old node oracle and grid users check: cluvfy stage-pre node

  2022-06-01 16:02:50 Views: 267
• 

  A case of manual construction of Oracle 10g AND Oracle 11g-- Oracle 11g

  Oracle 10g AND Oracle 11g manually built Library case-- Oracle 11g system Environment: operating system: RedHat EL6Oracle: Oracle 10g and Oracle 11g manually built

  2022-06-01 16:02:49 Views: 281
• 

  Postgresql database architecture

  Postgresql database is composed of connection management system (system controller), compiler execution system, storage management system, transaction system and system table. ①: connection management system: receive requests from external operations to the system, preprocess and distribute operation requests, and start system logic.

  2022-06-01 16:02:49 Views: 230
• 

  Delete and log issues, the use of PowerDesigner

  Delete and log problem: about the data deleted by delete: we all know that using DELETE will delete all the data in the table. If you delete the data carelessly, there is no paper data or no backup database, so try to use it as little as possible.

  2022-06-01 16:01:49 Views: 225
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (8)

  2.3.2 preparation for creating AG 1. To update the machine name of each node, it must be 15 characters or less. Is the only one in the network. You can modify the machine name with the following statement: sudo vi / etc/hostname2. Configure parsing of hostnames and IP addresses

  2022-06-01 16:01:43 Views: 218
• 

  MySQL sets the validity period of binlog logs to be automatically reclaimed

  Set the number of days to keep the log, and automatically delete and view the current log days after expiration: show variables like'% expire_logs_days%'; defaults to 0, that is, it will never expire. Modify: set global by setting global parameters

  2022-06-01 16:01:42 Views: 228
• 

  DB2 takes the natural days of the specified range

  Oracle: (Select to_char (axi1muri IDD) SHOW_TIME From (SELECT rownum Id,to_date (# {endDate,jdbcTy)

  2022-06-01 16:01:34 Views: 271
• 

  Online switching between MySQL5.7 traditional replication and GTID replication

  Switching from traditional replication to GTID replication master / slave database executes 1.SET @ @ GLOBAL.ENFORCE_GTID_CONSISTENCY = WARN; continuously observes the MySQL error log for a period of time to see if there is any violation of gtid consistency

  2022-06-01 16:01:34 Views: 287
• 

  The redis cluster deletes the specified key in batch

  1. Explain that sometimes you need to delete multiple key on the redis cluster, so you must log in to each node, and it is possible that the key is not on this node, so it is more troublesome to delete. 2. Check the mast in the redis cluster.

  2022-06-01 16:01:34 Views: 259