NAV: SLTechnology News&Howtos > Database >

• 

  Oracle 19C+13.4EMCC host monitoring

  Oracle 19C+13.4EMCC Host Monitoring EMCC add Host 192.168.2.187 rac1EMCC Server add hosts [root@cjcos emcc] # vim / etc/hosts

  2022-06-01 04:57:13 Views: 213
• 

  Redo log and binary log

  There are six kinds of log files in MySQL, namely: redo log (redo log), rollback log (undo log), binary log (binlog), error log (errorlog), slow query log (slow)

  2022-06-01 04:57:11 Views: 219
• 

  Rman incremental backup recovery

  Rman heterogeneous incremental backup to restore https://blog.csdn.net/qq_28766111/article/details/85252754https://blog.csdn.net/freedomp

  2022-06-01 04:57:11 Views: 260
• 

  Opp "Quick pass" scanning and recognition system

  Opp "Quick File pass" scanning and recognition system is a combination of software and hardware products with scanner and OCR recognition technology. After collecting common documents, official documents, bar code, ID card and other images through the scanner, OCR recognition technology is used to obtain relevant text information to achieve rapid extraction and input of information. Production

  2022-06-01 04:57:11 Views: 285
• 

  Getting started with MySQL-sorting

  MySQL sorting We know to use SQL SELECT statements to read data from the MySQL table. If we need to sort the read data, we can use the ORDER BY clause of MySQL to set which field you want to press

  2022-06-01 04:57:11 Views: 268
• 

  See the parameter modification level through the v$parameter view (11g, 18c, 19c)

  V$PARAMETER displays information about the initialization parameters that are currently in effect fo

  2022-06-01 04:57:10 Views: 208
• 

  Key technical characteristics of GreatDB

  The GreatDB database independently developed by Beijing Wanli Open Source Software Co., Ltd. is the leading domestic database in China. Since 2012, customer cases have spread across finance, energy, telecommunications, government and other industries. The products take "extreme stability, extreme performance, and extreme ease of use" as the core goal to satisfy customers.

  2022-06-01 04:57:10 Views: 255
• 

  Oracle 11G RAC adds nodes

  The addition of nodes in the cluster is roughly divided into four steps: the preparatory stage, the new node joining the cluster (installing GI software), the new node installing DB software, and assigning instances to the new node. One. Pre-preparation phase IP configuration, system kernel configuration, installation of RPM package, SHE

  2022-06-01 04:57:10 Views: 267
• 

  Instructions for using Oracle built-in package UTL_FILE

  In database development, when the PL/SQL statement is very complex, I want to write some Log, just like java's Log4j. In this way, you can well track the running of the program. The article found on the Internet is not very useful, so I revised it. 1: on the Oracle server

  2022-06-01 04:57:09 Views: 308
• 

  MySQL xtrabackup for centos7.2 installation

  Install xtrabackup, the backup tool for MySQL on centos7.2. It is recommended to mount the image, configure the YUM source, and use yum for installation to resolve package dependencies; unless you use compiler installation, do not use rpm-ivh to install xtrabackup

  2022-06-01 04:57:09 Views: 255
• 

  MSSQL database ndf file size changes to 0KB data recovery process

  First, the fault describes a customer in Chengdu, the storage is damaged and the database crashes. Reorganize the storage, restore the database files, and find that there are four ndf files with a size of 0 KB. The database size is about 80TB. There are 1223 files in the database, and the database generates a NDF file every 10 days, each ND

  2022-06-01 04:57:04 Views: 279
• 

  [lecture record] the practice of massive unstructured data management at PB level in banks

  [lecture record] recently, Hao Dawei, the technical director of Giant Sequoia Database, gave a speech on the theme of "Bank PB massive unstructured data Management practice" at the Seventh data Technology Carnival, sharing the financial industry of Giant Sequoia Database.

  2022-06-01 04:56:55 Views: 242
• 

  The fourth theoretical basis of Mysql database-the management of tables and indexes

  1. It is the most popular open source SQL database management system developed by MySQL AB Company. Its main features are as follows: 1. It is a database management system. 2. It is an associated database management system. 3. It is an open source software, and there are a large number of shared MySQL software 4, M available.

  2022-06-01 04:56:55 Views: 260
• 

  ERROR 1290 (HY000) solution

  Select * into outfile'/ home/update_testdbtest.txt' from update_test;ERROR 1290 (HY000): The MySQL s

  2022-06-01 04:56:54 Views: 266
• 

  Problems of MySQL replication lag and delay and their Solutions

  The method of confirming replication delay executes mysql > show slave status\ G if "seconds_behind_master" is not "0", we need to pay attention to it and investigate its root cause. First of all, we need to confirm that the cause of the delay comes from two.

  2022-06-01 04:56:54 Views: 310
• 

  Zhonganwei: a detailed explanation of the defense of common vulnerabilities in the SpringMVC framework

  Let's use the database operation class jdbcTemplate that comes with SpringMVC as an example. For example, there are two functions in the following Dao. The function save uses the form of binding variables to prevent sql injection, while queryForInt_

  2022-06-01 04:56:54 Views: 229
• 

  MySQL:slave delays a list of foreign key checks and self-incrementing locks

  This article does not have much readability, it is entirely my own notes. First, the phenomenon delay is big, big thing. Table structure image.png no IOimage.pngSQL THREAD occupies CPU 100%image.png II, pscak sampling outside 30 points

  2022-06-01 04:56:53 Views: 295
• 

  The Application of Deep Learning in the ranking of Meituan Dianping recommended platform

  The Application of Deep Learning in the ranking of Meituan Dianping recommendation platform Pan Hui Meituan Dianping is the largest life service platform in China. With the rapid development of business, the number of users and businesses of Meituan Dianping is growing rapidly. In this context, through the optimization of the recommendation algorithm, to create a high accuracy,

  2022-06-01 04:56:49 Views: 218
• 

  Day-to-day work of DBA

  Activity status check confirms that the database and instances are in a normal running state by querying the basic view, and can provide data services to the outside. 1.1 instance status SELECT instance_name,status FROM vault instance; query returns

  2022-06-01 04:56:48 Views: 311
• 

  PostgreSQL Source Code interpretation (10)-insert data # 9 (ProcessQuery)

  This paper briefly introduces the source code of the PG insert data part, including the implementation logic of the ProcessQuery function, which is located in the file pquery.c. 1. Basic information: data structures, macro definitions and dependent functions used by ProcessQuery functions

  2022-06-01 04:56:48 Views: 258