docs.singlestore.com Open in urlscan Pro
2600:9000:223c:d400:15:de59:8f00:93a1  Public Scan

Form analysis
0 forms found in the DOM

Text Content

We value your privacy

We use cookies to enhance your browsing experience, serve personalized ads or
content, and analyze our traffic. By clicking "Accept All", you consent to our
use of cookies. Read More

Customize Reject All Accept All
Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions.
You will find detailed information about all cookies under each consent category
below.

The cookies that are categorized as "Necessary" are stored on your browser as
they are essential for enabling the basic functionalities of the site. ... Show
more


NecessaryAlways Active

Necessary cookies are required to enable the basic features of this site, such
as providing secure log-in or adjusting your consent preferences. These cookies
do not store any personally identifiable data.

 * Cookie
   AUTH_SESSION_ID
 * Duration
   session
 * Description
   
   No description available.

 * Cookie
   AUTH_SESSION_ID_LEGACY
 * Duration
   session
 * Description
   
   No description available.

 * Cookie
   KC_RESTART
 * Duration
   session
 * Description
   
   No description available.

 * Cookie
   _forum_session
 * Duration
   session
 * Description
   
   No description available.

 * Cookie
   __cfruid
 * Duration
   session
 * Description
   Cloudflare sets this cookie to identify trusted web traffic.

 * Cookie
   AWSALBCORS
 * Duration
   7 days
 * Description
   This cookie is managed by Amazon Web Services and is used for load balancing.

 * Cookie
   YII_CSRF_TOKEN
 * Duration
   session
 * Description
   This cookie is used a unique token that used in securing forms and other
   website inputs against XSS attacks.

 * Cookie
   _GRECAPTCHA
 * Duration
   5 months 27 days
 * Description
   This cookie is set by the Google recaptcha service to identify bots to
   protect the website against malicious spam attacks.

 * Cookie
   AWSALB
 * Duration
   7 days
 * Description
   
   AWSALB is an application load balancer cookie set by Amazon Web Services to
   map the session to the target.

 * Cookie
   cookieyes-consent
 * Duration
   1 year
 * Description
   CookieYes sets this cookie to remember users' consent preferences so that
   their preferences are respected on their subsequent visits to this site. It
   does not collect or store any personal information of the site visitors.

 * Cookie
   __stripe_sid
 * Duration
   0
 * Description
   
   Cookie set by Stripe for fraud prevention purposes

 * Cookie
   __stripe_mid
 * Duration
   0
 * Description
   
   Set by Stripe for fraud prevention purposes

 * Cookie
   JSESSIONID
 * Duration
   session
 * Description
   New Relic uses this cookie to store a session identifier so that New Relic
   can monitor session counts for an application.

 * Cookie
   intercom-id-*
 * Duration
   8 months 26 days 1 hour
 * Description
   Intercom sets this cookie that allows visitors to see any conversations
   they've had on Intercom websites.

 * Cookie
   intercom-session-*
 * Duration
   7 days
 * Description
   Intercom sets this cookie that allows visitors to see any conversations
   they've had on Intercom websites.

 * Cookie
   intercom-device-id-*
 * Duration
   8 months 26 days 1 hour
 * Description
   Intercom sets this cookie that allows visitors to see any conversations
   they've had on Intercom websites.

Functional


Functional cookies help perform certain functionalities like sharing the content
of the website on social media platforms, collecting feedback, and other
third-party features.

 * Cookie
   _biz_uid
 * Duration
   1 year
 * Description
   This cookie is set by Bizible, to store user id on the current domain.

 * Cookie
   _biz_nA
 * Duration
   1 year
 * Description
   This cookie, set by Bizible, is a sequence number that Bizible includes for
   all requests, for internal diagnostics purposes.

 * Cookie
   __cf_bm
 * Duration
   30 minutes
 * Description
   This cookie, set by Cloudflare, is used to support Cloudflare Bot Management.

 * Cookie
   UserMatchHistory
 * Duration
   1 month
 * Description
   LinkedIn sets this cookie for LinkedIn Ads ID syncing.

 * Cookie
   lang
 * Duration
   session
 * Description
   LinkedIn sets this cookie to remember a user's language setting.

 * Cookie
   bcookie
 * Duration
   1 year
 * Description
   LinkedIn sets this cookie from LinkedIn share buttons and ad tags to
   recognize browser ID.

 * Cookie
   lidc
 * Duration
   1 day
 * Description
   LinkedIn sets the lidc cookie to facilitate data center selection.

 * Cookie
   bscookie
 * Duration
   1 year
 * Description
   LinkedIn sets this cookie to store performed actions on the website.

 * Cookie
   ELOQUA
 * Duration
   1 year 1 month
 * Description
   
   Eloqua global user identifier

 * Cookie
   ELOQUA
 * Duration
   1 year 1 month
 * Description
   
   Eloqua global user identifier

 * Cookie
   ajs_anonymous_id
 * Duration
   1 year
 * Description
   
   This cookie set by Segment is used to record the number of people that visit
   our site, and track whether you've visited before.

Analytics


