Necessary knowledge points of MySQL development log file

Necessary knowledge points of MySQL log file development Reference source: juejin.im/post/5b7c0aabf265da438415b9eb preface Log files record all kinds of activities that affect MySQL database. Common log files in MySQL database include error log, binary log, slow query log and query log. They are i ...

Posted by Yucky on Tue, 30 Jun 2020 00:40:28 -0700

centos7 uses docker to build the running environment and deploy jar

*First, there is a clean CentOS 7 environment 1. To install docker, you need to use Yum to pull it, so get the yum source first. yum install -y yum-utils device-mapper-persistent-data lvm2 Add docker warehouse location for yum source yum-config-manager --add-repo https://download.docker.com/linux/cento ...

Posted by czambran on Tue, 30 Jun 2020 00:28:51 -0700

Evaluation of million level data migration scheme

preface Recently, when the company used ABP to reconstruct the old project, the database was also switched from SQL SERVER to MySql. Tucao, the products used before make complaints about Windows Server 2008, SqlServer 2008R2,.Net Framework 4.5, and now embrace.net core. Back to the point. At present, there are 10w + and 100w + data in a single ...

Posted by cdwhalley.com on Mon, 29 Jun 2020 20:15:36 -0700

@What does the Transaction annotation not work?

Take a look at the simplest example of CGLIB, and feel how AOP is achieved? /** * Created with vernon-test * Description: * User: chenyuan * Date: 16/4/25 * Time: 9:25 am */ public class Target { public String execute() { String message = "----------test()----------"; System.out.println(message); return message ...

Posted by stylefrog on Mon, 29 Jun 2020 03:15:21 -0700

nodejs crawler project

The news data of several websites have been crawled before. Now we need to organize and display these data. The specific requirements are as follows The first step is to install the dependency package in npm install under the final project folder Here, I met a problem during the installation process. Th ...

Posted by moonman89 on Sun, 28 Jun 2020 20:05:01 -0700

FreeSql uses ToTreeList/AsTreeCte to query infinite level classification table

On infinite class The first option: Recursion algorithm is also the most frequently used, and most open source programs do the same, but generally only use four levels of classification. The database structure design of this algorithm is the simplest. A field ID and a field FID (parent id) in the category table. In this way, we can judge the up ...

Posted by jwoo on Sat, 27 Jun 2020 17:13:04 -0700

362. Java intermediate 17 - [JDBC] June 27, 2020

0. Directory 1,JDBC 2. Import the jar package of MySQL JDBC for the project 3. Initialize driver 4. Establish a connection to the database 5. Create Statement 6. Execute SQL statement 7. Close connection 8. Use try with resource to automatically close the connection 9. Reference link 1,JDBC JDBC ...

Posted by han2754 on Sat, 27 Jun 2020 02:34:49 -0700

Production environment database backup scheme

1, Introduction After the product goes online, our data is very important. It's not allowed to be lost. We should be well prepared. If one day is hacked or deleted maliciously, it will crash. So we need to do full backup and incremental backup for our online database regularly. For example, make incre ...

Posted by lauxanh on Sat, 27 Jun 2020 01:35:14 -0700

Introduction and use of systemctl command

Systemd program Systemd is actually a program used by Linux system to manage the system, which is used to replace the original init process (used to manage and start other service processes of the system). Now many Linux distributions have their own Systemd programs. systemctl command 1. Unit systemctl command is the most important command in ...

Posted by ramrod737 on Sat, 27 Jun 2020 01:33:42 -0700

Beauty of mybatis source code: 2.8. Parse the objectFactory element and configure the object creation factory of mybatis

Parse the objectFactory element and configure the object creation factory of mybatis In Mybatis, there are many operations to instantiate objects through reflection, such as converting JDBC operation results to specific instance objects based on reflection. For example, the following data are available: MYSQL data: Name Sex (sex) Age panda ...

Posted by gazoo on Fri, 26 Jun 2020 20:48:57 -0700