Hi MySQL, Deadlock

Preface In everyday life, I believe you have experienced this kind of experience more or less: "Every rush hour, the originally wide traffic arteries become blocked for a while, the drivers and passengers are restless, the trumpet sounds loud and when the car is stuck in the middle of the intersection, it is embarrassing to find it, no ma ...

Posted on Sun, 18 Aug 2019 17:08:35 -0700 by adamlacombe

Data Analysis [Classification 1] SQL

Write in front: Interview-Data Analysis-Topic 1-4: All of them were originally handed over by NetEase Leigh's "Extraction of Interview Materials". Articles Catalogue [SQL] 1. Rownumber 2. Association Rules 3. Left Link, Right Link, Cart ...

Posted on Sun, 18 Aug 2019 05:03:42 -0700 by ramonekalsaw

springboot 2.1.7 + mysql5.6 Discard Calendar type field

Reason: When using Calendar as the field type, each findById() operation returns a slightly larger value than the actual value.The query will be invoked after the update and will be larger.That is, if we use Calendar as the field type, the field will quietly grow when the program runs. Code preparation The sample code is simple: we only need to ...

Posted on Sat, 17 Aug 2019 19:18:39 -0700 by mie

LVM, Network Protocol and Management

1. Create Logical Volume Create physical volume pvcreate /dev/sd{b1,c} Create Volume Group Name vgcreate vg0 /dev/sd{b1,c} -s 4G Create Logical Volume lvcreate -n mysql -L 8G vg0 Create File System mkfs.xfs /dev/vg0/mysql mount mount /dev/vg0/mysql /mnt/mysql/ Extended File System lvextend -l +1534 /dev/vg0/mysql Synchronize XFS File Syst ...

Posted on Sat, 17 Aug 2019 11:11:16 -0700 by deepermethod

Data x Data Synchronization: A Simple Practice of Mysql 2 Mysql (Local windows) (Containing Several Solutions to Compile Errors)

This paper uses datax in windows environment and refers to it in Linux environment. Development tools and environmental parameters: Windows environment: IDEA, JDK 1.8, Maven 3.6.0, Python 2.7.16 Linux environment: MySQL 5.7.25 (deployed on tw ...

Posted on Fri, 16 Aug 2019 02:37:50 -0700 by shivangp

Installation of MySQL 5.7 series of tutorials

Architecture MySQL Installation Explain: 1. This document is based on linux (CentOS6, CentOS7) system only. 2. Use version MySQL 5.7.20 3. Refer to the official document https://dev.mysql.com/doc/refman/5.7/en./ Preparing for Planning Note: 1. ...

Posted on Tue, 13 Aug 2019 05:50:30 -0700 by micaudwell

Mysql trainees: six novice road projects

Connect Mysql d: cd D:\mysql-5.7.27-winx64\mysql-5.7.27-winx64\bin net start mysql mysql -u root -p Item 10: Employees with the highest salaries in all departments Create an Employee table that contains all employee information, each employee has ...

Posted on Tue, 13 Aug 2019 05:24:07 -0700 by yaba

[Spring cloud step by step advertising system] 15. Binlog incremental preparation

Introduction to MySQL Binlog What is binlog? A binary log that records SQL statements that make or potentially change to data and is saved on disk as a result. What is the role of binlog? There are three main uses: Data replication (master-slave synchronization) Mysql's Master-Slave protocol enables Slave to achieve data consistency by listeni ...

Posted on Sat, 10 Aug 2019 22:39:15 -0700 by frikus

MySql || Quickly create 100w records

Normally, each developer will discuss the optimization of sql when there is a large amount of data.But not everyone has 100w of data to use for actual combat, so today we'll start by simulating a table of 100w of data. Creation principle In fact, there are many ways to create, fast and slow.This blog is certainly not the fastest one to writ ...

Posted on Sat, 10 Aug 2019 21:42:21 -0700 by Rupo

mysql optimization-use case of clustering index and index coverage

        Table smth has 10,000 rows of data with two fields of 3,000 length. select id from smth order by id; very slow select id from smth order by id,ver; faster Reason?     create  table smth( id int(11) not null default 0, ver int(11) default null, content varchar(3000)  default null, ...

Posted on Sat, 10 Aug 2019 04:15:37 -0700 by .Stealth