evanelias

97 ms·

1261.
by evanelias 10y ago
"Around half the country" is an exaggeration. Even with a two-party system, in modern history no candidate has achieved the outright support of anything approaching half of the US population. Consider that only a portion of the po
1262.
by evanelias 10y ago
They announced a few weeks ago that they ditched this plan, ostensibly because it would be too expensive to lease back the space right now. http://nypost.com/2016/07/14/zynga-isnt-abandoning-its-headq...
1263.
by evanelias 10y ago
Agreed 100%, and the author also failed to mention several other advantages of having a clustered PK and indirect secondary indexes. A few off the top of my head: reads in PK order are faster due to lack of indirection; clustered index take
1264.
by evanelias 10y ago
That isn't fully accurate. It's true that the large majority of FB's mysql fleet is dedicated to the main product data, essentially an object-graph store with a restricted access pattern. The queries are indeed relatively sim
1265.
by evanelias 10y ago
At least in my experience, the assessed values for 4+ unit buildings tend to be substantially lower than 45% of true market value. Property tax rates in NYC are actually not too terrible. I've owned homes in NYC as well as northern N
1266.
by evanelias 10y ago
HyperTerminal was commonly referred to as "HyperTerm" in the BBS community, probably because the executable was hypertrm.exe. Also possibly because most other dial-up terminal emulators had names ending in "Term". The fr
1267.
by evanelias 10y ago
You'll need 5.7 to make full use of JSON features; ditto for geo. MySQL 5.7 is still considered pretty new (GA for ~9 months) so many companies haven't upgraded yet. Amazon RDS and Google Cloud SQL do offer 5.7 though, if you want
1268.
by evanelias 14y ago
It's impressive, but also unusual, which makes sense: most language-specific courses tend to be geared towards beginners / people who are relatively new to programming in general. Some language developers are great teachers, so they make ex
1269.
by evanelias 14y ago
Sure, those things can be a pain if you're relatively new to MySQL administration. But luckily there's a huge wealth of automation options released by some of the world's largest web sites. One of MySQL's greatest strengths is the maturity
1270.
Show HN: xargs gzip tee(giantcatco.com)
2 points by evanelias 14y ago|0 comments
1271.
by evanelias 14y ago
re: fault tolerance, it's a fair point. Although in practice I've never had this fail part-way on me, and I've used it a couple hundred times with >600GB transfers. We usually use this to copy to 2 or 3 machines at once; it's rare that
1272.
by evanelias 14y ago
Slave cloning is performed by shutting down mysqld on a standby slave and copying its raw data files. There's no dump involved. This is widely regarded to be the fastest possible way to clone a slave in MySQL. This is explained in the deepe
1273.
by evanelias 14y ago
The core functionality is currently very MySQL-specific. In theory a plugin could override a bunch of methods to target Postgres, and maybe even Redis or other persistent data stores with replication and import/export functionality. It woul
1274.
by evanelias 14y ago
We handle many thousands of write queries per second at Tumblr, and we use Jetpants to manage our entire MySQL topology, so trust me when I say the data changes quite often :) You can edit your existing posts on Tumblr, unlike on several o
1275.
by evanelias 14y ago
Good call -- we'll definitely set one up if there's sufficient need. Until then, feel free to email me; my email address is in the gemspec. I'll write up an FAQ once I have enough questions answered. re: your immediate question, you still c
1276.
by evanelias 14y ago
Cool, looking forward to seeing that! I love Python too, and readily admit it's perhaps a more frequent choice for this type of automation. That said, I really grew to love Ruby over the course of this project, which is actually my first in
1277.
Jetpants: a MySQL toolkit for managing billions of rows and hundreds of DBs(engineering.tumblr.com)
191 points by evanelias 14y ago|23 comments
1278.
by evanelias 14y ago
It's hard to say. A single-threaded import might not be saturating any particular hardware component; there's other overhead in the work. And when you account for multiple CPUs and multi-disk RAID arrays, the picture gets more complicated.
1279.
by evanelias 14y ago
I initially thought so too, but I found the same result -- loading indexes later gave little or no improvement in import speed. Sometimes it can even be a penalty. This actually makes sense though: InnoDB secondary indexes are just addition
1280.
by evanelias 14y ago
All great advice! As a fellow habitual migrator of billions of rows in MySQL, a few things I'd add: Do several chunked LOAD DATA INFILE queries in parallel. It's counter-intuitive but you'll get a performance boost. I usually chunk large da