NAV: SLTechnology News&Howtos > Database >

• 

  Detailed explanation of recovery of different damage levels of Oracle Database

  Recovery of data block damage when only a small number of data blocks in the data file are damaged, we can use RMAN to recover them at the block level. Local recovery at the block level can greatly shorten the recovery time, even to a few thousandths of that of other recovery methods. In addition, the data block exists

  2022-06-01 07:15:54 Views: 286
• 

  Application of the row_number () function of MSSQL sql server 2005x2008-delete the weight in the table

  Transferred from: the function of the http://www.maomao365.com/?p=4942**row_number function in the database is to generate a number for each row according to certain rules. We often use this attribute to paginate the table.

  2022-06-01 07:15:53 Views: 220
• 

  Optimization idea of latch:cache buffers chains

  Data blocks are stored in buffer cache as linked list. When a session wants to access / modify the block of a buffer cache, it first needs to check whether the block exists in the bu through the hash algorithm

  2022-06-01 07:15:50 Views: 271
• 

  Mysql startup and shutdown (manual and automatic)

  Manually manage the startup and shutdown of mysql [root@mysql ~] # service mysql start-- manually start mysqlStarting MySQL. SUCCESS! [root@mysql ~]

  2022-06-01 07:15:50 Views: 208
• 

  PostgreSQL: source code directory structure

  Part of the file used by the source code structure aclocal.m4:config, the directory of the file used by config/:config, the config.log:configure:configure file configure.in:co.

  2022-06-01 07:15:39 Views: 221
• 

  Stored procedure + job regular execution of fixed SQL statements

  When making a report, it needs to read a large amount of data and carry out complex calculations, which is often time-consuming, so the results are generally stored in a result table, and the report reads the result table directly, which will be very fast. At this point, in order to update the result table and get the latest data, you need to execute some SQL statements regularly.

  2022-06-01 07:15:38 Views: 256
• 

  PingCAP Ma Xiaoyu: TiDB's Road to HTAP

  HTAP is a popular concept in the database field at present. It can support both OLTP (online transaction processing) and OLAP (online Analytical processing). It can cover the needs of most enterprise applications and solve their problems in one stop. This time, the editor had the honor to interview PingCA.

  2022-06-01 07:15:30 Views: 217
• 

  On the description of xtrabackup-slave-info parameters

  -- slave-info: this parameter is used when backing up slave. The name and binlog pos of master are printed, and the information is also written to xtrabackup_slave with the command of change master.

  2022-06-01 07:15:29 Views: 215
• 

  Optimization of shmall and shmmax parameters of kernel by Oracle performance

  1. The kernel's shmall and shmmax parameters SHMMAX = the size of the maximum memory segment configured-> this setting is better than SGA_MAX_SIZE. SHMMAX parameter: the Linux process can assign

  2022-06-01 07:15:29 Views: 291
• 

  Talk about several operation options of Oracle foreign key constraint (Foreign Key)

  Relational database is based on data table and relation. The data table organizes the data in DBMS with two-dimensional relationship, while the relationship establishes the association between the data tables and builds the real object model. The primary foreign key is a constraint object that any database system needs to exist, adding from the business logic in the object model

  2022-06-01 07:15:27 Views: 208
• 

  Direct path read/read temp wait event

  The direct path read/read temp wait event occurs when a session reads data blocks directly from disk to PGA (bypassing SGA). The following figure briefly describes how to read in this way: if the Ibig O subsystem does not support asynchronous I/Os, each and so on

  2022-06-01 07:15:27 Views: 290
• 

  Brief introduction of postgre directory structure

  Introduction to postgre directories: ├── base # contains subdirectories of each database subdirectory │ ├── 1 │ │ ├── 112 ├── global # subdirectories that contain cluster scope tables, such as pg_database │ ├──

  2022-06-01 07:15:27 Views: 288
• 

  MariaDB 10.3 instant ADD COLUMN level 100 million table millisecond plus field

  Adding fields is painful, and tables need to be rebuilt, especially for large tables at the level of 100 million. Although Online DDL can avoid locking tables, if it takes 30 minutes to execute on the master database, then the master-slave replication will be delayed if you copy to the slave database. Use instant ADD C

  2022-06-01 07:15:24 Views: 280
• 

  Cobar mysql High availability

  -server2 IP:172.25.38.2server5 IP:172.25.38.5-

  2022-06-01 07:15:24 Views: 240
• 

  Why is it so important for you to understand the execution plan?

  A handsome SQL was thrown into the far-reaching TCP tunnel by an ignorant teenager. The teenager waited hard, but he didn't come back with a full load. So the teenager was angry and took great pains to get a good code from du Niang, but what came was timeout. If you're going through it,

  2022-06-01 07:15:21 Views: 203
• 

  Transaction state persistence

  Function interface: trx_lists_init_at_db_starttrx_resurrect_inserttrx_resurrect_update transaction status: / *--

  2022-06-01 07:15:20 Views: 205
• 

  IStatistica Pro for Mac (Mac easy to use system monitoring software) v2.1

  IStatistica Pro for Mac is a powerful system status monitoring tool on Mac platform. IStatistica for Mac contains temperature sensor, fan monitor, etc., which can transfer Mac battery information, network activity, memory for you.

  2022-06-01 07:15:17 Views: 273
• 

  Introduction to mysqlslap stress Test

  Mysqlslap is a stress testing tool that simulates multiple clients to access the MySQL service and records the time spent at each stage. The main parameters are as follows:-- host=host_name,-h host_name MySQL server host

  2022-06-01 07:15:17 Views: 277
• 

  Enumeration of storage systems and computing platforms in the data center

  Author: Xiang Shifu transferred: Alibaba data Zhongtai official website https://dp.alibaba.com collection & transport layer Sqoop Hadoop, a tool for transferring data between relational databases. When transferring, multiple MR jobs will be started to transfer data D concurrently.

  2022-06-01 07:15:17 Views: 218
• 

  Several common methods and recovery steps of MySQL backup

  1.mysqldump2.mysqlbackup3.mysqlhotcopy4.xtrabackup/innobackupex5.cp backup is everything. Today, we will summarize several common backup methods and recovery steps. 1.

  2022-06-01 07:14:55 Views: 209