MySQL

For an introduction to these four isolation levels: Unread (Read UNCOMMITTED). Another transaction modifies the data but has not yet committed, and select in this transaction reads the uncommitted data (dirty read). Submit Read

Environment: CentOS6.3 Database mysql6.5.26Edit/ETC/MY.CNFVi/etc/my.cnfRestart MySQLService mysqld RestartCreate user ' Mastj ' @ ' 192.168.1.16 ' identified by ' 123456 ';Grant Replication Slave on * * to ' mastj ' @ ' 118.123.199.12 ' identified

In MySQL database, Key_buffer_size is the most influential parameter to the performance of the MyISAM table.The following myisam is the configuration of the primary storage Engine server:MariaDB [(None)]> show variables like ' key_buffer_size ';+----

1. Connect MySQLFormat: mysql-h host address-u user name-P user Password1.1. Connect to MySQL on this machine.First open the DOS window, then enter the directory Mysql/bin, and then type the command mysql-u root-p, enter the password prompt. The

In Mysql-procedure (Cursor,loop), the text in the Spam_keyword table is all split into the T table, and each line of words are not duplicated, the T-table can be used as a dictionary, only 1000 of a dozen characters, this time the T-table as a

Method one: Stored procedures1. The stored procedure is as follows:delimiter $$DROP PROCEDURE IF EXISTSDataCREATE PROCEDUREDatainchIint)BEGIN whileI the DoINSERT intoGoodsVALUES("','Hammer Phone', i); SETI=I+1; END while;End$$Set @id=0; call

Modify via MySQL command line: Just modify the encoding of the current databaseMysql> set Character_set_client=utf8;Mysql> set Character_set_connection=utf8;Mysql> set Character_set_database=utf8;Mysql> set Character_set_results=utf8;Mysql> set

Because there are several installation configurations written in Lnmp, here are all commands.1 Turn off SELinuxCp/etc/selinux/config/etc/selinux/config.bakvim/etc/selinux/config #SELINUX =disable#selinuxtype=targeted2 packages and Software

EXPLAIN is the main way to see how the MySQL optimizer decides to execute a query, a feature that has limitations, that it will always tell the truth, but that it can get the best information. Learn to explain EXPLAIN, and you'll understand how the

1. adding groups and usersGroupadd MySQLuseradd-g MySQL mysql-s/bin/falseMkdir/data/mysql-pChown-r Mysql:mysql/data/mysql2. download the MySQL packageCd/usr/localwget http://cdn.mysql.com/archives/mysql-5.6/mysql-5.6.21.tar.gz3. Download the

Mysql Binlog logs are available in three formats, statement,mixed, respectively, and row!1.Statement: Every SQL that modifies data is recorded in Binlog .Advantages: There is no need to record changes in each row, reducing the Binlog log volume,

MySQL adds fields to the method is not complicated, the following will give you a detailed description of the MySQL add fields and modify the fields and other operations to implement the method, I hope you learn to add fields in MySQL will be

Environment: CentOS7Software: MySQL5.6.261 Download MySQL source packagewget http://nchc.dl.sourceforge.net/project/zabbix/ZABBIX%20Latest%20Stable/2.2.10/zabbix-2.2.10.tar.gz2 Unzip the downloaded file to the/usr/local directory and modify the

1. IntroductionXtrabackup is the MySQL database backup tool for Percona. An open source tool for hot provisioning of InnoDB and XTRADB.1> its backup process is fast and reliable2> can save disk and traffic based on compression function3> The backup

Source Installation gcc-5.10 and MariaDB-10.0.21http://cuchadanfan.blog.51cto.com/9940284/1689556MySQL (i) common binary format installation MySQL and database basic conceptshttp://cuchadanfan.blog.51cto.com/9940284/1688364MySQL (ii) MySQL basic

"Reprint" http://www.cnblogs.com/AndrewXu/p/4779648.html1. Open cmd, input, enterMysql-uroot-p-p3306-h127. 0.0.1 1)-U: Specifies the user name, Root is the super-privileged user.2)-P: Enter the password, enter the password when not specified, and

MySQL SQL statements Daquan1. Description: Create Database create database database-name2, Description: Delete database Drop database dbname3, Description: Backup SQL Server---Create Back up the data deviceuse masterexec sp_addumpdevice ' disk ', '

#!/bin/bash#auto backup MySQL#xiaosu 2015-08-06User=rootpassword=123456dir_back=/data/' Date +%y%m%d 'Date= ' Date +%y%m%d 'Database=test#判断用户是否是管理员rootIf [$UID-ne 0];thenEcho-e "\033[32mthe script must use root\033[0m"Sleep 2ExitFi#判断备份目录是否存在if

Reference: http://deidara.blog.51cto.com/400447/317526/First, the test environment:650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M02/72/D8/wKioL1Xup4ihJABKAACwHLXitCo559.jpg "title=" memcached test environment diagram. jpg "alt="

1 The concept of the MySQL storage engine The data in MySQL is stored in files (or memory) in various different technologies, using different storage mechanisms, indexing techniques, locking levels, and ultimately providing a wide range of