TiDB: HBase分布式事务与SQL实现## TiDB: HBase分布式事务与SQL实现 ## About me • TiDB & Codis founder • Golang expert • Distributed database developer • Currently, CEO and co-founder of PingCAP liuqi@pingcap.com https://github.com/pingcap/tidb What did they say? “Nothing is hotter than SQL-on-Hadoop, and now SQL-on-HBase is fast approaching equal hotness status” Form HBaseCon 2015 We want more! SQL + Transaction(ACID) ## TiDB Features ## • MySQL-client MySQL-client Load Balancer MySQL Protocol Server MySQL Protocol Server TiDB SQL Layer TiDB SQL Layer Transactional KV Storage KV KV KV KV ### AH. HBase • First things first ☐ Need0 码力 | 34 页 | 526.15 KB | 2 年前3- The SQL Handbook## SQL HANDBOOK # Table of Contents Preface The SQL Handbook Conclusion ## Preface The SQL Handbook follows the 80/20 rule: learn in 20% of the time the 80% of a topic. In particular, the goal is is to get you up to speed quickly with SQL. This book is written by Flavio. I publish programming tutorials on my blog flaviocopes.com and I organize a yearly bootcamp at bootcamp.dev. You can reach me ## The SQL Handbook • 1. Information systems, data and information • 2. What is a Database? And a DBMS? • 3. Do you always need a database? • 4. Relational Databases • 5. Introduction to SQL • 6.0 码力 | 26 页 | 440.71 KB | 2 年前3
- 分布式NewSQL数据库TiDB# 分布式NewSQL数据库 TiDB 产品文档 优刻得科技股份有限公司 版权所有 ## 目录 目录 2 概览 9 什么是TiDB 11 产品优势 12 高度兼容 MySQL 12 动态扩展 12 分布式事务 12 HTAP 12 真正金融级高可用 13 适用场景 14 对数据一致性及高可靠、 加个联合索引会锁表吗 117 Q11: TiDB默认时区 117 Q12: 查看TiDB创建索引的过程是否已经结束 118 Q13: TiDB 最大连接数 118 Q14: SQL执行时间突然变长 118 Q15: 如何通过tableID 查找表名 118 Q16: 如何查看当前版本 118 Q17: 如何查看慢查询 119 Q18: 监控图看有慢查询，但是 创建同步任务或同步到 MySQL 时遇到 Error 1298: Unknown or incorrect time zone: 'UTC' 错误？ 119 Q20: TiDB 数据库报错 ERROR 1105 (HY000): Out Of Memory Quota处理方法 ## 概览 - 产品简介 - 什么是TiDB - 产品优势 - 适用场景0 码力 | 120 页 | 7.42 MB | 1 年前3
- MYBATIS Dynamic SQLhttp://www.tutorialspoint.com/mybatis/mybatis_dynamic_sql.htm Copyright $ © $ tutorialspoint.com Dynamic SQL is a very powerful feature of MyBatis. It enables programmers to build queries based on write the query using the dynamic SQL. MyBatis uses a powerful Dynamic SQL language that can be used within any mapped SQL statement. Following are the OGNL based Dynamic SQL expressions provided by MyBatis otherwise • trim where, set • foreach ## The if Statement The most common thing to do in dynamic SQL is conditionally include a part of a where clause. For example –
共 1000 条
- 1
- 2
- 3
- 4
- 5
- 6
- 100