Analysis of MySQL lock in MySQL database
preface
In his work, the author encountered inserting a piece of data into the MySQL table, but he couldn't insert it. And the same operation can be inserted in Oracle, so I specially studied MySQL 5 7 lock logic.
Introduction of lock
Before introducing locks, you need to understand the transaction isolation level: https://www.cnblogs.com/jssj/ ...
Posted by ephmynus on Fri, 13 May 2022 07:43:21 +0300
Spring Boot uses mybatis with TK Mybatis for database operation
Use mybatis with TK Mybatis for database operation
This is a spring cloud project. mybatis uses TK Myabtis general mapper summary blog
Use TK Mybatis is very simple, but there are some pits. Now let's talk about introducing mybatis, which is also very simple
1. First, introduce the dependency of mybatis, jdbc and mysql connecteor into the Co ...
Posted by podja on Fri, 13 May 2022 06:30:58 +0300
Create a mybaits from scratch
catalogue
1: Create project maven
2: Import mybaits dependent package
3: Configure
4: Write mybaits tool class
mybaits tool class
5: Interface between code entity class and mapper/dao layer
6: Test
7: Attention items
SqlsessionFactoryBuilder class
SqlSessionFactory interface
SqlSession interface
1: Create maven project ...
Posted by 2705ap on Thu, 12 May 2022 21:06:11 +0300
Based on Spring+SpringMVC+Mybatis distributed agile development system architecture source code sharing
Based on Spring+SpringMVC+Mybatis distributed agile development system architecture, it provides a complete set of public microservice service modules: centralized authority management (single sign-on), content management, payment center, user management (support third-party login), WeChat platform, storage system , configuration center, log an ...
Posted by njm on Thu, 12 May 2022 14:30:35 +0300
Mysql backup and recovery and xtrabackup backup
[transfer] Mysql backup recovery and xtrabackup backup
🎉 New Year greetings 🎉
2017 is about to pass, and the bell of the new year is about to ring. At this beautiful moment of farewell to the old and ushering in the new year, I would like to extend new year's greetings to the people of all ethnic groups across the country, compatriots in th ...
Posted by titeroy on Thu, 12 May 2022 11:10:13 +0300
MySQL backup and recovery
preface
In enterprises, the value of data is very important, and data ensures the normal operation of enterprise business. Therefore, data security and data Reliability is the top priority of operation and maintenance. Any loss of data may have serious consequences for the enterprise.
1: Classification of database backup
1.1: what are t ...
Posted by corsc on Thu, 12 May 2022 07:41:45 +0300
Master slave replication of a database that has been running for a period of time
Master slave replication of a database that has been running for a period of time
Preface: a few days ago, the master-slave replication of MySQL database that has been running for a period of time and has not opened bin log was made. Hereby, the detailed operation steps and instructions are recorded. Note that this synchronization does not use ...
Posted by virtuexru on Wed, 11 May 2022 23:14:11 +0300
Development oriented memory debugging artifact, how to use ASAN to detect memory leakage, stack overflow and other problems
The original content of GreatSQL community cannot be used without authorization. Please contact Xiaobian and indicate the source for reprint.[toc]introduceFirst of all, let's introduce it Sanitizer The project is an open source project produced by Google. The project includes memory and thread error detection tools such as ASAN, LSAN, MSAN and ...
Posted by realnsleo on Wed, 11 May 2022 07:47:07 +0300
MySQL common statements
MySQL common instructions
Modify table structure
service mysql start
#Start the MySQL service. mysql55 is the server name specified when installing the MySQL server
net start mysql55
#Stop mysql service
net stop mysql55
Create database
#Create database Set character set Set collation
create database Database name character set gb2 ...
Posted by a94060 on Wed, 11 May 2022 00:09:32 +0300
Modify table structure
Learning objectives:
1. Modify field related information
2. Modify constraints
3. Modify other options
4. Modify table name
Learning content:
Create table
Syntax:
create table if not exists table name(
Field type constraints,
...
[constraint information]# last line information without comma
)engine=InnoDB[MyIASM] default charset=utf8;
For examp ...
Posted by aiikcmo on Tue, 10 May 2022 23:39:45 +0300