NAV: SLTechnology News&Howtos > Database >

• 

  Mongodb3 fragmentation deployment and Fault Simulation Verification

  This paper is divided into two parts to introduce the configuration of mongodb3.2.1 shard deployment and fault simulation verification. Part 1 installation and configuration 1. Experimental environment two groups of replica sets do shard version 3.2.1 replica set 1VOR 192.168.115.11VOR 27017192.168.11

  2022-06-01 22:28:24 Views: 279
• 

  MySQL 8.0.18 Hash Join does not support left/

  In MySQL 8.0.18, a new function of Hash Join has been added, which is suitable for fields that have not been indexed and do equivalent association queries. In previous versions, if the joined fields were not indexed, the query speed would be very slow, and the optimizer would use BNL (block nesting) calculation.

  2022-06-01 22:28:15 Views: 273
• 

  Analysis of InnoDB Index structure

  0, what are the characteristics of the index that guides the InnoDB table, and what is the index organization structure? 1. The characteristics of the InnoDB clustered index we know that the clustered index of the InnoDB engine organizes the table, there must be a clustered index. Row data (row data) is stored in the

  2022-06-01 22:28:14 Views: 290
• 

  Learning basic knowledge of mysql

  Although mysql has been acquired, but as the mainstream database on the market, we still need to learn. MySQL has three major data types, namely, number, date / time, and string. In these three categories, many subtypes are divided in more detail: numeric type integer: tinyin

  2022-06-01 22:28:14 Views: 219
• 

  MongoDB data query

  1. View the collection show collections2. Add data db.runoob.insertMany ([{'title':'data1','url':' https://blog.51cto.com] to the collection

  2022-06-01 22:27:45 Views: 299
• 

  Oracle 19c opatchauto patched wrong Miss

  Environment: rhel7.6 oracle 19crac cluster resource status [grid@19crac1 ~] $crsctl stat res-t-initora.asm1 ONLINE ONLINE 19cr

  2022-06-01 22:27:44 Views: 241
• 

  [ERROR] [MY-012263]

  You cannot increase the size of an existing system tablespace data file by changing its size attribu

  2022-06-01 22:27:41 Views: 294
• 

  Cleaning of Oracle inactive session

  STATUSACTIVE-Session currently executing SQLINACTIVEKILLED-Session marked to be killedCACHED-S

  2022-06-01 22:27:41 Views: 201
• 

  Guide of oracle expdp backup under liunx centos

  1. Reference setting environment variable 2. Record execution time and user 3. Delete old backup 4. Data pump extraction backup 5. Compressed backup 6. Delete the file #! / bin/sh before compression. / etc/profilesource ~ / .bash_profileOR

  2022-06-01 22:27:41 Views: 291
• 

  Sybase15.0.3 installation steps

  SYBASE15.0.3 installation simple step 1, install the Linux operating system, you need to pay attention to the configuration of shared memory in actual bytes. For example, if the memory I gave to the OS system is 1792m, it is 1792m / 1024m / etc/sysct.

  2022-06-01 22:27:40 Views: 274
• 

  Source code analysis of Zabbix trigger

  Zabbix's trigger is used to set monitoring alarm conditions. If the monitoring project is based on a template, you can directly set the trigger of the corresponding item when creating the template. If the monitoring project is not based on the template but added separately, then for multiple servers

  2022-06-01 22:27:40 Views: 235
• 

  Oracle sql command

  Review of oracle commands

  2022-06-01 22:27:40 Views: 283
• 

  ORACLE creates a custom function to return the varchar type

  Requirement description: two tables, as follows, need to query the nameselect from tmp1; select from tmp2; method of id_new in tmp2 in tmp1 table 1: advantages: simple, direct sql shows disadvantages: if the main table data

  2022-06-01 22:27:28 Views: 239
• 

  Types of DBs coming

  Oracle/MSSQL/MySQL...;, who used to operate and maintain at the same time, is now facing the need for more details this time, such as versions, new features, practice and promotion.

  2022-06-01 22:27:28 Views: 274
• 

  Mongodb basic exercise-- detailed explanation of sharding cluster operation

  MongoDB sharding introduces the purpose of sharding 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 cause 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. For

  2022-06-01 22:27:24 Views: 291
• 

  Database Optimization of zabbix

  Start testing with version 1.6 of zabbix, version 1.8 has been used online, have used version 1.9,2.0,2.2,3.0,4.0 online, and used or tested all versions after zabbix1.6. Individuals also have the previous SA transformed into DBA, just

  2022-06-01 22:27:23 Views: 257
• 

  Road map after Oracle12c

  In the official MOS article: Release Schedule of Current Database Releases (documentation ID 742060.1), you can clearly see the release plan of Oracle. First of all, at present

  2022-06-01 22:27:14 Views: 249
• 

  The Advanced part of MySQL Database-- Master-Slave synchronization and read-write Separation

  Master-slave synchronization and read-write separation master-slave synchronization experiment prepares a total of four virtual machines, one application side, one amoeba, one master server, one slave server ​ application: centos7-2 (MySQL installed before the experiment) ​ amoe

  2022-06-01 22:27:14 Views: 278
• 

  Oracle 11g RAC on rhel 6.9 installation

  1. Installation instructions 1. Environment description system version database version IP address patch rhel6.911.2.0.4RAC192.168.3.229698727rhel6.911.2.0.4RAC192.168.3.329698

  2022-06-01 22:26:43 Views: 213
• 

  Systemctl service configuration of MongoDB on CentOS 7

  [Unit] Description=mongodbAfter=network.target remote-fs.target nss- lookup.target[Service] Type=forkin

  2022-06-01 22:26:19 Views: 250