MySQL

Performing State analysisSleep statusUsually indicates that the resource is not released, and if it is through a connection pool, the sleep state should be constant within a certain number of rangesActual combat example: due to the front-end data

SummaryHow to use crontab to regularly back up MySQL database under Linux:Just follow the 3 steps below and everything is under your control:First step: Configure the backup directory code on the server:-----------------------------------------------

1. Create a foreign key directly in the SQLyog:You can create a foreign key by dragging 2 tables into the schema designer in SQLyog, and then selecting T_book Booktypeid to the ID location of the t_booktype of the other table.MySQL's foreign key

There are a lot of ways to install MySQL in a Linux environment, because I use Ubuntu as a development environment, so I want to install MySQL in a Debian packages way. Check the official documentation

The use of MySQL cursors is able to iterate through the result level to operateDefining cursorsDECLARE ID int;DECLARE name varchar (30);DECLARE cursor_name cursor FOR select C_id,c_name from tables (assigns the data of the select query to the cursor

1. View the status of MasterShow master status; Position should not be 0show Processlist; //state status should be have sent all binlog to slave; waiting for Binlog to be updated2. View slave statusshow slave status;//slave_io_running and

Installation:There is no normal installation of MySQL Mysql-sever files in the CentOS 7 yum source, which needs to be downloaded from the official website ( by installing MySQL's yum container and installing MySQL via Yum)Note: Before installing,

installing Msqyl on CentOSCheck to see if the MySQL database is already installed on our operating system using the following command[Email protected] ~]# Rpm-qa | 　　 grep MySQL #这个命令就会查看该操作系统上是否已经安装了mysql数据库有的话, we'll uninstall it by RPM-E command

Keepalived Hot Spares can be seen in the documentation: keepalived configuration usingMySQL master-slave Documentation: MySQL master-slave replicationKeepalived of the two-master, is a master-slave one, we see one eye on the understanding, in order

Method One,JS Code#/etc/init.d/mysqld stop --user=mysql--skip-grant-tables--skip-networking & -u Root mysql mysql > UPDATE user SET password=password ('newpassword') where user= ' Root ' ; MySQL> FLUSH privileges; MySQL> quit

The capability flags is used by the client and server to indicate which features they, and want to use.Protocol::capabilityflags: CLIENT_LONG_PASSWORD Use the improved version of Old Password Authentication .Note

MySQL various cascade queries after update (update Select).CREATE TABLE ' tb1 ' (' id ' int (one) is not NULL,' A ' varchar (+) default NULL,' B ' varchar (+) default NULL,' C ' varchar default NULL,PRIMARY KEY (' id '),KEY ' id ' (' ID '))

This article refers to Zhang Yi's nginx 0.8.x + PHP 5.2.13 (FastCGI) to build 10 times times more than Apache Web Server (6th edition) [Original] completed. All operational commands are successful under the CentOS 6.4 64-bit operating system.1.

Slow queryWe know that the general application system, MySQL read and write ratio of about 10:1, and the general insert and update operations rarely appear performance problems, encountered the most problems, but also the most prone to problems, or

Mysql yum repository provides RPM packages for mysql server, client and other components on the Linux platform. It supports the following platforms:     el5-, el6-,  and  el7-based platforms, such as the corresponding version of Ed hat enterprise

Binary Log Recording modeRow levelBinary log is recorded as a modified form for each row of data, and then the same data is modified on the slave side.If you modify the structure of a table, then the Binlog log records the action of recreating the

#!/bin/shif ["] = =" "-a" $ "= =" "];thenecho "Please enter a new library name"Exit 1Fi#if ["$ = =" "-a" $ = "=" "];then# echo "Usage: $ databas_ename Database_pass"# exit 1#fi/usr/local/mysql/bin/mysql-uroot [email protected] Create DATABASE

Back up the MySQL database script.Manually creating a directory/var/backups/mysqldata can also be customized, just modify the value of the variable Backup_dir.#!/bin/bash#mysql Backup Script

MySQL Transaction ISOLATION level detailedBlog Category: Sql MySQL data structure SQLThe SQL standard defines a Class 4 isolation level, which includes specific rules to define which changes within and outside the transaction are

Share new users and authorization methods in Mysql, and authorize mysql In the project development process, you may need to open your own database to others, but to ensure security, you cannot open other databases on your server at the same time.