NAV: SLTechnology News&Howtos > Database >

• 

  In-list extension & quot;inlist iterator" & quot;concatenation"

  The purpose of the experiment is to distinguish "inlist iterator" from "concatenation" in IN-LIST, to study the principle of it, and then to understand the tuning of sql. Note that the conjunction is the column keyword with index: / * + USE_CONCAT

  2022-06-01 06:58:11 Views: 234
• 

  Blocking Lookup Lock in RAC Environment

  Blocking in the RAC environment is different from the single-instance case because we need to take into account the session in different instances. That is to say, the previously queried vaccounsessionprecinct vroomlock should be changed to the global scope to find it. This paper provides two query scripts and gives an example.

  2022-06-01 06:58:10 Views: 208
• 

  [Mysql] use pt-table-checksum to check consistency between master and slave different ports

  Background master: 10.32.7.113 3306 from: 10.32.7.112 3307step 1: establish slave database information master database test database create table CREATE TABLE `dsns` (`id` int (11) NOT

  2022-06-01 06:58:10 Views: 249
• 

  [Redis] Fast replication from redis-cluster to redis-cluster

  The existing requirement is a rapid migration from redis-cluster to redis-cluster, and after the migration, two sets of redis-cluster have to use the independent approach one: use the online migration tool redis-mi in the previous redis migration

  2022-06-01 06:58:10 Views: 222
• 

  Mysql's summary of the tables for the memory engine

  See the official document https://dev.mysql.com/doc/refman/5.7/en/memory-storage-engine.html summary 1, memory engine table data is only stored in memory, after the data is inserted

  2022-06-01 06:58:09 Views: 245
• 

  The difference between MySQL host 127.0.0.1 and localhost

  1. Localhost is also called local, and the correct interpretation is: local server 127.0.0.1 in windows and other systems, the correct interpretation is: local address (local server) their resolution through the local host file, windows automatically loc

  2022-06-01 06:58:09 Views: 289
• 

  Patch 26925532-Oracle JavaVM Component 11.2.0.4.180116 Database PSU

  Https://updates.oracle.com/Orion/Services/download?type=readme&aru=21753493This document describes h

  2022-06-01 06:58:09 Views: 275
• 

  MySQL case-unlimited memory usage growth

  It has been dragging on for a long time, take the time to make up _ (: "∠") _

  2022-06-01 06:58:05 Views: 220
• 

  How to prove that the leaf nodes of INNODB secondary index are sorted according to PRIMARY KEY with the same key value

  Then how big is the NEXT-KEY LOCK scope in http://blog.itpub.net/7728585/viewspace-2126305/RR mode to prove the point: 1. Analyze the linked list in the page of the secondary index, if in the secondary index

  2022-06-01 06:58:04 Views: 287
• 

  Shared Pool shared pool

  Definition: a shared pool (shared pool) is an area of memory located in SGA and is mainly used to cache the execution plan of SQL. It is called sharing because this block of memory area can be shared by multiple sessions with the same execution plan. That is, if there is a session that executes SQL

  2022-06-01 06:58:04 Views: 267
• 

  Principle of MySQL Master-Slave replication and Summary of necessary knowledge

  This article is mainly about some principles and necessary knowledge of mysql master-slave replication. For the construction of mysql master-slave environment, please refer to another blog: MySQL master-slave replication environment deployment [http://blog.itpub.net/31015730/v]

  2022-06-01 06:57:57 Views: 244
• 

  Introduction to the concept, advantages and disadvantages of MySQL vertical segmentation and horizontal segmentation

  The Sharding of data can be divided into two segmentation modes according to the type of segmentation rules. One is to split into different databases (hosts) according to different tables (or Schema), which can be called vertical (vertical) segmentation of data; the other is root.

  2022-06-01 06:57:52 Views: 215
• 

  Thoughts on deleting a large amount of data (2)

  In part 1 of this short series, I provided an informal description of two scenarios in which we can make large-scale deletions from the table. Without a specific example, it is difficult to imagine the impact of a large amount of data deletion on the performance of the system due to the nature of the deleted data and the available access paths.

  2022-06-01 06:57:52 Views: 225
• 

  How To Use DBMS_ADVISOR.TUNE_MVIEW Tuning Materialized Views

  SQL Access Advisor index recommendations include bitmap, function-based, and B-tree indexes. A bitma

  2022-06-01 06:57:52 Views: 231
• 

  Notes on the installation and use of elasticsearch Import and Export tool elasticdump

  You need to install npm tools first. For more information, please see: https://www.runoob.com/nodejs/nodejs-npm.html starts to install elasticdump:# npm install elastic.

  2022-06-01 06:57:51 Views: 248
• 

  Detailed explanation of CONTROL_FILE_RECORD_KEEP_TIME and MAXLOGHISTORY parameters

  Before we begin, let's take a look at the official documentation explaining CONTROL_FILE_RECORD_KEEP_TIMEWhy is the MA to CONTROL_FILE_RECORD_KEEP_TIME and MAXLOGHISTORY.

  2022-06-01 06:57:51 Views: 290
• 

  On the perfect solution to the language problem of Mysql 4.1 (turn)

  The perfect solution to the Mysql 4.1language problem (turn) [@ more@] does not need to modify the my.ini. When setting up a database, it is not important to set the character set of the library and table, but it is best to set the GBK character set for fields of text type. For the existing

  2022-06-01 06:57:51 Views: 292
• 

  Repair method of building files to local storage in rac archive mode / non-archive mode-ORA-01157

  File build to local storage repair method in rac archive mode (the following is the test, careful operation in production environment) Simulation misoperation Node 1 add data file Click (here) collapse or open SQL > alter tablespace netdata add dataf

  2022-06-01 06:57:50 Views: 242
• 

  MySQL master and slave have equal MySQL server UUIDs

  Today, I backed up the data from a slave and wanted to create another slave. After startup, I reported an error: Last_IO_Error: Fatal error: The slave Imax O thread stops because ma

  2022-06-01 06:57:50 Views: 303
• 

  Oracle Rman

  Rman can be used for database replication: for testing or development; one is to copy manually, and the other is to use Rman duplicate; to manually copy, first shut down the database, and then package the related files and copy them to another server, using s

  2022-06-01 06:57:48 Views: 201