1. Concept of storage EngineThe storage engine (the storage engine can also be a table type) is actually how to store the data, how to index the stored data, how to update the data, and how to implement the technology. Data in MySQL is stored in
MySQL Master-slave configuration
MySQL Master-Slave introduction
Preparatory work
Configure the Primary
Configuration from
Test Master-Slave synchronization
MySQL Master-Slave introductionMySQL master-slave is also called
CREATE TABLE' Player ' (' ID ' )int( One) not NULLauto_increment, ' name 'Char( -) not NULL DEFAULT "'COMMENT'Site name', ' area 'varchar(255) not NULL DEFAULT "', ' Alexa 'int( One) not NULL DEFAULT '0'COMMENT'Alexa Rankings', ' team 'Char(Ten) not
/* time:2017.01.02--2017.01.04* AUTHOR:WJ* Function: Connect the database, read the picture from the database and display (succeeded)*/"Reference link"MySQL deposit image +QT read in the database read the picture-lpdpzc column-Blog channel-csdn.net
Show OPEN TABLES where In_use > 0; --Query whether the table is lockedShow Processlist; --Query to the corresponding process = = and then KillidSELECT * from Information_schema.innodb_trx; --all transactions that are currently runningSELECT * from
The syntax of a single-table querySELECT Field 1, Field 2 ... From table name WHERE condition GROUP by field have filter ORDER by field limit number of bars Second, the execution order of the
String functions (which are primarily used to process strings):Cancat (str1, str2, ... strn) connection string str1, str2 ..., strn as a string;Insert (str, x, Y, instr) starts the string str from position x, and the substring of Y strings is
The on DUPLICATE key update syntax is not a standard syntax for SQL, and if specified at the end of a sentence, it updates the contents of the database according to the specified primary key or uniquely labeled indexThe specific action is to see if
1, read UNCOMMITTED (row lock)Dirty reads occur, things are not committed and are seen by other things, and uncommitted data is dirty data.2. Read committed (Row lock)A non-repeatable read occurs, and when things start, only the things that have
First, the primary key index relationship1. Primary key: The only function of a primary key is to uniquely identify a row of data in the table. is divided into a single primary key and a federated primary key:Single PRIMARY key: You can uniquely
A view is a virtual table that does not actually store data and stores a "functional relationship."Grammar:CREATE VIEW name as SELECT statement.Why does a view store a function relationship?When referencing a view, it looks for related fields based
The knowledge of MySQL must be
Command line start mysql:mysql-u user name-p password
Show column details in the table: Show Columns form tablename equivalent to DESC tablename
View all Show commands: Help show
No sorting is used when
[Daily] mysql index usage test and mysql index test
1. index is a data structure that helps MySQL efficiently obtain data. It can be understood as "sorting the data structure in order", outside of the data, the database system also maintains data
InnoDB, MySAM, and mysqlinnodbmysam in mysqlFeatures of innoDB and MyISAM in mysql -- ENGINE = innodb
1. Provides transaction processing and supports row locks;
2. read without locking, increasing the number and space of concurrent reads;
3.
How RDS works-index of the query optimizer (translated from the Coding-Geek Article ),
This article is translated from the Coding-Geek article: How does a relational database work. Link: http://coding-geek.com/how-databases-work/#Buffer-Replacement_
MySQL view and mysql View
1. View: a virtual table, essentially a set of SQL statements.
-- A view is a virtual table.01. Partial data of a table or comprehensive data of multiple tables!02. The structure and data are based on queries to real tables!
MySQL Stored ProcedureA storage routine is a set of SQL statements stored on the database server. You can run these SQL statements by calling a specified name in the query.The SQL statement needs to be compiled and then executed, while the Stored
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
A Free Trial That Lets You Build Big!
Start building with 50+ products and up to 12 months usage for Elastic Compute Service