MySQL

1. First, we need two virtual machines (centos7,linux text).2. Configure the network environment for two virtual machines to bridge mode CentOS7 IP to 192.168.100.137, 24,linux text IP to 192.168.100.237/24, and then configure the Yum Source

Case: Today's implementation of MySQL master-slave +ssl encryption transfer, Master signed a certificate for slave has a small problem:failedto Update Database txt_dberror number 2650) this.width=650; "Src="

MySQL is stored on disk, and all kinds of natural disasters can result in data loss. Large companies when we often need to do a good job of data hot and cold, for small companies to do all the data backup needs to spend a lot of costs, many

1. The test process is as follows:CREATE TABLE' Test ' (' ID ')int( One) not NULLauto_increment, ' name 'varchar( -)DEFAULT NULL, PRIMARY KEY(' id '),UNIQUE KEY' name ' (' name ')) ENGINE=InnoDBDEFAULTCHARSET=utf8Transaction 1: 　　　　　　　　　　　　　　　　　　　　　

>>>>>>>>>>Practice Time: 2016.12.16Editing time: 2016-12-20-->22:12:08 title :related to: multi-table query, exists, COUNT (), group BY, order by1.1Relationship ModeStudent Student；SNO: study number;SNAMEName AgeAgeSEX: GenderCourse Course: CNO:

Parallel replication, mainly to solve the sql_thread in high concurrency environment, there are performance bottlenecks. The idea of mysql5.7 parallel replication is straightforward, and a group commits a transaction that can be replayed in parallel

Introduction: 关于数据库优化，网上有不少资料和方法，但是不少质量参差不齐，有些总结的不够到位，内容冗杂偶尔发现了这篇文章，总结得很经典，文章流量也很大，所以拿到自己的总结文集中，积累优质文章，提升个人能力，希望对大家今后开发中也有帮助 1. Select the most applicable field propertiesMySQL is good at supporting large data volumes, but in general,

I. Creating a MySQL stored procedure1,CREATE PROCEDURE ' Insertalarminfo ' (in Businessindex int, in Providerindex int., in Alarmtype int, in Alarmlevel Int,in detecttime DateTime, in alarmdescription varchar (+), in Alarmphenomenon int, in

Keepalived high-availability monitoring scripts for MySQL (or other services)Development Script Requirements : We know that KeepAlive is based on the survival of the virtual IP to determine whether to preempt the master mechanism, but if we do the

mysql query process: The client sends a query request. The server checks the query cache and returns the result if the cache is hit, otherwise, proceeds. The server performs SQL parsing, preprocessing, and then the optimizer

MySQL Query cacheUsed to save the full result returned by the MySQL query statement, when hit,MySQL returns results immediately, eliminating parsing, optimization, and execution phasesConcurrency query volume is very large, the CPU core number of a

Mysql buffer and cache settings MySQL Adjustable settings can be applied to the entire mysqld process, or to a single client session. Server Settings Each table can be represented as a file on the disk. It must be opened first and then read. To

Detailed description of MySQL master-slave replication, read/write splitting, Backup recovery, mysql master-slave I. MySQL master-slave Replication 1. Introduction Why do we need master-slave replication? Master-slave replication objective:

Mysql row-Level Lock usage and deadlock prevention solutions, mysql Solutions I. Preface Mysql InnoDB supports transactions and row-level locks. You can use row locks to process user withdrawal and other services. Sometimes deadlocks occur when

Mysql and mysql download For project reasons, mysql has been in use for two years, but it has never been summarized. Recently, it was the lead who reminded me of the summary of the use of mysql. I. Create 1. Single insert, SQL format: insert into

The reason why the Navicat query results cannot be modified and the solution is as follows: Problem: Navicat is often used in development to query databases and modify values in databases. The query result is read-only and cannot be modified. I

CentOS6.5 describes how to install MySQL5.1.71 and centostop yum install -y MySQL-server mysql mysql-deveservice mysqld start/stop/restart The following prompt is displayed when the system is started for the first time. Including How to Set

MySQL uses SSL connection configuration details, mysqlssl Check whether SSL is supported First, run the following command on MySQL to check whether MySQL supports SSL: mysql> SHOW VARIABLES LIKE 'have_ssl';+---------------+-------+| Variable_name |

In-depth parsing of temporary tablespace in MySQL 5.7 and in-depth parsing of mysql5.7 Temporary table A temporary table, as its name implies, is a temporary table that has been destroyed. Data can be stored in both a temporary file system and a

Use of mysql row-level locks and prevention of deadlocks, mysqlI. Preface Mysql InnoDB supports transactions and row-level locks. You can use row locks to process user withdrawal and other services. Sometimes deadlocks occur when mysql locks are