[size=large][color=red][b]MySQL半同步复制配置[/b][/color][/size]
[url]http://blog.csdn.net/lichangzai/article/details/50554057[/url]
[size=large][color=red][b]mysql索引详解[/b][/color][/size]
[url]http://www.cnblogs.com/ggjucheng/archive/2012/11/04/2754128.html[/url]
参考:[url]https://www.cnblogs.com/luyucheng/p/6289714.html[/url]
[size=large][color=red][b]MySQL数据库备份还原(基于binlog的增量备份)[/b][/color][/size]
[url]https://www.cnblogs.com/luoyx/p/5896419.html[/url]
[size=large][color=red][b]MYSQL增量备份(日志备份)[/b][/color][/size]
[url]https://www.cnblogs.com/AndyBian58/articles/6694013.html[/url]
[size=large][color=red][b]mysql数据库的完整备份、差异备份、增量备份[/b][/color][/size]
[url]http://blog.csdn.net/zmcyu/article/details/75353245[/url]
[size=large][color=red][b]MySQL全文索引 FULLTEXT索引和like的区别[/b][/color][/size]
[url]https://www.cnblogs.com/guifanbiji/p/6202195.html[/url]
[size=large][color=red][b]MySQL索引类型[/b][/color][/size]
[url]https://www.cnblogs.com/luyucheng/p/6289714.html[/url]
[size=large][color=red][b]mysql中explain用法和结果的含义[/b][/color][/size]
[url]http://blog.csdn.net/u010061060/article/details/52473244[/url]
[url]http://blog.csdn.net/jathamj/article/details/53909614[/url]
[url]http://blog.csdn.net/lichangzai/article/details/50554057[/url]
[size=large][color=red][b]mysql索引详解[/b][/color][/size]
[url]http://www.cnblogs.com/ggjucheng/archive/2012/11/04/2754128.html[/url]
--直接创建索引
CREATE INDEX IDX_GROUP_NAME ON base_group(GROUP_NAME);
或
CREATE INDEX IDX_GROUP_NAME ON base_group(GROUP_NAME(50));
--修改表结构的方式添加索引
ALTER TABLE base_group ADD INDEX IDX_GROUP_NAME(GROUP_NAME);
或
ALTER TABLE base_group ADD INDEX IDX_GROUP_NAME(GROUP_NAME(50));
--创建表的时间指定索引
CREATE TABLE `base_group` (
`id` int(11) NOT NULL AUTO_INCREMENT ,
`group_name` varchar(255) NOT NULL ,
`content` text NULL ,
`time` int(10) NULL DEFAULT NULL ,
PRIMARY KEY (`id`),
INDEX index_name (group_name(50))
)
--删除索引
DROP INDEX IDX_GROUP_NAME ON base_group;
参考:[url]https://www.cnblogs.com/luyucheng/p/6289714.html[/url]
[size=large][color=red][b]MySQL数据库备份还原(基于binlog的增量备份)[/b][/color][/size]
[url]https://www.cnblogs.com/luoyx/p/5896419.html[/url]
[size=large][color=red][b]MYSQL增量备份(日志备份)[/b][/color][/size]
[url]https://www.cnblogs.com/AndyBian58/articles/6694013.html[/url]
[size=large][color=red][b]mysql数据库的完整备份、差异备份、增量备份[/b][/color][/size]
[url]http://blog.csdn.net/zmcyu/article/details/75353245[/url]
[size=large][color=red][b]MySQL全文索引 FULLTEXT索引和like的区别[/b][/color][/size]
[url]https://www.cnblogs.com/guifanbiji/p/6202195.html[/url]
[size=large][color=red][b]MySQL索引类型[/b][/color][/size]
[url]https://www.cnblogs.com/luyucheng/p/6289714.html[/url]
[size=large][color=red][b]mysql中explain用法和结果的含义[/b][/color][/size]
[url]http://blog.csdn.net/u010061060/article/details/52473244[/url]
[url]http://blog.csdn.net/jathamj/article/details/53909614[/url]