MySQL

MySQL database installation manual in Linux systemFirst, installation Overview:Installing the MySQL database in the Linux operating system is a technology that we have to master, and it also determines the salary for your future job, so you know

Blue SealMySQL data types can be divided into 3 categories: numeric type , date and Time type , and string (character) typeSquare brackets ("[" and "]") indicate the part of the optional type modifierMIndicates the maximum display size. The largest

In order to realize the redundancy of MySQL database, backup, recovery, load balancing and other functions, the two days have been learning and studying MySQL dual-machine hot standby, in fact, MySQL's dual-machine hot standby is the use of MySQL

1, install the monitoring plug-inwget https://www.percona.com/downloads/percona-monitoring-plugins/percona-monitoring-plugins-1.1.7/binary/ redhat/6/x86_64/percona-zabbix-templates-1.1.7-2.noarch.rpmRPM-IVH

ReasonWe programmers have to deal with the database, after several years of exercise, feel that the handwriting SQL statement has been forgotten bad good, prompted me to this article is the reason why, one night I update a system of the database

SSL encryption method for MySQL 5.7MySQL 5.7.6 or later(1) Create a certificate to turn on SSL authentication--Installing OpenSSLYum Install-y OpenSSLOpenSSL versionOpenSSL 1.0.1e-fips 2013--Installation Certificate/usr/local/mysql/bin/mysql_ssl_rsa_

from:http://blog.csdn.net/mchdba/article/details/11575605As data continues to grow, and in order to be compatible with future InnoDB storage engines, consider the strategy of mysqldump full + log incremental backup. Using mysqldump is good support

Note that the official is not advocating the use of root.Download and install MySQLThe latest RPM address https://dev.mysql.com/downloads/repo/yum/#wget https://repo.mysql.com//#rpm-IVH mysql57-community-release-el7-. noarch.rpm#yum Install

After MySQL turns on Bin-log, the error number 1418 error occurs when you call a stored procedure or function and trigger:ERROR 1418 (HY000): This function has a none of deterministic, NO sql,or READS SQL DATA in its declaration and binary loggin G

Problem phenomenonThe MySQL service under Windows failed to start, reported a 1069 error.Cause of the problemIf MySQL starts the user's password or permissions error, it causes the Windows Server MySQL startup to "fail to start the service because

MySQL group query for data Tables (group by)The GROUP BY keyword can group query results by a field or multiple fields. The values in the field are equal to one group. The basic syntax format is as follows:GROUP by property name [having conditional

Recently, because of some things happened, there appeared a very benign page, into an empty page. Turn head development colleague to question me, is not what I moved, later after investigation found that the platform operation of colleagues

Best 20 + Experience sharing for MySQL performance optimizationMySQL the best over 20 experience sharing for performance optimization ....... ............... ....................... ........ 11. Optimize your query for the query cache ....... ..... .

MySQL database name method example with special characters, mysql Database Name Preface This article explains how to create a database name with special characters in MySQL. The special characters include :! @ # $ % ^ The method is as follows: Use

Use the command to create MySQL database (de1), mysqlde1 1. Connect to MYSQL Format: mysql-h host address-u user name-p User Password 1. Connect to MYSQL on the local machine. First, open the DOS window, enter the mysql \ bin directory, then type

MySQL cache mechanism (1) and mysql Cache Mechanism   This article used to learn | reference: http://www.2cto.com/database/201308/236361.html Understanding and summary of MySql Query Cache and SQL Server process Cache I. MySql Query Cache 1. Query

4G memory server MySQL configuration optimization, 4G memory server mysql As the company's website traffic increases (more than 0.1 million PVS per day), MySQL naturally becomes a bottleneck. The most basic optimization of MySQL system parameters is

MySQL -- pt-osc tool learning, mysql -- pt-osc Tool ##=================================================== ====================== ##Pt-osc workflow:1. Check whether the table has a primary key or a unique index and whether a trigger exists.2. Check

MySQL MEB common usage, mysqlmeb usage 1. Back up data to an image Backup: ./mysqlbackup --socket=/usr/local/mysql-advanced-5.6.23-linux-glibc2.5-x86_64/data/mysql.sock --backup-image=/images/20161008.mbi --backup-dir=/tmp/backup

About innodb locks (record, gap, Next-Key lock) and innodbnext-key Record lock locks a single index record. Record lock always locks the index instead of the record itself, even if the table does not have any indexes, then innodb will create a