MySQL

Process record of setting up Apache+php+mysql environment under Docker This is a process record for setting up a Docker environment for easy viewing later. The main records are the tools used to build, the commands used and the pits

Experiment Preparation: This experiment is implemented on two CentOS hosts, one as FTP server and one for database server . A CentOS-7 when MySQL server One CentOS-6 when FTP serverNote that here who when the FTP server is critical,

PHP//Asynchronous MySQL Operations$db =NewSwoole_mysql (); $config=[ 'Host'='192.168.10.31', 'User'='Zouke', 'Password'='zouke369189', 'Database'='Pro', 'CharSet'='UTF8'];//connecting to a database$dbConnect ($config, function ($db, $r)

Mysql JSON typeVersion 5.7 SupportNative JSON type instead of BLOB typeJSON Data validation CheckQuery performance boost: No need to traverse all strings to find dataSupport for partial attribute indexing1. JSON Format example2. Structured and

A deadlock occurs after MySQL InnoDB locks are unlocked.[Error] Deadlock found when trying to get lock; Try restarting transactionOne thing to keep in mind is this: InnoDB's row lock and unlock are for primary key indexing. If the query is based on

One: Download navicat for MySQLGo to Navicat for MySQL download, select the downloaded version as needed, I choose Windows 64bit, choose one of the image address download.　　　　　　Two: Install Navicat for MySQLRun → next → Click "I agree" → Select the

Vertical Sub-table technologyVertical segmentation refers to: The table is not a lot of records, but the field is very long, the table occupies a large amount of space, when retrieving the table need to execute a large number of IO, severely reduce

MySQL Performance tuningImprove the performance and impact speed of your MySQL system-Replacement hardware (cpu/disk/memory, etc.)-Operating parameter adjustment of the service program-Optimization of SQL queriesConcurrency and connection

King01 as Master king02 with king03 as King01 slave,king04 as Mha_manager[[email protected] ~]# mkdir. SSH[[Email protected] ~]# CD. SSH[email protected]. ssh]# ssh-keygen-t dsa-p "-F ID_DSA[email protected]. ssh]# Cat id_dsa.pub >> Authorized_keys[[

On the Internet to read the east of the great God of things copied West copy copy, always wrong, because a lot of information is not for 5.7 of this version of the content.First unzip the file, such as I unzip to D:\Program

The reason for this problem is that there is a parameter connector for update on the web, not an and, but that's not what I came across.The reason I'm having a problem is that in the where of the UPDATE statement, the varchar type field I used

Reprint: http://blog.csdn.net/u013215018/article/details/54981216Now there are two tables, one is the roles table (the role table), the other is the Roleuser table (user role)Now I want to set the Roleid property in the Roleuser table to a foreign

MySQL user management create user and authorize Specify the logon IPCreate an authorized new user with the root user login:Mysql> Grant all in . to ' user1 ' @ ' 127.0.0.1 ' identified by ' 123456 ';All operations (additions, deletions and

The problem of repeated data insertions before the line, by troubleshooting the problem and the default isolation level of MySQL-repeatable read (can be reread) , repeatable read ensures that multiple instances of the same transaction will see the

Because the MySQL database is the default case-sensitive, the deployment of the time to find a number of duplicate tables, so the redundant table deleted. However, the remaining duplicate tables are then deleted with a hint: The table does not exist.

Mysql for databases (4) -- navicat for mysql and navicatmysqlNavicat1. introduction: Navicat is a software that has different software versions for different databases and supports the following databases:   Here I use navicat for mysql. To operate

Difficulties in hot standby and hot standby of Mysql database In the past, I have introduced anyone interested in configuring hot standby for Mysql databases, in this section, we will summarize and analyze the important links and precautions. I.

Mysql5.6.36 script compilation and installation and initialization tutorial, mysql5.6.36 Initialization Overview This document describes how to automatically compile and install the script of mysql5.3.6 for centos7.3 and subsequent initialization

Best practices for MySQL upgrading and practices for MySQL upgrading MySQL5.7 has many new features, such as Online DDL, multi-source Replication, enhanced semi-synchronization, tablespace transmission, sys database, and Group Replication. I finally

Mysql transaction isolation level, mysql transaction isolationTransaction Isolation Levels InnoDB supports four isolation levels in the SQL1992 standard: read uncommitted, read committed, repeatable read, and SERIALIZABLE. The default isolation