Tuesday, August 23, 2016
Web-scale MySQL back in the day
I spent a few years at Facebook where I was extremely busy helping to make MySQL better at web-scale. I worked a lot with Domas. He found so many problems and I helped fix them along with a few others (the MySQL db-eng team was small). Domas made it easy to understand what was broken and there was a lot of low-hanging fruit. This slide deck is one perspective on what we did. I doubt I have the energy to go through another few years like that, but it was a great time. The timing was also right as there were many people at Oracle/MySQL pushing to make MySQL scale on modern hardware.
Subscribe to:
Post Comments (Atom)
RocksDB on a big server: LRU vs hyperclock
This has benchmark results for RocksDB using a big (48-core) server. I ran tests to document the impact of the the block cache type (LRU vs ...
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgheKpQ1wicaDdA1Ygal6SfyKpJcqWfIdTS_A1OyeqpzQ-ly7vf_s_vglBzoRjLUZy1K2LSbNWXAX9CObbF6-wNIKgA-Pl0ckr2Dm96460OmOwKmXl3vLT8QlfDW9CXHKUlF3WqFg7pwRcLsruwouNyb1Gk0L0DLvaYmYRivID0cE6J2xTnEQggyoAbQ-mb/w640-h397/QPS_%20fanout=8,%20write%20rate%20=%202M_s,%20size(L0)=4.png)
-
This provides additional results for Postgres versions 11 through 16 vs Sysbench on a medium server. My previous post is here . The goal is ...
-
MySQL 8.0.35 includes a fix for bug 109595 and with that fix the QPS is almost 4X larger on the read+write benchmark steps compared to MyS...
-
I am trying out a dedicated server from Hetzner for my performance work. I am trying the ax162-s that has 48 cores (96 vCPU), 128G of RAM a...
Thank you. It is fun for me to see how far InnoDB has come.
ReplyDelete