Analytical cookies are used to understand how visitors interact with the
website. These cookies help provide information on metrics such as the number of
visitors, bounce rate, traffic source, etc.

 * Cookie
   singlestoreTraits
 * Duration
   1 year
 * Description
   
   No description

 * Cookie
   _biz_sid
 * Duration
   30 minutes
 * Description
   
   This cookie is set by Bizible, to store the user's session id.

 * Cookie
   _biz_pendingA
 * Duration
   1 year
 * Description
   
   A Cloudflare cookie set to record users’ settings as well as for
   authentication and analytics.

 * Cookie
   _biz_flagsA
 * Duration
   1 year
 * Description
   
   A single cookie from Bizible that stores multiple information, such as
   whether or not the user has submitted a form, performed a crossdomain
   migration, sent a viewthrough pixel, opted out from tracking, etc.

 * Cookie
   _BUID
 * Duration
   1 year
 * Description
   This cookie, set by Bizible, is a universal user id to identify the same user
   across multiple clients’ domains.

 * Cookie
   _ga
 * Duration
   1 year 1 month 4 days
 * Description
   The _ga cookie, installed by Google Analytics, calculates visitor, session
   and campaign data and also keeps track of site usage for the site's analytics
   report. The cookie stores information anonymously and assigns a randomly
   generated number to recognize unique visitors.

 * Cookie
   _gid
 * Duration
   1 day
 * Description
   Installed by Google Analytics, _gid cookie stores information on how visitors
   use a website, while also creating an analytics report of the website's
   performance. Some of the data that are collected include the number of
   visitors, their source, and the pages they visit anonymously.

 * Cookie
   _gcl_au
 * Duration
   3 months
 * Description
   Provided by Google Tag Manager to experiment advertisement efficiency of
   websites using their services.

 * Cookie
   _hjFirstSeen
 * Duration
   30 minutes
 * Description
   Hotjar sets this cookie to identify a new user’s first session. It stores a
   true/false value, indicating whether it was the first time Hotjar saw this
   user.

 * Cookie
   _hjAbsoluteSessionInProgress
 * Duration
   30 minutes
 * Description
   Hotjar sets this cookie to detect the first pageview session of a user. This
   is a True/False flag set by the cookie.

 * Cookie
   _hjTLDTest
 * Duration
   session
 * Description
   To determine the most generic cookie path that has to be used instead of the
   page hostname, Hotjar sets the _hjTLDTest cookie to store different URL
   substring alternatives until it fails.

 * Cookie
   CONSENT
 * Duration
   2 years
 * Description
   YouTube sets this cookie via embedded youtube-videos and registers anonymous
   statistical data.

 * Cookie
   browser_id
 * Duration
   5 years
 * Description
   This cookie is used for identifying the visitor browser on re-visit to the
   website.

 * Cookie
   IDE
 * Duration
   1 year 24 days
 * Description
   Google DoubleClick IDE cookies are used to store information about how the
   user uses the website to present them with relevant ads and according to the
   user profile.

 * Cookie
   mp_aee4da1111c439e10ee2982f40abcd0d_mixpanel
 * Duration
   1 year
 * Description
   
   Mixpanel development

 * Cookie
   _ga_*
 * Duration
   1 year 1 month 4 days
 * Description
   Google Analytics sets this cookie to store and count page views.

 * Cookie
   _gat_UA-*
 * Duration
   1 minute
 * Description
   Google Analytics sets this cookie for user behaviour tracking.

 * Cookie
   _gd_visitor
 * Duration
   1 year 1 month 4 days
 * Description
   This cookie is used for collecting information on the users visit such as
   number of visits, average time spent on the website and the pages loaded for
   displaying targeted ads.

 * Cookie
   _gd_session
 * Duration
   4 hours
 * Description
   This cookie is used for collecting information on users visit to the website.
   It collects data such as total number of visits, average time spent on the
   website and the pages loaded.

 * Cookie
   demdex
 * Duration
   5 months 27 days
 * Description
   The demdex cookie, set under the domain demdex.net, is used by Adobe Audience
   Manager to help identify a unique visitor across domains.

 * Cookie
   u
 * Duration
   session
 * Description
   This cookie is used by Bombora to collect information that is used either in
   aggregate form, to help understand how websites are being used or how
   effective marketing campaigns are, or to help customize the websites for
   visitors.

 * Cookie
   ajs_user_id
 * Duration
   never
 * Description
   This cookie is set by Segment to help track visitor usage, events, target
   marketing, and also measure application performance and stability.

 * Cookie
   MR
 * Duration
   7 days
 * Description
   This cookie, set by Bing, is used to collect user information for analytics
   purposes.

 * Cookie
   _hjSessionUser_*
 * Duration
   1 year
 * Description
   Hotjar sets this cookie to ensure data from subsequent visits to the same
   site is attributed to the same user ID, which persists in the Hotjar User ID,
   which is unique to that site.

 * Cookie
   _hjSession_*
 * Duration
   30 minutes
 * Description
   Hotjar sets this cookie to ensure data from subsequent visits to the same
   site is attributed to the same user ID, which persists in the Hotjar User ID,
   which is unique to that site.

Performance


Performance cookies are used to understand and analyze the key performance
indexes of the website which helps in delivering a better user experience for
the visitors.

 * Cookie
   _gat
 * Duration
   1 minute
 * Description
   This cookie is installed by Google Universal Analytics to restrain request
   rate and thus limit the collection of data on high traffic sites.

 * Cookie
   _uetsid
 * Duration
   1 day
 * Description
   Bing Ads sets this cookie to engage with a user that has previously visited
   the website.

 * Cookie
   _uetvid
 * Duration
   1 year 24 days
 * Description
   Bing Ads sets this cookie to engage with a user that has previously visited
   the website.

 * Cookie
   SRM_B
 * Duration
   1 year 24 days
 * Description
   Used by Microsoft Advertising as a unique ID for visitors.

