MySQL

Original: MySQL Partitioning technologyThere are two main types of optimizations for massive data:the way of large table splitting table; optimization of SQL statements Partitioning Technology:similar to horizontal segmentation, but it is a

I. About slow query setup and analysisFind Slow Query parameters' long% ' ; +-----------------+----------+| Variable_name | Value 10.000000 |+-----------------+----------+Mysql> Show variables like ' slow% '; +---------------------+-------------

programme I:(Traditional programme)Backup +binlog log increment;Scenario Two:(for UPDATE, DELETE statement forget where the case)The Binlog log file holds two sets of data before and after the error operation, and modifies the data before the error

Use the following function to make a fuzzy query, if the occurrence of the position >0, indicates that the string is contained.Query efficiency is higher than like.Such as:Table.field like '%aaa% ' can be changed to locate (' AAA ', Table.field) > 0

Data query one, single-table query 1, inSelectstatement, use the*"indicates that all fields are queriedFirst of all:Create a table because the testCREATE TABLE student (ID int primary KEY not null,name varchar (), sex varchar (4), class varchar (10))

MySQL's key and index are somewhat confusing, which actually examines the understanding of the database architecture. 1 key is the physical structure of the database, it contains two layers of meaning, one is the constraint (which is biased to the

InstallationInstall MySQLInstall MySQL Needless to say, download the installation is, there is no special need to pay attention to the place.One: Click to open the link"Examples"? 123456789101112131415161718192021222324252627282930313233

Linux Environment: CentOS 6.5MySQL version: 5.5.20, attached: "Click to download"1, installation CMakeMySQL has been removed from version 5.5, and is replaced by the CMake tool./configure.Therefore, we first need to compile and install the CMake

Work with statistics December call records, statistics number dialed number, but the problem in a number can be dialed multiple times, each may or may not be connected, if the call Number Caller field group by group COUNT (*) after the number of

The Date_format () function is used to display date/time data in different formats.GrammarDate_format (Date,format) The date parameter is a valid day. format Specifies the date/time in which the output is formatted.The formats you can use are:

Create a Custom Function:1 DELIMITER $$2 3 Use ' dressv_website ' $$4 5 DROP FUNCTION IF EXISTS ' fn_queryrelation ' $$6 7CREATE definer= ' sa ' @ '% ' FUNCTION ' fn_queryrelation ' (Areaid int,relation TINYINT (1)) RETURNS VARCHAR (4000) CHARSET

1. Create a stored procedure1 Create procedure Proc_name () 2 begin 3 SQL; 4 EndSQL executes the code at a fixed value, for example, inserting the current time into the table: INSERT INTO Table VALUES (now ()), and then execute the stored procedure

today started to install MySQL, originally to the official website to download the installation package to install, but after installation but can not use, is expected to configure it, search the Internet very much information, the result or failure.

Mysql> show Processlist;Mysql> Show status;Mysql> Show status like ' Slow_queries ';Mysql> Show status like ' threads_created ';Mysql> show engine InnoDB status\g;Mysql> show global status like ' table_locks% ';Mysql> Show status like '%lock% ';=====

1. Create a tableCREATE TABLE Table name (ID int unsigned NOT NULL Auto_increment primary key,Field column type NOT null default ' ',......Field column type NOT null default ' ') engine MyISAM charset UTF8;2. Modify the tableAdd Columns:ALTER TABLE

How to Set pseudo-static rules through web. config in IIS 7.5 In is7.5, common programs use web. config to create a pseudo-static file named after web. config. Remember to enable the pseudo-static feature in the background. The following is an

Website bottleneck analysis-MYSQL performance analysis, website bottleneck mysql Performance 1. Slow query settings and Analysis Search for slow query parameters mysql> show variables like 'long%';+-----------------+----------+| Variable_name |

In Linux, how does one solve the #1036-Table ''is read only error in MySql, This article is for Reprinted content. Thanks to the original author. From: http://zhaoxiaoru39.blog.163.com/blog/static/609552192012511104730115/ 　The problem I encountered

MySQL Data TypeText CHAR (*): a fixed-length string of up to 255 bytes. Its length must be specified at creation.VARCHAR (*): a variable-length string of up to 255 bytes. Its length must be specified at creation.TEXT: variable-length TEXT with a

Install and use mysqlIn OJ, mysql is mainly used to store user information. It is easy to install and use. The following is a brief introduction. First, I will explain that my Linux branch environment is Ubuntu 12.04, and the general steps of other