Welcome to Percona Live Online 2021
Online Open Source Database Conference
Back To Schedule
Wednesday, May 12 • 13:00 - 13:30
WarpSQL - a distribution of MySQL 8 with columnar storage, bitmap indexing, and parallel query execution

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
WarpSQL is a distribution of MySQL 8 which includes the WARP storage engine and has parallel query execution features for queries that use WARP tables. The WARP storage engine features automatic creation of compressed bitmap indexes, which can be used to eciently execute complex queries that can not be executed eciently using traditional btree indexes, even over very large amounts of data. Columnar storage means that IO eciency is improved for queries that access a subset of columns in a table, because only columns accessed by a query are read from disk. WarpSQL also features parallel query execution, which can increase query performance substantially, by using multiple cores to execute queries. Performance improvements of 100x or more compared to the InnoDB storage engine are possible for queries in standard benchmarks, like the star schema benchmark. This talk will demonstrate how the WARP storage engine works, including a discussion of bitmap 2 of 4 Speakers indexes as compared to traditional btree indexes, and will oer benchmark comparisons between regular MySQL 8 and WarpSQL.

avatar for Justin Swanhart

Justin Swanhart

Justin Swanhart has over 20 years of experience working with database technologies. He is the author of WarpSQL, ShardQuery, Flexviews, and PHP-SQL-Parser. Currently the CEO of LeapDB, LLC, a company developing software as a service MySQL and MariaDB solutions for materialized views... Read More →

Wednesday May 12, 2021 13:00 - 13:30 EDT
Room #7