Advertisement


Advertisement cookies are used to provide visitors with customized
advertisements based on the pages you visited previously and to analyze the
effectiveness of the ad campaigns.

 * Cookie
   li_gc
 * Duration
   5 months 27 days
 * Description
   No description

 * Cookie
   MUID
 * Duration
   1 year 24 days
 * Description
   Bing sets this cookie to recognize unique web browsers visiting Microsoft
   sites. This cookie is used for advertising, site analytics, and other
   operations.

 * Cookie
   test_cookie
 * Duration
   15 minutes
 * Description
   The test_cookie is set by doubleclick.net and is used to determine if the
   user's browser supports cookies.

 * Cookie
   _fbp
 * Duration
   3 months
 * Description
   This cookie is set by Facebook to display advertisements when either on
   Facebook or on a digital platform powered by Facebook advertising, after
   visiting the website.

 * Cookie
   personalization_id
 * Duration
   1 year 1 month 4 days
 * Description
   Twitter sets this cookie to integrate and share features for social media and
   also store information about how the user uses the website, for tracking and
   targeting.

 * Cookie
   IDE
 * Duration
   1 year 24 days
 * Description
   Google DoubleClick IDE cookies are used to store information about how the
   user uses the website to present them with relevant ads and according to the
   user profile.

 * Cookie
   tuuid
 * Duration
   1 year 1 month 4 days
 * Description
   The tuuid cookie, set by BidSwitch, stores an unique ID to determine what
   adverts the users have seen if they have visited any of the advertiser's
   websites. The information is used to decide when and how often users will see
   a certain banner.

 * Cookie
   tuuid_lu
 * Duration
   1 year 1 month 4 days
 * Description
   This cookie, set by BidSwitch, stores a unique ID to determine what adverts
   the users have seen while visiting an advertiser's website. This information
   is then used to understand when and how often users will see a certain
   banner.

 * Cookie
   ANONCHK
 * Duration
   10 minutes
 * Description
   The ANONCHK cookie, set by Bing, is used to store a user's session ID and
   also verify the clicks from ads on the Bing search engine. The cookie helps
   in reporting and personalization as well.

 * Cookie
   bku
 * Duration
   6 months
 * Description
   Bluekai uses this cookie to build an anonymous user profile with data like
   the user's online behaviour and interests.

 * Cookie
   bkpa
 * Duration
   6 months
 * Description
   Set by Bluekai, this cookie stores anonymized data about the users' web usage
   in an aggregate form to build a profile for targeted advertising.

 * Cookie
   NID
 * Duration
   6 months
 * Description
   NID cookie, set by Google, is used for advertising purposes; to limit the
   number of times the user sees an ad, to mute unwanted ads, and to measure the
   effectiveness of ads.

 * Cookie
   YSC
 * Duration
   session
 * Description
   YSC cookie is set by Youtube and is used to track the views of embedded
   videos on Youtube pages.

 * Cookie
   VISITOR_INFO1_LIVE
 * Duration
   5 months 27 days
 * Description
   A cookie set by YouTube to measure bandwidth that determines whether the user
   gets the new or old player interface.

 * Cookie
   yt-remote-device-id
 * Duration
   never
 * Description
   YouTube sets this cookie to store the video preferences of the user using
   embedded YouTube video.

 * Cookie
   yt.innertube::requests
 * Duration
   never
 * Description
   This cookie, set by YouTube, registers a unique ID to store data on what
   videos from YouTube the user has seen.

 * Cookie
   yt.innertube::nextId
 * Duration
   never
 * Description
   This cookie, set by YouTube, registers a unique ID to store data on what
   videos from YouTube the user has seen.

 * Cookie
   yt-remote-connected-devices
 * Duration
   never
 * Description
   YouTube sets this cookie to store the video preferences of the user using
   embedded YouTube video.

 * Cookie
   ln_or
 * Duration
   1 day
 * Description
   
   Set by LinkedIn. Used to determine if Oribi analytics can be carried out on a
   specific domain

 * Cookie
   li_sugr
 * Duration
   3 months
 * Description
   LinkedIn sets this cookie to collect user behaviour data to optimise the
   website and make advertisements on the website more relevant.

 * Cookie
   CMID
 * Duration
   1 year
 * Description
   Casale Media sets this cookie to collect information on user behaviour for
   targeted advertising.

 * Cookie
   CMPS
 * Duration
   3 months
 * Description
   CasaleMedia sets CMPS cookie for anonymous user tracking based on users'
   website visits to display targeted ads.

 * Cookie
   CMPRO
 * Duration
   3 months
 * Description
   CasaleMedia sets CMPRO cookie for anonymous usage tracking and targeted
   advertising.

 * Cookie
   dpm
 * Duration
   5 months 27 days
 * Description
   The dpm cookie, set under the Demdex domain, assigns a unique ID to each
   visiting user, hence allowing third-party advertisers to target these users
   with relevant ads.

 * Cookie
   ab
 * Duration
   1 year
 * Description
   Owned by agkn, this cookie is used for targeting and advertising purposes.

 * Cookie
   scribd_ubtc
 * Duration
   10 years
 * Description
   Scribd sets this cookie to gather data on user behaviour across several
   websites and maximise the relevancy of the advertisements on the website.

 * Cookie
   PREF
 * Duration
   1 year 1 month 4 days
 * Description
   PREF cookie is set by Youtube to store user preferences like language, format
   of search results and other customizations for YouTube Videos embedded in
   different sites.

 * Cookie
   __Host-GAPS
 * Duration
   2 years
 * Description
   This cookie allows the website to identify a user and provide enhanced
   functionality and personalisation.

