NAV: SLTechnology News&Howtos > Database >

• 

  Building of mysql Learning Notes MHA is highly available

  4. Build MHA high availability 4.1 architecture diagram here only one set of master and slave is built, the architecture is as follows: 4.2 install MHA Node all nodes need to be installed, including MHA,Master,Slave4.2.1 installation dependency package yum install-y

  2022-06-01 06:27:14 Views: 244
• 

  The use of Oracle ASM AMDU tools

  In Oracle 10g, the information of the ASM disk group can only be queried through the internal view after Mount. If the disk group cannot be loaded normally because of a fault, then the information will not be available, which brings a lot of inconvenience to the diagnosis of ASM-related faults. Oracle in 11g

  2022-06-01 06:27:14 Views: 241
• 

  Construction of Oracle 19c Data Guard physical Reserve Library

  The deployment target sets up the deployment target deployment environment introduces the operation procedure (1). Check the configuration of the main library archive and additional logs. The following output shows that archive mode is enabled but no additional logs are enabled; [oracle@sdedu ~] $sqlplus / as sysdb

  2022-06-01 06:27:13 Views: 215
• 

  Centos7 installs mysql database

  Centos7 install mysql New address https://blog.csdn.net/qq_30758673 download install mysql uninstall the built-in mini library rpm-qa | grep mariadb | xargs rp

  2022-06-01 06:27:13 Views: 279
• 

  [PSU] Oracle hits PSU and uninstalls PSU (single instance)

  1. Planning database version: Oracle 11.2.0.4 single instance operating system: Redhat 6.5 64-bitPSU: p28204707_112040_Linux-x86-64.zipOPatch:

  2022-06-01 06:27:13 Views: 300
• 

  Summary of whether the MySQL null value field uses an index

  The invalidation of null and not null indexes is mainly related to the establishment of fields in the table, which is divided into two corresponding cases. When an index is used for fields that cannot be null, both null and not null indexes are invalid, and when fields that can be null are used.

  2022-06-01 06:27:13 Views: 242
• 

  MySQL-- Index Optimization principle

  Index optimization principle 1, leftmost prefix matching principle, federated index, mysql will stop matching from right to range query (>, <, between, like), such as a = 1 and b = 2 and c > 3 and d

  2022-06-01 06:27:12 Views: 253
• 

  Talking about 30 methods commonly used to optimize sql statement query in MySQL

  1. In order to optimize the query, we should avoid full table scanning as far as possible, and first consider establishing indexes on the columns involved in where and order by. 2. Try to avoid using the! = or < > operator in the where clause, otherwise the engine will abandon the use of the index and do it all.

  2022-06-01 06:27:12 Views: 278
• 

  Oracle data pump import encounter bug record

  In the afternoon, I received a demand for guided data, a table, more than 200,000 data, and a small case, but encountered a problem. Key error report: ORA-39097 ORA-39065 ORA-01427 ORA-39126 ORA-06502 LPX-002

  2022-06-01 06:27:12 Views: 260
• 

  Merry Christmas: draw a Christmas tree with GaussDB T and discuss the syntax compatibility of Gauss database

  In the twinkling of an eye is the Christmas holiday, I wish you all a happy holiday. Draw a Christmas tree with GaussDB T (that is, GaussDB 100), pure domestic, more festive. Needless to say, the picture above: SQL is as follows: SELECTCASE WHEN ENMOTEC

  2022-06-01 06:27:06 Views: 227
• 

  Summary of MySQL basic knowledge points

  This article gives you a summary of the 23 basic knowledge points of mysql, which are all necessary knowledge for learning mysql, which friends can refer to. 1. What is the SQL statement sql language: a structured query language. (Structured Query Lang

  2022-06-01 06:27:05 Views: 280
• 

  Mysql startup error (InnoDB: Operating system error number 13)

  Service mysqld status can see mysqld status service mysqld start can start mysql and startup error can be viewed / var/log/mysqld.log if the error message is as follows

  2022-06-01 06:27:05 Views: 246
• 

  PL/SQL operator

  An operator is a symbol that tells the compiler to perform specific mathematical or logical operations. The PL/SQL language has a wealth of built-in operators, which provide the following types: arithmetic operators the following table lists all the arithmetic operators supported by PL/SQL. Hypothetical variables Atom 10 and variable Broad 5

  2022-06-01 06:27:05 Views: 209
• 

  Enable synchronization after DUPLICATE is available. Open ADG to open database. Error: ORA-10458

  Enable synchronization after preparing the library DUPLICATE. Open ADG to open the database. Error: ORA-10458SQL > select status from vastness instanceism STATUSMUSMOUNTED

  2022-06-01 06:27:05 Views: 260
• 

  New features of MySQL 8.0.2 increase flexibility of UNDO tablespace management

  A self-translated article, originally from the official MySQL Server team blog: original link: http://mysqlserverteam.com/mysql-8-0-2-more-flexible-undo-tabl

  2022-06-01 06:27:03 Views: 265
• 

  SQL Server 2017 AlwaysOn on Linux configuration and maintenance (14)

  2.5 Action 2.5.1 availability group upgrade before upgrading, you can refer to the model and practice of upgrading AG replica instances. The order in which instances are upgraded depends on whether the roles are secondary copies and whether they are synchronous or asynchronous copies. First upgrade the instance that hosts the asynchronous copy, and then upgrade the instance that hosts the synchronous replica

  2022-06-01 06:27:02 Views: 208
• 

  Dimp Times error, string truncation

  Phenomenon description Dameng also has its own logical backup tools (dexp, dimp) usage similar to Oracle. For more information, please refer to the official manual dexp&dimp.pdf. However, we sometimes encounter the problem of string truncation in dimp. Encounter

  2022-06-01 06:27:02 Views: 260
• 

  Oracle 19.3 Sharding installation configuration 02 (install Sharding- system management shards)

  Planning serial number hostname component sidOracle_HomeIP memory size 1gsm01shard Director/u05/../gsm_110.0.99.1014GB2gsm02shard Director/u05

  2022-06-01 06:27:02 Views: 209
• 

  Two backup-related tools in MySQL Database-- mysqlbinlog and mysqldump

  1. Mysqldump makes a full backup of the database in the command format: # mysqldump-h server ip-u user name-p password backup object > / dbdir/ file name. SQL description: 1. Do not specify the path to be stored in the current directory; 2. / dbdi

  2022-06-01 06:27:01 Views: 243
• 

  12 questions that DBA is following in 200000? DBASK answers the seventh issue of the collection.

  Original: introduction to https://www.enmotech.com/web/detail/1/796/1.html recently we have newly linked Han Feng Channel, Internet Reconnaissance, Database SQL, SQL Database Development, Cross-border in DBASK Mini Program.

  2022-06-01 06:26:59 Views: 234