NAV: SLTechnology News&Howtos > Database >

• 

  MySQL master-slave synchronous error report, server-id consistency leads to error report

  Today, a new slave library is added to synchronize master data, but the my.cnf configuration file is copied directly without modifying server-id, resulting in an error: 2017-04-01 14:57:16 140661325472512 [Note]

  2022-06-01 15:35:40 Views: 285
• 

  Memcache service building

  The function of MemcacheMemcache is well described on the Internet. To put it simply, it is to reduce the pressure of reading the database. The principle is also very simple: the requested data will be fetched in memcache first. If not, go to the database and bring a copy to memcache by the way.

  2022-06-01 15:35:12 Views: 279
• 

  Analysis of 1Z0-052 in Chinese and English (3)

  Which two operations can be performed on an external table? (Choose two.) A. Create a view on the tab

  2022-06-01 15:35:11 Views: 237
• 

  Advantages and disadvantages of Paradigm and Anti-normal form in Mysql

  Today, I would like to talk to you about the advantages and disadvantages of paradigm and anti-paradigm in Mysql. Many people may not know much about it. In order to make you understand better, the editor has summarized the following for you. I hope you can get something from this article. The first paradigm 1NF is the atomicity of attributes.

  2022-06-01 15:35:01 Views: 266
• 

  What are the main application scenarios of redis

  What are the main application scenarios of redis? 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. Redis has created a new idea of data storage. With Redis, we don't have to face the function.

  2022-06-01 15:35:01 Views: 249
• 

  Use LogMiner to analyze redo logs and archives for oracle

  Oracle LogMiner is a practical and useful analysis tool provided by Oracle since product 8i. Using this tool, you can easily obtain the specific contents of Oracle online / archive log files, especially the tool can analyze all the data.

  2022-06-01 15:35:00 Views: 286
• 

  What if the alert_sid.log alarm log cannot be found?

  There are always some DBA or engineer-installed databases that are not standard enough to find the alarm log file according to the regular discussion. Let me tell you a little way, no matter how you don't follow the routine, I can find the alarm log. 1. View the parameter background_dump_destS

  2022-06-01 15:35:00 Views: 244
• 

  The method of realizing message queue in redis

  The editor in this issue will bring you the method of realizing message queue in redis, which will be analyzed and described from a professional point of view. I hope you can get something after reading this article. Message queuing, Message Queue, is often used to solve resource consistency in concurrent systems

  2022-06-01 15:34:57 Views: 271
• 

  How to configure redis persistence

  The editor in this issue will bring you a way to configure redis persistence, analyze and describe it from a professional point of view. I hope you can get something after reading this article. Since the data of Redis is stored in memory, if persistence is not configured, redis restarts

  2022-06-01 15:34:54 Views: 215
• 

  Introduction to DBM_SQLTUNE usage

  Permissions required for the use of DBMS_SQLTUNE grant advisor to user;grant select_catalog_role to user;-- essential grant exe management through OEM

  2022-06-01 15:34:47 Views: 212
• 

  Introduction and use of redis command

  This article shows the syntax and use of the redis command, the code is concise and easy to understand, and it will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article. The Redis command is used to perform operations on the redis service. To take it in redis.

  2022-06-01 15:34:47 Views: 253
• 

  The realization method of Database synchronization to Redis

  Today, I will talk to you about the implementation of database synchronization to Redis, many people may not know much about it. In order to make you understand better, the editor summed up the following content for you. I hope you can get something according to this article. Most of us tend to use this approach, that is, in the database

  2022-06-01 15:34:47 Views: 265
• 

  Steps to set up and configure a redis cluster

  The editor in this issue will bring you the steps of building and configuring redis clusters, and analyze and describe them from a professional point of view. I hope you can get something after reading this article. The Redis cluster needs at least three nodes, because the voting fault tolerance mechanism requires more than half of the nodes to think

  2022-06-01 15:34:47 Views: 254
• 

  Locking Mechanism in mysql Database

  This article will explain in detail about the locking mechanism in the mysql database. 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. Mysql locks are mainly divided into three categories: table-level locks: storage engine is Myisam. Lock

  2022-06-01 15:34:46 Views: 302
• 

  How to query and delete duplicate records by MySQL

  This article uses easy-to-understand examples to introduce MySQL how to query and delete duplicate records, the code is very detailed, interested friends can refer to, hope to be helpful to you. Find records for all duplicate headings: select title,count (*

  2022-06-01 15:34:46 Views: 253
• 

  SQL attached database

  The attached database copies the database files and log files that need to be attached to a folder that has been created. For educational purposes, we copied this file to the directory DATA folder that was generated when we installed SQL Server. In the following window, right-click the database object, and in the shortcut

  2022-06-01 15:34:34 Views: 270
• 

  Steps of building mysql master-slave service in cnetos7 system

  The editor in this issue will bring you the steps of building mysql master and slave services in the cnetos7 system, and analyze and describe them from a professional point of view. I hope you can get something after reading this article. one。 Install from virtual machine: 1, right-> manage-> Clone 2, select

  2022-06-01 15:34:15 Views: 225
• 

  SEGMENT_SIZE hasn't changed since TRUNCATE TABLE?

  In the test environment, the historical transaction table can be emptied, as long as the table structure is retained. So I want to clean up the space through TRUNCATE, and it turns out that after TRUNCATE, the size of SEGMENT has not changed. The query found that it was due to the INITIAL_EXTEN of the table

  2022-06-01 15:34:15 Views: 277
• 

  SQL string merging

  Create table # tb (id int, value varchar (10), cname varchar (20)) insert into # tb values (1, 'aa','aaaa') I

  2022-06-01 15:34:14 Views: 288
• 

  Use of RunTime-Category changes all fonts for the entire project

  On the basis of the relatively mature project, there is such a demand that new fonts need to be introduced in the application, and all Label default fonts need to be replaced, but at the same time, some special label fonts do not need to be replaced. At first glance, this problem is indeed very thorny, first of all, the project

  2022-06-01 15:34:14 Views: 266