NAV: SLTechnology News&Howtos > Database >

• 

  How does AlwaysOn deal with large transaction operations?

  For archiving (or other large transaction operations) in AlwaysOn and mirror environments, I think we should pay attention to: 1. Try to avoid doing large transaction operations in synchronous mode, and once you decide to do so, please change to asynchronous mode. two。 Do it frequently and loop delete top every time you do it

  2022-06-01 21:23:30 Views: 296
• 

  Postgresql user Management

  Postgresql user management: default user: after postgres installation is complete, a user named postgres and a database also named postgres are automatically created in the operating system and postgres database, respectively. 1. Group roles

  2022-06-01 21:23:18 Views: 241
• 

  MySQL: common backup methods (based on 5.7)

  Http://xsboke.blog.51cto.com-------: thank you for your reference. If you have any questions, you are welcome to communicate 1. Mysqldump backup combined with binlog log recovery use mysqldump for full library backup

  2022-06-01 21:23:18 Views: 238
• 

  Oracle idle instance case

  Usually, either there is a problem with the environment variable, or there is a problem with the oracle execution file permissions, or the root user is used, or the oracle_sid export is set incorrectly, or the database itself is not started, and so on. The scenario described in this article is about an environment variable: su.

  2022-06-01 21:23:18 Views: 221
• 

  Interface of Sybase IQ-15_1 local login problem

  Environment description: operating system: rhel 5.4Database version: Sybase IQ-15_1 problem description: a customer in Shanghai Sybase IQ-15_1 database host restarts, Sybase IQ-15_1 database starts abnormally, due to database administrator

  2022-06-01 21:23:16 Views: 240
• 

  Xtrabackup of mysql data backup

  The previous article briefly introduced mysqldump for database backup and recovery, this one talked about another backup tool xtrabackup, in the era of InnoDB transaction engine flooding, xtrabackup can well support the hot backup of the database, this is very

  2022-06-01 21:23:16 Views: 276
• 

  Introduction to redis service & & detailed explanation of redis.conf profile

  # I. introduction to redis Service redis is a key-value storage system. Similar to Memcached, it supports relatively more value types for storage (memcached does not support value types, only key), including stri

  2022-06-01 21:23:15 Views: 276
• 

  Mysql appears ncorrect string value:'\ xF0\ x9F..' For co

  1) modify the code of the database as utf8bm4# vi / etc/ my.cnf [client] default-character-set = utf8mb4 [MySQL] default-character-s

  2022-06-01 21:23:15 Views: 294
• 

  ORA-100501: non-ORACLE exception

  ORA-100501 is the error returned when you trap a Raise Form_Trigger_Failure in an exception handler.

  2022-06-01 21:23:15 Views: 211
• 

  Design skills of Redis key

  Redis key design tip 1: convert the table name to the key prefix such as, tag:2: paragraph 2 places the field for the partition key-the column name of the primary key in the corresponding mysql, such as userid3: paragraph 3 places the primary key value, such as 2mem3.

  2022-06-01 21:23:12 Views: 203
• 

  A brief introduction to flashback database

  The flashback database method can be executed with sqlplus or RMAN: SQL > FLASHBACK DATABASE TO TIMESTAMP ('');-- (based on point in time) SQL > FLASHBACK DATAB

  2022-06-01 21:23:11 Views: 201
• 

  Oracle 12c dbca cannot discover asm diskgroup

  DBCA log path [root@oracle73 ~] # cd / u01/app/oracle/cfgtoollogs/dbca/ [root@oracle73 dbca] # lltotal 1700-

  2022-06-01 21:23:05 Views: 204
• 

  PostgreSQL DBA (- PG 12 Improv

  When PG 10 executes a query on a partition table, it checks the constraints of each partition one by one to see if it is necessary, and if there are many partitions, there will be a significant performance loss during the planning phase. PG 11 uses the "partition pruning" algorithm to quickly identify matching partitions to improve performance

  2022-06-01 21:23:05 Views: 207
• 

  MySQL master-slave delayed replication

  The master-slave replication of MySQL is the basis of realizing MySQL large-scale cluster, and it is widely used in daily production environment. After MySQL5.6 began to reconstruct and improve the underlying code of MySQL, the master-slave replication of MySQL has made great progress.

  2022-06-01 21:23:02 Views: 301
• 

  Postgres11.2 version client opens column & quo

  When postgres is upgraded to version 11, the client opens and prompts ERROR:column p.proisagg does not existLINE 1:...database d on d.datname=cu

  2022-06-01 21:22:56 Views: 269
• 

  Creation and use of 1Z0-051-DDL-1 tables and temporary tables

  First, create a simple table 1.1 create a table syntax using the column specification: CREATETABLE [schema.] tablename [ORGANIZATION HEAP] (columndatatype [default exp)

  2022-06-01 21:22:55 Views: 242
• 

  Two small lessons of resource pool

  "do not use a global resource pool. Unless you really know its reasonable configuration-such as size, timeout, etc." I've stepped on this pit twice. The first time is Http's connection pool. I used a default PoolingHttpClientConnectionMana

  2022-06-01 21:22:50 Views: 202
• 

  C # SQL package (2)

  Join the C # SQL package (1) to start the test of operating the database: using System;using System.Collections.Generic;using System.Linq;using Syste

  2022-06-01 21:22:50 Views: 227
• 

  If you modify the maximum number of connections for postgresql

  1. Find the location of postgresql's configuration file postgresql.conf. 2. Modify one of the parameters, max_connections = 100 # (change requires restart)

  2022-06-01 21:22:50 Views: 226
• 

  [mysql Learning] linux installs mysql, using install script (2)

  This article introduces the installation of MySQL 5.6.27 under Linux. 1. Download address https://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.27-linux-glibc2.5

  2022-06-01 21:22:49 Views: 296