Aliyun CentOS7.3 Build LNMP Manually

** 1. Turn off firewalls and selinux --------------- ** Close Firewall [root@localhost ~]# systemctl stop firewalld.service selinux [root@localhost ~]# vim /etc/sysconfig/selinux Find SELINUX=enforcing and change enforcing to disabled [root@localhost ~]# setenforce 0 ** 2. Install nginx --------- ** wget download install ngi ...

Posted on Sat, 04 Jul 2020 11:44:33 -0400 by lajocar

python3 implements mysql export excel

I. Preparations Python Tool Library Installation xlwt and xlrd Installation under 1.1win7 1.1.1 Method 1: Download and Install 1. From http://pypi.python.org/pypi/xlwt Download xlwt-1.0.0.tar.gz; 2. From http://pypi.python.org/pypi/xlrd Download xlrd-0.9.4.tar.gz; 3. Unzip the package; 4. Run under win7. [plain] view plain copy cmd ...

Posted on Thu, 02 Jul 2020 11:05:12 -0400 by seventheyejosh

python3 implements mysql export excel

I. Preparations Python Tool Library Installation xlwt and xlrd Installation under 1.1win7 1.1.1 Method 1: Download and Install 1. From http://pypi.python.org/pypi/xlwt Download xlwt-1.0.0.tar.gz; 2. From http://pypi.python.org/pypi/xlrd Download xlrd-0.9.4.tar.gz; 3. Unzip the package; 4. Run under win7. [plain] view plain copy cmd ...

Posted on Thu, 02 Jul 2020 11:04:09 -0400 by jlp09550

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 on Tue, 30 Jun 2020 02:24:32 -0400 by flyersun

Application of partition table in MySQL database

What is partition table First of all, let's look at the normal storage of tables The upper part is innodb engine, the lower part is myISAM engine customer_login_log.frm #The metadata of each table is saved, including the table structure and the corresponding definition, regardless of the number Acc ...

Posted on Tue, 30 Jun 2020 00:40:43 -0400 by ghostrider1

spring annotation Driven Development -- attribute assignment

1. @Value assignment and @ PropertySource loading configuration file SpEl Introduction: https://www.jianshu.com/p/e0b50053b5d3 @Value assignment public class Person { //Use @ Value to assign Value; //1. Basic value //2. You can write a spiel; ා {} //3. You can write ${}; take out the val ...

Posted on Tue, 30 Jun 2020 00:29:28 -0400 by utahcon

MYSQL Basics__ Query language DQL

The first chapter is the basic syntax specification of SQL 1.sql is not case sensitive, but it is customary for keywords, system reserved words, function names to be uppercase, and table and column names to be lowercase 2.sql uses space or carriage return to separate each word. It is customary for ...

Posted on Mon, 29 Jun 2020 03:51:57 -0400 by weevil

Percona MySQL View Tables Not Accessed

It's really hard to find out if a table in an instance has access.( A common method is to open a tcpdump or tshark persistent packet to filter suspected table names.( However, if we were using MySQL from the Percona branch, this would be much easier. Under Percona MySQL, we can open the userstat parameter and query the system statistics tabl ...

Posted on Sun, 28 Jun 2020 12:51:50 -0400 by Sno

009 - generation method of distributed ID

effect Unique identification of data and information in distributed cluster system target Global uniqueness: duplicate ID number is not allowed. Since it is the only identification, this is the most basic requirement. Trend increasing: in MySQL InnoDB engine, clustered index is used. Because most ...

Posted on Sun, 28 Jun 2020 01:06:53 -0400 by plzhelpme

azkaban multi node deployment and installation record

Environmental preparation jdk8+ mysql Node Division centosx1 centosx2 centosx3 web-server exe-server exe-server mysql Here, the hosts file is edited and selinux and firewalld are closed [root@centos7x3 azkaban-exec-server]# cat /etc/hosts 127.0.0.1 localhost localhost.localdomain ...

Posted on Sat, 27 Jun 2020 04:26:17 -0400 by siminder