MySQL

Performance optimizationPrinciples of MYQL Database optimization:1. Reduce the bottleneck of the system.2. Reduce the use of resources.3. Increase the reaction speed of the system.Optimizing queries1. Impact of indexes on queriesFor example, there

1. and 1=1 and 1=2 judgment2. Whether to support the order by burst display bit3. Display bit to check important information, user (), version (), database (), Construct syntax query table4. According to the above information to see if the authority

Installation (based on CentOS)Yum-y Install mariadb mariadb-server # centos7 version #centos7 The following versionsStartService mysqld start # centos7 The following version Chkconfig mysqld on # set power on start orsystemctl start mariadb

Indexing a field in a data table will greatly increase the speed of the query:For example: SELECT * FROM mytable where username= ' admin ' if an index is established on the column username, only one time is required to find the recordOne, the type

The nature of the indexThe official MySQL definition for an index is: The index is the data structure that helps MySQL to get data efficiently. It can be understood that the index is a data structure.We know that database query is one of the most

I. The role of affairsA transaction is a sequence of successive operations that will occur.Transaction security is to ensure that the results of a series of operations are kept in sync to ensure data integrity.When a transaction is turned on, the

The MySQL database has a concept of autocommit transactions, autocommit. The implication is that if autocommit is turned on, each statement is automatically committed after execution. That is, a statement is treated as a transaction.In the mysqldb

Some of the more well-spoken information:Http://www.cnblogs.com/liangshaoye/p/5464794.html: Explains the hot spare, Win Bei, cold, incremental backup, differential backup and many other concepts.Http://www.cnblogs.com/guoyibao/p/3867634.html:

First, the index length and the degree of differentiation are contradictory,The index length is too short, then the sensitivity is very low, the index length is longer, the sensitivity is high, but the index is to occupy memory, so we need to find a

---restore content starts---MysqlConcept: is a collection of tables, is a large classificationInstallationInstallation File Download path: (Leoning blog)http://www.cnblogs.com/SmartNing/p/5178616.html1. Configure VideoThe first step: Download the

#!/bin/bashusername=roothostname=localhostpassword=rootmysql-u$username-h$hostname-p$password-e "Show Databases" Read-p "PLZ input a dbname:" dbnameread-p "PLZ input backupdir:" backupdirread-p "PLZ input backupname:" BackupName if [["$dbname" = = "

Transferred from: http://www.cnblogs.com/zhuawang/p/4185302.html*********************Create a table*****************************/delimiter//DROP TABLE if existsTest//CREATE TABLETest (IDint( One)NULL) ///********************** One of the simplest

1, by the hour statistics statementSelectConcat (Date_format (gmt_create, "%y-%m-%d%k:00~"), Hour (gmt_create) +1, ": xx") as ' time ',COUNT (*) as NumFrom T_orderwhere gmt_create>= ' 2016-03-06 00:00:00 ' and gmt_createGroup by left (Gmt_create, 13)

I. INTRODUCTION OF TriggersTrigger (trigger), bind some code in advance for a table, and when this table data changes, the system will automatically call these bound code.Event Type: Insert, delete, updateTrigger time: befor, afterEvent object: Each

MySQL5.7.10 installation document tutorial details, mysql5.7.10 details 1. Install the dependency package yum -y install gcc-c++ ncurses-devel cmake make perl gcc autoconf automake zlib libxml libgcrypt libtool bison 2. Install the boost

Create a stored procedure, trigger, and a simple instance (image and text) using a cursor in navicat. 1. Create a tableFirst, create two tables (users table and number table). The specific design is as follows: 2. Stored ProcedureWrite a stored

Class and ObjectObject Oriented (OO ). At first, "object-oriented" refers to the use of encapsulation, inheritance, polymorphism and other design methods in program design. Now, the object-oriented thinking involves various aspects of software

PACK_KEYS and mysqlPACK_KEYS in mysql Original http://jackyrong.iteye.com/blog/2170222   One of the myisam engines in mysql is easy to ignore, called the compressed index PACK_KEYS, MyISAM uses prefix compression to reduce the index size. By default,

Enable phpmyadmin. The advanced function is not fully set. Some functions are not activated.     Q: How can I solve this problem if I enable phpmyadmin to display advanced functions that have not been fully set and some functions are not activated?

XtraBackup backup appears "Can't locate Digest/MD5.pm in @ INC", xtrabackupm5.pm   Xtrabackup 2.4.5 (innobackupex version 2.4.5 Linux (x86_64) (revision id: e41c0be) is installed on CentOS 7 )), the following error message "Can't locate