MySQL

MySQL log has many kinds, divided into error log, general query log, slow query log, binary log, relay log, transaction log , these log information has a very powerful function, error query, query diagnosis, replication, data recovery, maintain the

Article source: CentOS-based MySQL learning Supplement two--Create a database using the shellThe article, "How to use the MySQL database based on commands ," can be seen in the articles "description of the use of the CentOS-based MySQL", this

int range Type Bytes Minimum Value Maximum Value (signed/unsigned) (signed/unsigned) TINYINT 1 -128 127 0 255

Detailed syntax for MySQL modification tableALTER [IGNORE] TABLE tbl_name[Alter_specification [, Alter_specification] ...][Partition_options]Algorithm_option:algorithm [=] {default| inplace| COPY}Lock_option:LOCK [=] {default| none| shared|

Method 1: Use the Set password commandMysql-u Rootmysql> SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' Newpass ');Method 2: Use Mysqladminmysqladmin-u root Password "Newpass"If Root has already set a password, use the following

Host1 and Host3 are mainly from each other, that is, Host1 is the host3 of the host, but also for the host3 slavehost1 192.168.203.131host2 192.168.203.132host3 192.168.203.133 1. Install keepalivedwww.keepalived.org 2. Notice to empty the firewall

Experimental operating Environment: centos-6.5 Package Mysql-5.6.10.tar Mysql-5.5.15-linux2.6-i686.tar Cmake-2.8.10.2.tarInstall Source code Mysql1 First Download the latest version of the MySQL installation package source code to the MySQL official

Log in to native MySQL first①# Mysql-uroot-plam2linuxSee which libraries are included②> Show Database;Switch libraries③> use discuz or use MySQLSee which library is currently under④> Select Database ();View Current User⑤> seletc User ();View version

Server programs often want to access the database, and the server program is kept running for a long time, MySQL has a feature, when connected to the database does not do anything, the default 8 hours will automatically shut down the hibernation

The slow query analysis day was originally used to capture relatively "slow" queries, and in the mysql5.1 + version, the functionality of the slow query was enhanced to capture all queries by setting Long_query_time to zero, and the response time of

DELIMITER is actually defining a statement to execute the TerminatorDelimiter in MySQL:Http://blog.sina.com.cn/s/blog_4c197d420101d3oa.html1: Define Stored Procedure drop PROCEDURE test_insert;D elimiter $$//define Terminator Create PROCEDURE

Each table in MySQL has a clustered index (clustered index), except that each nonclustered index on the table is a level two index, also known as a secondary index (secondary indexes).For InnoDB, each InnoDB table has a special index called a

MyBatis Version: 3.2.8 Actually very simple, before want to complicate ... MyBatis after inserting a record of the self-increment ID, the incoming Pojo automatically updates the value of the ID to the inserted result (currently only the ID is

--Query statementsSelect class from Stu_info where sid=1000000102;SELECT * from Stu_info t where t.age=88; --T is the alias of the table, more convenient when querying multiple tablesSELECT * from Atable A, btable b where a.aid = B.bid;SELECT * from

website Description: Normally, a slave does not Log toits ownbinary Log anyUpdates that is received froma master server. ThisoptionTells the slave to LogThe updates performed byIts SQL thread toits ownbinary Log. forThisoption toHave anyeffect,

High buildings rise from the ground.Starting from the most basic, starting from the simplest.-----------------------------------------------------------------------1. Default ConstraintsCREATE TABLE emp (ID INT DEFAULT 12)View CodeCREATE TABLE emp

Due to work needs, need to learn PHP, originally wanted to install lamp but considering now Nginx server has good performance and wide application. Here I decided to build a Web server under Linux (centos7+nginx+mysql+php).

Partition PartitionTake doctrine, MYSQL 5.6 manual: Http://dev.mysql.com/doc/refman/5.6/en/partitioning.htmlPartition Type mysql supports Range,list,hash,key. The longest is the range list: List create table employees  ( 

First, IntroductionMyisampack is a tool that compresses the use of MyISAM engine tables, typically compresses 40%~70%, and when access to data is required, the server reads the required information into memory, so performance is better when

We know that the application of access to the database is typically read in most cases, with only a small portion of the write. Therefore, read/write separation (read-write-splitting) can effectively reduce the pressure of the main library, thus