Performance tuning ColumnStore

Speakers
  • Patrick LeBlanc, Principal Software Engineer at MariaDB
  • Roman Nozdrin, Software Engineer at MariaDB
Session Abstract

When your query execution is slow, a couple of questions arise. Where to look for resources utilization? What tools do you have to analyze CPU, hard drive and RAM bottlenecks? Could you do something to reduce query execution time? MariaDB’s Patrick LeBlanc and Roman Nozdrin touch on both Columnstore’s query execution introspection tools as well as operating system capabilities that everyone should know about. They go on to discuss a number of real life use cases too. Some called for configuration changes whilst others forced them to make serious changes in the code.

View Presentation Slides