MySQL installation steps

MySQL installation steps Install dependency package yum -y install autoconf automake libtool cmake ncurses-devel openssl-devel lzo-devel zlib-devel gcc gcc-c++ Download the corresponding source package wget http://downloads.sourceforge.net/project/boost/boost/1.59.0/boost_1_59_0.tar.gz wget http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql ...

Posted on Wed, 04 Dec 2019 12:28:49 -0500 by justcrapx

GDB debugging Mysql source compilation and installation

Download source code git clone https://github.com/mysql/mysql-server.git cd mysql-server git checkout 5.7 Compilation and installation Installation dependency yum install -y cmake make gcc gcc-c++ ncurses-devel bison gdb Note that you need to specify the boost path, which will be downloaded automatically when cmake cd BUILD; cmake .. -DDOWNLOA ...

Posted on Wed, 04 Dec 2019 11:32:44 -0500 by philippe2

How does the line record length statistics come from GDB debugging Mysql priority queue sorting algorithm

background Next https://mengkang.net/1328.html We continue to kowtow.Last article GDB debugging Mysql practice (3) priority queue sorting algorithm research (1) The reason why the row UU size in Experiment 3 is 24 is analyzed. In other experiments, the row size was 36, and the number of scanning lines was not as expected. Let's explore this art ...

Posted on Wed, 04 Dec 2019 03:36:02 -0500 by mattcooper

Integer type of [numeric type] of data type

1.1 mediumint description 1.2 mediumint practice 1.2.1 environmental preparation 1.2.2 plus UNSIGNED parameter 1.2.3 add ZEROFILL parameter 1.2.4 without UNSIGNED and ZEROFILL parameters 1.3 summary of mediumint 1.1 mediumint description type length Length is when length is not specified Occupying byte Signed Unsigned mediumint 8 9 (act ...

Posted on Wed, 04 Dec 2019 02:11:17 -0500 by ddragas

Analyze the Gaud map api to obtain the provincial and urban areas, and generate the latest three-level linkage sql table

Preface: In the recent project, the three-level information of provincial and urban areas in China has been used, but the information found on the Internet is relatively old. It doesn't match the latest regional information. Later, I saw that there was such information on the map of Gaode, so I analyzed the api interface and generated the sql i ...

Posted on Tue, 03 Dec 2019 21:46:01 -0500 by keithwjones

Troubleshooting for abnormal downtime of nodes in Galera Cluster

background Before Group Replication was released, MySQL official replication had asynchronous and semi synchronous. At that time, most companies would choose Galera cluster to make up for the full synchronization scheme, mainly including PXC of percona server and MGC of MariaDB, which are embedded in their own versions. In this paper, a case of ...

Posted on Tue, 03 Dec 2019 20:42:21 -0500 by tphgangster

About the front-end processing emoticons (solution)

Today, there is a problem in the test feedback, that is, the comments with emoticons are uploaded and reported wrongly. It is obvious that there is no relevant processing for emoticons in the background. Let them handle it. What kind of trouble do they say? Forget it. The front end should handle it by itself! The specific reason is ...

Posted on Tue, 03 Dec 2019 15:39:17 -0500 by MattSharp

SpringBoot practice | using JdbcTemplates to access Mysql

WeChat public number: an excellent wasterIf you have any questions or suggestions, please leave a message in the background. I will try my best to solve your problems. Preface For example, today we will introduce that springboot accesses relational mysql through jdbc and spring's JdbcTemplate. Preparation SpringBoot 2.x jdk 1.8 maven 3.0 idea ...

Posted on Tue, 03 Dec 2019 13:27:25 -0500 by AL-Kateb

Navicat tool and pymysql module of mysql

1. Introduction to ide tools (Navicat) In order to facilitate the test, use the IDE tool, Navicat, which is essentially a socket client, a visual tool for connecting mysql server, and a graphical interface version. The difference between it and using the command line directly is similar to the difference between linux and windows. Navicat downl ...

Posted on Tue, 03 Dec 2019 13:07:45 -0500 by 9902468

Character set scrambling in mysql

#View the character set of mysql database mysql> show variables like "%character%"; +--------------------------+-----------------------------+ | Variable_name            | Value                       | +--------------------------+-----------------------------+ | character_set_client     | utf8                        | | character_set_connec ...

Posted on Tue, 03 Dec 2019 10:31:29 -0500 by bigsid