Installation and description of mysql report monitoring tool
mysql report displays mysql status changes in a friendly way. In fact, it reports almost all the states. Unlike show status, which only shows more than 100 state values, mysql report interprets and formats these state values in a humane way, greatly increasing their readability.
The advantage of MySQL report is that it can quickly view variou ...
Posted by jackthebookie on Sun, 23 Jun 2019 15:28:10 -0700
Basic commands of Mysql database
1. When you need to install mysql database through yumFirst you need to update the yum source[root@server ~]# rpm -Uvh http://dev.mysql.com/get/mysql57-community-release-el7-7.noarch.rpm [root@server ~]# yum install mysql-community-server mysql-community-devel2. Source Package InstallationReference resources http://douer ...
Posted by Ganlek on Sat, 22 Jun 2019 16:59:20 -0700
CentOS 7 installs mysql to change data storage location
Recently, I changed my computer system to centos. Everyday development tools need to be reconfigured. Here I record the configuration of mysql, which is different from the ubuntu series.
Reference resources: http://www.centoscn.com/mysql/2016/0315/6844.html
1. MySQL relies on libaio, so first install libaio
yum search libaio # Retrieval ...
Posted by Willburt on Sat, 22 Jun 2019 14:29:33 -0700
6. Use read to define variables
To illustrate the example below, we first install the Apache server and then start Apache.
[root@localhost ~]# yum install httpd
[root@localhost ~]# systemctl start httpd
[root@localhost ~]# ps aux | grep http
root 3716 0.5 0.0 221936 5000 ? Ss 13:49 0:00 /usr/sbin/httpd -DFOREGROUND
apache 3717 0.0 0.0 224020 3088 ...
Posted by Gokul on Fri, 21 Jun 2019 13:55:33 -0700
LVS Dual-machine Load Balancing Deployment Scheme Based on Centos 7.3.10-514
LVS Dual-machine Load Balancing Deployment Scheme Based on Centos 7.3.10-514
Host: 192.168.1.51
Standby: 192.168.1.52
LVS VIP: 192.168.1.50
0. Production system local CD-ROM yum source
Note: Use CentOS-7-x86_64-DVD-1611.iso file to upload to the system for completing the following installation steps without access to the public netwo ...
Posted by rake on Thu, 20 Jun 2019 17:06:20 -0700
CentOS 6.5 configures the LNPM environment (PHP 7.0)
CentOS 6.5 configures the LNPM environment (PHP 7.0)
After installing virtual machine on window s platform, install LNPM (PHP 7.0) environment in CentOS 6.5:
The following parts are reproduced separately from (thanks to the relevant authors, I only make merger adjustments for your reference): http://blog.csdn.net/boolbo/article/details/52353 ...
Posted by Jessup on Wed, 19 Jun 2019 12:03:34 -0700
CentOS6 Disc Merge
Introduction: Systems before CentOS6 and CentOS6 will store the system on two discs, DVD1 and DVD2. DVD1 can be used to install the operating system. System installation package files are stored in DVD1 and DVD2 respectively.
When installing software using local yum sources, if you only use the package files on one disc, the installation ...
Posted by DJ Judas on Wed, 19 Jun 2019 09:55:58 -0700
Nginx configures multiple HTTPS domain names
This article is synchronized with the personal Github blog: https://github.com/johnnian/Blog/issues/8 Welcome to leave a message.
Recently, I've been playing the Wechat app. I have the following programs on hand:
A Cloud Server: CentOS 7
Multiple primary domain names
During the development and testing process, for some reasons, we want to mak ...
Posted by @sh on Mon, 17 Jun 2019 11:41:39 -0700
pt-table-checksum checks master-slave database data
pt-table-checksum and pt-table-sync, the former is mainly used to verify the consistency of master and slave, and the latter is mainly used to repair data. The combination of the two can repair the problem of data inconsistency.
1. pt-table-checksum installation
The latest address for downloading the toolkit is as follows:
https://www.percona. ...
Posted by maxpagels on Sat, 15 Jun 2019 17:11:35 -0700
Tengine 2.2.0 Compilation, Installation, Boot-up, Reverse Agent Configuration and Health Check
Tengine 2.2.0 Compilation, Installation, Boot-up, Reverse Agent Configuration and Health Check
tengine is an open source project based on nginx initiated by taobao. nginx throughput is relatively high, fast and stable, and reverse proxy and load balancing using nginx is the most common. This article describes how to compile and install under ...
Posted by LoganK on Thu, 13 Jun 2019 13:42:14 -0700