Sunny Bains @TiDB (@sunbains) 's Twitter Profile
Sunny Bains @TiDB

@sunbains

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

ID: 551616645

linkhttps://wp.bains.org/ calendar_today12-04-2012 03:28:34

3,3K Tweet

4,4K Followers

266 Following

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

The long-awaited full-text search feature has finally been released for TiDB Cloud Serverless! (Although it is still available in limited regions.)

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

I was surprised by the 5K lines part. The 5K lines are just for running a single process for a single user. The IO is handled by dedicated Linux nodes. The messy part of an OS is scheduling and IO.

Ittai Abraham (@ittaia) 's Twitter Profile Photo

How do you reason about your system's correctness? Decentralized thoughts by Heidi Howard on how to reason about the correctness of real distributed systems decentralizedthoughts.github.io/2025-05-23-sma…

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

Had a technical discussion over lunch in Jakarta, ended up using cutlery, eg., the glass represented S3 , to describe the new TiDB architecture 🙂. Great discussion.

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

Snowflake Unistore was announced with great fanfare 3 years ago. Did the project fail and so they had to acquihire a team to run regular Postgres?

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

TiDB uses Jepsen among many other tests. It has helped uncover many bugs in TiDB, this time the QA team found a bug in the connector used by Jepsen: The PR is here: github.com/pingcap/jepsen… The problem in the connector is here. github.com/clojure/java.j…

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

While discussing TiFlash, its MPP mode came up in the discussion, I had a high level view that it supports Broadcast Hash Join, Shuffled Hash Join etc. I decided to play around with it, to learn more, and found this page very useful: docs.pingcap.com/tidb/stable/us…

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

Started serious coding after a month or so, Cursor seems to have gotten better at some mundane things like code formatting and fixing comments.

Yu Dong (@jerrydongusa) 's Twitter Profile Photo

In the latest episode of #DataintheHallway, we chat with Kabilesh P.R. (Founding Partner at Mydbops) about what’s fueling #TiDB’s growth across India. 🇮🇳 🎧 Tune in to the full episode: youtu.be/W7tx50V6b2U #Mydbops #IndiaTech #Database #Data #MySQL

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

Add column is instant in most databases these days, one thing that cannot be made instant is create index. Nothing comes close to TiDB AFAIK, 40T table add index 50 minutes.

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

I'm not a big fan of too many tuning knobs in software, this is a case where an obscure RocksDB parameter was used to improve performance 100x for some use cases. pingcap.com/blog/tikv-writ…

Sunny Bains @TiDB (@sunbains) 's Twitter Profile Photo

Interesting variation, wonder how if it will work well on write heavy and NUMA architectures? Seems to be optimized for low contention and read heavy loads.