sunbains Profile Banner
Sunny Bains @TiDB Profile
Sunny Bains @TiDB

@sunbains

Followers
5K
Following
3K
Media
127
Statuses
4K

swe@PingCAP - The company behind TiDB. Oracle/MySQL/InnoDB team lead in a past life

California, USA
Joined April 2012
Don't wanna be here? Send us removal request.
@sunbains
Sunny Bains @TiDB
6 hours
RT @PingCAP: Excited to host Sanjay Mishra, Dir. of Product Mgmt @Google AlloyDB, at #TiDBSCaiLE 2025! ⚡️. 📍 Scaling Real-World GenAI: Less….
0
2
0
@sunbains
Sunny Bains @TiDB
1 day
My hobby project woes come from my lack of understanding the Folios and the relevant details around it in the Linux kernel. I found a good talk by the author, worth watching:.
0
1
20
@grok
Grok
1 day
Join millions who have switched to Grok.
96
177
1K
@sunbains
Sunny Bains @TiDB
2 days
Finally, I've reached a stage where I'm crashing it all the time due to my incompetence at this :-). Switched to a VM model and it's a lot easier than waiting for 10mins for the server to boot.
@sunbains
Sunny Bains @TiDB
6 days
The Linux kernel has become quite resilient, working on the Ubuntu kernel v6.8.0 variant. My hacking (figuring out) on a custom driver and kernel module shows all kind of error messages in the logs , page faults, RCU invariant violations etc. I've had to reboot only twice so.
0
0
11
@sunbains
Sunny Bains @TiDB
6 days
The Linux kernel has become quite resilient, working on the Ubuntu kernel v6.8.0 variant. My hacking (figuring out) on a custom driver and kernel module shows all kind of error messages in the logs , page faults, RCU invariant violations etc. I've had to reboot only twice so.
2
0
19
@sunbains
Sunny Bains @TiDB
7 days
Setting up the build system to write a kernel module or driver has become quite easy with these new LLM tools. The last time I tried this by scouring the Internet it took forever.
0
0
13
@sunbains
Sunny Bains @TiDB
7 days
RT @PingCAP: 🌍 Can’t make it to TiDB SCaiLE 2025 in person? We’ve got you covered. Registration is NOW OPEN for online attendance! Join u….
0
1
0
@sunbains
Sunny Bains @TiDB
8 days
ALRs (Almost Local Reads) essentially optimize batching by making the remote coordination cost independent of batch size, the core insight doesn’t seem to be revolutionary AFAIU. Their evaluation demonstrates that the technique works but is limited to specific protocol classes.
1
1
6
@sunbains
Sunny Bains @TiDB
8 days
A theorem called LAW, not CAP, has been proposed. - Linearizable (linearizability, consistency).- Local Reads (local reads or high-cost reads).- Asynchronous.Until now, only two of these could be satisfied. LS is synchronous replication, RA is Raft, etc. RC seems to correspond to.
@tzkb
こば -Koba as a DB engineer-
8 days
CAPではなくLAWという定理が提案されてるんだ。.- Linearizable(線形化可���性、一貫性).- Local Reads(ローカル読み取りか、高コスト読み取り).- Asynchronous.のうち、2つしかこれまで満たせなかった。LSが同期レプリケーション、RAがRaftなど。RCはeventualに相当しそう。.
1
11
72
@sunbains
Sunny Bains @TiDB
9 days
IIRC, this paper advocates tiered storage of LSM data, where WAL, L0 and L1 go on the fastest storage and the lower levels on something like S3. Writers need to respect device limits. I think the more important observation is context driven IO. Pass LSM operation type (flush,.
@pvldb
PVLDB
10 days
Vol:18 No:9 → Keigo: Co-designing Log-Structured Merge Key-Value Stores with a Non-Volatile, Concurrency-aware Storage Hierarchy
Tweet media one
0
2
26
@sunbains
Sunny Bains @TiDB
9 days
August 25 (Mon) - 26 (Tue) ✨ #WebX ✨🌐 Asia's largest global conference, held again this year 🌈 We look forward to welcoming you at exhibition booth G-94 😀 Please check out #TiDB as a high-performance and highly available data infrastructure in the Web3 domain 🚀.
@PingCAP_Japan
PingCAP Japan
9 days
8月25日 (月)〜26日 (火)✨ #WebX ✨🌐アジア最大級のグローバルカンファレンス、今年も開催🌈 展示ブースG-94で皆様のご来場をお待ちしています😀Web3領域における高性能かつ高可用なデータ基盤としての #TiDB ぜひチェックしてみてください🚀
Tweet media one
0
0
1
@sunbains
Sunny Bains @TiDB
9 days
Does it make sense to write a database focused VM that can support multi-tenancy?.
6
0
38
@sunbains
Sunny Bains @TiDB
14 days
Really like the SQLite Vtable functionality, was able to map an API to SQL quite easily.
0
0
10
@sunbains
Sunny Bains @TiDB
15 days
Divide et impera - the strategy for all problems.
0
1
8
@sunbains
Sunny Bains @TiDB
17 days
The happy path in distributed systems, with no concern for latency and handling errors is fairly straight forward.
1
0
10
@sunbains
Sunny Bains @TiDB
20 days
Google translate does a decent job of Yasufumi’s blog post talking about some performance tests.
0
2
8
@sunbains
Sunny Bains @TiDB
20 days
Yasufumi Kinoshita one of the top MySQL engineers left MySQL/InnoDB in May and is working on a fork where he is focusing on performance. I have huge respect for his talent and skills, expecting some solid changes. AFAIK, he is also the original author of Percona’s XtraBackup and.
1
12
114
@sunbains
Sunny Bains @TiDB
20 days
RT @ngaut1: TiDB at Flipkart: Managing Data at E-Commerce Scale via @YouTube.
0
1
0
@sunbains
Sunny Bains @TiDB
21 days
Database are sticky, gaining trust is difficult.
@penberg
Pekka Enberg
22 days
This is an interesting point! Years of work actually guarantees very little, as we’ve seen with things like fsync() gate or Meltdown bugs! We as infrastructure developers need to build systems that are both fast and safe because users wont be able to make an informed decision!.
2
1
26
@sunbains
Sunny Bains @TiDB
27 days
"in practice the users try and a consistent load" -> "in practice the users try and maintain a consistent load".
0
0
2
@sunbains
Sunny Bains @TiDB
27 days
At cursory read it should help in making it dynamic, currently in TiDB the DBA has to do static modeling (well almost) there is a calibrate feature that helps with the allocation of RUs based on historic data because in practice the users try and a consistent load on the DB. I.
1
0
1