Implementation principle of HashMap (just read this article)
HashMap is a collection container that senior java engineers must be proficient in. Its importance is almost equal to the importance of Volatile in concurrent programming (visibility and order).Through the detailed explanation of graphic source code, this article deeply analyzes the important kernel knowledge of HashMap, which is easy to read, ...
Added by pietbez on Mon, 17 Jan 2022 20:29:41 +0200
Technology sharing | analysis of Prometheus+Grafana monitoring MySQL
The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.brief introductionPrometheus is an open-source combination of monitoring & Alarm & time series database. Usually, Kubernetes will cooperate with Prometheus for monitoring. Because the image of Prom ...
Added by infusionstudios on Mon, 17 Jan 2022 09:19:53 +0200
MySQL-2 transaction table association table strengthening: 6 constraints multi table associated query join
MySQL
transaction
Overview: what is a transaction
Database transaction refers to a series of operations performed as a single logical unit of work, either completely or not. To put it simply: a transaction is to bind a pile of SQL statements (usually add, delete and modify operations) together for execution. Either all of them are execu ...
Added by hdpt00 on Mon, 17 Jan 2022 09:13:11 +0200
Easy to understand index
*1 * ***** 0 * * * introduction
Why index?
In general application systems, the read-write ratio is about 10:1, and there are few performance problems in insert operations and general update operations. In the production environment, we encounter the most and most prone to problems, or some complex query operations. Therefore, the optimization ...
Added by gtanzer on Mon, 17 Jan 2022 00:03:03 +0200
java Transformation Road - Database
java Transformation Road - database (I)
Those who discipline themselves are enough to convince others, and small steps can reach thousands of miles.
As mobile developers, although they are familiar with java syntax, they are only the tip of the iceberg for back-end development. Self discipline is not a temporary brain fever. Ideas need to be ...
Added by davinci on Sun, 16 Jan 2022 22:29:26 +0200
MySQL federated query
1, Internal connection query
First create the tables student, course, and exam
CREATE TABLE student(
uid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
name VARCHAR(20) NOT NULL,
age TINYINT UNSIGNED NOT NULL,
sex enum("man", "woman") NOT NULL
);
CREATE TABLE course(
cid INT UNSIGNED PRIMARY KEY NOT NULL AUTO_INCREMENT,
name VA ...
Added by JMM on Sun, 16 Jan 2022 22:14:42 +0200
Description of parameters related to MySQL configuration file
[mysqld] #Set mysql installation directory basedir =/usr/local/mysql #Set the data storage directory of mysql database datadir = /usr/local/mysql/data #Set port port = 3306 socket = /tmp/mysql.sock #Set character set character-set-server=utf8 #Log storage directory log-error = /usr/local/mysql/data/mysqld.log pid-file = /usr/local/mysql/data/my ...
Added by xavier.rayne on Sun, 16 Jan 2022 20:41:50 +0200
Elastic actual combat: realize the data preprocessing of mysql synchronous data to es through pipeline
0. Introduction
Recently, when synchronizing part of the company's mysql data to es, the Logstash input JDBC for full synchronization,Incremental synchronization with canal However, another problem is that the data structure in ES needs to be redesigned, which leads to the need for some mysql fields to be transformed and then synchronized to ...
Added by vadercole on Sun, 16 Jan 2022 11:14:57 +0200
Query rewriting rules for MySQL
MySQL Learning Series
For some very performance-consuming statements, MySQL still tries its best to convert this bad statement into a more efficient form according to some rules. This process can also be called query rewriting.
Conditional simplification
The search condition of the query statement we write is essentially an expression. The ...
Added by KirstyBurgoine on Sun, 16 Jan 2022 09:06:36 +0200
MySQL8.0 Summary of new features
1. Overview of new MySQL8 features
1.1 MySQL8.0 New Features
1. Simpler NoSQL support NoSQL refers generally to non-relational databases and data storage. With the rapid development of Internet platform, traditional relational databases have become increasingly unsatisfactory. MySQL has been supporting simple NoSQL storage since version 5.6. ...
Added by Iceman18 on Sat, 15 Jan 2022 06:53:39 +0200