rwultsch

6 ms·

1.
by rwultsch 29d ago
"MySQL was also potentially faster as it did not implement all features of the SQL standard. " This is a not great start. I assume it refers to MyISAM which has not been relevant for over a decade at this point. InnoDB made differ
2.
by rwultsch 2y ago
Does this not speaks to the rapid growth of Central Europe economies rather than a decline of Japan? I have read similar comparisons for both the U.K. and Germany vs Poland. Also, a quick googling suggests both Poland and Japan both have fe
3.
by rwultsch 2y ago
Oddly enough I am visiting Japan right now. There are lots of foreign workers in service jobs. They speak zone language and don’t jay walk. Prices feel like a middle income country, but that is just the Yen sucking. Otherwise it feels very
4.
by rwultsch 2y ago
They are however incredibly loud. Being close to someone shooting 556 with a brake is a really annoying experience and I would not be shocked if there were follow on effects.
5.
by rwultsch 2y ago
I am an overweight person that drank more than I should. Ozempic helped me drop 15 lb and I don’t feel the draw of drink nearly as much as I had. I was diagnosis ADHD as a kid. Since being on Ozempic I have noticed no difference in ability
6.
by rwultsch 2y ago
“Introduced in 2013, HBase was Pinterest’s first NoSQL datastore.” I don’t think this is correct. When I started in late 2013 Redis was being used as a persistent data store. And what pain it was. I convinced leadership in late 2014 this wa
7.
by rwultsch 3y ago
I enjoy that “ma” has ambiguous meaning above. Does it mean mandarin question mark word or does possibly mean mother?
8.
by rwultsch 3y ago
A pin was a 1.2 KB json blob . There were other tables but pins was the big one. Why MySQL? It did not destroy data like the alternatives. how storage became efficient https://medium.com/pinterest-engineering/evolvin
9.
by rwultsch 3y ago
Before I joined in late 2013, they had not known how to run schema change without downtime. Once we fixed the kernel the db’s were nearly completely untaxed in terms of performance. They did however need large instances due to disk usage.
10.
by rwultsch 3y ago
I am getting a Sub-zero in a few weeks which is damn near the most expensive fridge. It does not have nice pull out shelves or the veggie compartments. I expect the sealing and ethylene scrubbing will keep veggies fresh linger.
11.
by rwultsch 4y ago
We recently moved to Frederick, MD. Walking distance to the very lively downtown, inexpensive housing, close to an airport, yada, yada...
12.
by rwultsch 5y ago
OT: How is the tech scene in Taiwan? My wife is from Taiwan. Every time we visit I am very sad to leave. We have thought about moving to Taipei.
13.
by rwultsch 5y ago
And Taiwan.
14.
by rwultsch 6y ago
FB had plenty of schema changes. I know, I wrote software to push them out. The important concepts for pushing schema at scale became part of Skeema.
15.
by rwultsch 6y ago
Taiwan.
16.
by rwultsch 7y ago
Eh, I will kind of buy that. It was a church before it was a mosque and churches tend to have quite a bit more music than mosques. The race war comment above seemed uncharitable.
17.
by rwultsch 7y ago
The Hagia Sophia was the site of a significant massacre when it was forcibly converted from a church to a mosque.
18.
by rwultsch 7y ago
I was on the DBA team there around that MAU. I had lots of company and support from SRO (aka jr DBA's) as well as other teams (provisioning, etc...).
19.
by rwultsch 8y ago
Short duration: network, bad software deploy Long duration: db. If you break data, it takes a while to unbreak. Source: Me. My career has been spent managing db's for internet scale sites.
20.
How Pinterest cut the storage for Pins almost in half, again(engineering.pinterest.com)
2 points by rwultsch 10y ago|0 comments
21.
Evolving MySQL Compression – Part 1(engineering.pinterest.com)
1 points by rwultsch 10y ago|0 comments
22.
by rwultsch 10y ago
Postgres has had CTE for a while, but not that long. MySQL 8.0 (the next version) plans to them http://mysqlserverteam.com/mysql-8-0-labs-recursive-common-t...
23.
by rwultsch 10y ago
You missed the point of my post. You are going to have one of the two issues, either looking through two index or indexes including the a large PK. At least with InnoDB you can make the choice. The strategy I suggested gets you the desired
24.
by rwultsch 10y ago
If you don't want a clustered index in InnoDB you can define the primary key as an auto incrementing uint.
25.
by rwultsch 10y ago
The PG storage engine is not particularly awesome. It is basically COW (with exceptions) and compaction (called vacuum) has been quite painful for a long time. Every release it is supposedly fixed, but people keep complaining. This not to s
26.
Tracker: Ingesting MySQL data at scale – Part 2(engineering.pinterest.com)
3 points by rwultsch 10y ago|1 comments
27.
by rwultsch 10y ago
Hi cookiecaper, All our operational code (other than pinterest specific bits) is open sourced https://github.com/pinterest/mysql_utils Both statement and row based replication can be very reliable in modern versions of
28.
by rwultsch 10y ago
Hi, I was the first MySQL DBA hired Pinterest and before that I worked at Facebook and GoDaddy. At none of these places did we run active/actice. One of the first things I did at Pinterest was rip out the multi-master configure because
29.
by rwultsch 10y ago
I was on the DBA team at FB and I spent the better part of a year working on the deployment system for online schema change. It was a pain. Other companies have done quite a bit of work on this as well (Shift from Square, etc...). Later on
30.
by rwultsch 11y ago
It has not open sourced and I think (and am in no way authoritative) it is unlikely to be open sourced.

More ›