I ntroducon to MemSQL Core MemSQL Technical Concepts In this secon we will go over some key technical concepts that underpin MemSQL’s architecture. It’s these key technical differences that differenate it from other soluons and make it a soluon of choice for customers. Code Generaon and Compiled Plans When a query is submied to a database, the query is interpreted, an execuon plan generated and the query is executed. Opmizing this process is crical for performance. MemSQL embeds an industrial compiler (LLVM) for low-level opmizaons along hot code paths - opmizaons that are not possible when execung via interpretaon. This approach also takes advantage of newer instrucon sets that are available with modern cpus. When a MemSQL server encounters a query shape for the first me, it generates a just-in-me execuon plan, wrien in C++, which is incrementally compiled to machine code as it processes the query. This has two-fold benefits allowing opmal query performance with first run queries while offering extreme fast response me to repeat queries. Each compiled plan is cached to prepare for future invocaons of the given query. When future queries match an exisng parameterized query plan template, MemSQL bypasses code generaon and executes the query immediately using the cached plan. 7