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

Kotlin - delay initialization and sealing classes

1, lateinit delay initialization keyword Many syntax features in Kotlin, such as variable immutability, variable non nullability, and so on, are designed to ensure program safety as much as possible. For example, there are many global variable instances in your class. In order to ensure that they can meet Kotlin's null pointer check sta ...

Posted by Cut on Sun, 31 Jul 2022 22:28:16 +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

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

Using Baidu map open source code to realize positioning and real-time path tracking

First demonstrate the effect: (the video can't be played, and the pictures make up the number) Ideas and steps of real-time path: Idea: if you need to realize real-time tracking on the map, you first need to realize the positioning function. On the basis of realizing the positioning function, you need to draw the walking track on the map, ...

Posted by realnsleo on Tue, 24 May 2022 20:03:34 +0300

Rxjava2 source code analysis

reference resources As an opening remark, this article recommends: RxJava meditation I'm not familiar with the source code characteristics of Rxjava. To be honest, I've seen it N times and barely read it( AAC The source code involved in the demo of basic rxjavasample (I don't want to read it all, but to be practical, I'll start with the demo an ...

Posted by learningsql on Tue, 24 May 2022 08:49:03 +0300

Comprehensive implementation of Android OkHttp + Glide + RecyclerView + ButterKnife popular framework

requirement Use one OkHttp to obtain muke.com movie data (20 pieces), use Glide to load pictures and display them in each movie Item, and search and display them by movie name and type. Operation effect Task description 1, Contents displayed on the home page: Movie sea ...

Posted by plutoplanet on Tue, 24 May 2022 04:06:34 +0300