github 0 码力 |
22 页 |
1.01 MB
| 2 年前 3 # TiDB 2.1.7
Kyle Kingsbury
2019-06-12
TiDB is a distributed, auto-sharded SQL database based on Google's Percolator model. Despite promising snapshot isolation, TiDB 2.1.7 through 3.0.0-beta.1-40 thanks to two auto-retry mechanisms which blindly re-applied updates when a transaction conflicted. TiDB also supports a select ... for update statement which mostly, but not entirely, prevents write skew disabled, TiDB 2.1.8 through 3.0.0-beta.1-40 passed our tests for snapshot isolation and single-key linearizability. 3.0.0-rc.2, which disables auto-retry by default, also passes. Finally, TiDB has a theoretical 0 码力 |
9 页 |
141.29 KB
| 1 年前 3 ## TiDB and Amazon Aurora
Compare / Contrast / Combine
Ed Huang, CTO @ PingCAP
h@pingcap.com
PingCAP TiDB
TiDB Community Slack Channel https://pingcap.com/tidbslack/
## TiDB is not a database middleware
||Sharding middleware|TiDB|
|---|---|---|
|ACID Transaction Capacity (Good performance)|Few TBs|200 TB+|
## TiDB architecture
TiDB Server
## Storage Physical Stack
Highly layered 0 码力 |
57 页 |
2.52 MB
| 1 年前 3 1_1.jpg)
## Go in TiDB
## 申砾@PingCAP
## GopherChina 2017
## Agenda
• About Me
• What is TiDB
• TiDB Architecture
• SQL Layer Internal
• Golang in TiDB
• Next Step of TiDB
## GopherChina 2017 About Me
• Shen Li (申砾)
• Tech Lead of TiDB, VP of Engineering
• Netease / 360 / PingCAP
• Infrastructure software engineer
GopherChina 2017
## What is TiDB
A Distributed, Consistent, Scalable, SQL idx1: $(10, +\infty)$
GopherChina 2017
## Example - Distributed Physical Plan
Physical Plan on TiDB
Final Aggregate sum(count(c1))
DistSQL Scan
Physical Plan on TiKV
## 目录
致谢
README
TDB简介
TDB快速入门指南
TDB用户文档
TiDB数据库管理
TiDB服务
TiDB进程启动参数
TiDB系统数据库
TiDB系统变量
TiDB专用系统变量和语法
TiDB访问权限管理 TiDB访问权限管理
TiDB用户账户管理
使用加密连接
SQL优化
理解TiDB执行计划
统计信息
语言结构
字面值
数据库、表、索引、列和别名
关键字和保留字
用户变量
表达式语法
注释语法
字符集和时区
字符集支持
字符集配置
时区
数据类型
TiDB 事务隔离级别
错误码与故障诊断
与 MySQL 兼容性对比
TiDB 内存控制文档
Bit-value Literals
Boolean Literals
Date 和 Time 字面值
十六进制的字面值
NULL Values
数值字面值
字符串字面值
TiDB 用户文档 0 码力 |
444 页 |
4.89 MB
| 1 年前 3 ## TiDB 101
Fernando Ipar / Percona University Montevideo / April 2019
## Pythian
About me
•Internal Principal Consultant @ Pythian.
•Pager-carrying, buck stops at my team.
•OSDB Practice (MySQL/MariaDB 3/0/4/7/304714d8e786caf05d379f2d7654ca4f/p11_1.jpg)
### https://pingcap.com/tidb-academy/
## TiDB ACADEMY Welcome to TiDB Academy!
Log In / Sign Up
Please log in to view the courses.
I have certification 0 码力 |
13 页 |
2.59 MB
| 1 年前 3 ## TiDB Documentation
## PingCAP Inc
## 20240520
## Table of Contents
1 Docs Home 24
2 About TiDB 24
2.1 TiDB Introduction 24
2.1.1 Key features 24
2.1.2 Use cases 25
2.1 3 See also 26
2.2 TiDB 5.1 Release Notes 26
2.2.1 Compatibility changes 27
2.2.2 New features 37
2.2.3 Improvements 39
2.2.4 Bug Fixes 42
2.3 TiDB Features 45
2.3.1 Data Security 48
2.3.10 Data import and export 48
2.3.11 Management, observability, and tools 48
2.4 TiDB Experimental Features 49
2.4.1 Performance 49
2.4.2 Stability 49
2.4.3 Scheduling 49
2.4.4 0 码力 |
2745 页 |
47.65 MB
| 2 年前 3 ## TiDB Documentation
## PingCAP Inc
## 20240520
## Table of Contents
1 Docs Home 26
2 About TiDB 26
2.1 TiDB Introduction 26
2.1.1 Key features 26
2.1.2 Use cases 27
2.1 1.3 See also 28
2.2 TiDB 5.3 Release Notes 28
2.2.1 Compatibility changes 29
2.2.2 New features 42
2.2.3 Telemetry 47
2.2.4 Removed feature 47
2.2.5 Improvements 47
2 2.2.6 Bug Fixes 49
2.3 TiDB Features 53
2.3.1 Data types, functions, and operators 53
2.3.2 Indexing and constraints 53
2.3.3 SQL statements 54
2.3.4 Advanced SQL features 54 0 码力 |
2996 页 |
49.30 MB
| 2 年前 3 ## TiDB Documentation
## PingCAP Inc
## 20240520
## Table of Contents
1 Docs Home 25
2 About TiDB 25
2.1 TiDB Introduction 25
2.1.1 Key features 25
2.1.2 Use cases 26
2.1
2.2 TiDB 5.2 Release Notes 27
2.2.1 Compatibility changes 28
2.2.2 New features 36
2.2.3 Feature Enhancements 39
2.2.4 Improvements 40
2.2.5 Bug Fixes 41
2.3 TiDB Features 3.10 Data import and export ..... 47
2.3.11 Management, observability, and tools ..... 47
2.4 TiDB Experimental Features ..... 48
2.4.1 Performance ..... 48
2.4.2 Stability ..... 48
2.4.3 Scheduling 0 码力 |
2848 页 |
47.90 MB
| 2 年前 3
| 
Go in TiDB## Go in TiDB Yao Wei | PingCAP ## About me • Yao Wei (姚维) • TiDB Kernel Expert, General Manager of South Region, China • 360 Infra team / Alibaba-UC / PingCAP • Atlas/MySQL-Sniffer • Infrastructure complex than KV  ## Why TiDB choose Golang? • Easy-learning Productivity • Concurrency • Easy to trace bugs and profile • Standard libraries and tools • Tolerant GC latency • Good performance • Quick improvement ## Go in TiDB - More than 160K lines of Go code and 138 contributors.