[Spring Boot quick start] Spring Boot integrates Druid data monitoring
preface
Druid Spring Boot Starter is used to help you easily integrate Druid database connection pool and monitoring in Spring Boot projects. This article will integrate Druid with Spring Boot for data source monitoring.
First met Druid
Druid is a JDBC application component open source by Alibaba. It includes three parts: ...
Added by Tryfan on Sun, 19 Dec 2021 14:56:07 +0200
SQL - Structured Query Language
1. Introduction to SQL
SQL is a structured query language. It is a set of operation commands specially established for database. It is a database language.
The interactive operation of the database is inseparable from SQL, which provides great convenience for us to manage the database.
1.1 database use case construction
Note: all of ...
Added by wmac on Sun, 19 Dec 2021 05:43:26 +0200
Java CAS principle analysis, MySQL 10 million data deep paging optimization
The CAS operation process mentioned above is not very difficult. But the above description is not enough. Next, I will introduce some other background knowledge. With these background knowledge, we can better understand the follow-up content.
2. Background introduction
As we all know, CPU transmits data through bus and memory. In the multi- ...
Added by Quevas on Sun, 19 Dec 2021 04:07:17 +0200
CAS operation based on Redis
introduction
Yes NET, we can use interlocked Compareexchange to implement CAS (Compare And Swap) operation. In the distributed scenario, we often use redis. Recently, a wechat game project before the change was run on a single machine. Some data storage is based on memory and directly based on object operation. Recently, redis is introduced to ...
Added by cfemocha on Sat, 18 Dec 2021 20:07:00 +0200
mysql service startup exception; mysql service is lost;
background
Recently, many people have encountered mysql exception problems. They checked them one by one. But today, I suddenly encountered this problem myself. I usually follow the problem to find Du Niang. However, in order to have a faster solution, I decided to take this opportunity to sort out the solutions for mysql exceptions.
The mysq ...
Added by tlenker09 on Sat, 18 Dec 2021 08:29:29 +0200
MySQL basics -- 003 SQL DDL, DML and DCL usage: creating and managing tables, adding, deleting and modifying data processing, detailed description of MySQL data types, and constraints
Chapter 10_ Create and manage tables
Lecturer: Shang Silicon Valley - Song Hongkang (Jianghu person: Master Kang)
Official website: http://www.atguigu.com
1. Basic knowledge
1.1 a data storage process
Storing data is the first step in processing data. Only by storing the data correctly can we process and analyze it effectively. Otherwise ...
Added by IOAF on Sat, 18 Dec 2021 07:24:42 +0200
Redis advanced project practice, complete collection of old boy linux e-books
Function [#](
)
Ensure complete data transmission
Redis distributed lock implementation source code explanation [#](
)
Graphic explanation [#](
)
Step [#](
)
Distributed locks meet two conditions: one is the lock with effective time, and the other is high-performance unlockingredis commands setnx (set if not exist) and setex (set exp ...
Added by thoand on Sat, 18 Dec 2021 06:11:36 +0200
MySQL index and database management (data backup)
Indexes
MySQL's official definition of Index is: Index is a data structure that helps MySQL efficiently obtain data. Extract the sentence trunk to get the essence of Index: Index is a data structure. For details, you can check this blog post (the original blog post has expired, and this blog post is reprinted) https://blog.csdn.net/weichi7549/ ...
Added by richcrack on Sat, 18 Dec 2021 05:42:16 +0200
Problems and solutions encountered in the use of polling lock!
When we encounter a deadlock, we can not only manually restart the program to solve it, but also consider using sequence lock and polling lock. For this part, please refer to my previous article, which will not be repeated here. However, improper use of polling lock will bring new serious problems, so in this article, we will learn about these ...
Added by SwiftlyTilting on Sat, 18 Dec 2021 03:23:42 +0200
mysql database security policy
mysql database security policy
MySQL system itself can set password complexity and automatic expiration policy, which may be less used. Recently, I was informed to adjust the password and began to understand it
mysql password complexity policy
The MySQL system comes with validate_password plug-in, which can verify the password strength ...
Added by jscix on Sat, 18 Dec 2021 03:14:44 +0200