Database Administrator

GoldenGate Extract process hang solution example The normal extract process suddenly hang. At first, I suspected that the Archive was not found. However, after careful check, all the archives required by extract are still there, and no error is

Redis configuration details, redis details Web programmer blog: http://blog.csdn.net/thinkercode If it is a professional DBA, many parameters will be added when the instance is started to make the system run very stably, so that a parameter may

Centos7 installation mariadb-10, centos7mariadb-10 : Http://mirrors.ustc.edu.cn/mariadb/mariadb-10.0.19/source/mariadb-10.0.19.tar.gz Because cmake is used, this can be installed offline. Yum install cmake Download the tar.gz file and

SQL query beginner's Guide Reading Notes (3) value expression introduction, beginner's Guide Reading Notes CHAPTER 5 Getting More Than Simple Columns Intro Value expression, itcontains column names, literal values, functions, orother

10 configuration items that must be adjusted for newly installed MySQL and 10 configuration items for mysql I am still worried about the newly installed mysql service. I don't know which default configurations to modify? Mysql has more than 100

ERROR 1160 (08S01): Got an error writing communication packets, 116008s01 The application encounters an error message: MySQLNonTransientConnectionException: Got an error writing communication packets. It is related to packet and has never

What Happens When A Tablespace/Database Is Kept In Begin Backup Mode (Doc ID 469950.1), tablespace469950.1Goal This document explains in detail about what happens when a tablespace/datafile is kept in hot backup/begin backup mode.Solution To

SSIS [Foreach loop container _ Foreach file enumerator] (content of all txt files in the import path) (convert ), Original article: http://blog.csdn.net/kk185800961/article/details/12276449 SQLServer 2008 R2 SSIS_Foreach loop container _ Foreach

Aerospike C client manual --- key-value storage-read records, aerospike ClientRead records The Aerospike C client AP provides four operations to read a record from the database: aerospike_key_get()-Read all bin data of a record.

Tutorial on creating a MongoDB copy based on PostgreSQL, postgresqlmongodb I have an idea of laziness. How can I start with this idea? Well, this is an appropriate little crazy: Why don't we build our own MongoDB version on the basis of ipvs? It

Mysql common SQL statements (1) and mysqlsql statements[1] Clear TABLE statement truncate table fke_message; [2] resetting the start value of the auto-increment Field alter table fke_message auto_increment = 10001; [3] common table creation

Mysql left join the right table data is not unique solution, mysqljoin1. Basic left join usage Mysql left join statement format A left join B ON condition expression Left join is based on table A. Table A is the left table, and table B is the

MongoDB step by step (2) mongodb compared with T-SQL, mongodbt-SQL SQL Terms/Concepts MongoDB Terms/Concepts Database Database Table Collection) Row Document) Column Key) Value

PostgreSQL tutorial (II): Schema description, postgresqlschema A database contains one or more naming modes. The schema also contains tables. The schema also contains other named objects, including data types, functions, and operators. The same

One way to view the rac heartbeat ip address is to view the rac heartbeat ip address. A Method for viewing heartbeat IP addresses Source: GI Fails to Start as no Private Network Interface is Available (Doc ID 1481176.1) From ocssd. log: 16:28:07. 224

About the NOZEROCONF = yes parameter in linux/etc/sysconfig/network, etcsysconfigi18n About the NOZEROCONF = yes parameter in linux/etc/sysconfig/network Today, we saw this parameter in the CSSD Fails to Join the Cluster After Private Network

Database optimization tutorial (3) Slow query of records and database optimization tutorial Query1. Slow query foundIn the previous section, we made data preparation for slow queries. This section allows us to find slow queries and record them to

Database optimization tutorial (I) preface & definition of slow query, and introduction of database optimization tutorial Preface   Recently, I helped the company optimize the database. Based on what I learned, I used the learning knowledge step by

Redis Admin UI-A Redis UI management interface, redisuiRedis Admin UI-A Redis UI Management Interface  The Redis management UI consists of two parts:   1. an Ajax client Web application (developed based on Google's closed Library: https://github.com/

If you do not use the judgment operation to ensure that if any number is greater than 30, it is 30; otherwise, it is the original value (maximum limit on Field Values in SQL sorting), and 30 SQL statements Scenario: in a database, you need to sort a