Skip to content

Instantly share code, notes, and snippets.

dongxu c4pt0r

Block or report user

Report or block c4pt0r

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@c4pt0r
c4pt0r / result
Created May 26, 2019
TiDB vs Aurora on TPCH10
View result
TiDB Aurora With FK Aurora Without FK
Q1 15.28 144 144.13
Q2 4.09 4.18 4.21
Q3 4.93 20.59 34.18
Q4 2.3 7.5 7.49
Q5 19.44 18.25 22.43
Q6 5.96 21.74 21.94
Q7 8.42 12.06 81.83
Q8 3.49 41.7 53.99
Q9 34.71 33.7 442.26
@c4pt0r
c4pt0r / tpcc.conf
Created May 26, 2019
tpcc configuration for TiDB
View tpcc.conf
db=mysql
driver=com.mysql.jdbc.Driver
conn=jdbc:mysql://0.0.0.0:6000/tpcc?useSSL=false&useServerPrepStmts=true&useConfigs=maxPerformance&rewriteBatchedStatements=false&callableStmtCacheSize=1000&prepStmtCacheSize=1000&sessionVariables=tidb_batch_commit=1
user=root
password=
warehouses=1000
loadWorkers=32
terminals=500
@c4pt0r
c4pt0r / tikv.toml.patch
Created May 26, 2019
tikv config for sysbench
View tikv.toml.patch
diff --git a/conf/tidb.yml b/conf/tidb.yml
index d7e1d23..6e15aab 100644
--- a/conf/tidb.yml
+++ b/conf/tidb.yml
@@ -42,7 +42,7 @@ global:
log:
# Log level: debug, info, warn, error, fatal.
- # level: "info"
+ level: "error"
View task-aurora.yaml
name: test
task-mode: all
is-sharding: false
meta-schema: "dm_meta"
remove-meta: false
enable-heartbeat: false
ignore-checking-items: ["dump_privilege", "replication_privilege"]
target-database:
host: ""
View gist:1be3c9ef6f23b13d53c824cc8a0fa917
{
"comment": "",
"ignore": "test",
"package": [
{
"checksumSHA1": "2sLgks1Fi3Dek1svURoHiI95gAw=",
"origin": "github.com/pingcap/tidb/vendor/github.com/BurntSushi/toml",
"path": "github.com/BurntSushi/toml",
"revision": "418cdf2308c8ebedadbf356142f9afbab9aea111",
"revisionTime": "2018-09-03T23:56:42Z"
@c4pt0r
c4pt0r / benchseek.go
Last active Jan 10, 2018
A simple demo of TiKV's prefix seek API
View benchseek.go
// A simple demo of TiKV's prefix seek API
/*
$./benchseek
INFO[0000] [pd] create pd client with endpoints [localhost:2379]
INFO[0000] [pd] leader switches to: http://127.0.0.1:2379, previous:
INFO[0000] [pd] init cluster id 6508961674812833664
hello_1
hello_2
hello_3
@c4pt0r
c4pt0r / dlock.go
Created Mar 19, 2017
simple distributed lock using TiKV
View dlock.go
package main
import (
"encoding/json"
"errors"
"flag"
"fmt"
"math/rand"
"time"
View gist:a708ef694cb65635312e06a705333a9b
2016 数据库圈盘点
我简单说一下今年我觉得印象比较深刻的几个事情:
1. Facebook 和 Percona 合作 MyRocks 正式进入市场
2. MySQL Group Replication 发布, 基于选举的 Replication 方案正式进场
3. Hive 2.0 的发布,新的 feature 和性能提升让我蛮惊艳的
4. RethinkDB 的落幕
5. CockacheDB 、 TiDB 这类的 NewSQL 在社区展露头角
6. SycallaDB 的发布,让我看到了性能提升上的一些新的思路
View compression.h
inline bool Zlib_Compress(const CompressionOptions& opts,
uint32_t compress_format_version, const char* input,
size_t length, ::std::string* output,
const Slice& compression_dict = Slice()) {
#ifdef ZLIB
if (length > std::numeric_limits<uint32_t>::max()) {
// Can't compress more than 4GB
return false;
}
@c4pt0r
c4pt0r / coisf.md
Last active Nov 20, 2016
coisf - 中国开源基础软件基金会
View coisf.md

##章程


使命 (Mission)

China Open Infrastructure Software Foundation,以下简称 COISF 或 COI,致力于促进和发展中国的新一代开源基础软件, COISF 的使命是:促进中国下一代开源互联网基础软件生态系统的发展。

新一代的开源基础设施需要具备以下的条件:

  1. Scale:面向云和更大规模的分布式系统设计,系统高度自治和自动化。
You can’t perform that action at this time.