Others


Other uncategorized cookies are those that are being analyzed and have not been
classified into a category as yet.

 * Cookie
   AnalyticsSyncHistory
 * Duration
   1 month
 * Description
   No description

 * Cookie
   _rdt_uuid
 * Duration
   3 months
 * Description
   No description available.

 * Cookie
   muc_ads
 * Duration
   1 year 1 month 4 days
 * Description
   No description

 * Cookie
   CLID
 * Duration
   1 year
 * Description
   No description

 * Cookie
   chzdpsync
 * Duration
   1 month
 * Description
   No description available.

 * Cookie
   _clck
 * Duration
   1 year
 * Description
   No description

 * Cookie
   _clsk
 * Duration
   1 day
 * Description
   No description

 * Cookie
   SM
 * Duration
   session
 * Description
   No description available.

 * Cookie
   loglevel
 * Duration
   never
 * Description
   No description available.

 * Cookie
   _zendesk_shared_session
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _zendesk_session
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _zendesk_authenticated
 * Duration
   past
 * Description
   No description

 * Cookie
   __tld__
 * Duration
   session
 * Description
   No description

 * Cookie
   r
 * Duration
   session
 * Description
   No description

 * Cookie
   docebo_session
 * Duration
   session
 * Description
   No description available.

 * Cookie
   _help_center_session
 * Duration
   session
 * Description
   No description available.

 * Cookie
   UserSettings
 * Duration
   1 year 1 month 4 days
 * Description
   No description

 * Cookie
   visitorId
 * Duration
   1 year
 * Description
   No description

 * Cookie
   _cfuvid
 * Duration
   session
 * Description
   Description is currently not available.

 * Cookie
   6suuid
 * Duration
   1 year 1 month 4 days
 * Description
   No description available.

 * Cookie
   tvid
 * Duration
   1 year
 * Description
   No description available.

 * Cookie
   tv_UIDM
 * Duration
   1 year 1 month 4 days
 * Description
   Description is currently not available.

 * Cookie
   _hjIncludedInSessionSample_2171074
 * Duration
   2 minutes
 * Description
   Description is currently not available.

 * Cookie
   ph_phc_tmyI0UQGFnLiRkVseDcCpO2vJmB1fuq8UI8XB2tmCU4_posthog
 * Duration
   1 year
 * Description
   Description is currently not available.

 * Cookie
   _an_uid
 * Duration
   7 days
 * Description
   No description available.

 * Cookie
   __Secure-YEC
 * Duration
   1 year 1 month
 * Description
   Description is currently not available.

 * Cookie
   VISITOR_PRIVACY_METADATA
 * Duration
   5 months 27 days
 * Description
   Description is currently not available.

 * Cookie
   state
 * Duration
   session
 * Description
   No description available.

 * Cookie
   pkce
 * Duration
   session
 * Description
   Description is currently not available.

 * Cookie
   cf_clearance
 * Duration
   1 year
 * Description
   Description is currently not available.

 * Cookie
   KEYCLOAK_IDENTITY
 * Duration
   past
 * Description
   Description is currently not available.

 * Cookie
   KEYCLOAK_IDENTITY_LEGACY
 * Duration
   past
 * Description
   Description is currently not available.

 * Cookie
   KEYCLOAK_SESSION
 * Duration
   past
 * Description
   Description is currently not available.

 * Cookie
   KEYCLOAK_SESSION_LEGACY
 * Duration
   past
 * Description
   Description is currently not available.

 * Cookie
   cloud.session.token
 * Duration
   past
 * Description
   Description is currently not available.

 * Cookie
   atlassian.account.ffs.id
 * Duration
   1 year
 * Description
   No description available.

 * Cookie
   atlassian.account.xsrf.token
 * Duration
   session
 * Description
   No description available.

Reject All Save My Preferences Accept All
Search
ctrlk
Sign inTry Free

Cloud
 * Getting Started with SingleStoreDB Cloud
 * Connect to Your Workspace
 * Create a Database
 * Integrate with SingleStoreDB Cloud
 * Load Data
 * Query Data
 * Manage Data
 * Developer Resources
 * User and Workspace Administration
 * Security
 * Reference
 * Release Notes
   * SingleStoreDB Cloud Release Notes
   * 8.5 Release Notes
     * Maintenance Release Changelog
   * 8.1 Release Notes
   * 8.0 Release Notes
   * 7.9 Maintenance Release Changelog (Cloud Only)
   * 7.8 Release Notes
   * 7.6 Release Notes
   * 7.5 Release Notes
   * 7.3 Release Notes
   * 7.1 Release Notes
   * 7.0 Release Notes
   * Documentation Changelog
 * Support
 * Glossary

 1. Cloud
 2. /
 3. ...
 4. /
 5. 8.5 Release Notes


8.5 RELEASE NOTES


