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 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
## 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 ## TiDB 中文技术 文档
书栈(BookStack.CN)
## 目录
致谢
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 原理与实战
## About me
● 程序媛, TiDB committer, Go 语言狂热粉
☐ 主要研究方向为分布式系统，坚信分布式系统才是未来
● 目前在 PingCAP 就职
☐ 15 年中旬加入 PingCAP
☐ 主要参与模块为 TiDB 的 online DDL, SQL 优化器, 各种必要的功能改进以及性能提升
之前在京东就职
☐ 12 年末入职，学习 lixia@pingcap.com
○ GitHub: https://github.com/zimulala
## Agenda
• A brief introduction of NewSQL
• TiDB
• Plan optimization
• Dist SQL
• Online DDL
• TiKV
• Feelings
• Q & A
## A brief introduction Google F1
TiDB
## TiDB and TiKV
MySQL Client
MySQL Client
MySQL Client
MySQL Client
MySQL Client
MySQL Client
MySQL Protocol
MySQL Protocol
MySQL Protocol
TiDB
TiDB
TiDB
SQL Layer
TiDB SQL Layer 0 码力 |
23 页 |
496.41 KB
| 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.
20240415
## Table of Contents
# 1 Docs Home 34
# 2 About TiDB 34
2.1 TiDB Introduction 34
2.1.1 Key features 34
2.1.2 Use cases 35
2.1.3 See also 36
2.2 TiDB 2.4 Deprecated features 63
2.2.5 Improvements 64
2.2.6 Bug fixes 65
2.2.7 Contributors 71
2.3 TiDB Features 72
2.3.1 Data types, functions, and operators 73
2.3.2 Indexing and constraints 73
2.3 Compatibility ··· 88
2.4.1 Unsupported features ··· 88
2.4.2 Differences from MySQL ··· 89
2.5 TiDB Limitations ··· 95
2.5.1 Limitations on identifier length ··· 95
2.5.2 Limitations on the total 0 码力 |
6123 页 |
107.24 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.