--- title: "This week's database news, issue 112" publication: "DB Weekly" issue: 112 published_at: "2016-07-08" canonical_url: "https://dbweekly.com/issues/112" --- Database Weekly 112 . This week's database news -[Read this on the Web](http://dbweekly.com/issues/112) [Database Weekly](http://dbweekly.com) Issue 112 — July 8, 2016 Featured [Reindexing 36bn Documents in 5 Days on an Elasticsearch Cluster](https://thoughts.t37.net/how-we-reindexed-36-billions-documents-in-5-days-within-the-same-elasticsearch-cluster-cd9c054d1db8?utm_source=dbweekly&utm_medium=email) — A very thorough walk through of the techniques, trials, and tribulations involved with reindexing a large Elasticsearch cluster. Fred de Villamiltutorial [All About Indexes: The Very Basics](http://www.vertabelo.com/blog/technical-articles/all-about-indexes-the-very-basics?utm_source=dbweekly&utm_medium=email) — 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](https://blog.jooq.org/2016/07/05/say-no-to-venn-diagrams-when-explaining-joins/?utm_source=dbweekly&utm_medium=email) — 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 Sedertutorial [Put database performance in context](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeekly&utm_content=Databases) — 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. Datadogsponsored [![\](https://copm.s3.amazonaws.com/3cc08687.png)](https://www.datadoghq.com/database-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPress-DBWeekly&utm_content=Databases) [MySQL 8.0 to Be the Next Major Release of MySQL](https://www.percona.com/blog/2016/07/05/mysql-8-0/?utm_source=dbweekly&utm_medium=email) — 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.) Perconanews [Kueri: A Natural Language Interface to SQL](http://kueri.me/?utm_source=dbweekly&utm_medium=email) — 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. Kueritools [Redis-Commander: A Webapp for Managing a Redis Database](http://joeferner.github.io/redis-commander/?utm_source=dbweekly&utm_medium=email) — A Node.js-based web application used to view, edit, and manage a Redis Database. Joe Fernertools Jobs [Hired is the best place to find engineering jobs.](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=bestplace&utm_campaign=q3-16-dbweekly&utm_location=us) — 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.](https://hired.com/?utm_source=newsletters&utm_medium=petercooperpress&utm_term=cat-tech-database&utm_content=bestplace&utm_campaign=q3-16-dbweekly&utm_location=us) Hired.​com In brief [InfluxDB Tops Cassandra in Time-Series Data and Metrics Benchmark](https://influxdata.com/blog/influxdb-vs-cassandra-benchmark-time-series-metrics/?utm_source=dbweekly&utm_medium=email) — As always, note who is doing the benchmarking. InfluxDatanews [Reindexing Elasticsearch with Zero Downtime](https://summera.github.io/infrastructure/2016/07/04/reindexing-elasticsearch.html?utm_source=dbweekly&utm_medium=email) Ari Summertutorial [Implementing a Neural Network in SQL](http://blog.itdxer.com/2016/07/01/neural-networs-in-mysql.html?utm_source=dbweekly&utm_medium=email) Yuri Shevchuktutorial [Autoscaling MySQL for Massive Datasets](http://www.geektyler.com/2016/07/03/autoscaling-mysql/?utm_source=dbweekly&utm_medium=email) geektylertutorial [Building WePay's Data Warehouse using BigQuery and Airflow](https://wecode.wepay.com/posts/wepays-data-warehouse-bigquery-airflow?utm_source=dbweekly&utm_medium=email) WePaystory [Finding and Killing Long Running Queries On PostgreSQL](https://medium.com/little-programming-joys/finding-and-killing-long-running-queries-on-postgres-7c4f0449e86d?utm_source=dbweekly&utm_medium=email) — From time to time we need to investigate if there is any query running indefinitely on a PostgreSQL database. Anderson Dias [The Evolution of Apache Spark: Journey of Spark in 1.x Series](http://blog.madhukaraphatak.com/evolution-of-apache-spark/?utm_source=dbweekly&utm_medium=email) Madhukara Phatakvideo [Introduction to Spark 2.0](https://www.youtube.com/watch?v=GhZ-XPGyXiM&utm_source=dbweekly&utm_medium=email) Madhukara Phatakvideo [An Interview about RavenDB on the NoSQL Podcast](https://ayende.com/blog/174817/ravendb-on-the-nosql-podcast?utm_source=dbweekly&utm_medium=email) Ayende Rahien [A Full Comparison of Redshift and BigQuery](http://panoply.io/a-full-comparison-of-redshift-and-bigquery/?utm_source=dbweekly&utm_medium=email) Roi Avinoamopinion [Thinking in SQL vs Thinking in Python](https://blog.modeanalytics.com/learning-python-sql/?utm_source=dbweekly&utm_medium=email) Benn Stancilopinion [The Performance Characteristics of MySQL on Docker](http://mysqlserverteam.com/mysql-with-docker-performance-characteristics/?utm_source=dbweekly&utm_medium=email) Trond Humborstadopinion [SQL Dashboards in a Flash](http://www.launchbit.com/taz/11159-6330-111) — Periscope Data lets you run analyses over billions of rows in seconds. Periscope Datatools sponsored [SparkADMM: A Massively-Parallel Framework for Solving Big Data Problems](https://yahooresearch.tumblr.com/post/147013834176/open-sourcing-sparkadmm-a-massively-parallel?utm_source=dbweekly&utm_medium=email) Yahoo Researchtools [EclairJS: Access Apache Spark from Node.js](http://eclairjs.github.io/?utm_source=dbweekly&utm_medium=email) IBMcode Database Weekly is curated by Peter Cooper [Read this issue on the Web](http://dbweekly.com/issues/112) [See our archives](http://dbweekly.com/issues) [Change your email address](*|UPDATE_PROFILE|*) [Stop getting this newsletter](*|UNSUB|*) Published by [Cooperpress](https://cooperpress.com/) Fairfield Enterprise Centre, Lincoln Way, Louth, LN11 0LS, UK