mysql数据库运维要求_MySQL 数据库运维管理基础知识

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