NAV: SLTechnology News&Howtos > Database >

• 

  Variables, query caches, and indexes of MySQL

  System database mysql database in MySQL: it is the core database of mysql, similar to the master library in sql server. It is mainly responsible for storing the control and management information PE that mysql needs to use, such as database users, permissions settings, keywords and so on.

  2022-06-01 12:47:34 Views: 216
• 

  Alarm problems encountered in 12c-rac installation (SCAN)

  1. Describe that there will always be an alarm when installing the pre-check of oracle 12c rac graphical interface, which looks very uncomfortable. The alarm message is as follows: INFO: PRVF-4664: Found inconsistent name res

  2022-06-01 12:47:33 Views: 261
• 

  02.redis installation

  Because I am using the centos7 mini version here, I need to install gcc, and install gcc with the command shown below (because redis is developed in C, you need to install the gcc compiler environment). After linux is installed, you can download redis (

  2022-06-01 12:47:26 Views: 223
• 

  Mysql initialization error [1] Can't find error-message file & # 39 * * usr *

  Environment: CentOS 7.2MySQL 5.7.18 download the rpm package from the official mysql website to the server local, and install the following RPM package: mysql-community-common-5.7.18-1.el7.x86 _

  2022-06-01 12:47:22 Views: 268
• 

  Backup concept (consistency, inconsistency)

  Consistent backup (consistent backup) means that all changes in each file included in the backup have the same system change number (system change number,SCN). That is, in the various files contained in the backup

  2022-06-01 12:47:22 Views: 302
• 

  Shell implements mysql database backup / compression / ftp upload

  #! / bin/bash#author:zwy#2016-12-15#auto backup db ypshdt= `date "+% Y_%m_%d" `prefix= "ypsh_" suffix='.sql

  2022-06-01 12:47:22 Views: 257
• 

  How MySQL Database works

  When we come into contact with a new thing, it is necessary to start with its working principle, to find out the context of this thing, to pave the way for further study, and to master its principle will help us to grasp this thing as a whole. and help us sort out our thoughts in the process of troubleshooting. Next, or

  2022-06-01 12:47:22 Views: 209
• 

  The user smsdb in Oracle cannot log in to LOCKED (TIMED)

  A user smsdb created. After the status LOCKED (TIMED) is unlocked, the conn smsdb/password still reports an error, and then it is locked. Finally, it is found that the number of wrong logins has reached the limit of 10 times for oracle. As a result, subsequent login is not possible.

  2022-06-01 12:47:21 Views: 238
• 

  SQLServer from beginner to proficient

  1. Data paging OFFSET: specifies the number of rows that will be skipped before returning rows from the query expression. FETCH: specifies the number of rows to be returned after the OFFSET clause. OFFSET is synonymous with page number, and FRTCH represents the number of rows displayed per page. Select P

  2022-06-01 12:47:21 Views: 228
• 

  Oracle rman restore error RMAN-06023

  When building the dg, I used the complete equipment of the main database to restore in the standby database. After the first recovery, gap appeared, and then I wanted to use the latest backup to restore the data again, so the following problems occurred: error: RMAN-00571: =

  2022-06-01 12:47:18 Views: 298
• 

  Reconstruction Control File of ORACLE

  Uploading pictures here has always failed. If you want to view details and screenshots, you can download attachments. First, take a look at the understanding of the control file: the control file is a binary file that records the physical structure of the database. A control file belongs to only one database. When you create a database, create a control file. When data

  2022-06-01 12:46:48 Views: 218
• 

  Solaris 10 (x86) to build Oracle 10g RAC-- install CRS

  Solaris 10 (x86) build Oracle 10g RAC-install CRS system environment: operating system: Solaris 10 (x86-64) Cluster: Oracle CRS 10.2.0.1.0Ora

  2022-06-01 12:46:48 Views: 300
• 

  Sql is displayed according to the order of the data in in

  The first way to write it: SELECT USER_ID,USER_NAME FROM user WHERE USER_ID in (1008622115Jing 1008610664Jing 1008622031Jing 10086103

  2022-06-01 12:46:47 Views: 282
• 

  How to avoid brain fissure by Oracle RAC

  The bebeOracle CSSD (Cluster ServicesSynchronization Daemon) process monitors the health of cluster nodes through two independent heartbeats: network heart bea

  2022-06-01 12:46:41 Views: 258
• 

  How to modify the parameters of spfile when the Oracle instance is closed

  Important note: since this article is tested and completed by myself, there may be some shortcomings, and there may be different solutions in different environments. This article is for reference only, and welcome to refer to the description of the problem: modify the sga size in 11G stand-alone ASM, after modification, close instance and s.

  2022-06-01 12:46:32 Views: 249
• 

  SpringBoot (14): using SQL relational databases-transaction processing

  First, the four characteristics of a transaction (ACID) atomicity (Atomicity): a transaction is an atomic operation, which consists of a series of actions. The atomicity of the transaction ensures that the action is either complete or completely ineffective. Consistency (Consistency): once the transaction is completed (no

  2022-06-01 12:46:32 Views: 271
• 

  Add, delete, modify and check the basic operation of mysql

  Query query all columns select * from table names; for example: select * from classes; query specifies that columns can use as to specify aliases for columns or tables: select column 1, column 2. From table name; example: select

  2022-06-01 12:46:31 Views: 228
• 

  Transaction and try catch usage in SQL statement

  Ordinary SQL transactions: begin transaction tr declare @ error int; set @ error=0; select * from Car_Brand set @

  2022-06-01 12:46:31 Views: 255
• 

  After installing oracle, there is no network directory under the installation directory, and the placement directory of tnsnames.ora

  When installing oracle, you chose the first option:install client that does not have a network directory, so you should choose the second: administrator, the directory where my tnsname.ora is placed is: d:\ app\ computer name\ product\

  2022-06-01 12:46:16 Views: 242
• 

  Guarantee of consistency between cache and database

  It's all practical information! This paper mainly discusses the following questions: (1) when the data in the database and the cache will be inconsistent (2) inconsistent optimization ideas (3) how to ensure the consistency between the database and the cache 1. When the data changes, the point of "eliminate the cache first and then modify the database" is everyone's point.

  2022-06-01 12:46:16 Views: 223