![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
[5]Mysql
hjw199089
从事大数据
(1)查询引擎开发-presto深度开发-hive开发-自研查询引擎开发
(2)大数据用户行为分析
(3)spark、sparkstreaming、storm、druid开发应用经验
(4)数据仓库开发
展开
-
mysql索引(mysql 索引类型以及创建)
点击打开链接 点击打开链接 转自: http://blog.csdn.net/xluren/article/details/32746183 http://feiyan.info/16.html 关于MySQL索引的好处,如果正确合理设计并且使用索引的MySQL是一辆兰博基尼的话,那么没有设计和使用索引的MySQL就是一个人力三轮车。对于没有索引的表,单表查询可能几十转载 2017-01-12 13:45:49 · 276 阅读 · 0 评论 -
Mac安装Mysql_解决中文乱码_JDBC访问操作
mac安装mysql的两种方法(含配置)原创 2017-07-27 10:25:10 · 1657 阅读 · 0 评论 -
ch6 Optimize Data Access
chapter 6 Query Performance Optimization Optimize Data Access Slow Query Basics: Optimize Data Access We’ve found it useful to analyze a poorly performing query in two steps: Find out whether your ap...翻译 2018-12-01 22:12:41 · 162 阅读 · 0 评论 -
ch6 Ways to Restructure Queries
High.Performance.MySQL 读书笔记 chapter 6 Query Performance Optimization Ways to Restructure Queries Ways to Restructure Queries As you optimize problematic queries,You can sometimes transform queries int...翻译 2018-12-01 22:48:13 · 158 阅读 · 0 评论 -
MySQL storage engine
MySQL storage engine说明文档 MySQL中存储engine决定了表的类型(Storage engines are MySQL components that handle the SQL operations for different table types),具体体现在以下特性的支持度: 存储机制、外键、索引技巧、锁定水平、事物支持(Transactions)、XA、S...原创 2019-02-18 12:53:01 · 471 阅读 · 0 评论 -
MySQL Window Functions
原文:MySQL Window Functions Summary: in this tutorial, you will learn about the MySQL window functions and their useful applications in solving analytical query challenges. MySQL has supported window ...转载 2019-04-29 18:14:01 · 518 阅读 · 0 评论