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