Programmer Think

Environment-related: OS: CentOS release 5.11 IP: 192.168.77.10 MEM: 16G DISK: 50G 1. Brief description This blog post is actually a silent installation of the CentOS 5 system Oracle 10g in the production environment in use. This blog includes oracle Software silent installation, software upgrade, playing PSU, man ...

3.1. Basic queries: Basic grammar GET/Index Library Name/_search { "query":{ "Query type":{ "Query Conditions": "Query Conditional Values" } } } Here query represents a query object, which can have different query attributes. Query type: For example: match_ ...

In our last blog post, we used direct exchange instead of fanout exchange. This time, let's look at topic exchange. Introduction to Topic Exchange Topic exchange is similar to direct exchange in that it matches routing key and binding key, but topic exchange can set multiple criteria for routing key. direct routers are similar to exact queri ...

[TOC] 1. Steps to generate AWE reports For SQL tuning, local SQL, we can use direct tuning such as execution plan, for the whole system?Oracle provides several performance analysis reports, such as AWR, ASH, ADDM and so on. This blog focuses on AWR AWR, fully known as Automatic Workload Repository, is a performance collection and a ...

stored procedureConcept: Stored Procedure s are large database system In order to accomplish specific functions, a set of SQL statements is stored in the database. After the first compilation, the first call does not need to be compiled again. The user executes it by specifying the name of the stored procedure and giving param ...

Label PostgreSQL , ms sql , SQL Server background This paper introduces the simple deployment and use of MS SQL on Linux. https://docs.microsoft.com/zh-cn/sql/linux/quickstart-install-connect-red-hat?view=sql-server-2017 Later, I will briefly introduce how to migrate MS SQL to PostgreSQL. 1 environment CentOS 7.x x64 ECS 2. Environmental ...

Label PostgreSQL, citus, pgbouncer, network optimization, worker node background Network requirements between citus nodes: 1. The cn node accesses all worker nodes. oltp services are frequently accessed. 2. When data is redistributed, worker nodes visit each other. Access frequency is not high, OLAP business is common, once possible, data ex ...

The following personal learning notes are for reference only. You are welcome to make corrections. MyBatis is a persistent layer framework that supports customized SQL, stored procedures, and advanced mapping. It mainly accomplishes two things: Encapsulating JDBC operations Using Reflection to Interchange Java Classes and SQL Statemen ...

Return Proxy SQL Series: http://www.cnblogs.com/f-ck-need-u/p/7586194.html   1. Understanding Chain Rules In the mysql_query_rules table, there are two special fields, "flagIN" and "flagOUT", which are used to define the entry and exit of the rules respectively, so as to realize the chains of rules. The implementation of ch ...

ContentProvider is mainly used to realize data sharing between different applications. It provides a complete mechanism to allow one program to access data in another program, while ensuring the security of the visited data. PS: The bottom layer of ContentProvider is to adopt the Binder mechanism in Android The main methods ...