NAV: SLTechnology News&Howtos > Database >

• 

  How to optimize the database

  In this issue, the editor will bring you about how to optimize the database, analyze and describe it from a professional point of view. I hope you can get something after reading this article. 1. Database optimization is a wide range, involving many things, and each specific database has its specific advantages.

  2022-06-01 15:42:03 Views: 266
• 

  How to optimize the SQL statement in MySQL

  This article will explain in detail how to optimize the SQL sentence in MySQL, the content of the article is of high quality, so share it with you for reference. I hope you can get something after reading this article. Structured query language (Structured Query Lang)

  2022-06-01 15:41:32 Views: 224
• 

  Environment configuration for oracle-basic configuration

  Host IP address: 10.1.1.x gateway: 10.1.1.1 virtual machine node IP address (created on the local workstation): 10.1.1.101room253 gateway: 10.1.1.1 teacher machine (VNC): 10.1.1.25

  2022-06-01 15:41:32 Views: 270
• 

  Deprecation of Listener Password in Oracle 11g

  Strongly oppose the configuration database listening password in Oracle 11g and later versions, force the use of local operating system authentication (LOSA) on the top of the check should also be updated to check the document, the official has been strongly opposed, you have to check whether the password is not quite right ah!

  2022-06-01 15:41:32 Views: 289
• 

  Infortrend database storage solution

  Storage requirements of database system for database storage, the most important thing is that it can fully support multiple random real-time queries / transactions from the client. Online transaction processing (OLTP) must be highly stable, and high IOPS of small chunks of data and excellent random read and write performance are required. In addition

  2022-06-01 15:41:26 Views: 296
• 

  Solutions to redis cache avalanche and cache penetration

  How to solve redis cache avalanche and cache penetration? I believe that many inexperienced people are at a loss about this, so this article summarizes the causes and solutions of the problem. Through this article, I hope you can solve this problem. Cache traversal refers to querying a data that must not exist. Due to slowness

  2022-06-01 15:41:19 Views: 227
• 

  Index optimization series three aggregation factors

  The colocated table has a certain physical order drop table colocated purge;create table colocated (x int, y varchar2 (80)) according to the x column.

  2022-06-01 15:41:19 Views: 224
• 

  Oracle 12.2 New feature-online conversion of non-partitioned tables to partitioned tables

  Before the Oracle12.2 version, there are several common ways to convert a non-partitioned table into a partitioned table: 1. Build the partitioned table and then insert into select inserts the data into the partitioned table; 2. Use online redefinition (DBMS_REDEF

  2022-06-01 15:41:19 Views: 279
• 

  How to Create an OCM Response file to Apply a Patch (document ID 966023.1)

  How to Create an OCM Response file to Apply a Patch in Silent Mode-opatch silent (document ID 966023.1) A

  2022-06-01 15:41:16 Views: 205
• 

  Brief introduction of Oracle Database

  (1) basic concept introduction there is a relational database of independent intellectual property rights (Dameng) in China, and its basic principle and management mode are similar to Oracle, so the main basic concepts involved and the significance of the representatives are basically the same, so there is no longer recalcitrant here, please refer to another article on Dameng database.

  2022-06-01 15:41:13 Views: 288
• 

  Install MYSQL under Ubuntu system

  Operating system version: Ubuntu 12.0LTS installation command: sudo apt-get install mysql-server checks whether MYSQL is installed successfully: sudo netstat-tap | grep m

  2022-06-01 15:41:09 Views: 270
• 

  How to realize distributed Lock through redis

  This article shows the specific operation of distributed locks through redis, the code is concise and easy to understand, can definitely make your eyes bright, through the detailed introduction of this article, I hope you can get something. Distributed lock is a way to control synchronous access to shared resources between distributed systems. In the distributed system

  2022-06-01 15:41:09 Views: 298
• 

  There are several modes of redis update cache

  How many modes are there in the redis update cache? In response to this problem, the editor summed up this article today, hoping to help more friends who want to solve this problem to find a more simple and feasible way. There are four kinds of Design Pattern for redis update cache: Cache asi

  2022-06-01 15:41:00 Views: 283
• 

  GitLab ce community version modified to mysql configuration (yum)

  Gitlab database replaced by mysql database Note: this I only succeeded in the 8.9.9 version of the experiment, because this 8.9.9 can be Chinese, the latest modification of mysql according to this method has a problem, see the comments, there is a netizen installed the latest. Install Mysql first

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

  The method of realizing paging query by redis

  In this issue, the editor will bring you the method of paging query on redis, and analyze and describe it from a professional point of view. I hope you can get something after reading this article. Paging query caching scheme based on SortedSet the first solution that comes to mind is to use @ se

  2022-06-01 15:40:50 Views: 279
• 

  The method of realizing incremental synchronization of redis

  This article will explain in detail the methods to achieve incremental synchronization of redis. The editor thinks it is very practical, so I share it for you as a reference. I hope you can get something after reading this article. 1. The concept of incremental synchronization incremental synchronization is when the master server has data

  2022-06-01 15:40:49 Views: 217
• 

  Sqladvisor- comments on sql statement Optimization tool

  Github address: https://github.com/Meituan-Dianping/SQLAdvisor/blob/master/doc/QUICK_START.md installation method: install the dependency package yum

  2022-06-01 15:40:49 Views: 216
• 

  The method of serialization by redisson

  This article uses easy-to-understand examples to introduce the method of redisson serialization, the code is very detailed, interested friends can refer to, hope to be helpful to you. Redisson is a Java resident memory data based on Redis.

  2022-06-01 15:40:49 Views: 253
• 

  A command destroys an instance of MongoDB

  A command destroys the MongoDB instance background Part1: written in the replica set architecture, we often adjust the background database architecture through the rs.add (), rs.remove () commands. In this case, we unexpectedly trigger a MongoDB

  2022-06-01 15:40:22 Views: 277
• 

  Data import and export, basic operations of table records, queries and matching conditions, multi-table queries,

  Data management: (manage table records) data import: store the contents of system files in the database. MySQL > create table uesr (- > name varchar (50),-> mima char (1),-> U

  2022-06-01 15:40:21 Views: 224