NAV: SLTechnology News&Howtos > Database >

• 

  Oracle tablespace

  Only by thinking twice before you can understand it, can you remember effectively for a long time when I first learned Oracle, I already understood the advantages of Oracle, such as distributed management and easy coordination; excellent performance; supporting big data's format; and another point is that Oracle's original tablespace is unique and strong

  2022-06-01 08:19:52 Views: 210
• 

  Building and testing of codis3.2.1 Cluster

  Codis is written in go language. In order to deal with redis cluster software in high and parallel environment, the principle is that before operating on a redis key, the key is assigned to a slot of different redis through the crc32 algorithm to achieve concurrent read and write work.

  2022-06-01 08:19:22 Views: 300
• 

  Query caching of MySQL

  1. The misunderstanding of query cache when I first came into contact with QC, I thought it was a good thing to put the results of the query into QC, which greatly improved the speed of the query, but later I learned that if the table is cached corresponding to DML or DDL,QC, it will be released, so for databases that change frequently

  2022-06-01 08:19:21 Views: 242
• 

  ORACLE expdp exports / imports all tables that begin with XX

  Scenario: there are 2 oracle users, userA default tablespace tablespaceA, userB default tablespace tablespaceB. Now you need to export the system tables in userA (tables that start with SYS in this user tablespace) to userB

  2022-06-01 08:19:21 Views: 203
• 

  MySQL Database Optimization (1)

  No matter which kind of service, the optimization is nothing more than two aspects, the first is the optimization of the hardware, the second is the optimization of the system and the service itself. 1. Query the number of times to connect to the MySQL server mysql > show status like

  2022-06-01 08:19:21 Views: 258
• 

  The MySQL statement IFNULL function uses the

  The MySQL IFNULL function is one of the MySQL control flow functions, which takes two arguments and returns the first parameter if it is not NULL. Otherwise, the IFNULL function returns the second argument. The grammatical structure of IFNULL function

  2022-06-01 08:19:20 Views: 266
• 

  REF CURSOR summary

  REF cursors: REF cursors, also known as dynamic cursors, associate different statements with them at run time, and dynamically associate temporary objects of the result set, that is, dynamically decide to execute queries at run time. REF cursors can use cursor variables. Cursor variable: a cursor variable is a reference to the REF cursor type

  2022-06-01 08:19:20 Views: 223
• 

  Redis data manipulation-hash key

  | A hash consists of multiple field value pairs (field-value pair). The fields and values of the hash can be text, integer, floating point or binary data. # each field in the same hash must be unique, while the values of different fields can be duplicated. #

  2022-06-01 08:19:20 Views: 206
• 

  The data recovery method of partition loss after assembling the computer to adjust the partition

  The absence of partitions after partition adjustment is a more common data recovery case. It should be noted that do not rebuild new partitions after partition adjustment. Protect the scene of missing documents and recover the files to the maximum extent. The specific recovery method is understood in the text. Tools / software: star data recovery software step 1

  2022-06-01 08:19:00 Views: 230
• 

  CentOS6.9 install Redis4.0.0

  Security code: it is impossible to have inner peace without a considerable degree of loneliness. 1. Prepare the hostname of the environment IP system redis-01192.168.10.24CentOS release 6.9 (Final) Redis is easy to install and download from the official website

  2022-06-01 08:18:49 Views: 270
• 

  Parsing the ultra-detailed steps of installing Zabix3.0 on centos7

  Preparation before installation: 1.1 install dependency package: yum-y install wget net-snmp-devel OpenIPMI-devel httpd openssl-devel java lrzsz fpi

  2022-06-01 08:18:49 Views: 203
• 

  Oracle create table

  1. Oracle creates a table format: create table xxx (xxx_id char (10) not null,... Xxx_name char (20) not null,xxx_address cha

  2022-06-01 08:18:46 Views: 287
• 

  SAP HANA database backup methods and tools

  Type of backup OptionDescriptionComplete Data BackupA data backup includes all the data structures that are re

  2022-06-01 08:18:34 Views: 297
• 

  Optimizer of oracle

  RBO and CBO mode of Oracle optimizer 1. Rule-based optimization mode (Rule-Based Optimization, referred to as RBO) when analyzing SQL statements, the optimizer follows some predetermined rules within Oracle.

  2022-06-01 08:18:34 Views: 285
• 

  PostgreSQL 9.6.1 Source installation

  RHEL7.2+PostgreSQL9.6.1Requirements softwares1.GNU make version 3.80 or newer is required [root@rhel7

  2022-06-01 08:18:34 Views: 216
• 

  Oracle sql

  Data DefinitionCREATE, to create a new database objectALTER, to change an aspect of the structure of

  2022-06-01 08:18:33 Views: 230
• 

  MongoDb basic command

  Some basics forget to check at any time. # standby recovery mongodump-- port 20001-- authenticationDatabase=admin-u *-d lvlv-c lvlv-o / home

  2022-06-01 08:18:33 Views: 215
• 

  Stand-alone multi-instance deployment of MYSQL

  Centos6.6 installs and configures stand-alone multi-instance MYSQL database this paper introduces the environment for installing stand-alone multi-instance MYSQL database as follows: system platform environment: Centos6.6Mysql software package: Mysql-5.5.32.tar.gz 1:

  2022-06-01 08:18:33 Views: 213
• 

  The principle of database architecture of Alipay supporting 213.5 billion turnover

  OceanBase's SQL optimizer and distributed parallel executive summary: this paper mainly introduces that the general relational database OceanBase,OceanBase independently developed by Ant Financial Services Group adopts distributed architecture, which has been implemented on ordinary PC server cluster through technological innovation.

  2022-06-01 08:18:03 Views: 239
• 

  Overview of SQL Server 2012 Licensing

  * for more details, please click for more details * the sales and licensing methods of products may vary from country to country, please contact your local dealer or sales representative for accurate sales and licensing methods. Microsoft has the final right to explain the way products are sold and licensed. SQL Server 20

  2022-06-01 08:18:02 Views: 223