MySQL

I. Preface (Introduction)Used amoeba for some time, found the official blog: Amoeba Use the guide there are many places are wrong, in my actual combat to give some wrong instructions, so I want to write some in the construction of the actual combat

#!/bin/sh#date: 2015-12-07#filename: check_mysql-rep.sh#linuxzkq#Email: [Email protected]#version: v1.0Mysql_cmd= "Mysql-uroot-poldboy"error_num= (1158 1159 1008 1007 1062)While TrueDoRep= ($ ($Mysql _cmd-e "show slave status\g;" | Egrep "_running|

The first is to build the environment, I was testing on a virtual machine1> first install MySQL RPM-IVH mysql-server-5.5.38-1.rhel5.i386.rpmRPM-IVH mysql-client-5.5.38-1.rhel5.i386.rpmIf the error says less Prel install Prel packageyum-y Install

1. Unzip the mysql-5.1.73 installation package (same nginx)2. Pre-compile, compile and install (steps below)CD mysql-5.1.73./configure--prefix=/usr/mysql-5.1Make && make install3 Adding a MySQL user group and user name:Groupadd MySQLUseradd mysql-g

MySQL replication is the most widely used set up, the previous section has simply said some of the use of replication and the principle of replication, know that we can quickly build a copy of the platform, but only know that these are not enough,

Configure Master-Slave preparationCreate a test database in our LordFirst log in to master MySQL, or use the absolute path/usr/local/mysql/bin/mysqlMysql> CREATE Database db1; > QuitCopy MySQL Library123. sqlCopy MySQL Library123. sqlLog in to

1 . connection.php file that connects to the database　　2 　　3 . Imported upload_excel.php FileRequire ("connection.php");//import Excel File function UploadFile ($file, $filetempname) {//Set the upload file for your own path $filePath = '

Compile and install MySQL today at startup, the following error is reported:Starting MySQL ......... ........ error! The server quit without updating PID file (/usr/local/mysql/data/k8s-1.pid)Workaround1. See if the/usr/local/mysql/data/mysql.pid

The following describes how to copy a MySQL database, MySQL replication is actually to copy data from one node (master) to another node (slaves). Of course, depending on the application architecture, the method is also different, the replication

The SQL statement for calculating the average value of mysql every 30 minutes, Table Structure: Create table 'instance' ('id' int (11) unsigned not null AUTO_INCREMENT, 'timestamp' int (10) unsigned default null, 'cpu' decimal (8, 3) default null,

Compile a script to allow Xtrabackup to back up MySQL Data, Xtrabackup Backup recovery PrincipleWhen backing up the innodb table, xtrabackup several threads copy the. ibd file of the independent tablespace, constantly monitor the changes in the redo

Simple sorting of MySQL Log operation commands, 1. First confirm whether your log is enabled MySQL>show variables like 'log_bin'; If ON is enabled, the log file is in the data directory of the MySQL installation directory. 2. How to know the

The problem of coexistence between automatic synchronization of MYSQL Update Time and default Creation TimeWhen using SQL, I want to automatically fill in the Update time when updating data. How can I implement it in mysql? For example, create a

MySQL optimization -- UsingfilesortThis problem occurs because MySQL can only use one index for each query. The WHERE condition of your SQL statement is different from that of ORDER BY. If the index is not created, order by cannot use the index, and

The latest database for provinces, municipalities, and counties nationwide and databases for provinces and counties nationwide The latest database for provinces, municipalities, and counties nationwide can be directly imported into the database.

Tutorial on installing and configuring MySQL performance monitoring software Nagios, Nagios is an open-source IT infrastructure monitoring system that monitors the running status and network information of mature Linux systems. Nagios can monitor

The basic usage tutorial of Distinct and Group By statements in MySQL, Remove duplicate query results from MySQL DistinctDISTINCTYou can use the DISTINCT keyword to remove duplicate records of a field in the query.Syntax: SELECT DISTINCT(column)

Install and configure Zabbix to monitor the basic tutorial of MySQL, Simple installation and configuration of Zabbix1. Install zabbix on the basis of the existing LAMP or LNMP and install some dependent packages: yum -y install mysql-devel

PureFTP uses MySQL to implement user authentication, Pureftp integrates mysql authentication to save ftp user information to the mysql database, which enables centralized management of a large number of ftp servers, to maintain a user account, you

REMOTE_LOGIN_PASSWORDFILE (10.2)REMOTE_LOGIN_PASSWORDFILE (whether the password file can be used during remote connection) Property Description Parameter type String Syntax REMOTE_LOGIN_PASSWORDFILE ={NONE |