NAV: SLTechnology News&Howtos > Database >

• 

  ORA-01102: cannot mount database in EXCLUSIVE processing method

  Today started the rac database of a node Times wrong! SQL > startup mountORACLE instance started.Total System Global Area 608174080 byte

  2022-06-01 07:33:18 Views: 265
• 

  MongoDB troubleshooting: why did the load increase after the upgrade?

  This article is written by Li Pengchong, the second prize winner of the essay contest "the Story of MongoDB and me". Next, let's enjoy it together. Recently, after a three-fragment cluster was upgraded from version 3.2 to version 4.0, the CPU load of the cluster nodes increased a lot (10

  2022-06-01 07:33:07 Views: 261
• 

  Redis master-slave configuration and detailed explanation of parameters

  Install redis to download rediswget http://download.redis.io/releases/redis-3.0.7.tar.gz and extract redistar-xvf redis-3.0.7.t

  2022-06-01 07:32:54 Views: 266
• 

  Startup configuration jso of couchbase sync_gateway

  {"interface": ": 4984", "adminInterface": ": 4985", "log": ["REST", "Changes", "CRUD"], "databases": {"sync_g"

  2022-06-01 07:32:54 Views: 255
• 

  Record a persistent error caused by a full disk space

  Environment: 3.0.7 redis 8-node cluster 4 master 4 slave development test environment operation: clear cluster persistence data # redis-cli-c-p 6383-h 172.31.103.238 after login cluster nodes

  2022-06-01 07:32:54 Views: 280
• 

  Jira and confluence configuration issu

  The server restarted yesterday, and then many services need to be restarted, running automation scripts to check the tomcat status, all normal, then visit the server and find that the tomcat where jira and wikr (confluence) are located shuts down automatically; find the reason, embarrassed

  2022-06-01 07:32:53 Views: 253
• 

  MySQL- trigger

  First, trigger (TRIGGER) is one of the database objects of MySQL, which is supported from version 5.0.2. This object is very similar to a function in a programming language, requiring declaration, execution, and so on. But the execution of the trigger is not called by the program, nor started manually, but by the

  2022-06-01 07:32:50 Views: 301
• 

  Delete the data file of offline status in oracle

  Oracle is in archive mode: I started to want to delete data files in a tablespace separately. First, query the relevant information about the data file you want to delete: select * from vested datafile alter database datafile

  2022-06-01 07:32:50 Views: 255
• 

  Hadoop HBase

  1. Overview: 1. Definition: HBase is an open source copycat version of Google Bigtable. It is a database system based on HDFS, which provides high reliability, high performance, column storage, scalability, real-time, random read and write. It is between nosql and RDBMS.

  2022-06-01 07:32:50 Views: 260
• 

  Oracle archive log deletion

  We all know that the information about each archivelog is recorded in controlfile. Of course, after we drop these physical files delete under OS, we still record these archivelog information in our controlfile.

  2022-06-01 07:32:49 Views: 239
• 

  Mysql character garbled

  1) MySQL insert Chinese data garbled problem: simulate garbled phenomenon: mysql > create database kitty;Query OK, 1 row affected (0.00 sec) mysql > show

  2022-06-01 07:32:49 Views: 206
• 

  Analyze the reason and solution of slow insertion speed of ecbil database

  The problem raised by the R & D team is as follows: when the discount engine inserts data into the database, it takes an hour to analyze the data. 1 calculates that the number of rows inserted per second is only about 900000, which is far below the normal performance range. 2 communicate with the developer and find that every time the inser is inserted into the database

  2022-06-01 07:32:49 Views: 223
• 

  Common query statements in postgresql

  1. Look for slow execution of sql:select* from pg_stat_statements;2. Look up the answer according to the pid of the operating system: select d.query from pg_stat_activity d

  2022-06-01 07:32:49 Views: 286
• 

  The scene that caused the Hbase to die

  The scenarios that cause Hbase to hang up are as follows: master service stop caused by 1.zk exception is the most common scenario, involving operations including but not limited to the following: a) Zk link timeout, timeout

  2022-06-01 07:32:48 Views: 232
• 

  Oracle database insert error: invalid data type

  Today, I encountered such an error when I was working to insert data in oracle database: invalid data type, log is also printed out error occurred setting parameters, that's probably what it means. Forget the specific letters.

  2022-06-01 07:32:48 Views: 294
• 

  Exp and expdp Import and Export Oracle10g Learning Series (8)

  1. Matters needing attention when using both: 1. Exp and imp are client-side tools, which can be used either on the client or on the server. Expdp and impdp are server-side tools. They can only be used on the oracle server, not on the client.

  2022-06-01 07:32:48 Views: 209
• 

  -bash: ulimit: max user processes: cannot modify limit: Operation not permitted

  When installing oracle, after creating oracle users and switching oracle users, the following error is reported [root@localhost ~] # su-oracle-bash: ulimit: max user proces

  2022-06-01 07:32:48 Views: 279
• 

  SqlServer Series Notes-string function

  LEN (): calculate the string length LOWER (), UPPER (): turn to lowercase, uppercase LTRIM (): remove the space on the left side of the string, remove RTRIM (): remove the space on the right side of the string, remove LTRIM (RTRIM ('bb')) SUB

  2022-06-01 07:32:48 Views: 287
• 

  SpringMVC + MyBatis integration [transfer]

  Environment: there are too many articles about this architecture on the spring3.1.1+mybatis3.2.8+mybatis-spring1.2.3 network. This article is to sort out some points that I paid attention to when I built it for the first time. Mainly some configuration files

  2022-06-01 07:32:43 Views: 213
• 

  Mongodb slow query

  Turn on Profiling function 1. Directly in the startup parameters to set up the startup MongoDB with-profile=1 can also be slow query time (that is, more than how much time is recorded in the slow query)-slowms 2002. You can use d

  2022-06-01 07:32:24 Views: 263