基于消息中间件的学生登记系统.PPT

存储引擎和表 为表指定存储引擎 mysqlcreate table Student(s_id int,s_name varchar(20),sex int ,major_id int,age int,primary key(s_id)) ENGINE = innodb; 插入定制存储引擎 mysqlINSTALL PLUGIN my_school SONAME ha_school.so; 为表转换存储引擎 mysqlALTER TABLE student ENGINE = my_school; 拔出定制存储引擎 mysqlUNINSTALL PLUGIN my_school ; 索引 Hash索引 无序索引，适合单值查找。 B-tree索引 有序索引，适合有序范围查找。 Mysql5.1的新特性 Partition：对数据水平分片，支持大数据。 mysqlcreate table Chose_course(s_id int ,c_id int,grade int ,primary key (s_id,c_id)) partition by grade ( partition fail value less than (60), partition normal value less than (80), partition go