show engine innodb status and innodb lock monitoring
innodb monitor overview
innodb monitor is a built-in monitoring module of innodb. You can view it with show engine innodb status.
innodb monitor output can be output in the error log
To view finer grained innodb lock information, you need to open innodb_status_output_locks
Type of innodb monitor
There are two types of innodb monitor: innod ...
Posted by AcousticJames on Sat, 12 Feb 2022 07:35:04 +0100
Installation and use of SQLite
In the previous article, we gave an overview of database knowledge:< Database overview >, this paper introduces some basic and commonly used SQLite database knowledge.
SQLite Foundation
SQL basic syntax
insert INSERT INTO Table name (Column name 1,...)
VALUES (Column 1 value,...);
modify UPDATE Table name
SET Column name 1= Colum ...
Posted by celestineweb on Sat, 12 Feb 2022 07:32:38 +0100
Kotlin grammar manual
Kotlin grammar manual (I)
When using kotlin, because the mastery is not reliable enough, it is still a habit of Java programming, which wastes the language features, convenience and indirectness provided by kotlin. When reading some Android open source libraries, it is difficult to read because many of them are written by kotlin syntax, and it ...
Posted by advancedfuture on Sat, 12 Feb 2022 07:26:33 +0100
Creating and using FTP virtual account
1. Environmental planning
Environment system version, hereinafter referred to as host A and host BA: CentOS 7.6 (172.20.10.4)B: RedHat 8.2 (172.20.10.6) Machine A establishes and uploads test files for easy distinction. The naming method is "system abbreviation + system version + virtual account abbreviation"
[root@CentOS7-6 test]# ...
Posted by mouli on Sat, 12 Feb 2022 07:18:42 +0100
Spring mvc02: the first MVC program
Configuration version
1. Create a new Moudle, springmvc-02-hello, and add web support!
2. Make sure the dependency of spring MVC is imported!
3. Configure web XML, register DispatcherServlet
<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns="http://xmlns.jcp.org/xml/ns/javaee"
xmlns:xsi="http://www.w3.org/2001/XMLSchema ...
Posted by phbock on Sat, 12 Feb 2022 07:15:53 +0100
Section 10: log management in SpringBoot
The default logging framework used by SpringBoot is logback. Spring boot starter contains the spring boot starter logging module. The log framework is logback. Therefore, we do not need to introduce the spring boot starter logging module separately.<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId ...
Posted by trauch on Sat, 12 Feb 2022 07:12:04 +0100
Analysis and appreciation of classes and objects in C + + (Part I)
1, Process oriented and object oriented
Before learning classes, let's review some connections and differences between C language and C + +: C language is process oriented, focusing on the process, analyzing the steps of solving the problem, and gradually solving the problem through function call. At the code level, it embodies functions. ...
Posted by lives4him06 on Sat, 12 Feb 2022 07:10:20 +0100
Java web learning notes 3: tomcat implementation principle
Hit in front: part of the picture is cut from the horse soldier teacher servlet and jsp Lecture notes. Video link: https://www.bilibili.com/video/BV1cV411H7RY?p=1
**Operation principle of tomcat: * Interactive process: The client sends a request to the server. tomcat request receives the request and presents it to the service request object. ...
Posted by joquius on Sat, 12 Feb 2022 07:09:22 +0100
HTML CSS transition effect
HTML CSS transition effect
1,transition
Transition: through the transition, you can specify the switching mode of the attribute of an element when it changes, so as to create some very good effects and improve the user experience. For example:
transition: height 2s; /*When the height of the element changes, it takes two seconds to transition ...
Posted by saraadmin on Sat, 12 Feb 2022 07:06:16 +0100
Stored procedures and functions in MySQL (super detailed, with code analysis)
Stored procedures and functions
MySQL supports stored procedures and functions from version 5.0. Stored procedures and functions can encapsulate complex SQL logic. Applications do not need to pay attention to the complex SQL logic inside stored procedures and functions, but simply call stored procedures and functions.
1. Overview of stored pr ...
Posted by MDanz on Sat, 12 Feb 2022 07:04:03 +0100