It’s my great pleasure to announce the arrival of SingleStoreDB 8.1! Highlights of the release include:
Real-time Analytics improvements:
- Query optimizer improvements: Generally useful enhancements that also improve TPC-H benchmark results including a 20x gain on Q17 and 2.5x gain on Q20
- Improved spilling: a new disk manager balances needs of spilling and blob cache
- Improved recursive CTE (RCTE) query support: the most common RCTE query shapes that were not supported will work in 8.1
- Improved workload management so that medium-sized queries can be run in the large-sized query queue if the large queue is empty, to improve throughput and response time
Distributed SQL/Mission-critical workload support improvements:
- Column group indexes: for up to 6X faster seeks into wide columnstores
- Upgrade to OpenSSL 3.0: allows SingleStoreDB to pass stringent enterprise security scans, reduces security vulnerability surface area, improves performance via reduced locking
Developer Experience improvements:
- Sparse JSON fast load & insert: allows customers using JSON with a very large number of distinct property names across a full set of documents to load and insert data fast
- LOAD DATA from S3: easier to do simple loads and get started with SingleStoreDB Cloud
- Support for full-text search (FTS) with emojis & advanced Chinese characters (FTS for utf8mb4)
- Light-weight query profiling suitable for always-on use (see auto_profile_type variable documentation)
- Graphical explain/profile view on the web using SHOW PROFILE UI
- Wasm-based user-defined aggregate functions based on “handle” (by-reference) state giving 1000x or more performance improvement for aggregates with large internal state.
Also, IPV6 will be supported for self-hosted installation by invitation only. Contact your SingleStore account team if you’d like to try it.
Changes in Patch Releases Since 8.0 GA
Several features have been added since the GA release of 8.0 (8.0.4). Particularly notable ones include GROUP BY ALL, ORDER BY ALL, and new JSON built-in functions for powerful and easy matching of parts of documents and searching in documents, including JSON_INCLUDE_MASK, JSON_EXCLUDE_MASK, and JSON_MATCH_ANY. Please refer to the 8.0 maintenance release change log for additional details.
Eric Hanson
Director of Product Management
SingleStore, Inc.