WarpSQL - a distribution of MySQL 8 with columnar storage, bitmap indexing

Justin Swanhart LeapDB Ceo, presents, WarpSQL - a distribution of MySQL 8 with columnar storage, bitmap indexing, and parallel query execution.

#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.

You can find more information about #OpenSource #Databases and Percona Database Events in these links 👇👇👇

Connect With us on our Social Networks 👇👇👇