Issue 112 — July 8, 2016
Featured
Reindexing 36bn Documents in 5 Days on an Elasticsearch Cluster — A very thorough walk through of the techniques, trials, and tribulations involved with reindexing a large Elasticsearch cluster.
Fred de Villamil tutorial
All About Indexes: The Very Basics — Well defined indexes will improve your database’s performance significantly, but how do they work?
Emil Drkušić tutorial
Say No to Venn Diagrams When Explaining JOINs — It’s common to illustrate how SQL JOIN operations work using Venn diagrams, but is there a better way? Luka Seder considers other options.
Luka Seder tutorial
Put database performance in context — Visualize key metrics and set targeted alerts across your infrastructure. Datadog has built-in integrations with MySQL, Postgres, Redis, and more, plus StatsD support for monitoring custom metrics from your client applications.
Datadog sponsored
MySQL 8.0 to Be the Next Major Release of MySQL — MySQL 8.0 seems likely to be the next release of the world-famous database server, rather than 5.8. (Most likely due to MySQL Cluster being at 7.4 already.)
Percona news
Kueri: A Natural Language Interface to SQL — A new, interactive search-box interface to allow your users to navigate, explore, and present their data with intuitive as-you-type auto-complete suggestions.
Kueri tools
Redis-Commander: A Webapp for Managing a Redis Database — A Node.js-based web application used to view, edit, and manage a Redis Database.
Joe Ferner tools
Jobs
Hired is the best place to find engineering jobs. — Bored at work? Want to try a new stack? Find 3500+ great tech companies on Hired who will compete to hire you. Try it today.
Hired.com
In brief
InfluxDB Tops Cassandra in Time-Series Data and Metrics Benchmark — As always, note who is doing the benchmarking.
InfluxData news
Ari Summer tutorial
Yuri Shevchuk tutorial
geektyler tutorial
Finding and Killing Long Running Queries On PostgreSQL — From time to time we need to investigate if there is any query running indefinitely on a PostgreSQL database.
Anderson Dias
Madhukara Phatak video
Madhukara Phatak video
Ayende Rahien
Roi Avinoam opinion
Benn Stancil opinion
Trond Humborstad opinion
SQL Dashboards in a Flash — Periscope Data lets you run analyses over billions of rows in seconds.
Periscope Data tools sponsored
Yahoo Research tools