Top Technology Performance Pulse Virtualization Tuning Content for Wed.Oct 03, 2018

Wed.Oct 03, 2018

Percona Live Europe Tutorial: Elasticsearch 101

Percona Community

OCTOBER 3, 2018

For Percona Live Europe, I’ll be presenting the tutorial Elasticsearch 101 alongside my colleagues and fellow presenters from ObjectRocket Alex Cercel, DBA, and Mihai Aldoiu, Data Engineer. Here’s a brief overview of our tutorial. Elasticsearch® is well known as a highly scalable search engine that stores data in a structure optimized for language based searches but its capabilities and use cases don’t stop there.

Data Engineering

Data Engineering Scalability Engineering

Finding Table Differences on Nullable Columns Using MySQL Generated Columns

Percona

OCTOBER 3, 2018

Some time ago, a customer had a performance issue with an internal process. He was comparing, finding, and reporting the rows that were different between two tables. This is simple if you use a LEFT JOIN and an IS NULL comparison over the second table in the WHERE clause, but what if the column could be null? That is why he used UNION, GROUP BY and a HAVING clauses, which resulted in poor performance.

C++

C++ Virtualization Performance Processing

Wed.Oct 03, 2018

Percona Live Europe Tutorial: Elasticsearch 101

Finding Table Differences on Nullable Columns Using MySQL Generated Columns

Stay Connected