MySQL - slow query log analysis
Article catalogue
MySQL - slow query log analysis
1. Start and set slow query log2. Data preparation3. Slow query log analysis tool: mysqldumpslow4. Delete slow query log5,show profile
MySQL - slow query log analysis
MySQL's slow query log is a kind of log record provided by mysql. It is used to record the statements whose response ...
Posted by razvypp on Tue, 02 Aug 2022 21:39:47 +0300
LRU and LFU algorithm (page replacement algorithm)
Differences between LRU and LFU
Both LRU and LFU are page replacement algorithms for memory management.
LRU: Least Recently Used (longest time) elimination algorithm. LRU is the page that has not been used for the longest time.
LFU: Least Frequently Used. LFU is the least used page in a period of time.
example
Assume that th ...
Posted by latinofever on Mon, 01 Aug 2022 21:07:12 +0300
SpringBoot integration springcloud Alibaba Seata details
SpringCloud Alibab-Seata Introduction:
Seata is an open source distributed transaction solution, which is committed to providing high-performance and easy-to-use distributed transaction services under the microservice architecture.
Seata will provide users with AT, TCC, SAGA and XA transaction modes to create a one-stop distributed soluti ...
Posted by kporter.porter on Sun, 31 Jul 2022 21:07:19 +0300
Quickly master MyBatis framework
Article catalogue
1, Foreword
1.1 database and table1.2 entity class1.3 MyBatisX plug-in1.4 SQL log view configuration 2, Multi table query
2.1 one to one2.2 one to many 3, Dynamic SQL usage
3.1 < if > label3.2 < trim > label3.3 < where > label3.4 < set > label3.5 < foreach > label
1, Forewor ...
Posted by mithras on Sat, 30 Jul 2022 21:38:10 +0300
Springboot Alipay sandbox payment - complete and detailed steps
1. Enter Alipay development platform sandbox environment
Sandbox environment - Alipay Document Center
1.1. Enter personal sandbox environment
Click to enter the sandbox environment and log in with Alipay Sandbox management interface is shown in the figure
appid, Alipay gateway, custom key, etc Here is the account number and password of ...
Posted by Mike-2003 on Sat, 30 Jul 2022 21:14:49 +0300
952. Calculate the maximum component size according to the common factor: enumerating prime factors + parallel search set application questions
Title DescriptionThis is from LeetCode 952. Calculate the maximum component size by common factor , difficulty is difficulty.Tag: "Mathematics", "joint search set"Given a non empty array num composed of different positive integers, consider the following figure:There are num.length nodes, marked from num[0] to num[num.length ...
Posted by patrickrock on Sat, 30 Jul 2022 10:13:45 +0300
Basic syntax of MySQL DDL and DML and DQL
preface
SQL statement, namely structured query language, is a programming language for special purposes. It is a database query and programming language, which is used to access data, query, update and manage relational database systems. It is also an extension of database files.
The SQL statements specified in the SQL standard are divided in ...
Posted by Noctagon on Sat, 30 Jul 2022 09:58:45 +0300
Building a Node.js Enterprise Web Server from Scratch: Middleware
About middleware
In a broad sense, middleware refers to software that can provide functions for applications other than the operating system, ranging from various services of cloud computing vendors to detection modules in a certain field. Express middleware refers specifically to software modules that provide functions based on the Express mi ...
Posted by bbreslauer on Fri, 01 Jul 2022 21:34:39 +0300
10 minutes to thoroughly understand the single page application routing
Last time, we popularized the custom routing routes of the applet and started the routing journey; Today, I'll take advantage of the trend to apply routing on a single page and chat with you for 50 cents. If you don't talk well... Return... A dollar?
Single page application features
Suppose: in a web page, there is a button. Click it to jump to ...
Posted by trellie on Wed, 25 May 2022 17:27:57 +0300
Mybatis Series Textbook - Basic - many to one
Step 1: run first, see the effect, and then learn Step 2: imitation and troubleshooting Step 3: many to one relationship Step 4: see the effect before learning Step 5: modify product java Step 6: product xml Step 7: mybatis config xml Step 8: Test mybatis Step 9: runnable projects Step 10: Exercise - modify the many to one relationship ...
Posted by M. Abdel-Ghani on Tue, 24 May 2022 13:15:21 +0300