[5]Mysql
hjw199089
从事大数据
(1)查询引擎开发-presto深度开发-hive开发-自研查询引擎开发
(2)大数据用户行为分析
(3)spark、sparkstreaming、storm、druid开发应用经验
(4)数据仓库开发
展开
-
mysql索引(mysql 索引类型以及创建)
点击打开链接点击打开链接转自:http://blog.csdn.net/xluren/article/details/32746183http://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 · 1658 阅读 · 0 评论 -
ch6 Optimize Data Access
chapter 6 Query Performance OptimizationOptimize Data AccessSlow Query Basics: Optimize Data AccessWe’ve found it useful to analyze a poorly performing query in two steps:Find out whether your ap...翻译 2018-12-01 22:12:41 · 163 阅读 · 0 评论 -
ch6 Ways to Restructure Queries
High.Performance.MySQL 读书笔记chapter 6 Query Performance OptimizationWays to Restructure QueriesWays to Restructure QueriesAs 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 · 472 阅读 · 0 评论 -
MySQL Window Functions
原文:MySQL Window FunctionsSummary: 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 评论