MySQL

B-TreeB-Tree, here is balance (balanced meaning), B-Tree is a multi-path self-balancing search tree It resembles a normal balanced binary tree, the difference is that the B-tree allows each node to have more child nodes. is a simplified map of

Category_search_name similar to the following0-123: Clothing Shoes and hats 0-123-137-202: Clothing shoes and hats-0-speed food-0 instant noodlesfirst-with the second-(the number between the:) is the first-level category ID (123)Substring_index

How to use locate and position functions in MySQL Find_in_set (Str,strlist)If the string str is in a string list strlist consisting of N substrings, the return value ranges from 1 to N. A list of strings is a string of self-chains that are

Horizontal partitioning of a tableIf a table has too many records, such as thousands, and needs to be retrieved frequently, then we need to piecemeal. If I break into 100 tables, then there are only 100,000 records for each table. Of course this

 http://blog.csdn.net/tonyxf121/article/details/8393545B+/-tree Principle B-tree Introduction B-tree is a multi-path search tree (not two-pronged):1. Definition of any non-leaf node up to only m sons; m>2;2. The number of sons of the root node is [2,

MySQL index creationI. What is an index?Indexes are used to quickly look for records with specific values, and all MySQL indexes are saved as B-trees. If there is no index, MySQL must start scanning all records of the entire table from the first

#一, enter MySQL from the terminalis different from MySQL under Windows. The MySQL installation path under Mac is different, so the operation will be slightly different;The following actions are premised on installing MySQL by default.# #一 (1): After

MySQL CONCAT (str1,str2,...)Returns the string that results from the connection parameter. If any one of the arguments is NULL, the return value is null. There may be one or more parameters. If all parameters are non-binary strings, the result is a

In a MySQL replication environment, we usually only judge the latency of the slave based on the value of the seconds_behind_master . This is acceptable in most cases, but is not accurate enough and should be considered for more factors.First, let's

#!/bin/bashUser=rootpasswd=123456Sock=/data/3306/mysql.socklogin= "Mysql-u$user-p$passwd-s $SOCK"Database= ' $LOGIN-e "show databases; | Sed ' 1d ' |egrep-v ". *schema|mysql" 'dump= "Mysqldump-u$user-p$passwd-s $SOCK"#cd/backup/mysql/For database in

Because the completion of the underground garage management system, so the intention to learn JSP development ~Today is mainly "new Web site project +mysql Link", the work done before in this article: Tomcat server configuration, MySQL database

A view is a virtual table that is guided from one or more tables. A view is like a window through which you can see the data that is specifically provided by the system.1. Introduction to view 1.1 What the view meansA view is a virtual table from

MySQL Database optimizationI. SQL and index optimizationHow do I find the problematic SQL?Use the MySQL slow query log to monitor efficiency issues with SQLTo see if the slow query log is turned onShow variables like ' Slow_query_log '650)

For two development, a large part of the search for files and the change of databasefor database changes. has not found the more useful monitoring database change monitoring software.Today, I'll show you how to monitor database changes using MySQL's

Mysql performance optimization 3 (Table sharding, Incremental backup, and restoration), mysql Performance OptimizationHorizontal table Division If a table contains too many records, for example, tens of millions of records and needs to be searched

Mysql logon ERROR message: ERROR 1045 (28000) solution, 104528000 This article analyzes the solution to the mysql logon ERROR: ERROR 1045 (28000. We will share this with you for your reference. The details are as follows: I. Problems: The root user

Plugin 'federated 'is disabled or 1067 error startup error and "service mysql unexpectedly stopped" solution, federated1067 MYSQL startup reports a 1067 error. In the system log "service mysql unexpectedly stopped", the Mysql Log is: "Plugin

Mysql High Availability LVS + KEEPALIVE + MYSQL, lvskeepalive1. Architecture Diagram    Note: (1) Mysql needs to remove the bind-address Configuration; otherwise, virtual ip access cannot be implemented. (2) Disable all linux

Summary of MySql5.7.11 compiling and installing and modifying the root password, mysql5.7.11root Recommended reading: Mysql5.7 how to forget the root password and mysql5.7 how to change the root password How to install and uninstall Mysql5.7.11 on

MySQL startup Principle Analysis, mysql Principle AnalysisIntroduction This article focuses on viewing the MySQL startup command code to learn more about the MySQL startup process. It is important to understand the MySQL startup principle and be