ON THIS PAGE

 * Release Highlights
   * Indexed Approximate-Nearest-Neighbor Search
   * Query Plan Pinning
   * Extensions
   * Trace Events and Query History
   * Trace Log Rotation
   * Improved Memory Management for Resource Pools
   * Load Data Updates
 * Other Improvements and Fixes
   * Other Performance Enhancements
   * New Information Schema Views and Columns
   * New Commands and Functions
   * New or Modified Engine Variables
   * Miscellaneous
   * Changes in Patch Releases Since 8.1GA


RELEASE HIGHLIGHTS

Note

This is the complete list of new features and fixes in engine version 8.5 and
its maintenance patches. For a list of all new features and bug fixes added in
maintenance releases only, see the maintenance release changelog. If you are
upgrading from an existing 8.5 version, see the changelog for a list of new
features and fixes added to 8.5 by date.


INDEXED APPROXIMATE-NEAREST-NEIGHBOR SEARCH

A major feature introduced in this release is support for Vector Indexing.
Vector indexing allows approximate-nearest-neighbor (ANN) search to improve
performance of queries to find the top-K closest matches to a query vector.
Supported index types include inverted file (IVF), hierarchical navigable small
world (HNSW) and variants of both that use product quantization (PQ) to reduce
memory usage. ANN search enables semantic text search, retrieval-augmented
generation, and image search on larger-scale data sets more economically and
with faster response time than was previously possible. It is an important tool
to enable generative AI applications over larger data sets and with higher
concurrency.


QUERY PLAN PINNING

SingleStoreDB now offers query plan pinning. Plan pinning ensures the optimizer
will always pick a specific plan for a given query. Plan pinning allows users to
select the most effective query plans for every query in their workload.

Query plan pinning can be used to prevent query plan regression after automatic
upgrades. It can be used to avoid changes to query plans after statistics change
or global settings change that affect query plans. It can also be used to avoid
changes to query plans when a cluster is resized.


EXTENSIONS

Extensions in SingleStoreDB allow you to combine user-defined objects, such as
UDFs or UDAFs, into a packaged archive (the extension) and then create, manage,
and deploy these objects and other resources using a single command. Extensions
support both Wasm-based and PSQL functions. For more information, refer to
Extensions.


TRACE EVENTS AND QUERY HISTORY

Added the ability to trace query completions as events, which is the initial
installment of the larger event tracing framework. The Query History feature
relies on query event tracing, and can be used to display query trace events
over time. The Query History feature can therefore be used to troubleshoot and
optimize query performance, including, but not limited to, tracing and recording
expensive queries, resolving unexpected slowdowns, and viewing and optimizing
workloads in real time. Refer to Query History for more information.


TRACE LOG ROTATION

SingleStoreDB now has a built-in trace log rotation function. This is separate
from and mutually exclusive of any manual log rotation implementation already in
place, so if you want to use the new function and already have a solution in
place using logrotate or similar, you will need to disable that before enabling
this new rotation feature.

The built-in trace log rotation feature can be configured to rotate logs based
on their size, based on time, or both. You can also, optionally, configure it to
automatically delete logs after a specified number of days. The default, when
the feature is enabled, is to never delete logs.

The new trace log rotation feature is disabled by default. See Rotating Trace
Log to Manage its Size for information on how to enable and configure the new
rotation feature.


IMPROVED MEMORY MANAGEMENT FOR RESOURCE POOLS

Added the QUERY_MEMORY_PERCENTAGE option for resource pools, which restricts
memory usage in the pool on a per-individual query basis. This in contrast to
MEMORY_PERCENTAGE which restricts usage based on total memory used within the
current pool.

For example, when creating or altering a resource pool, setting MEMORY_
PERCENTAGE to 60% and QUERY_MEMORY_PERCENTAGE to 50% would configure the system
so that all queries running within the specified resource pool should together
use a maximum of 60% of system memory, and any single query running within the
pool should use, at most, 50% of system memory. Example syntax:

SQL
Copy
CREATE RESOURCE POOL rpoolmain WITH
   MEMORY_PERCENTAGE = 60,
   QUERY_MEMORY_PERCENTAGE = 50, 
   SOFT_CPU_LIMIT_PERCENTAGE = 65,
   MAX_CONCURRENCY = 40;


LOAD DATA UPDATES

SingleStoreDB now supports loading data using the Change Data Capture (CDC)
pipelines from the following data sources: MongoDB® and MySQL. Refer to
Replicate MongoDB® Collections to SingleStoreDB or Load Data from MySQL for
information on loading data from the respective data source.


OTHER IMPROVEMENTS AND FIXES


OTHER PERFORMANCE ENHANCEMENTS

   

 * SingleStoreDB now supports creating shallow copies of tables. The WITH
   SHALLOW COPY feature copies an existing table and creates a new table that
   will have the same structure as the original table. The data is not
   physically copied to the new table, but referenced against the original table
   .

   

 * SingleStoreDB now supports sorted scan query plan operators for queries
   containing ORDER BY/LIMIT clauses when utilizing flexible parallelism. Before
   this enhancement, there could be performance regressions for this query shape
   using flexible parallelism.

   

 * Improved performance when completing large sets of security operations
   (creating a lot of groups/users/roles, etc.).

   

 * Added the ability to use named argument notation when calling a PSQL SP or
   function. Can reduce total lines of code and make code more readable.

   

 * Added reduction of memory pre-allocation during columnstore JSON reads.

   

 * Added ability to check if all leaf node partitions are available, before
   processing new batches.

   

 * Addressed a table resolution issue for embedded recursive Common Table
   Expressions (CTEs).

   

