BatchExecutor of Executor source code parsing in MyBatis not understood

To facilitate source code analysis, let's start with MyBatis Demo mybatis-mysql-config.xml 1 <?xml version="1.0" encoding="UTF-8"?> 2 <!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" 3 "http://mybatis.org/dtd/mybatis-3-config.dtd"> 4 5 <configuration> 6 <properties> 7 <p ...

Posted on Mon, 13 Apr 2020 02:53:42 -0700 by Goldeneye

Writing a reusable distributed scheduling task management WebUI component based on Quartz

premise Small business teams give priority to cost savings regardless of the options they choose.With regard to the Distributed Timing Scheduling Framework, mature candidates are XXL-JOB, Easy Scheduler, Light Task Scheduler, Elastic Job, etc., which have been used in production environments before.However, to build a highly available distribu ...

Posted on Sat, 11 Apr 2020 17:03:00 -0700 by chuddyuk

How do I use Mybatis Generator

Beginning Buzz Mybatis Generator is the official code generator provided by Mybatis.I've used two versions of different styles: targetRuntime="MyBatis3DynamicSql", and targetRuntime="MyBatis3", which is just about the MyBatis3 type. 2. Native Insufficiency 1. No Paging 2. Data queries cannot specify that all returned colum ...

Posted on Fri, 10 Apr 2020 17:11:29 -0700 by Vbabiy

Once hired, it encountered the optimization of MySQL's billion level large tables

1, background In the xxx alarm of XX instance (one master and one slave), SLA alarm is reported every morning, which means there is a certain master-slave delay. (if the master-slave switch occurs at this time, it will take a long time to complete the switch, and the delay should be traced to ensure the consistency of the master-slave data.) XX ...

Posted on Fri, 10 Apr 2020 01:52:56 -0700 by KiwiDave

selenium+python for web-side automated test framework and case-based detailed tutorial

Recently suffered a 10,000-point attack, due to problems in the company's business, less heavy work tasks, time to explore selenium+python automated testing, combined with the information found on the Internet to write their own framework for web automated testing, as I am also just beginning to learn python, this automation framework has been ...

Posted on Wed, 08 Apr 2020 20:10:11 -0700 by adnan1983

Stored procedure of IF judgment

Query the data one by one, and return the data directly. Here is an example: Query data from table1, table2 and table3 in turn. The default value of resultCount is 0. Copy the number of rows of each query result to resultCount. Terminate or continue according to the condition IF @resultCount=0 THEN. Temp ...

Posted on Tue, 07 Apr 2020 08:50:44 -0700 by dabaR

Spring learning -- sql parameter injection of JDBC template

Turn around: sql parameter injection of [spring] JDBC template demo @Repository("jdbcDao") public class JdbcTemplateDao { @Autowired private JdbcTemplate jdbcTemplate; @Autowired private NamedParameterJdbcTemplate namedTemplate; private final static List<String> names = new ArrayList<String>(); priva ...

Posted on Mon, 06 Apr 2020 04:11:29 -0700 by jungalist

MySQL benchmark tool

1, Benchmarking Benchmark is a kind of stress test for system design. Benchmarking is simplified stress testing. 1.1 common indicators TPS QPS response time Concurrency 1.2 script for data collection and analysis The shell script gather.sh for collecting data #!/bin/sh INTERVAL=5 PREFIX=$INTERVAL-sec-status RUNFILE=/home/benchmarks/running m ...

Posted on Sun, 05 Apr 2020 22:26:11 -0700 by Cheeseweasel

Solution to slow page turning with Limit after MySQL data volume increases

1. Problem status The existing MySQL data table event_data has a data volume of 300000 +, as follows: mysql> select count(1) from event_data; +----------+ | count(1) | +----------+ | 367961 | +----------+ 1 row in set (0.05 sec) It takes 382 seconds to use SQL limit paging query, as follows: SELECT a.* FROM event_data a WHE ...

Posted on Sun, 05 Apr 2020 17:18:52 -0700 by CG_dude

prepare usage of MySQL

MySQL officially refers to prepare, execute and deallocate as PREPARE STATEMENT, which is used to be called preprocessing statement. The following is a detailed introduction. Sample code PREPARE stmt_name FROM preparable_stmt EXECUTE stmt_name [USING @var_name [, @var_name] ...] - {DEALLOCATE | DROP} PREPARE stmt_name   Here's a chestnut ...

Posted on Sun, 05 Apr 2020 01:42:57 -0700 by dsinghldh