NAV: SLTechnology News&Howtos > Database >

• 

  Spring boot application.properties configuration

  From https://docs.spring.io/spring-boot/docs/current/reference/html/common-application-properties.html

  2022-06-01 10:50:30 Views: 232
• 

  Using Mysqldump to realize data restore of full database backup + binlog

  With the growth of business, the database is also growing exponentially. The original full-database backup is no longer suitable for the current database. 10G-20G is easily backed up, which takes up too much disk space, so we consider using a more concise, faster and more space-saving backup method, which brings us to the idea of using binlo.

  2022-06-01 10:50:24 Views: 283
• 

  Record a Historical data Migration from oracle to hive (1)

  Introduce the specific scenario that the historical data needs to be migrated from the existing oracle and imported into hive, there are several problems: 1, the existing oracle database is unable to export the entire database, the database server does not have permission; 2, due to each upgrade of each data provider

  2022-06-01 10:50:23 Views: 249
• 

  Oracle to view the process that a user has permissions

  Create or replace procedure p_roleprivs (v_role varchar2) iscursor c_rolesys is select PRIVILEGE from

  2022-06-01 10:50:23 Views: 235
• 

  [Oracle RAC illustrated] detailed process of installation and configuration of Linux system Oracle11gR2 RAC 3.1

  [Oracle RAC] Linux system Oracle11gR2 RAC installation and configuration detailed process V3.1 (illustrated) 2 Oracle11gR2 RAC database installation preparation work 2.1 installation environment introduction 2.2 database installation software

  2022-06-01 10:50:20 Views: 308
• 

  Application of Redis transaction

  Redis's support for transactions is relatively simple at the moment. Redis can only guarantee that commands in a client-initiated transaction can be executed continuously without inserting commands from other client. Because redis is the place where all client requests are processed by a single thread

  2022-06-01 10:50:19 Views: 281
• 

  Orchestrator+proxysql+mysql5.7GTID Master-Slave switching Test process

  [root@es2 ~] # cat < > > "[root@es2 ~] # mysql-u admin-padmin-h 127.0.0.1-P6032 mysql: [Warning] Usin

  2022-06-01 10:50:19 Views: 279
• 

  Openstack virtual machine creation process

  The process of creating a virtual machine is as follows: 1. The interface or command line obtains authentication information from keystone through RESTful API. 2.keystone requests authentication information through the user, and generates auth-token to return to the corresponding authentication request. 3. Interface or command line

  2022-06-01 10:50:16 Views: 303
• 

  Cbc latch in logical Reading (3)

  Continue to verify the cbc latch-related situation when using the index, and write the dtrace script more cbc.dBINGUR * memnr;in using the dtrace in solaris.

  2022-06-01 10:50:15 Views: 206
• 

  Wordpress database transfer

  Background: the database was specified incorrectly during Wordpress installation, resulting in the data on the website being placed in the system library of mysql. Mysql > show tables from mysql;+-

  2022-06-01 10:50:15 Views: 301
• 

  Using Software to define data Center to help the Construction of Test Standardization system of Chinese Banking Industry

  Author: Charlie release time: 2019.01.21 this article is transferred from the December 2017 supplement in charge of China Finance. Figure 1 | in the post-Internet era, the adaptability of enterprises is competitiveness. In the post-Internet era, Charles, founder of Jie Yi Software and CEO. The response ability of enterprises depends on

  2022-06-01 10:50:12 Views: 260
• 

  Using regular expressions in MySQL

  The REGEXP function in MySQL can match regular expressions when you use SQL, and when you use some query conditions, you can use REGEXP function to match the corresponding characters, which can replace many SQL functions that you are not familiar with or do not know.

  2022-06-01 10:50:11 Views: 270
• 

  Oracle 10g real application clusters introduction (RAC principle)

  1. What is a cluster? a cluster is made up of two or more independent servers connected through the network. Several hardware vendors have provided various requirements for Cluster performance over the years. Some Clusters are simply designed to provide high availability

  2022-06-01 10:49:41 Views: 273
• 

  Linux does not install Oracle using the exp Export Utility

  Application scenario: sometimes we need to export DMP files to ORACLE regularly, but we don't need to install Oracle software. 1. Prepare 1.1 http://www.oracle.com/technetwork/topics/linuxx86-

  2022-06-01 10:49:40 Views: 235
• 

  MYSQL Database Learning Series 4

  MYSQL Database Learning Series 44. The Application of 4.1-MySQL Index Optimization and Design what is the significance of the Index Index-- quickly locate the data to be found database index search full table scan VS index search how to find the row based on the first letter II

  2022-06-01 10:49:40 Views: 209
• 

  V$SQL and V$SQLAREA

  Is the SYS@newtest > DESC V$SQL name empty? Type SQL_TEXT VARCHAR2 (1000) SQL_FULLTEXT CLOBSQL_ID VARCHAR2 (13) SHARABLE

  2022-06-01 10:49:16 Views: 270
• 

  Linux installation Oracle kernel parameter configuration instructions

  Fs.file-max = 6815744 fs.file-max-represents the maximum number of file handles and the number of files that can be opened in the Linux system. Fs.aio-max-nr = 1048576 Mui-this parameter restricts the concurrency of outstanding requests and avoids Ihand O

  2022-06-01 10:49:16 Views: 206
• 

  Bitmap Index in hbase-- Bloom filter

  In hbase, business reading is very frequent. Many operations are that the client locates to the specific regionserver according to the meta table and then queries the specific data in the region. But now the problem is that a region is made up of a memstore.

  2022-06-01 10:49:15 Views: 213
• 

  OGG Operation and maintenance Optimization script (19)-process Operation Class-Auxiliary Operation

  File: info.sh start.sh stop.sh path $HOME/ggscript/ggoperat because after writing too many scripts, sometimes you have to switch frequently between the GGSCI and the system interface in order to check the running status of OGG, so

  2022-06-01 10:49:15 Views: 294
• 

  Summary of LogMiner tools

  (1) the role of LogMiner tools Logminer tools are mainly used to analyze redo log and archive log files. Through this tool, you can easily get the details of Oracle redo log and archive log files

  2022-06-01 10:49:14 Views: 219