NAV: SLTechnology News&Howtos > Database >

• 

  MySQL DDL details revealed

  DDL sentence in MySQL, namely data definition language, is used to create, delete, modify, library or table structure, and operate on the structure of database or table. Common ones are create,alter,drop and so on. Such statements are usually costly, especially for large tables

  2022-06-01 06:14:26 Views: 302
• 

  Analysis and treatment of Master-Slave non-synchronization in MySQL

  Previously deployed Mysql master-slave replication environment (MySQL master-slave replication environment deployment [http://blog.itpub.net/31015730/viewspace-2153251/]) and summarized the principles of mysql master-slave replication and

  2022-06-01 06:14:26 Views: 240
• 

  The cause of MySQL Master-Slave delay and its solution

  The principle of master-slave synchronization delay in 1.MySQL database. When talking about the master-slave synchronization delay principle of MySQL database, we should start with the master-slave replication principle of mysql database. The master-slave replication of mysql is a single-threaded operation (before the mysql5.6 version), and the master library is responsible for all DDL and

  2022-06-01 06:14:25 Views: 264
• 

  Stuck recovery of database ORA-00600 [3020] (Doc ID 283269.1)

  In this DocumentSymptomsCauseSolutionReferencesApplies to:Enterprise Manager for Oracle Database-V

  2022-06-01 06:14:25 Views: 250
• 

  Oracle 9i switch logfile hang

  Phenomenon: solaris system oracle 9i single instance database SQL > alter system switch logfile; # hang solution: 1. Generate 10046 files: SQL > select

  2022-06-01 06:14:25 Views: 215
• 

  Database backup

  [oracle@oracle01 ~] $[oracle@oracle01 ~] $rman target / Recovery Manager: Release 11.2.0.4.0-Product

  2022-06-01 06:14:25 Views: 280
• 

  Performance deification, talk about Exadata's "Seven deadly sins"

  Performance deification, talk about Exadata's "seven deadly sins". What is Exadata? Like some domestic oracle database all-in-one brands, it is a set of software and hardware integrated database platform specially built for Oracle database, commonly known as "database all-in-one machine". You can simply

  2022-06-01 06:14:24 Views: 271
• 

  [Oracle Database] Oracle RAC (2): DNS

  [root@wallet03 ~] # yum install-y bind [root@wallet03 ~] # vi / etc/named.confoptions {listen-o

  2022-06-01 06:14:24 Views: 248
• 

  Oracle generates awr report

  1. The method of manually generating awr report 1. After the corresponding authorized user logs in (sysdba), execute @? / rdbms/admin/awrrpt.sql in $ORACLE_HOME/rdbms/admin2 and sqlplus, and follow

  2022-06-01 06:14:23 Views: 272
• 

  Steps for the 11gR2 RAC of Oracle to modify the listener port number

  Oracle 11gR2 RAC steps to modify the listener port number: 192.168.188.181: public ip1192.168.188.182 is public ip2192.168.188.183

  2022-06-01 06:14:23 Views: 248
• 

  Exploration and practice of distributed Cache Redis Cluster in Huatai Securities

  This article is selected from the 30th issue of the Frontier of Trading Technology (March 2018). Author: fan Jian, Chen Ying, GE Baolei / Huatai Securities Co., Ltd. Abstract: as the most popular open source distributed cache, what kind of application scenario will Redis Cluster have in the securities field? This article is from China.

  2022-06-01 06:14:23 Views: 206
• 

  Understanding of rollforward rollback for instance recovery when database startup starts

  The rollforward rollback process should be like this: the database records the latest SCN, the SCN of the incremental checkpoint, and the maximum SCN of the redo log, and starts applying the redo log through the SCN of the incremental checkpoint until the most of the redo log

  2022-06-01 06:14:23 Views: 236
• 

  All kinds of oracle awr generation scripts

  An instance @ $ORACLE_HOME/rdbms/admin/awrrpt.sql RAC report @ $ORACLE_HOME/rdbms/admin/awrgrpt.sql specifies an instance @ $ORACL

  2022-06-01 06:14:22 Views: 295
• 

  Mysql unzipped version runs

  Download address of mysql decompressed version: https://dev.mysql.com/downloads/mysql/ initializes mysql after decompression, open the command line (cmd) to enter the bin directory of mysql and enter the initialization mysql command:

  2022-06-01 06:14:15 Views: 297
• 

  Mysql innodb cluster building

  Build the https://dev.mysql.com/doc/refman/8.0/en/mysql-innodb-cluster-production-deployment.html environment according to the documentation.

  2022-06-01 06:14:15 Views: 267
• 

  ORA-27300: OS system dependent operation:fork failed with status

  Problem phenomenon: Sun Sep 30 21:12:28 2018Errors in file / DBSoft2/oracle/diag/rdbms/fzdbcgbk/fzdbcgbk1/trace/fzdb

  2022-06-01 06:14:15 Views: 231
• 

  [BASIS] HANA SR replication option

  When the replication mode details auxiliary system is not available, the primary system notes synchronizing synchronous the primary system waits for the secondary system to receive the data and persist it to disk. If the primary system waits to operate logshipping_timeout (the default is 30 seconds), the primary system

  2022-06-01 06:14:15 Views: 269
• 

  Synchronization of MySQL Cascade replication (1)

  Today encountered a strange problem, there is a set of environment, there are some problems in the master-slave replication. The general process design is as follows: the three nodes are located in three different areas, because there are problems in the network between node 1 and node 3, so node 2 is used to transfer, so the delay is inevitable, but

  2022-06-01 06:14:13 Views: 295
• 

  How to make MySQL more secure against decryption experts (transfer)

  How to make MySQL more secure against decryption masters [@ more@] when you connect to a MySQL server, you should usually use a password. Passwords are not transmitted on the connection in clear text. All other information is transmitted as text that can be read by anyone. If you're worried about that,

  2022-06-01 06:14:12 Views: 230
• 

  About the storage of FLOAT and DOUBLE types in MYSQL

  With regard to the storage of FLOAT and DOUBLE types in MYSQL, in fact, in single-precision and double-precision floating-point storage, their storage methods are both floating-point type, so-called floating-point type, in which the position of the decimal point is variable, and the range that can be expressed is larger than that of a fixed point.

  2022-06-01 06:14:12 Views: 301