NAV: SLTechnology News&Howtos > Database >

• 

  GoldenGate replication single table open parallel

  Recently, several businesses have gone offline and more than 680 million pieces of data need to be deleted from a table. Try to delete the data, but there is a delay in replication on the corresponding ogg disaster recovery side, and the longer the delay. For the delay caused by too many tables, all tables can be divided into multiple groups to copy, so I want to repeat

  2022-06-01 11:47:04 Views: 238
• 

  ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction solution

  First, problem description: colleagues reported that one of the data items in the online table could not be deleted, and the other items were normal. I got the sql of deleted data and tried to execute it. The error report is as follows: mysql > delete from facebook_posts where id =

  2022-06-01 11:47:03 Views: 204
• 

  EntityFramework, a simple entrance.

  In any data-related system, data persistence is a problem that can not be ignored. For a long time, Java platform has produced many ORM frameworks of NB, such as Hibernate, MyBatis and so on. On the. Net platform, the ORM framework has always been

  2022-06-01 11:46:49 Views: 287
• 

  Jboss6.1 installation configuration

  The use, configuration, and use of Jboss6.1. Introduction: JBoss is the result of the joint efforts of developers all over the world, an open source application server based on J2EE, because the JBoss code follows the LGPL license, you can use it for free in any commercial application.

  2022-06-01 11:46:49 Views: 208
• 

  Use xtrabackup to back up the database of the innodb engine

  The database of the innodb engine can be backed up with mysqldump. If the table is large, dozens of gigabytes or even hundreds of gigabytes, it will be very slow to back up with mysqldump. Then you can quickly back up the innodb database online using xtrabackup. Inno

  2022-06-01 11:46:48 Views: 254
• 

  Centos7 configuration mysql master-slave: one master and multiple slaves

  Principle of mysql master-slave replication 1. First, master records the data update to the binary binlog file. 2.slave requests the content of the specified location of the binlog log file from master through the I O thread. 3.master receives the I of slave.

  2022-06-01 11:46:31 Views: 218
• 

  The difference between the Commercial Edition and the Community Edition of mysql Database

  1. The organization, management and testing of the commercial version are more strictly controlled, and in terms of stability, it will be more stable than the community version. 2. Mysql is a mature product, and there is little difference in performance between the commercial version and the community version. 3. The commercial version does not abide by the GPL agreement, while the community version complies with the GPL agreement and can be used free of charge. four

  2022-06-01 11:46:31 Views: 262
• 

  The solution to the disappearance of MySQL services

  I have encountered the same problem twice recently, one is my own computer and the other is a live server, so I think it is necessary to write about the solution when the Mysql service disappears. 1. First find your Mysql installation directory, as shown below: 2. Open the running command window and type cmd to open d.

  2022-06-01 11:46:21 Views: 243
• 

  Mycat Learning practice-Mycat Global Primary key

  Mycat learning practice-Mycat global primary key @ (learning) [mycat, mysql] Mycat learning play-Mycat global primary key 1. Mycat global primary key introduction 2. Mycat global primary key mode 2.1 local file mode 2.2 book

  2022-06-01 11:46:21 Views: 233
• 

  MongoDB mongodump exports data by time region

  According to ObjectId, we can get the time region ["2014-01-01 00:00:00", "2015-11-15 00:00:00") in mongo shell, and generate the idbegin of this area according to time.

  2022-06-01 11:46:18 Views: 224
• 

  CentOS6.8 installation mongodb3.0 and backup script

  First, the system environment CentOS 6.8_x64 official reference document https://docs.mongodb.org/manual/reference/glossary/#term-init-script II, add official

  2022-06-01 11:46:17 Views: 243
• 

  Data types and setting methods of redis

  1. Redis supports five data types: string (string), Hash (hash), list (list), set (collection), and zset (ordered set). String is the most basic type of redis, and a key can store up to 5.

  2022-06-01 11:46:17 Views: 254
• 

  Detailed explanation of Oracle nvl, nvl2, nullif, decode and case functions

  1. NVL function nvl (expr1,expr2), if expr1 is empty, return expr2;2, NVL2 function nvl2 (expr1,expr2,expr3), if expr1 is empty, return expr3, otherwise return ex

  2022-06-01 11:46:17 Views: 237
• 

  Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name

  Today, I wanted to start OEM under the installed test environment, but I reported an error as follows: Environment variable ORACLE_UNQNAME not defined. Please set ORACL

  2022-06-01 11:46:08 Views: 210
• 

  Installation and basic operation of MySQL

  MySQL is a real multi-threaded, multi-user SQL database service. With its high performance, high reliability and easy to use, it has become the most popular open source database system in the server field. At present, Oracle is responsible for developing and maintaining the compilation and installation of MySQL

  2022-06-01 11:45:48 Views: 207
• 

  Add and delete users, groups, assign directory permissions

  1. Users and groups 1. Add and delete users (and assign to groups) useradd-g preferred-G supplement username-g login preferred group-G other supplementary group username username 2. Add and delete

  2022-06-01 11:45:46 Views: 250
• 

  Redis stress test instructions

  Redis stress test shows that redis-benchmark is a stress testing tool that comes with redis: how to use: you can use redis-benchmark-help to show how to use: 1. Redis-benchmark-t

  2022-06-01 11:45:46 Views: 240
• 

  ORACLE online table redefinition

  ORACLE in practice, due to the increase of business, the amount of data of some tables that were not planned to be very large has greatly increased. In order to optimize these tables, we need to change these tables from ordinary tables to partitioned tables. Now let's introduce a technique that comes with ORACLE to deal with this situation-this technique is called online table redefinition. first

  2022-06-01 11:45:39 Views: 275
• 

  Percona-XtraDB-Cluster+haproxy+keepalived compilation and installation

  System: centos7192.168.1.55 mysql port 3306 Percona-XtraDB-Cluster master node 192.168.1.56 mysql port 3307 Percona-XtraD

  2022-06-01 11:45:39 Views: 231
• 

  Oracle asm disk_repair_time

  When oracle rac expands a large number of tablespaces, alert reports an error: caused by disk_repair_time timeout. Solution: alter diskgroup datadg online disk datadg_000

  2022-06-01 11:45:33 Views: 297