Query Optimization Enhancements:

   

 * Added support for Row Count and Selectivity hints in views.

   

 * Added new join logic to recognize when a non-reference table is being joined
   exclusively to reference tables and then gather the non-reference table to
   avoid duplicating work across every partition.

   

 * Remove redundant aggregation functions and GROUP BY statements.

   

 * JSON expressions are properly pushed down.

   

 * Allow columnstore optimization for JSON_MATCH_ANY with JSON_EXTRACT in
   predicate.

   

 * Added support for hash joins on null-accepting expressions in the ON
   condition of outer joins.

   

 * Automatically rewrite A=B OR (A IS NULL AND B IS NULL) to null safe equal
   (A<=>B) so that many important optimizations (e.g. shard key joins, hash
   joins) will work.

   

 * Perform a subselect to join rewrite in an UPDATE statement when there are
   multiple columns in the subselect.

   

 * Removed some query shape lockdowns.

   

 * Added support for flipping join order for full outer join.

   
   

 * Improved performance by not executing query optimization procedures for read
   queries during the process of persistent plan cache lookup. This optimization
   strategy has resulted in improved lookup performance, leading to faster data
   retrieval operations.

   

 * Added support for statistics on correlations between columns in cases where
   highly correlated filters are used.

   

 * The Data API now supports HTTPS for connections where ssl_key is encrypted
   with ssl_key_passphrase.

   

 * Removed parametrization of LIMIT 0 and LIMIT 1 to unlock more rewrites,
   especially for subselects.

   

 * Modified computed column matching to accurately evaluate JSON expressions
   containing equality and non-safe equality comparisons.

   

 * Fixed an issue where filtering with a JSON_EXTRACT_<type> function performs
   inconsistently.

   

 * The query optimizer now considers more LEFT JOIN elimination cases.

   


NEW INFORMATION SCHEMA VIEWS AND COLUMNS

   

 * Added a new view, correlated_column_statistics, to provide metadata on
   correlated columns.

   
   

 * Added a new view, RESOURCE_POOL_PRIVILEGES, to provide information about
   resource pool grants and privileges.

   

 * Added the following new columns to MV_BACKUP_HISTORY:
   
     
   
   * error_code: Error code for failed backups.
   
     
   
   * error_message: Error message for failed backups.
   
     
   

 * Added the following new columns to MV_SYSINFO_DISK:
   
     
   
   * read_operations_cumulative_per_device: Number of read operations performed
     by the device since start up.
   
     
   
   * write_operations_cumulative_per_device: Number of write operations
     performed by the device since start up.
   
     
   
   * device_name: Name of the device to which the values in read_operations_
     cumulative_per_device and write_operations_cumulative_per_device are
     associated.
   
     
   

 * Added the following to support trace events that are used by the Query
   History feature:
   
     
   
   * MV_TRACE_EVENTS: A snapshot of all trace events, the size of which is
     dictated by the trace_events_queue_size variable
   
     
   
   * MV_TRACE_EVENTS_STATUS: A view that reflects the status of current trace
     events
   
     
   
   * LMV_TRACE_EVENTS: A snapshot of each node's trace events
   
     
   

 * Added the following new column to ADVANCED_HISTOGRAMS, L/MV_QUERY_PROSPECTIVE
   _HISTOGRAMS, and L/MV_PROSPECTIVE_HISTOGRAMS:
   
     
   
   * JSON_KEY: an entry for each (column, json_key) pair. For non-json columns
     JSON_KEY is NULL.
   
     
   

 * Added the blob_cache_miss_b and blob_cache_wait_time_ms columns to the
   following information schema views: information_schema.plancache, information
   _schema.MV_ACTIVITIES, information_schema.MV_ACTIVITIES_CUMULATIVE,
   information_schema.MV_TASKS, information_schema.MV_FINISHED_TASKS, and
   information_schema.MV_QUERY_ACTIVITIES_EXTENDED_CUMULATIVE.

   

 * Bugfix: Updated the information_schema.USERS view to reflect the account
   status for locked users.

   


NEW COMMANDS AND FUNCTIONS

   

 * Added support for the REGEXP_MATCH() function. This function returns a JSON
   array of matching substring(s) within the first match of a regular expression
   pattern to a string.

   

 * Added support for CUBE and ROLLUP grouping operations to Wasm-based
   user-defined aggregate functions (UDAFs) in SingleStoreDB. For more
   information, refer to CREATE AGGREGATE.

   

 * Added the following to support trace events that are used by the Query
   History feature:
   
     
   
   * CREATE EVENT TRACE to create a trace event
   
     
   
   * DROP EVENT to drop a trace event
   
     
   

 * Added ability to use DELETE on identical keys with the ON DUPLICATE KEY
   clause. This is in addition to existing "upsert" support with ON DUPLICATE
   KEY UPDATE. This allows new scenarios such as the ability to manage streaming
   aggregation with INSERT … ON DUPLICATE KEY UPDATE … ELSE DELETE ….

   

 * INFER PIPELINE for MongoDC CDC-in now generates tables with BSON column
   types.

   


