Slide 1
MySQL2013 7
136 6166 8096jinguanding@hotpu.cn1
DML DDL #
MySQL
#
MySQL 5.0MySQL3.X MySQL4.X MySQL5.0.X MySQL5.1.X+Build-in InnoDB MySQL5.1.X+Plug-in InnoDB MySQL5.5.X MySQL5.6.X MySQL Cluster 6.2.X MySQL Cluster 6.3.X MySQL Cluster 7.0.X MySQL Cluster 7.1.X MySQL Cluster 7.2.X MySQL Cluster 7.3.X#
18 1-2 MySQL5.5.31 MySQL5.5.31BUG MySQL5.5.32BUG MySQL5.5.30BUG#
MySQL MySQL #
DML DDL #
IOIO CPUIO #
DML DDL #
10 5 2+ + + mysqldump xtrabackup InnoDB hot backup#
DML DDL # DML
INSERT UPDATE DELETE# DML
INSERT INSERT INTO VALUES(),(),().
LOAD DATA .
INSERT SELECT # DML
UPDATE SELECT # DML
DELETE +UPDATE 2+ 3 DELETE #
DML DDL # DDL
InnoDB DDL# DDL
:ALTER TABLE tmp_test ADD COLUMN gmt_CreateDate TIMESTAMP NOT NULL DEFAULT 0000-00-00 00:00:00;ALTER TABLE tmp_test ADD COLUMN age TINYINT UNSIGNED NOT NULL DEFAULT 0 FIRST;
ALTER TABLE tmp_test ADD COLUMN age TINYINT UNSIGNED NOT NULL DEFAULT 0;# DDL
NOT NULL NULL ALTER TABLE tmp_test ADD COLUMN age TINYINT UNSIGNED NOT NULL DEFAULT 0;ALTER TABLE tmp_test ADD COLUMN gmt_CreateDate TIMESTAMP NOT NULL DEFAULT 0000-00-00;ALTER TABLE tmp_test ADD COLUMN age TINYINT UNSIGNED NOT NULL DEFAULT 0,ADD COLUMN gmt_CreateDate TIMESTAMP NOT NULL DEFAULT '0000-00-00';# DDL
InnoDB
# DDL
DDL DDL MyISAMInnoDB #***.frm#***.MYD#***.MYI, #***.frm#***.ibd RENAME # DDL
DDL SESSION SESSIONsort_buffer_size DDL SESSIONread_buffer_size SESSIONtmp_table_size max_heap_table_size InnoDBMyISAM key_buffer_size# DDL
DROP TABLE # DDL
SESSION.sql_log_bin=0 DDL SESSION.sql_log_bin=0 DDL #
DML DDL #
#
#
MySQL POC MySQL MySQL MySQL MySQL #
2003-2006 SQL Server 2005- MySQL 2008-20103000 2010-2012 30 2012--U-Cloud DaaS MySQLMySQL 50 5000 CTO#
# 2011427
31