Skip to content
Yisheng's blog

Yisheng's blog

software engineering, poetry and short stories

  • Home
  • Developer story
  • short story
  • drafts
  • About Me

Year: 2023

What will happen if we use big strings as MySQL index key

May 27, 2023May 27, 2023 ~ Yisheng Gong ~ 1 Comment

Keep primary key / index key as tiny as possible

Is 20M of rows still a valid soft limit of MySQL table in 2023?

May 22, 2023May 23, 2023 ~ Yisheng Gong ~ 7 Comments

Innodb_buffer_pool size / table size decides whether there'll be a performance downgrade.

Festival 节日

May 17, 2023 ~ Yisheng Gong ~ Leave a comment

The splinters and the blood were still there, and it was a festival. 碎片和血迹依旧在那里,今天是一个节日。

为什么我的网络传输速度下降了

May 6, 2023May 7, 2023 ~ Yisheng Gong ~ Leave a comment

AWS通过扩大rtt和retry实现限速

Drafts 04/23

May 1, 2023May 8, 2023 ~ Yisheng Gong ~ 1 Comment

We told stories in such a night that all those stories seemed to never end. 我们在这样的夜晚中讲故事,那些故事都仿佛不会终止

Packet capture experiment 2: send/receive buffer

April 15, 2023May 6, 2023 ~ Yisheng Gong ~ Leave a comment

Don't hardcode buffer size. Don't keep CPU usage so high.

Packet capture experiment 1: packet delay, loss, duplicate, corrupt, out-of-order and bandwidth limit

April 11, 2023May 6, 2023 ~ Yisheng Gong ~ 1 Comment

Patterns of network issues

Drafts 03/23

March 31, 2023 ~ Yisheng Gong ~ Leave a comment

You stopped talking any more in my dream. I knew it was me who was forgetting. 梦中的你不再说话,我知道是我在忘记

Spot instance termination makes pipeline runtime unstable

March 18, 2023April 2, 2023 ~ Yisheng Gong ~ Leave a comment

Spot instance can save a lot of cost if it fits your use case.

Redis closes connection due to big keys

March 16, 2023April 16, 2023 ~ Yisheng Gong ~ Leave a comment

Again, avoid redis big keys

Posts navigation

Older posts

Category

  • Developer Story (13)
  • Draft (7)
  • Short Story (10)

Tag Cloud

connection pool (1) database (2) databricks (2) data engineering (3) deadlock (1) incident (5) linux (1) mysql (3) network (3) OOM (1) packet capture (4) photograph (7) redis (2) software engineering (12) spark (3) ssh (1) story (10) tcp (3) wireshark (3) writing (17)

Archive

  • 2023 (17)
  • 2022 (6)
  • 2021 (1)
  • 2020 (6)

Subscribe Me

Join 544 other followers

Blog Stats

  • 25,830 hits since 2020
  • twitter
  • instagram
  • linkedin
  • github
Website Powered by WordPress.com.
  • Follow Following
    • Yisheng's blog
    • Already have a WordPress.com account? Log in now.
    • Yisheng's blog
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar
 

Loading Comments...