NEW OR MODIFIED ENGINE VARIABLES

   

 * Added enable_idle_table_optimizations and enable_idle_table_eviction, which
   are used to reduce table memory overhead for idle tables on a cluster. The
   feature is enabled by default on all new and existing clusters. The variable
   enable_idle_table_optimizations needs to be set at runtime and requires a
   restart for changes to take effect. It can be set to OFF or ON (default). The
   other related variable, enable_idle_table_eviction, can be set during a
   session (though a very small amount of overhead will remain until the server
   is restarted) and can be set to Full, SkipListsOnly, and Off. It defaults to
   SkipListsOnly, which means SingleStoreDB will only evict skiplist indexes for
   idle tables on the cluster. Full means it will evict skiplists and table
   modules, and Off means no eviction.

   

 * Added privilege_caches_update_mode, which can be used to address some
   performance issues that occur when performing large sets of security
   operations (creating a lot of groups/users/roles, etc.).

   

 * Added the optimizer_use_average_rowsize engine variable which can be used to
   now allow row size estimations in query optimization costing.

   

 * The query_parallelism engine variable (which was deprecated in 8.1) now is
   non-functional. To modify Flexible Parallelism settings, use query_
   parallelism_per_leaf_core instead.

   

 * Added the use_user_provided_index_types_in_show engine variable which
   controls what will be displayed via the DESCRIBE <table_name> or SHOW COLUMNS
   syntaxes for backward compatibility.

   

 * Added the throttle_replay_behind_tail_mb engine variable which controls how
   far the system allows a child aggregator to lag behind replicating the
   transaction log of it's master aggregator before throttling is applied to the
   master aggregator.

   

 * Added the ability to use the ANALYZE command with JSON keys to create
   histograms when the new engine variable enable_json_statistics is enabled.
   The engine variable enable_json_statistics is disabled by default.

   

 * Added trace_events_queue_size to capture trace events, the first of which is
   query event tracing. This engine variable is enabled by default (set to a
   value of 16 MB, where the value must be provided in bytes). Refer to Query
   History for more information.

   

 * Added the optimizer_disable_transitive_predicates engine variable which
   disables predicate transitivity on query rewrites if set to TRUE. This engine
   variable defaults to FALSE.

   
   

 * Added a new engine variable pipelines_cdc_java_heap_size to specify the JVM
   heap size limit for CDC-in pipelines.

   

 * Added the bottomless_experimental_blobstore_mode engine variable, which when
   enabled, completes additional verification of persisted files immediately
   after upload. This mode is experimental and may reduce upload speed. Please
   use with caution.

   


