mysql杂记

 

配置本地连接文件：

# vim .my.cnf

[client]
user = 'xxx'
password = 'xxxxx'
host = 'localhost'

 

mysq学习心得

http://www.cnblogs.com/lyhabc/p/3691555.html

 

mysql体系结构

http://www.cnblogs.com/cjing2011/p/c46ebfb372476c625d5fbc23a56deb65.html

http://www.cnblogs.com/kumulinux/archive/2012/08/23/2808724.html

http://www.cnblogs.com/pythonal/p/6651120.html

http://www.cnblogs.com/chenmh/p/4914754.html

 

mysql系统表

http://www.cnblogs.com/loveling-0239/p/6414988.html

http://blog.sina.com.cn/s/blog_7a9735620102v03b.html

 

mysqladmin

http://www.cnblogs.com/qq78292959/p/3639384.html

http://www.cnblogs.com/kevingrace/p/6151066.html

http://www.cnblogs.com/sunmengbbm/p/5827605.html

 

数据类型

http://www.cnblogs.com/lyhabc/p/3697952.html

http://www.cnblogs.com/lteal/archive/2013/03/04/2943061.html

http://www.cnblogs.com/kissdodog/p/4159176.html

http://www.cnblogs.com/bukudekong/archive/2011/06/27/2091590.html

 

 

MYSQL权限

http://blog.csdn.net/mchdba/article/details/45934981

http://www.cnblogs.com/fslnet/p/3143344.html

http://www.cnblogs.com/Richardzhu/p/3318595.html

 

防止人为误操作

http://oldboy.blog.51cto.com/2561410/1321061/

 

自动提交对性能的影响

https://yq.aliyun.com/articles/43069

 

二进制日志

http://www.cnblogs.com/kerrycode/p/6610874.html

 

mysql事务和隔离级别

http://www.cnblogs.com/phpcoder/p/4440833.html

http://www.cnblogs.com/zhaoyl/p/4121010.html

http://www.cnblogs.com/JohnABC/p/3521061.html

http://www.cnblogs.com/zhoujinyi/p/3437475.html

 

MYSQL用户权限管理

http://www.cnblogs.com/4php/p/4113593.html

http://www.cnblogs.com/candle806/p/4048651.html

http://www.cnblogs.com/goodhacker/p/3373213.html

http://www.cnblogs.com/mengyuxin/p/4893820.html

http://www.cnblogs.com/wujuntian/p/5782279.html

http://www.cnblogs.com/lizhi221/p/6814303.html

 

MYSQL日志

http://www.cnblogs.com/lyhabc/p/3879163.html

http://www.cnblogs.com/wangkongming/p/3684950.html

http://www.cnblogs.com/ggjucheng/archive/2012/11/15/2771535.html

http://www.cnblogs.com/roverliang/p/6414457.html

http://www.cnblogs.com/kerrycode/p/5593204.html

 

MYSQL全局变量

https://wenku.baidu.com/view/75b21df1a300a6c30d229fc2.html

http://www.cnblogs.com/lenagt/archive/2012/06/06/2538227.html

http://blog.csdn.net/jiang1986829/article/details/47315807

http://www.cnblogs.com/signheart/p/6595394.html

 

MYSQL备份：

http://www.cnblogs.com/lyhabc/p/3842015.html

mysqldump:

http://www.cnblogs.com/feichexia/p/MysqlDataBackup.html

http://www.cnblogs.com/xuejie/archive/2013/01/11/2856911.html

 

 

mysql分库分表

http://wentao365.iteye.com/blog/1740874

http://www.cnblogs.com/try-better-tomorrow/p/4987620.html

http://blog.csdn.net/xiongping_/article/details/47082609

http://6226001001.blog.51cto.com/9243584/1726092

http://blog.chinaunix.net/uid-25979788-id-3270311.html

http://blog.csdn.net/lgslgs123456/article/details/51542085

http://www.cnblogs.com/loongqiang/p/4015888.html

 

MYSQL分区分表分库

http://gao-xianglong.iteye.com/blog/2019729/

http://www.cnblogs.com/freeton/p/4265228.html

http://blog.51yip.com/mysql/949.html

http://www.cnblogs.com/langtianya/p/4997768.html

https://my.oschina.net/u/37763/blog/609168

http://blog.csdn.net/zhanjianshinian/article/details/48733419

http://www.cnblogs.com/dinglang/p/6084306.html

http://blog.csdn.net/dinglang_2009/article/details/53195835

http://www.cnblogs.com/aigongsi/archive/2013/01/25/2875731.html

http://1028826685.iteye.com/blog/2309463

http://www.xuebuyuan.com/54022.html

http://www.blogjava.net/cenwenchu/archive/2011/12/07/365776.html

 

字段冗余

http://www.cnblogs.com/xswz/p/7041507.html

http://www.cnblogs.com/emilchan/archive/2009/11/22/1607891.html

http://www.cnblogs.com/manastudent/p/6629050.html

http://www.cnblogs.com/pyt5208/archive/2007/10/14/923943.html

 

 

 

全局变量

https://yq.aliyun.com/ziliao/69448

http://www.ttlsa.com/mysql/mysql_show_status_descriptsions/

http://kaifly.blog.51cto.com/3209616/1592080

http://blog.csdn.net/starnight_cbj/article/details/4492555

https://wenku.baidu.com/view/75b21df1a300a6c30d229fc2.html

https://wenku.baidu.com/view/289c200201f69e314232940a.html

http://blog.csdn.net/yang1982_0907/article/details/20123055

 

 

EXPLAIN:

http://www.cnblogs.com/zhanjindong/p/3439042.html

http://www.cnblogs.com/xuanzhi201111/p/4175635.html

http://www.cnblogs.com/xiaoboluo768/p/5400990.html

 

索引使用情况相关

http://www.cnblogs.com/wangchy0927/p/3301665.html

http://blog.csdn.net/chenyu_wswx/article/details/53704094

http://m.blog.csdn.net/qq_25551295/article/details/49428999

http://www.cnblogs.com/zengkefu/p/5685811.html