Zabbix enterprise class open source monitoring solution

1, Zabbix 1. Necessity of monitoring system As an O & M, you need to be able to use the monitoring system to view the server status and website traffic indicators, and use the data of the monitoring system to understand the results published online and the health status of the website. 2. Function of monitoring software With an ex ...

Posted by kokomo310 on Wed, 01 Dec 2021 14:24:13 +0100

The invalid character encoding of mysql index is inconsistent

preface I'm sure you've heard that if the character codes of the two tables are inconsistent, the index field will cause index invalidation during join, but is that true? This article will carefully analyze this problem. prepare We first prepare two tables, one using utf8 character set and one using utf8mb4 character set, and insert a piece ...

Posted by nothingatall on Wed, 01 Dec 2021 14:22:23 +0100

Rust develops postgres extensions

prefaceRust language is a general system level programming language. It has no GC and is famous for ensuring memory security, concurrency security and high performance. It has been privately developed by Graydon Hoare since 2008 and sponsored by Mozilla in 2009. Version 0.1.0 was released for the first time in 2010 for the development of Servo ...

Posted by CapEsiouS on Tue, 30 Nov 2021 10:21:31 +0100

Past and present life of Redis thread model

1, OverviewAs we all know, Redis is a high-performance data storage framework. In high concurrency system design, Redis is also a key component and a powerful tool for us to improve system performance. It is more and more important to deeply understand the high-performance principle of Redis. Of course, the high-performance design of Redis is a ...

Posted by villas on Tue, 30 Nov 2021 03:35:52 +0100

SQL Server (table creation and constraint)

In the process of using the database, the most exposed is the table in the database, which stores all the data in the database. Therefore, the table is the basic information storage structure of SQL Server database system and the most important part of the database. Managing the table naturally manages the database. 1. Data sheet overview & ...

Posted by Nommy on Mon, 29 Nov 2021 14:16:58 +0100

Easily complete a distributed transaction TCC with Java, and automatically handle null compensation, suspension, idempotent, etc

What is TCC? TCC is the abbreviation of Try, Confirm and Cancel. It was first proposed by a paper entitled Life beyond Distributed Transactions:an Apostate's Opinion published by Pat Helland in 2007.TCC compositionTCC is divided into three stagesTry phase: try to execute, complete all business checks (consistency), and reserve necessary busines ...

Posted by tlawless on Mon, 29 Nov 2021 03:46:04 +0100

Java policy pattern of Java proxy pattern

Java policy pattern In strategy pattern, the behavior of a class or its algorithm can be changed at run time. This type of design pattern belongs to behavioral pattern. In the policy pattern, we create objects representing various policies and a context object whose behavior changes with the change of policy objects. The policy object changes ...

Posted by BRUUUCE on Sun, 28 Nov 2021 06:15:41 +0100

Easily recognize the sequence list and linked list ------------ happy person's java beginner's diary [6]

1, Linear table A linear list is a finite sequence of n data elements with the same characteristics. Linear table is a data structure widely used in practice. Common linear tables: sequential table, linked list, stack, queue, string... Linear table is a linear structure logically, that is, a continuous straight line. However, the physica ...

Posted by brokenshadows on Sun, 28 Nov 2021 05:12:35 +0100

MySQL index -- how to improve query speed

What is the index? If you have been to the library, you should know the library's retrieval system. The library has prepared a search catalogue for books, including book name, book number and corresponding location information, including which area, shelf and floor. We can quickly know the location of books and get the books we need through th ...

Posted by xXx_Hobbes_xXx on Fri, 26 Nov 2021 16:21:40 +0100

Tool | one SQL to realize PostgreSQL data retrieval

Author: Zhang Lianzhuang, PostgreSQL R & D Engineer He has been engaged in the development of PostgreSQL database kernel for many years and has a very in-depth research on citus. Recovering lost data quickly is an important functional requirement of the database. It is generally recommended to use the tools recommended by the official. For ...

Posted by WM_Programmer_noob on Wed, 24 Nov 2021 11:01:12 +0100