MISCELLANEOUS

   

 * Enhancement: Introduced a new VECTOR datatype that is recommended over the
   BLOB datatype for vector operations and use with ANN indexes. The VECTOR type
   improves code readability, error checking, and reduces total lines of code.

   

 * Enhancement: Added support for DDL forwarding for CLEAR BACKUP_HISTORY.CLEAR
   BACKUP_HISTORY works on the DML endpoint now.

   

 * Enhancement: Improved retry logic for connection reset: write errors.

   

 * Enhancement: SingleStoreDB now natively supports the BSON data type.

   

 * Enhancement: Added support for collection.exclude.list, database.include.list
   , and database.exclude.list parameters to the CONFIG/CREDENTIAL clause of the
   CREATE AGGREGATOR PIPELINE ... AS LOAD DATA MONGODB statement. Refer to
   Replicate MongoDB® Collections to SingleStoreDB for more information.

   

 * Enhancement: Added support for Approximate Nearest Neighbor (ANN) vector
   search using inverted file (IVF) and hierarchical navigable small world
   (HNSW) indexes, and variants of them based on product quantization (PQ).
   Enables support of larger-scale semantic search and generative AI
   applications.

   

 * Enhancement: Increased name length limit to 256 characters for  tables,
   views, table columns, view columns, procedures, functions, and aliases.

   

 * Enhancement: Added the ability to truncate plancache file names if they
   exceed the operating system's specified limit (255 bytes).

   

 * Bugfix: Both SHOW PIPELINES and SELECT * FROM information_schema.pipelines
   now show consistent pipeline state information across master and child
   aggregators.

   

 * Bugfix: Specific pipeline built-ins like pipeline_source_file() and pipeline_
   batch_Id() should not be used in UPSERT clause when creating a pipeline.

   

 * Bugfix: Improved the ability to terminate expressions containing JSON
   built-ins.

   

 * Enhancement: Added error-handling details for pipelines, including state,
   error, and performance-related metrics through monitoring solutions.

   

 * Enhancement: MemSQL Procedural SQL (MPSQL) has been renamed to simply
   Procedural SQL (PSQL). The name change will only show in some SHOW command
   output and information schema views. For example, SHOW FUNCTIONS output
   changed.

   

 * Enhancement: Added support for %ROWTYPE and %TYPE for use in declaring scalar
   type variables and parameters. Employing these abbreviations in Procedural
   SQL (PSQL) can lead to a reduction in the required lines of code.

   

 * Enhancement: Introduced blob cache profiling metrics for columnstore tables
   on unlimited storage databases. Refer to the PROFILE page for more
   information on what blob cache metrics are available.

   

 * Enhancement: Added infix operators for dot_product (<*>) and euclidean_
   distance (<->).

   

 * Enhancement: Added ability to delay retry attempts for pipeline retries.

   

 * Bugfix: Updated the output for the Key_name and Index_type columns in the
   SHOW INDEX, SHOW INDEXES, and SHOW KEYS commands for primary keys on
   columnstore tables. Refer to the SHOW INDEX, SHOW INDEXES, SHOW KEYS page for
   more information.

   

 * Bugfix: Improved the error message displayed when trying to create a primary
   key on an existing table.

   

 * Bugfix: Improved the error message displayed when a GRANT command fails due
   to missing permissions. The error message will now show the missing
   permissions:
   
   SQL
   Copy
   GRANT SELECT, UPDATE, DELETE, EXECUTE ON *.* TO test2;
   
   ERROR 1045 (28000): Current user is missing UPDATE, DELETE permission(s) for this GRANT

   

 * Bugfix: Fixed a case when UNIX_TIMESTAMP() was incorrectly returning
   999999999.999999 for DATETIME datatypes with precision.

   

 * Bugfix: Fixed a potential issue that could cause a crash when SELECT INTO
   OUTFILE is run on a leaf with no context database.

   

 * Bugfix: Fixed an issue where a user could be erroneously marked as deleted.

   

 * Bugfix: Fixed an issue where a child aggregator could crash if it ran out of
   memory during query forwarding.

   

 * Bugfix: Fixed an issue with blob cache LRU2 eviction that could occur when a
   query fetches a blob, evict it, and fetches it again.

   
   

 * Bugfix: Fixed an issue that could cause information for a blob to be missing
   from an Information Schema table.

   
   

 * Bugfix: Disk Spilling now takes the resource pool settings into
   consideration.

   

 * Enhancement: Auto user creation is deprecated and the NO_AUTO_CREATE_USER
   variable is enabled by default.

   

 * Bugfix: Fixed an erroneous access denied issue to views selecting from shard
   tables with computed columns.

   

 * Bugfix: Fixed a rare issue where the incorrect timezone could be used in
   logging.

   

 * Bugfix: Fixed an issue where using user-defined variables inside ORDER/GROUP
   BY statements could cause a crash.

   

 * Enhancement: Added column name to error messages when invalid date/time is
   inserted into a column.

   

 * Enhancement: Added BSON columnstore functionality over Parquet storage.

   

 * Enhancement: Added support for SELECT ... INTO KAFKA using OAUTH credentials.

   

 * Bugfix: Prevent the ability to create a Kafka Pipeline using Parquet Format.

   

 * Bugfix: Queued Time is now excluded from the cost estimate for workload
   management leaf memory.

   

 * Bugfix: Specific error messages are now logged for GCS subprocess failures.

   

 * Bugfix: JSON_KEY escape characters were not working as expected.

   

 * Bugfix: ALTER PIPELINE setting max_partitions_per_batch to use a default 0
   value is now allowed.

   

 * Enhancement: Improved performance for JSON_EXTRACT_<type> built-ins in ORDER
   BY clauses.

   

 * Bugfix: Fixed an issue where INSERT...SELECT queries with a partition_id()
   filter generating an error.

   

 * Bugfix: Fixed an issue with memory crashing when using REGEXP_MATCH, JSON_
   INCLUDE_MASK, or JSON_EXCLUDE_MASK built-ins.

   

 * Enhancement: Improved performance by optimizing joins on TABLE(JSON_TO_
   ARRAY()) queries.

   

 * Enhancement: Now suppressing a harmless traceSuspiciousClockUpdate trace
   message during recovery.

   

 * Enhancement: Added the ability for users to kill queries on a remote node
   without the user having PROCESS privileges.

   

 * Bugfix: Fixed an allocation issue that caused poor performance on high load
   insertion queries.

   

 * Enhancement: Enabled support for external UDFs used in INSERT statements with
   multiple VALUE clauses.

   

 * Enhancement: Added BSON fundamentals and column type support for SingleStore
   Kai.

   


CHANGES IN PATCH RELEASES SINCE 8.1GA

Several features have been added since the GA release of 8.1 (8.1.2).
 Particularly notable ones include Tracelog Rotation, renaming MPSQL to PSQL,
and the 8.1 data_conversion_compatibility_level; however, there are others.
Please refer to the 8.1 Release Notes or maintenance release change log for
additional details.


IN THIS SECTION

 * Maintenance Release Changelog

Last modified: January 25, 2024


WAS THIS ARTICLE HELPFUL?


SingleStoreDB Cloud Release Notes
Maintenance Release Changelog


PRODUCT

 * Product Overview
 * Solutions
 * Pricing
 * Support


COMMUNITY

 * Forums
 * Developer Hub
 * Events
 * Training


COMPANY

 * Contact Us
 * Blog
 * Careers
 * SingleStore Connect

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of
Service apply.

 * © SingleStore

 * |

 * Privacy Policy

 * |

 * Terms of Service

 * |

 * Legal Terms and Conditions


ON THIS PAGE

 * Release Highlights
   * Indexed Approximate-Nearest-Neighbor Search
   * Query Plan Pinning
   * Extensions
   * Trace Events and Query History
   * Trace Log Rotation
   * Improved Memory Management for Resource Pools
   * Load Data Updates
 * Other Improvements and Fixes
   * Other Performance Enhancements
   * New Information Schema Views and Columns
   * New Commands and Functions
   * New or Modified Engine Variables
   * Miscellaneous
   * Changes in Patch Releases Since 8.1GA


WAS THIS ARTICLE HELPFUL?



Cloud


RECENTLY VIEWED

 1. 8.5 Release Notes
    
    
    
     1. Cloud
     2. /
     3. Release Notes
    
    


to select

to navigate
esc
to close



Please accept the cookie consent