HarrisonFisk
No user record in our sample, but HarrisonFisk has activity below (stories or comments). Likely we have partial data — the full bulk-load will fill profiles in.
No user record in our sample, but HarrisonFisk has activity below (stories or comments). Likely we have partial data — the full bulk-load will fill profiles in.
https://engineering.fb.com/2024/03/06/security/whatsapp-mess...
It wasn’t the top selling car. That seems to be something Elon made up: https://www.autoweek.com/news/industry-news/a44600661/is-tes...
The big tech companies (ie. FANG) all have huge demand for principal+ engineers and know how to scope and support them properly. The size means they have lots of them which reduces the snowflake nature of the role and…
Direct source is available at: https://github.com/facebook/mysql-5.6 The social graph is indeed stored in MySQL via TAO. A recent white paper about MyRocks is:…
The code is open source: https://github.com/facebook/mysql-5.6
https://en.wikipedia.org/wiki/Anti-Mask_League_of_San_Franci...
Facebook doesn't have engineering titles for exactly this reason.
This is every day at Facebook! https://code.facebook.com/posts/1007323976059780/continuous-...
If you find this book interesting, a good video which talks about Production Engineering at Facebook and talks a bit about Google SRE: https://www.youtube.com/watch?v=ugkkza3vKbc
There is nothing that prevents these from being implemented for PostgreSQL. In fact, they have already done a lot of optimizations that close the gap, such as covering indexes. Before covering indexes, InnoDB was even…
Right, PG calls the REDO log the WAL (for most purposes they are the same thing). I did not know that 9.4 can do partial page writes to the WAL now. Guess I will have more reading to do, thanks for pointing it out! A…
(I am a manager of the Data-Perf team at FB which deals with lots of different DB technologies) MySQL (specifically InnoDB) is extremely efficient as a storage backend compared to PostgreSQL. There are a few features…
There is nothing that precludes public contributions to the project. The important part is that the change be useful to 'webscale' type applications. Prior to this announcement, the only people involved have been these…
Yes, we are still very active users of MySQL. Most of the primary portions of facebook.com are still served from a backend MySQL system (with lots of caching and many other services involved). Some data is not stored in…
Doing compression on the ZFS level is significantly worse than InnoDB compression. InnoDB has a lot of really smart optimizations which make it much better than just zipping things up. Included are the modification log…
In addition, when you are dealing with many thousand application servers and many hundred database connections, the database will not end up happy having to maintain > 10k connections. So you will end up needing to add…
Why would the license matter for a kernel module? You know that the linux kernel is also GPL v2 right?
It wasn't for 1B cash, it was 800M cash, 200M Sun stock.
The easiest way is to avoid running into the problem. The main reason the central table space grows is due to rollback segments. To avoid collecting a lot of them there are two tips (in addition to file per table you…
This really reminds me a lot of the progression of MySQL. Originally it was used with ISAM/MyISAM and it was pretty popular. Then InnoDB came around and it quickly revolutionized the MySQL world, allowing MySQL to grow…
When you delete your account, the data is actually removed. As part of the recent privacy audit, the Irish DPC reviewed the account deletion framework and verified that it does indeed work:…
Facebook does not sell user data regardless of what you may have heard. See: https://www.facebook.com/help/152637448140583/
The interesting part about this is that MariaDB is only a drop in replacement for MySQL 5.5. MariaDB isn't porting to MySQL 5.6 (which came out last month), instead they are going to try to reimplement all of the…
PostgreSQL doesn't do parallel query.
jemalloc is the new hotness for MySQL. We are using it at Facebook (and I know percona/oracle use it for benchmarks and testing as well). Good benchmark showing the impact of the different options:…