NAV: SLTechnology News&Howtos > Database >

• 

  Mysql Learning 6: chapter 3 MYSQL Architecture and Storage engine

  1. Chapter 3 MYSQL architecture and storage engine 1.1. Mysql architecture is divided into two layers: l mysql server layer: including connection layer, SQL layer; l storage engine layer; 1.2. Detailed explanation and clearance of query cache

  2022-06-01 04:50:40 Views: 299
• 

  One of the DataGuard broker: an introduction to DataGuard broker

  After taking a look at DataGuard broker, it feels good, and after testing it, consider whether to configure it in a production environment. [@ more@] The Data Guard broker is a distributed management architecture for automatically creating, maintaining, and monitoring dat

  2022-06-01 04:50:39 Views: 278
• 

  Some experience on MySQL Security (Anonymous users)

  We know that after installing MySQL, it will automatically create a root user and an anonymous user whose initial password is empty. For the former, many Resources will remind you to set a password in time, while ignoring the latter, probably because the latter is set by default only in this

  2022-06-01 04:50:39 Views: 225
• 

  Midea Operation and maintenance Diary | need to know the software version of Oracle database

  Why do you recommend 19.3 for the new environment version when the customer AGR 11g extension service expires? Customer B: will it be difficult to operate across so many versions? Customer C: then why are there still manufacturers in Amway 10g/11g? Intern D: from 12c to 18c to 19c, in the middle

  2022-06-01 04:50:34 Views: 273
• 

  Detailed interpretation of Oracle SCN Mechanism

  In-depth Analysis-detailed interpretation of https://mp.weixin.qq.com/s?__biz=MjM5MDAxOTk2MQ==&mid=2650276971&idx=1&sn=b5f by Oracle SCN Mechanism

  2022-06-01 04:50:33 Views: 239
• 

  The Oracle 12C RAC cluster node cannot be started due to the loss of private IP

  A production environment Oracle Linux 7.1 Oracle 12C RAC shows that the cluster resources of node 1 are not started. The information is as follows: [grid@cs2 ~] $crsctl stat res-t-

  2022-06-01 04:50:33 Views: 256
• 

  2011-10-10 COLLECTION EXISTS accepts the performance of NULL parameters

  Http://www.itpub.net/thread-1499223-2-1.html15 Building I created this help function to display the value of the Boolean variable: CREATE OR REPLACE PROCEDURE plc

  2022-06-01 04:50:33 Views: 250
• 

  Direct path read/write

  Direct path read1. Principle: this wait event occurs when the session reads the data block directly into the PGA instead of the SGA. The read data is usually private to the session, so it does not need to be put into the SGA as shared data, because this is the case.

  2022-06-01 04:50:32 Views: 223
• 

  4215 The log was not truncated because records at the beginning of the log

  Backup Times wrong The log was not truncated because records at the beginning of the log are pending replication.

  2022-06-01 04:50:29 Views: 298
• 

  Oracle installs environment configuration under Linux

  1. Check the memory situation 2. Check the swap situation 3. Check the disk space 4./tmp directory space is larger than 400MB1. Create user group 2. Create user 3. Set the password for oracle users # mkdir-p / u01/app/oracle/pr

  2022-06-01 04:50:29 Views: 237
• 

  Separation of HA read and write by PostgreSQL+Pgpool

  Environment description and host planning: operating system hostname host role port CentOS 7.3 master 10.0.40.191 PG-Master 54321 CentOS 7.3 slave 10.0.40.

  2022-06-01 04:50:29 Views: 258
• 

  RHEL install Xtrabackup

  Xtrabackup is a mysql database backup tool provided by percona. According to official introduction, it is the only open source tool in the world that can provide physical hot backup for innodb and xtradb databases. There are two main components in Xtrabackup

  2022-06-01 04:50:28 Views: 223
• 

  Online ddl add multiple columns

  Pt-online-schema-change-user=root-password=root-defaults-file=/home/mysql/my6306.cnf-charset

  2022-06-01 04:50:28 Views: 271
• 

  Oracle performance tuning-Virtual Index

  1. Introduction DBA in daily maintenance and management database for low-performance SQL analysis, sometimes need to create an index to optimize SQL, but sometimes the index we create can be used? The effect can only be seen after this is created, but in practice, especially for large tables.

  2022-06-01 04:50:28 Views: 207
• 

  Oracle12c solves plsql login CDB and PDB problems

  I have nothing to do today. I installed oracle12c on win10, thinking that it can be operated normally. During the installation, there is a check box that is created as a container database. Although I don't know what it means, I checked it. Later, when logging in using plsql, I found that there was no sco.

  2022-06-01 04:50:22 Views: 235
• 

  The process of indicating that the dmwatcher.ctl file does not exist when the Damon count Watcher service is started

  When starting the Damon count Watcher service, it is prompted that the dmwatcher.ctl file does not exist, as follows: [dmdba@localhost DAMENG] $/ etc/rc.d/init.d/DmServiceWatche

  2022-06-01 04:50:21 Views: 264
• 

  The execution efficiency of exists statements in MYSQL becomes lower.

  In ORACLE, we often recommend using exists instead of in, which can also achieve better optimization results. In the process of moving the ORACLE application to MYSQL, we found that part of the sub-query statements of in were brought into MYSQL, and its execution efficiency became very high.

  2022-06-01 04:50:21 Views: 279
• 

  Sqlserver sets the linked server for oracle

  First install the client side of oracle on the sqlserver server: configure listening and tnsnames:tnsnames:D:\ app\ username\ product\ 11.2.0\ client_1\ netwo

  2022-06-01 04:50:15 Views: 242
• 

  Add remote control user to MySql (transfer)

  Add remote control user (transfer) [@ more@] to MySql. After installing MySql, there is only one super administrative user ROOT, and ROOT restrictions can only be used on the local database. What if we want to remotely manage MySql? So, actually, we need

  2022-06-01 04:50:12 Views: 233
• 

  Oracle 12.2 RAC on Linux Best Practice Documentation

  The Oracle 12.2 RAC on RedHat 7.3 Best Practice Documentation# project requires the construction of multiple RAC sets. In order to reduce the management cost, a unified 12.2 RAC template is established. Hope

  2022-06-01 04:50:12 Views: 249