NAV: SLTechnology News&Howtos > Database >

• 

  How to install MySQL8 compressed package version of Win10

  This article mainly shows you how to install Win10 compressed MySQL8 package version, the content is easy to understand, I hope you can learn, after learning there will be a harvest, the following let the editor to take a look at it. 1 official website download MySQL8 installation this download is a

  2022-06-01 08:04:22 Views: 212
• 

  Easily master the way of database management-- operation and maintenance inspection part 7 (log)

  In the preface, daily inspection is an important step in database management and maintenance, and it is necessary to register the date and result of each inspection, and a patrol report may be needed at the same time. The purpose of this series is to solve some common problems: do not know what to patrol, do not know how to facilitate the physical examination machine, there are too many physical examination troubles.

  2022-06-01 08:04:10 Views: 211
• 

  Mysql master-slave copy notes

  1. Failure level S1 is the most serious, affecting 30% of the transaction volume lasting more than 15 minutes, or affecting 30% of users' normal access, lasting more than 15 minutes S2 is more serious, affecting 15% of the transaction volume more than 15 minutes S3 serious failure, affecting 5% of the transaction volume for about 15 minutes

  2022-06-01 08:04:00 Views: 282
• 

  Ora-03113 error-solving

  When you open the database, you can start to mount status, to open Times 03113 error, there are too many archived logs, resulting in insufficient space, just increase the archived log space. Solution: enter the path and check alert_oracle.log. You can see the following file record errors:

  2022-06-01 08:04:00 Views: 244
• 

  MongoDB Note 2

  5. Mongodb's API http://api.mongodb.org/js/2.4.9/index.html VI. Mongodb's shell built-in javascript engine can directly execute js code funct

  2022-06-01 08:03:59 Views: 250
• 

  Simple configuration of Mysql database cluster

  Environment: 192.168.5.155 mysql-mgm-node192.168.5.156 mysql-sql-node1 mysql-data-node1192.168.5.157 mysql-sql

  2022-06-01 08:03:59 Views: 230
• 

  Oracle parallel Foundation I

  Oracle parallel Foundation (serial 1) author: Wei Xinghua, a senior database technology expert at Waldorf Technology, summarizes that Oracle Enterprise Edition has a very powerful technology: parallel query, that is, a statement can employ multiple server processes (parallel slaves is also called P

  2022-06-01 08:03:50 Views: 293
• 

  [ORACLE] ORA-12537

  This problem is caused by the excessive size of the monitoring log. Here are the solutions: 1. Delete the listener.log under... / product/10.2.0\ db_1/NETWORK/log and restart the listener rename listener.

  2022-06-01 08:03:50 Views: 231
• 

  Spring aop + xmemcached configure service layer caching policy

  Basic introduction to the function and use of Memcached 1, for cache access, in short, is to store data in memory in the form of key-value pairs. The operations involved in the daily business are nothing more than additions, deletions, alterations and queries. After adding the caching mechanism, when querying, the data is cached, added, deleted and modified.

  2022-06-01 08:03:50 Views: 266
• 

  Getting started with the basic operation of MongoDb

  About 1.MongoDb mongodb is an open source database system based on distributed storage, also known as document database, which can store data as a document. The data structure is composed of key-value pairs (key= > value), and the stored documents are similar to JSON objects (BS).

  2022-06-01 08:03:49 Views: 208
• 

  Oracle tasks transfer history manually

  Select to_char (rwfpsj,'yyyy-mm-dd'), rwzt,count (*) from out_sale_task_d0906 t group by rwzt, to_char

  2022-06-01 08:03:37 Views: 260
• 

  ADG terminated by LGWR, terminating the instance

  11.2.0.4 RAC TO RAC FOR ADG environment. Due to historical reasons, standby node 2 has not been started, and it has always been a startup node to provide external services. Node 1 alert reports an error, and lgwr performs kill instance operation and restarts itself. Mon D

  2022-06-01 08:03:37 Views: 231
• 

  Centos7 systemctl Management mysql

  Centos 7 started using systemctl to manage the service script directory / etc/systemd/system/mysql.service script as follows: # # Simple MySQL systemd serv

  2022-06-01 08:03:37 Views: 211
• 

  Grid user cluster monitoring for Oracle:RAC? Node monitoring of oracle users

  A similar problem has been encountered: Oracle 11g R2.0.1 RAC grid cluster resource {crs_start listening resource name | svrctl start listener} after startup, one of the listeners always fails to start, enter

  2022-06-01 08:03:17 Views: 222
• 

  Analysis of ingenious tricks for data loading

  How does big data load the data? What problems should be paid attention to in data loading? What are the differences between relational databases and Impala and Hive loading data? Before you understand loading data, you must make clear the concept of "data validation", Impala and Hive and other relational data

  2022-06-01 08:03:17 Views: 277
• 

  Oracle asm amdu and dd use

  With the promotion of the new version of the database, ASM will certainly be paid more and more attention. Before 11g, what can be done is very limited. If you want a file in copyASM to come out, you can only use DD and exec dbms_file_transfer.copy_file ().

  2022-06-01 08:03:16 Views: 294
• 

  Oracle lock mechanism learning

  Brief introduction of locks: Oracle implements concurrent access control, which is achieved through locks. Locks are divided into pessimistic locks (transaction scheduling may be scheduled serially)-row-level locks at the transaction level. Optimistic lock (transaction is scheduled serially)-timestamp and transaction scheduling based on validation. The so-called optimistic lock refers to the transaction scheduling serial machine.

  2022-06-01 08:03:16 Views: 218
• 

  Postgresql add UUID function

  PostgreSQL has a built-in UUID type, but the default installation does not come with related functions and needs to be generated manually. 1. If it is a separate package installation, download the package to the website mentioned in my previous blog as shown below. 1. Master node: install postgresql94-c

  2022-06-01 08:03:16 Views: 206
• 

  How to use mysql foreign keys

  This article mainly shows you how to use mysql foreign keys, the content is easy to understand, I hope you can learn, after learning there will be a harvest, the following let the editor take you to take a look at it. What is a foreign key: a foreign key is a primary key in a table where there is a field pointing to another table.

  2022-06-01 08:03:07 Views: 286
• 

  How to use mysql join query, federated query, subquery

  This article mainly explains how to use mysql join query, federated query, sub-query, the content is clear, interested friends can learn, I believe it will be helpful after reading. Join query: join query is to join multiple tables together to query, join query mode has internal connection

  2022-06-01 08:02:56 Views: 255