More elegant use of limit (the effect of limit on the performance of mysql data query)

More elegant use of limit (the effect of limit on the performance of mysql data query) This paper re typesetting based on zhangyachen Source: zhangyachen https://github.com/zhangyachen/zhangyachen.github.io/issues/117 I. Preface First of all, explain the MySQL version: mysql> select version() ...

Posted on Sun, 19 Jan 2020 01:44:13 -0800 by lynncrystal

python builds IP pool

It is said that the title is the soul of the article. After thinking for a long time, I didn't think of any more creative title, so I had to Baidu one. Ha ha ha ha ha ha, I'm so smart This is an article about how to use python to build IP pool. If Ai Qing is not interested in it, I'm sorry that the titl ...

Posted on Sun, 19 Jan 2020 00:26:12 -0800 by JMulligan

[probably the best in the whole network] summary notes of MySQL advanced introduction

view Meaning: MySQL started from version 5.0.1. It is a virtual existing table. The data of rows and columns comes from the tables used in the query defining the view. It is generated dynamically when using the view. Only the sql logic is saved, and the query results are not saved. Application scenari ...

Posted on Sat, 18 Jan 2020 23:00:45 -0800 by monk.e.boy

Spring Boot 2.X: integrated mybatis plus efficient development

Preface This paper introduces the operation of adding, deleting, modifying and querying the database by integrating Mybatis with SpringBoot, and gives two ways to implement the mapper interface: xml and annotation. Although the annotation method kills the xml file, it is not elegant to use. This paper will introduce the common examples of mybat ...

Posted on Thu, 16 Jan 2020 21:50:24 -0800 by Chrisj

Django practice - personal blog website

After watching Django video in a week, it took two days to finish it Watching the progress of video learning is too fast, so flask and ajax are not very useful. Do a good job of this project and review it later. django is a kind of knowledge that can be consolidated immediately after learning. It's re ...

Posted on Thu, 16 Jan 2020 06:07:01 -0800 by darence

Pure jdbc operation oracle database migration to mysql database (test 2000 tables, single table data more than one million, no OOM)

Article directory Preface Thinking before coding Realization demo structure Introducing dependency Implementation class optimization Source code Preface Data migration is always troublesome. If there is a need for oracle to mysql, data migration is a big problem Before data migration, baidu ha ...

Posted on Wed, 15 Jan 2020 04:14:48 -0800 by rudibr

springboot integration mybats

Preface Recently, mybatiesplus was integrated with springboot( SpringBoot integrates mybatis plus )In fact, it is known that the steps of integration are not complicated. Today, try integrating mybats with springboot. This paper uses the xml configuration method. Although the annotation method is si ...

Posted on Mon, 13 Jan 2020 19:25:08 -0800 by TubeRev

MySQL -- read write separation

MySQL -- read write separation 1: Principle Read write separation is to write only on the master server and read only on the slave server The primary database processes transactional queries, while the secondary database processes select queries Database replication is used to synchronize chan ...

Posted on Mon, 13 Jan 2020 04:44:15 -0800 by playaz

Batch rewriteBatchedStatements=true

Recently, we are optimizing the performance of mass data insertion. The original mass data insertion method used in the project is the foreach splicing SQL method of Mybatis. I found that no matter the method changed to Mybatis Batch submission or native JDBC Batch does not work. In fact, when insert ...

Posted on Sun, 12 Jan 2020 23:34:34 -0800 by Hyperjase

Spring cloud's Hystrix and service monitoring Dashboard for dealing with avalanche effect

Article directory Preface The concept and reason of avalanche effect Avalanche effect Using the Hystrix processing strategy Hystrix case test summary Preface This chapter is no longer a configuration file as before, but a case study of how to deal with avalanche effect. Because avalanche effec ...

Posted on Sun, 12 Jan 2020 05:56:34 -0800 by shaitand