NAV: SLTechnology News&Howtos > Database >

• 

  Construction of distributed sharding Cluster by MongoDB4.0

  MongoDB slicing briefly describes that database applications with high data volume and throughput will cause great pressure on the performance of a single machine, a large amount of query will exhaust the CPU of a single machine, and a large amount of data will exert greater pressure on the storage of a single machine, which will eventually deplete the memory of the system and transfer the pressure to the disk IO. Mo

  2022-06-01 22:00:40 Views: 287
• 

  Logstash acquires Beijing time

  Because logstash will automatically convert @ timestamp time to UTC time, many methods have been searched on the Internet without results. We have to extract the year, month and day from the log and classify them according to Beijing time. Log format JSON: {"@ timestamp": "2016-08

  2022-06-01 22:00:40 Views: 211
• 

  Two problems encountered in importing data using the import tool that comes with HBase

  Because the development environment needs to be migrated, the tables from the original HBase are serialized to hdfs using the org.apache.hadoop.hbase.mapreduce.Export tool, downloaded and imported in the new development environment. Two were encountered during import.

  2022-06-01 22:00:40 Views: 287
• 

  Oracle set autotrace on reported an error

  Log in to the username/password@ library name as sysdba;D:\ Oracle11g\ app\ oracle\ product\ 11.2.0\ server\ rdbms\ admin\ u using the sys user

  2022-06-01 22:00:33 Views: 200
• 

  Oracle 11g ADR

  ADR is a file-based database diagnostic data repository referenced by 11g to store such as traces, dumps, alarm logs, health monitor reports, and so on. It has a unified directory structure across multiple instances and products. Initialization parameter BACKGROUND_DUM in 10g

  2022-06-01 22:00:33 Views: 263
• 

  Mysql sort query field

  Sort query syntax: select query fields 1from table where [filter criteria] order by to sort fields 2 asc ascending order, desc descending order, to sort fields 3 asc ascending order, desc descending order if you do not write the default ascending order case: querier

  2022-06-01 22:00:33 Views: 206
• 

  MongoDB based on time aggregate example

  You need to accumulate TranslateFields values for the following collection, grouped by day according to LastUpdate. Rs_test:SECONDARY > db.new_result.find (); {"_ id": Obje

  2022-06-01 22:00:23 Views: 231
• 

  Verification of the problem that rac thought of himself

  1. When a single node starts, it is operable [oracle@rac1 ~] $sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Thu Ju

  2022-06-01 22:00:23 Views: 239
• 

  MySQL 8.0.17 clone plugin local remote backup and master-slave summary

  The clone plug-in allows you to clone data locally or from a remote MySQL server instance. It can also be seen as a backup method, so I put it into backup arrangement. Clone data is a physical snapshot of the data stored in InnoDB, including schema, table, tablespace, and data dictionary metadata. Cloned

  2022-06-01 22:00:23 Views: 289
• 

  Centos 7 makes Oracle 12c Docker

  Resource preparation requires downloading oracle-related things, such as installation files, dockerfile. These can be found on oracle's github. Https://github.com/oracle/docker-ima

  2022-06-01 22:00:19 Views: 207
• 

  Change the pit left by user host

  We always specify host when we create a database user, that is, a complete user can be described as' username'@'host'. If host is not explicitly specified when creating a user, the default is%, which means that this user can be used by all ip segments, or we can

  2022-06-01 22:00:18 Views: 273
• 

  HBASE REGION SPLIT strategy

  In version 0.94.0 of hbase, a very convenient SplitPolicy is introduced into the split mode of region. Through this SplitPolicy, you can actively intervene in the way of controlling region split. In org.

  2022-06-01 22:00:11 Views: 281
• 

  [giant Sequoia Database SequoiaDB] Application of domestic distributed Database of Provincial Rural Credit

  This article is reproduced from the original link of "Electronic Finance": https://mp.weixin.qq.com/s/WGG91Rv9QTBHPsNVPG8Z5g with the rapid development of mobile Internet, distributed architecture is widely used in the field of Internet IT technology.

  2022-06-01 21:59:56 Views: 279
• 

  Revisit by Oracle lock

  Https://www.cnblogs.com/leoh/p/7039907.html to be edited, quote v$lock, see request,lmodev$locked_objects xidusn,sid

  2022-06-01 21:59:44 Views: 249
• 

  Installation and setup of Sybase charset character set

  1. Install the character set such as cp036:1) install cp936 > cd c:\\ sybase\ charsets\ cp936c:\ Sybase\ charsets\ cp936 > charset-Usa-Ppassw

  2022-06-01 21:59:44 Views: 276
• 

  User management

  Mongodb user management note: a) in mongodb, there is an admin database, which involves server configuration operations, so you need to switch to admin data first. That is, use admin,-- > is equivalent to entering superuser management mode. B

  2022-06-01 21:59:44 Views: 208
• 

  How to switch a field of type varchar2 to clob

  The specific operations are as follows: the original field bookdetails is varchar2 (4000), and the original table already has business data ALTER TABLE testADD (bookdetails01 CLOB); UPDATE test S

  2022-06-01 21:59:43 Views: 242
• 

  HBase replaces Memcachedb

  Background: Memcachedb is now unmaintained, and there are always problems, downtime and disk over. The boss proposed to replace it and found someone to study it for many days, but there was no sound because he was busy. It has a short life, just as the equipment is streamlined, and Memcachedb occupies several physical machines. Two channels

  2022-06-01 21:59:43 Views: 266
• 

  Practice of Partition Table under MySQL--RDS

  In the practical background project, some table spaces are too large and there are too many rows, so it is decided to divide some tables into databases and tables. When studying the selection scheme, it is found that some commonly used sub-library and sub-table solutions have more modifications to the business code, so I decided to adopt the partition scheme of MySQL. In fact, in my personal opinion, the partition table is

  2022-06-01 21:59:37 Views: 217
• 

  Functions, stored procedures and triggers of MySQL

  Functions, stored procedures and triggers in MySQL are not much used now, just understand it, because now database performance is the bottleneck of many systems, these operations can be done outside the database by professional programming languages such as java, to reduce the burden of the database, the database is only responsible for data storage

  2022-06-01 21:59:34 Views: 242