/top/
/new/
/best/
/ask/
/show/
/job/
^
slacker news
login
about
←back to thread
Upgrading Uber's MySQL Fleet
(www.uber.com)
234 points
benocodes
| 1 comments |
14 Oct 24 12:08 UTC
|
HN request time: 0s
|
source
Show context
whalesalad
◴[
14 Oct 24 12:39 UTC
]
No.
41836959
[source]
▶
>>41836748 (OP)
#
So satisfying to do a huge upgrade like this and then see the actual proof in the pudding with all the reduced latencies and query times.
replies(1):
>>41837062
#
hu3
◴[
14 Oct 24 12:52 UTC
]
No.
41837062
[source]
▶
>>41836959
#
Yeah some numbers caught my attention like ~94% reduction in overall database lock time.
And to think they never have to worry about VACUUM. Ahh the peace.
replies(4):
>>41837227
#
>>41837317
#
>>41837626
#
>>41838255
#
InsideOutSanta
◴[
14 Oct 24 13:22 UTC
]
No.
41837317
[source]
▶
>>41837062
#
As somebody who has always used MySQL, but always been told that I should be using Postgres, I'd love to understand what the issues with VACUUM are, and what I should be aware of when potentially switching databases?
replies(5):
>>41837435
#
>>41838160
#
>>41838537
#
>>41839012
#
>>41845775
#
1.
evanelias
◴[
14 Oct 24 16:22 UTC
]
No.
41839012
{3}
[source]
▶
>>41837317
#
For an in-depth read on the differences in MVCC implementations, this post is pure gold:
https://www.cs.cmu.edu/~pavlo/blog/2023/04/the-part-of-postg...
ID:
GO
↑