---
title: "Breaking the trillion-rows-per-second barrier with MemSQL"
publication: "DB Weekly"
issue: 196
published_at: "2018-03-23"
canonical_url: "https://dbweekly.com/issues/196"
---

This week's database news       

#196 — March 23, 2018 

[Read on the Web](https://dbweekly.com/issues/196)   

Database Weekly  

[User-Defined Order in SQL](https://begriffs.com/posts/2018-03-20-user-defined-order.html) — If your app has a type of item that can be arbitrarily reordered by users (e.g. a list of ‘to do’ items), this guide on ways to model that concept in SQL should prove interesting especially as it considers using _fractions_ to do it. 

Joe Nelson   

[Breaking a Trillion-Rows-Per-Second with MemSQL](http://blog.memsql.com/shattering-the-trillion-rows-per-second-barrier-with-memsql/) — [MemSQL](https://www.memsql.com/product/) is a proprietary, high performance real-time SQL database and a 9 server cluster with 448 total cores has managed to scan a trillion rows per second during queries. 

Eric Hanson   [![\](https://copm.s3.amazonaws.com/82423a4d.png)](https://learn.percona.com/cp-ebook-practical-mysql-performance-optimization-section) 

[Learn MySQL Optimization From the Experts with Percona’s eBook Series](https://learn.percona.com/cp-ebook-practical-mysql-performance-optimization-section) — The content in this eBook will enable you to troubleshoot and optimize your own database performance. 

Percona sponsor    

[A Single-Node Hadoop 3 Install Guide](http://tech.marksblogg.com/hadoop-3-single-node-install-guide.html) — Want to explore Hadoop 3 without having a huge cluster to hand? You can do it on a single machine, as here. 

Mark Litwintschik   

[JSON Comes to CockroachDB](https://www.cockroachlabs.com/blog/json-coming-to-cockroach/) — CockroachDB is an open source distributed SQL database and it has just introduced Postgres-like JSONB support. 

Justin Jaffray   

[Why a Picture of Scarlett Johansson Got a Postgres Database to Start Mining Cryptocurrency](https://www.imperva.com/blog/2018/03/deep-dive-database-attacks-scarlett-johanssons-picture-used-for-crypto-mining-on-postgre-database/) — A payload was boiled into a photo which when stored and then accessed in a certain way led to a security issue. 

Imperva   

▶[Redis' Creator on Writing System Software](https://www.youtube.com/watch?v=VBrnmciV9fM&list=PLrEMgOSrS_3fghr8ez63xKFNF-BA6Pz13) — The creator of Redis is producing a series of YouTube videos where he digs into implementation details of the popular data structure server. 

Salvatore Sanfilippo   

[Why Should I Use a Time Series Database?](https://www.influxdata.com/blog/why-should-i-use-a-time-series-database/) 

InfluxData sponsoropinion   

[InfluxData Working on a Go(lang) Implementation of Apache Arrow](https://www.influxdata.com/blog/influxdata-apache-arrow-go-implementation/) — Arrow is a columnar in-memory data storage system and InfluxDB is keen to use it so have been working on a Go implementation - here’s why and how. 

Stuart Carnie  

🛠 Tips & Tutorials  

[Migrating from MySQL to PostgreSQL: What You Should Know](https://severalnines.com/blog/migrating-mysql-postgresql-what-you-should-know) — A high-level overview of what you need to know if you are considering migrating your database from MySQL to PostgreSQL. 

Brian Fehrle   

[Encouraging Minimal SQL Privileges](https://veronneau.org/minimal-sql-privileges.html) — A call to encourage open source projects to only make users give apps the minimum privileges needed to operate. 

Louis-Philippe Véronneau  

🔧 Tools & Code  

[Correlate Request Traces, Metrics, and Logs. Try Datadog Free](https://www.datadoghq.com/dg/logs/log-monitoring/?utm_source=Advertisement&utm_medium=CooperPress&utm_campaign=CooperPressLogs-DBWeeklyB) 

Datadog sponsortools   

[![The Dejavu Elasticsearch Web UI\](https://res.cloudinary.com/cpress/image/upload/w_800/f9uddoe5wcnle78whqgg.jpg)](https://github.com/appbaseio/dejavu)  

[Dejavu: The 'Missing' Web UI for Elasticsearch](https://github.com/appbaseio/dejavu) — A 100% client-side rendered, modern Web UI for Elasticsearch. 

appbase   

[Azure Cosmos DB Query Cheat Sheets](https://docs.microsoft.com/en-us/azure/cosmos-db/query-cheat-sheet) — Printable PDF cheat sheets that helps you use Azure Cosmos DB’s SQL, MongoDB, Graph, and Table APIs. 

Microsoft Azure   

[RediSearch: A Full Text Search Module for Redis](https://github.com/RedisLabsModules/RediSearch) 

Redis Labs Modules   

Golden Oldies Worth Revisiting ✨  

[Efficient Pagination of a Table with 100M Records using SQL](http://allyouneedisbackend.com/blog/2017/09/24/the-sql-i-love-part-1-scanning-large-table/) 
Viach Kakovskyi   

[Say No to Venn Diagrams When Explaining JOINs](https://blog.jooq.org/2016/07/05/say-no-to-venn-diagrams-when-explaining-joins/) 
Luka Seder   

[Why SQL Is Beating NoSQL, and What This Means for The Future of Data](https://blog.timescale.com/why-sql-beating-nosql-what-this-means-for-future-of-data-time-series-database-348b777b847a) 
Ajay Kulkarni          

A **[Cooperpress](https://cooperpress.com/)** publication. 

[Change your email address](https://dbweekly.com/edit_subscription/*|UID|*) or[Stop getting this newsletter](https://dbweekly.com/leave/*|UID|*) 

© Cooper Press Ltd · Fairfield Enterprise Centre, Louth, LN11 0LS, United Kingdom