CentOS 7 installs the LNMP environment (PHP7 + MySQL 5.7 + Nginx 1.10)

tool VMware version number: 12.0.0 CentOS version: 7.0 I. Modifying the yum Source [root@localhost ~]# rpm -Uvh https://dl.fedoraproject.org/pub/epel/epel-release-latest-7.noarch.rpm [root@localhost ~]# rpm -Uvh https://mirror.webtatic.com/yum/el7/webtatic-release.rpm [root@localhost ~]# rpm -Uvh http://dev.mysql.com/get/mysql57-community-re ...

Posted on Mon, 31 Dec 2018 23:24:09 -0500 by play_

MySQL 5.7.18 binary package installation under Linux (no default configuration file my_default.cnf)

The source of this paper is: http://www.cnblogs.com/wy123/p/6815049.html      The latest in learning MySQL, pure novice, also know little about Linux, because it is the latest download version of MySQL (MySQL 5.7.18) binary package, CentOS 7.2 test installation, easy to toss about later.Probably the following steps, installation and deletion ...

Posted on Mon, 31 Dec 2018 22:27:09 -0500 by notsleepy

Group by, have, count of Mysql statements

Mysql's group by, have, count Usually it is used incorrectly. Here are some examples. group by having Aggregate functions count, avg, min, max, sum, etc. Some basic sql statements: http://www.cnblogs.com/xinge1993/p/4769468.html Commonly used sql http://www.cnblogs.com/sunada2005/p/3411873.html group by Grouped according to the values ...

Posted on Mon, 31 Dec 2018 15:06:08 -0500 by mikevarela

12.1-12.5 LNMP Architecture Introduction, MySQL Installation, PHP Installation, Nginx Introduction

Introduction to LNMP Architecture lamp architecture, linux, mysql, apache, php; P-hp exists as a module of apache. libphp5 or libphp7 is used to parse P hp. Apache provides services called httpd. when a user logs on to the website, Apache will request the P HP module to interact with the database. lnmg architecture, linx, mysql, nginx, php ...

Posted on Sat, 29 Dec 2018 10:33:09 -0500 by neiltaylormade

Java for Web Learning Notes (105): Using JPA (5) Isolation and CP30 in the Spring Framework (Part 1)

What is the isolation of transactions? isolation is important for data consistency. There are many introductions on the internet. Recommended reading: MYSQL official website 14.5.2.1 Transaction Isolation Levels Hibernate Tutorial 20.7.2 Transaction Isolation Levels Generally speaking, if you use READ_UNCOMMITTED, this is suitable for ...

Posted on Sat, 29 Dec 2018 09:03:07 -0500 by avalonindigo

Spring uses Jdbcdaosupport, C3P0, and properties

Spring uses Jdbcdaosupport, C3P0, and properties Concept: 1. C3P0 is an open source JDBC connection pool, which implements data source and JNDI binding and supports JDBC 3 specification and JDBC 2 standard extension. At present, open source projects using it include Hibernate, Spring, etc. The emergence of c3p0 greatly improves the efficiency ...

Posted on Thu, 27 Dec 2018 15:45:06 -0500 by fireant

LEFT (RIGHT) JOIN in MYSQL Using ON and WHERE Screening Differences

The question is whether the query uses left(right)join filters in mysql to distinguish the data queried on and where. Maybe you can't see any problems just by looking at two keywords. So let's use actual examples to see if there is any difference.   For example, there are two table structures Table structure 1 Sql code DROP TABLE IF EXIST ...

Posted on Thu, 27 Dec 2018 15:21:06 -0500 by sdm

Centos7 mysql-5.6.30-linux-glibc2.5-x86_64.tar.gz installation

 [mysql] # Set the default character set for mysql client default-character-set=utf8 socket=/var/lib/mysql/mysql.sock [mysqld] skip-name-resolve Setting Port 3306 port = 3306 socket=/var/lib/mysql/mysql.sock # Set up the installation directory of mysql basedir=/usr/local/mysql # Set up the storage directory of mysql database dat ...

Posted on Tue, 25 Dec 2018 17:54:06 -0500 by keziah

Linux installs JDK,MySQL,Tomcat,Redis and other software

Add Micro-Signal GO_HOME_2020 to Discuss Java Linux Installation Software Install JDK The first step is to see if there is a JDk in the system. Step 2 Install JDK The third step is to configure environment variables Step 4: Enabling the configuration of environmental variables Step 5: Look at environment variables St ...

Posted on Tue, 25 Dec 2018 01:30:06 -0500 by WolfRage

memcache cache server (Nginx+PHP+memcache+MySQL)

Anti-counterfeiting code: Wanzhang Hongdun three cups of wine, Qianqiu Daye a pot of tea.I. MemCache JanesessionMemCache is a free, open source, high performance, distributed memory object caching system for dynamic Web applications to reduce the load of the database. By caching data and objects in memory, it can reduce the number of times to r ...

Posted on Tue, 25 Dec 2018 00:06:07 -0500 by ltoso