NAV: SLTechnology News&Howtos > Database >

• 

  How to query the capacity of database by Mysql

  This article mainly shows you how to achieve Mysql query database capacity size, the content is easy to understand, I hope you can learn, after learning will certainly have a harvest, the following let the editor to take a look at it. The total size of all databases is queried as follows: mysql >

  2022-06-01 11:27:06 Views: 273
• 

  Several IP in Oracle RAC

  At the beginning of oracle11g, set up SCAN ip, in addition to there is public ip,virtual ip,private ip, easy to make people dizzy. The following is explained one by one: public ip: oracle data similar to single instance

  2022-06-01 11:27:06 Views: 241
• 

  Differences and definitions of DML, DDL, DCL

  DML (Data Manipulation Language, data manipulation language): used to retrieve or modify data. DML includes: SELECT: for retrieving data; INSERT: for adding data to the database; UPDATE: for slave numbers

  2022-06-01 11:27:05 Views: 230
• 

  MySQL: common usage problems

  1. Install MySQL on Linux installation steps: 1) decompress tar.gz file shell > tar-zxvf mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz2) initialize default data

  2022-06-01 11:27:05 Views: 246
• 

  How to get province, city, gender and age according to ID card number in Oracle

  What the editor wants to share with you this time is how Oracle can get provinces and cities, gender and age by ID card number. The article is rich in content. Interested friends can learn about it. I hope you can get something after reading this article. 1. Query the SELECT of the province and city through the ID card number

  2022-06-01 11:26:53 Views: 281
• 

  Oracle insert into and update

  IDNAMEAGEGENDERBB11 Zhang San17 male 1622 Li Si 18 male 1633 Wang 519 male 1644 Zhao Liu20 female 1655 Li Jian 17 male 1666 Wang Jian 39 male 1677 Sun Jian 17 female 1688 Sun Qian 13 male 1699 Zhang Jing 32 female 1610

  2022-06-01 11:26:53 Views: 275
• 

  MySQL Master-Slave replication Project implementation and maintenance 01 (MR) _ MySQL High availability replication and distributed Cluster Architecture 02

  MySQL Master-Slave replication Project implementation and maintenance 01 (MR) _ MySQL High availability replication and distributed Cluster Architecture 02 Video tutorial Learning address http://edu.51cto.com/course/14237.htmlOracle/MySQ

  2022-06-01 11:26:50 Views: 249
• 

  Performance Optimization of Oracle Learning (1) SQL statement processing

  What exactly did Oracle do when submitting a sql command to Oracle? Having a good understanding of this problem can help you better analyze the optimization of sql statements. From the beginning to the end of a sql statement, you need to go through four steps: analyze-- enter the submitted statement

  2022-06-01 11:26:44 Views: 296
• 

  Oracle create index online

  1.1 create index if the target table has a DML operation and is not committed, an error ORA-00054: resource busy and acquire with NOWAIT specifie is reported when the index is created

  2022-06-01 11:26:44 Views: 247
• 

  ORACLE ADF:EO Method verification

  In ADF's EO, there are many ways to validate data, one of which is METHOD validation. Next I have two time fields as examples to show you how to use METHOD authentication. Illustration: end.

  2022-06-01 11:26:13 Views: 278
• 

  Getting started experiment of db2

  The new unit still needs to be familiar with db2,IBM 's heavyweight database products. The old routine, first look at the basic data, understand the basic concepts, and then begin to set up an experimental environment for hands-on experiments. First, use the virtual box virtual machine to prepare a centos7 64-bit

  2022-06-01 11:25:44 Views: 263
• 

  Comparison of the parameters of each stable version of Oracle database

  Database version all parameters (including public parameters and implied parameters) expose parameters Oracle 10.2.0.5.01618259Oracle 11.2.0.4.02912351Oracle 12.1.0.2.03975380Or

  2022-06-01 11:24:44 Views: 266
• 

  Mongodb cluster

  MongoDB Sharding technology sharding is the method used by MongoDB to split large collections into different servers (or a cluster). Although sharding originated from relational database partitioning, MongoDB fragmentation is finished.

  2022-06-01 11:24:44 Views: 290
• 

  Weblogic 12c (12.1.3) Silent installation and creation of domain

  OS:centos mini6.4 ip:192.168.1.115 first installs jdk, which uses 1.7#install javarpm-ivh jdk-7u75-linux-x64.rp

  2022-06-01 11:24:44 Views: 274
• 

  Shell secondary menu

  Today the weather is cloudy and a little boring, so I have made such a boring play. #! / bin/bash#Date:2017-6-20#Version:1.0#Author:xcn (baishuchao@yeah.net) m

  2022-06-01 11:24:43 Views: 203
• 

  Zabbix MongoDB monitoring

  The template used to monitor mongodb settings last year, including the number of mongodb connections, memory, replication latency, and whether or not Master is monitored. Here are some examples of monitoring graphics, and we also have some triggers, such as the availability of mongodb instances and the role of mongodb replica sets.

  2022-06-01 11:24:20 Views: 246
• 

  Binlog2sql referenc

  To install pip, refer to the installation website: https://pip.pypa.io/en/stable/installing/curl https://bootstrap.pypa.io/get-pip.py-o g

  2022-06-01 11:24:19 Views: 267
• 

  RAC+ADG off-machine recovery error-ORA-16072

  1. Environment description 11g RAC+ADG maximum available mode 2. Error reports in the alarm log of different machine recovery are as follows: ORA-16072: a minimum of one standby database destination is r

  2022-06-01 11:24:19 Views: 229
• 

  Oracle trigger

  Create table a trigger create table T_AC_TEST (ID VARCHAR2 (32) not null primary key, AT_SWITCH CHAR (

  2022-06-01 11:24:16 Views: 245
• 

  How to realize mysql remote automatic backup under Linux

  This article mainly explains how to achieve mysql remote automatic backup under Linux, the content is clear, interested friends can learn, I believe it will be helpful after reading it. Basically, whether it is for our own use or for deploying servers to customers, my

  2022-06-01 11:24:16 Views: 220