SingleStore Studio Release Notes
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
2024-06-04 Version 4. 1. 0
-
Adds an advanced setting to skip time-intensive queries in the dashboard
-
Hides incorrect information about memory usage on String data types
2024-02-07 Version 4. 0. 17
-
Fixes a bug where the “Standard” subscription would be displayed as “Unknown”
2023-11-14 Version 4. 0. 16
-
Fixes a bug where the Studio and database engine upgrade banners would not be displayed
2023-10-27 Version 4. 0. 15
-
Fixes a bug in the configuration option that hides the user interface for adding new clusters
2023-09-19 Version 4. 0. 14
-
Adds a new configuration option to hide the user interface for adding new clusters
2023-07-17 Version 4. 0. 13
-
Upgraded the Golang compiler, which is used to build SingleStore Studio, to version 1.
20. 5.
2023-06-15 Version 4. 0. 12
-
Adds a new “disableUITelemetry” property to the Studio configuration file to disable external requests
2022-12-15 Version 4. 0. 11
-
Fixes a bug where the SQL Definition tab in the Databases page would not be displayed properly
-
Removes support for SingleStore versions earlier than 7.
1
2022-11-29 Version 4. 0. 9
-
Fixes connection validations for SingleStore Helios users.
This has no impact for self-managed users of Studio.
2022-06-14 Version 4. 0. 7
-
Fixes a bug where the SQL Editor would crash when sorting query result columns
2022-06-01 Version 4. 0. 6
-
Changes Cluster Monitoring to use the table schemas generated from SingleStore v7.
8. 2 -
Fixes a bug in the Active Queries page where the query time would be displayed incorrectly
-
Minor style fixes
2022-04-27 Version 4. 0. 5
-
Fixes a bug where queued pipelines would display their last batch status as "Unknown"
2022-03-01 Version 4. 0. 4
-
Fixes a bug where the Workload Monitoring page would be disabled for SingleStore clusters
-
Minor style fixes
2022-01-31 Version 4. 0. 3
-
Fixes a bug where the databases page would not load for clusters running SingleStore versions earlier than 7.
5 -
Fixes a bug where the Table page would crash
2022-01-26 Version 4. 0. 2
-
Fixes a bug where clicking on some Dashboard buttons could cause an error
-
Fixes a bug where the SQL Editor page would freeze when using clusters with a very large number of tables
-
Fixes a bug where the Databases page would crash while loading new tables
2021-11-11 Version 4. 0. 1
-
Fixes a bug where Historical Monitoring was not displaying any results
-
Fixes a bug where the Databases page would sometimes stop working
-
Fixes a bug where the cluster schema did not update based on the connected cluster
-
Simplifies the Help menu and removes tutorials
-
Improves Visual Explain panning
2021-09-21 Version 4. 0. 0
-
Removes support for SingleStore versions earlier than 7.
0 -
Tutorial content updates
-
Fixes a bug where queries would occasionally appear without any information on the Workload Monitoring page
-
Fixes a bug where the license expiration date was not reported correctly
-
Minor style fixes and other improvements
2021-06-23 Version 3. 2. 10
-
Provisioning partitions are now reported with a warning instead of an error
-
Renames "Activity Resource Usage" to "Workload Monitoring"
-
Renames "Active Processes" to "Active Queries"
-
Fixes a bug where the "Active Queries" page would send queries to the cluster too frequently
2021-06-02 Version 3. 2. 9
-
Adds a refresh button on Activity Resource that updates the date for the time period selected
-
Adds validation to ensure that a monitoring database name is defined for monitoring clusters
-
Fixes a bug where some warnings appeared without a description in the Visual Explain page
-
Fixes a bug where some external links were not working
-
Fixes a bug where the
information_
database would crash the Databases pageschema -
Fixes a bug where the disk usage in the Databases page would not be displayed for empty databases
-
Fixes a bug where the Help menu incorrectly displayed that it was offline
-
Fixes a bug where the SQL Editor tabs could not be closed
-
Minor style fixes
2021-05-18 Version 3. 2. 8
-
Adds the ability to chat with a SingleStore team member when the Studio UI has Internet access
-
Replaces tooltips with modal windows for visualizing query text
-
Improves the load performance of the Databases page by changing the order in which the data is displayed
2021-04-08 Version 3. 2. 6
-
Fixes some code samples in the Tutorials that were not working on Windows
-
Fixes a bug where the dashboard was not being populated due to a timeout error
-
The Message Logs tab in the SQL Editor now remains open when clicked, even while new queries are run
-
Minor styling fixes
2021-03-23 Version 3. 2. 5
-
Fixes a bug where the Console was not displaying results
-
Fixes a bug where the Activity Resource Usage page would not display if one or more activities did not have a MemSQL ID
-
Adds a warning message when a query is executed for the first time in Visual Explain
-
Fixes a bug where dates were not being displayed in ISO format
-
Adds the ability to use Profile Execution time from a JSON file in SingleStore v7.
0 or higher -
Adds the ability to paste a JSON file into Visual Explain
-
Fixes some code samples in the Tutorials that were not working on Windows
-
Fixes a bug where the
PROFILE
SQL statement was running with a row limit -
Adds Total Network Traffic metric to the Visual Explain sidebar
-
Adds a confirmation modal when changing pages during a tutorial
-
Sorts activities in Activity Resource Usage by CPU usage by default
-
Minor styling fixes
2021-02-15 Version 3. 2. 3
-
Fixes a bug where a tutorial was incorrectly marked as completed
-
Styling changes to allow for a more compact UI
-
Minor styling fixes
-
Adds warning when the profile of a query includes its compile time
-
Adds ability to configure TLS version and TLS cipher suite for Studio
2021-02-04 Version 3. 2. 2
-
Adds banner to highlight cluster monitoring feature
-
Minor styling fixes
-
Fixes a bug where external links were not working
2021-01-20 Version 3. 2. 1
-
Adds pipeline and database name validation to the tutorials
-
Fixes timezone issue in the Activity Resource Usage page
-
Minor styling fixes
-
Adds quick start tutorial to the tutorial homepage
-
Adds interactive tutorials for loading data
-
Fixes a bug that caused the AdTech tutorial to not load
-
Fixes a bug where running certain queries in the SQL Editor would error with
Multiple statements detected in a single query
2021-01-08 Version 3. 2. 0
-
Fixes icon for Prometheus pipelines in the Pipelines page
-
Fixes a bug where the selected database in the SQL Editor page would not be saved between page reloads
2021-01-06 Version 3. 1. 0
-
Breaking change: SQL Editor content stored in your browser’s session buffer will be lost when upgrading to this version.
SingleStore recommends saving it so you can manually restore it. -
Adds support for historical Activity Resource Usage via SingleStore Studio.
-
Various Tutorial UI fixes and improvements
2020-11-19 Version 3. 0. 0
-
Removes support for MemSQL 6.
7. x versions -
Fixes a bug in the SQL Editor where queries that took more than a certain amount of time would never return results
-
Adds checkable sections to the tutorials in the Tutorial UI that allow users to keep track of their progress throughout the guides
-
Adds new data (Elapsed Time and Lock Time) to the Activity Resource Usage table
-
Fixes a bug where the Tutorial UI would be displayed over the Run button in the SQL Editor
2020-10-27 Version 2. 0. 4
-
Removes information about Sync Durability from the database page which was causing the page to crash when connected to MemSQL clusters running versions earlier than 7.
0
2020-10-26 Version 2. 0. 3
-
Adds database filter to the Activity Resource Usage page
-
Fixes a bug where SQL Editor content would scroll down when the page loads
-
Adds a minimize button to the Tutorial UI
-
Adds SQL previews to the Tutorial UI
-
(Preview) Adds support for exposing MemSQL’s SAML authentication via the UI
-
Fixes a bug where certain special characters in a cluster’s description would cause Studio to crash on load
-
Adds information about Sync Durability to the database page
-
Truncates the query text in a query error when it exceeds a certain length
-
Adds total disk available and total memory available to the Dashboard page
-
Rebrands the UI as
SingleStore Studio
2020-09-23 Version 2. 0. 2
-
Fixes a bug where
studio.
could not connect to SingleStoreclusters.memsql. com This has no impact for self-managed users of Studio.
2020-09-23 Version 2. 0. 1
-
Improves the performance of the
Databases
page -
Changes the result columns of the SQL Editor to automatically adjust the width to match the content
-
Adds
About
page link to the Help menu -
Adds a progress indicator to the minimized tutorial button
-
Fixes a bug where the tutorial UI would close unexpectedly when a user clicked outside of it
-
Fixes a bug where the monitoring charts in the
Nodes
andHosts
pages would not be displayed -
Fixes errors related to preloading static assets
-
Adds Prometheus
/api/metrics
endpoint to thesinglestoredb-studio
server -
Fixes a bug where Studio wouldn’t function on earlier versions of Firefox
-
Updates the the sidebar to auto-collapse when the SQL Editor is opened
-
Improves the UI on the
Databases
page for visualizing the SQL statements for tables and views -
Adds a notification when copying code from the tutorial UI
-
Changes the
Activity Resource Usage
page to allow browsing all activity types in addition to queries
2020-08-21 Version 2. 0. 0
-
Removes support for MemSQL 6.
5. x versions -
Incorporates visual improvements to the Help menu
-
Improves the the SQL Editor functionality where a new tab is now opened when a new query is run
-
Adds a new
Message Logs
tab in the SQL Editor that contains information about each query that’s been run during the session -
SQL Editor scroll and cursor position are now saved across pages and sessions
2020-08-06 Version 1. 9. 8
-
SQL functions and keywords now appear as autocomplete suggestions in the SQL Editor
-
Fixes a bug when parsing zero-width characters in the SQL Editor
-
Allows MemSQL users that have been configured with Kerberos/GSSAPI to sign in
-
Adds new columns to the
Partitions
page for each database -
Adds support for serving the Studio front end under a specific URL prefix
-
Improves the performance of the
Databases
page in clusters where queryingINFORMATION_
would typically take an extended time to returnSCHEMA. COLUMN_ STATISTICS -
Fixes a bug where loading the same file in the SQL Editor more than once in the same session would not work
2020-07-09 Version 1. 9. 7
-
Adds a Settings modal with an option for configuring the number of rows returned for queries run in the SQL Editor
-
Adds a new tutorial to the Tutorial side panel
-
Improves the SQL Editor to persist the selected database in the SQL Editor across sessions
-
Adds tooltips that help explain Compression Ratio
-
Improves the sidebar to persist its width across sessions
-
Adds support for directly connecting to MemSQL clusters via WebSocket
-
Adds a banner notification to alert users when a new version of MemSQL is available
2020-05-06 Version 1. 9. 6
Bug fixes
-
Fixes a bug where the
Stock Trade Database
tutorial would error while starting a pipeline -
Fixes a bug where Studio could potentially send too many repeated connections to the cluster
-
Stops warning users about an incorrect replication type on replica partitions for databases marked as replicas
-
Fixes a bug where the
Sample Data
tab in theDatabases
page would crash if a user back-navigates -
Fixes pipeline icons for MemSQL clusters above version 7
Performance improvements
-
Reduces the bundle size of the Studio web application by 3x, decreasing the time it takes for the UI to initially load
UX improvements
-
Improves number formatting of byte-type values to better display large numbers
-
Improves time formatting to show seconds rather than fractions of a minute
-
Adds support for hours in the resource usage counter
-
[Self-managed] - Improves error message when Studio is unable to connect a cluster
-
[Self-managed] - Improves message when removing cluster from Studio
2020-01-22 Version 1. 9. 5
-
Adds support for serving the User Interface with HTTPS (via TLS)
-
Fixes a bug in the sorting of the “Partition Instance Status“ column in the “Nodes“ table
-
Fixes a bug in the sorting of dates in the “Events“ and “Pipelines“ tables
-
Fixes a bug where the “SQL_
MODE“ was not being properly configured when issuing queries to MemSQL -
Adds support for invalid cluster profiles in the Studio configuration file
-
Adds “Disk Usage“ information to columnstore secondary indexes
2019-12-17 Version 1. 9. 4
-
Adds
rows read per second
androws written per second
to the dashboard -
Adds a new Projections section to the Visual Explain sidebar
-
Modifies the Visual Explain feature to display the query text from the plan text file
-
Adds
table compression
to the table page in the Schema Explorer -
Fixes a bug where dates would be incorrectly formatted in the Sample Data tab in the Schema Explorer
2019-11-26 Version 1. 9. 3
-
Adds support for visualizing query output for those queries that return multiple tables in the Console
-
Adds the ability to copy the query column to the clipboard in the Active Processes page
-
Fixes a bug in the SQL Editor that prevented the cursor from selecting the results table scrollbar
-
Fixes a bug where data would stop loading when changing pages due to the lack of available connections
2019-11-06 Version 1. 9. 2
-
Displays an error on the console and in the SQL Editor if the connection is dropped while a query is being run
-
Adds warnings to the Databases page if the databases appear to be offline due to insufficient permissions
-
Adds various warnings to Visual Explain
-
Fixes a bug where node CPU usage was calculated incorrectly
-
On the Databases page, shows how many nodes a database occupies
2019-10-15 Version 1. 9. 1
-
Adds two tutorials to help users load data into a cluster
-
Adds support for PAM authentication
-
Fixes a bug where live monitoring would show perpetual loading bars for CPU Usage
-
Updates definition for
Disk Read
column on Resource Usage page
2019-09-20 Version 1. 9. 0
-
Adds a tutorial to the user interface.
The tutorial helps users load data into a cluster -
Fixes a bug where the
Save as CSV
button in the SQL Editor would disappear from the user interface
2019-09-06 Version 1. 8. 2
-
Fixes a bug where closing the Studio upgrade notification would cause the UI to crash the next time Studio loads
-
Visual refactor to the help links on the Sidebar
2019-09-04 Version 1. 8. 1
-
Adds result tabs to the SQL Editor’s output pane
-
Disables the bottom panel from appearing when queries fail in the SQL Editor
-
Visual refactor to the table page in the Schema Explorer
-
Fixes a bug where tables with a date column would crash the Sample Data tab on the table page
2019-08-23 Version 1. 8. 0
-
Adds new Active Processes page where queries currently running in MemSQL can be explored
-
Improves the load time of the Studio application by a factor of four by compressing static assets with gzip
-
Improves the performance of the Databases page for MemSQL clusters running MemSQL 6.
7. 11 or higher -
Fixes a bug where the Pipelines page would not load on some MemSQL clusters
-
Adds more information to the query error dialog box in the SQL Editor
-
Separates the SQL Editor Results user interface into two tabs (one for logs and one for query results)
-
Changes the placement of the
Save as CSV
button to make it closer to the query results in the SQL Editor -
Removes the pagination of SQL Editor results
-
Fixes a bug where some tabs would not be properly marked as active/inactive
-
General improvements to the checkbox component style
2019-08-12 Version 1. 7. 1
-
Updates look to match the new MemSQL brand
-
Fixes a bug where the Visual Explain tree would not be visible when loading it from the SQL Editor
-
Fixes a bug where drag handles would be visible on top of modals
2019-08-06 Version 1. 7. 0
-
Adds Physical Monitoring metrics to clusters running on versions of MemSQL 6.
8. 6 or higher -
Adds support for double clicking column header edges to auto-resize them
-
Adds a database selector dropdown to the SQL Editor
-
Adds support for resizing the results pane and the Schema Tree pane in the SQL Editor
-
Adds support for searching in the SQL Editor Schema Tree
-
Improves performance of table rendering across all pages
-
Adds support for disabling current sort state on a table’s column
-
Fixes some small visual bugs
2019-06-17 Version 1. 6. 3
-
Fixes a bug where the SQL Editor would disappear on very recent versions of Google Chrome
-
Improves the Studio browser logs to be more detailed when errors occur
-
Fixes the calculation of total time in Visual Explain nodes to include network time and CPU time
-
Displays CPU time as its own metric in Visual Explain nodes
2019-05-03 Version 1. 6. 2
-
Adds new dashboard design with a focus on the health status of various logical components of the cluster
-
Persists the selected database in the SQL Editor and the Bottom Panel console across reconnects in the same session
-
Implements a notification system that informs users about new Studio versions
-
Adds more information to nodes, databases, and partitions in their respective pages
-
Replaces the
topology
URL withnodes
-
Fixes a bug where the query results would be incorrect for queries that return more than one column with the same name
-
Fixes a visual bug where resizing table columns would affect other columns
-
Fixes a visual bug where the schema tree on the SQL Editor would be cut off vertically
-
Fixes a visual bug with long cluster titles in the clusters list page
-
Fixes a visual bug where enabling columns in the Resource Usage page would break some columns’ widths
2019-05-02 Version 1. 6. 0
-
Adds hosts page with host-level information
-
Adds partition and partition instance data to the Schema Explorer
-
Improves the performance of the Schema Explorer by not blocking on columnar segments data
-
Adds support for deleting clusters from the Studio UI
-
Adds a refresh button to the schema tree in the SQL Editor
-
Various visual updates and styling improvements to the sidebar
-
Adds Studio version card to the About page
-
Fixes a visual bug in the cluster switcher dropdown
-
Various visual improvements to the Schema Explorer pages (e.
g. , new tab styling, new circle indicator styling)
2019-03-15 Version 1. 5. 6
-
Fixes a bug where users without read permissions on all databases could not view any schema data
-
Fixes a bug where Stored Procedures would not show up on clusters running versions 6.
7. 11 or higher -
Fixes a bug where the query editor buffer would not be saved on some connections
-
Fixes a bug in auto-connect
-
Fixes a bug where the Dashboard would crash when the High Availabilty query failed
-
Fixes a visual alignment issue in the connect to cluster page
-
Adds support for unit licensing
-
Fixes how long cluster names are displayed on the sidebar
2019-02-28 Version 1. 5. 5
-
Cluster creation via the UI can be disabled via the
disableClusterMutations
flag in the config -
Fixes bug with long hostnames in the UI
2019-02-28 Version 1. 5. 4
-
Broken release - skip to 1.
5. 5 -
If you have trouble upgrading to 1.
5. 5 from 1. 5. 4, remove the line allowClusterMutations
from the Studio config file.
2019-02-07 Version 1. 5. 3
-
Adds support for resizing columns in all of the tables in the UI
-
Fixes a bug where older browsers would not be able to load Studio
-
Fixes a bug where the SQL Editor content would not be persisted across sessions after logging out from a cluster
-
Fixes a bug where the
Leave Site
alert would not be disabled in the connect pages after logging out from a cluster
2019-01-23 Version 1. 5. 2
-
Fixes a few memory leaks in older versions of Chrome and Firefox
-
Fixes a bug where double clicking table cells would select more than one cell
-
Fixes a bug where the singlestoredb-studio server would not immediately error when it fails to bind the desired port
-
Adds support for importing version 3 plan files in Visual Explain
-
Fixes extra bottom padding at the bottom of the SQL Editor page on Firefox
-
Fixes a bug where the global SQL MODE on some clusters could break queries that Studio runs
2019-01-14 Version 1. 5. 1
-
Fixes page load crash on older browsers
-
Correctly shows the Unsupported Browser page on unsupported browsers
-
Fixes a bug where the Resource Usage page would incorrectly label some partitions
-
Fixes how large numbers are rounded and displayed across the application (Visual Explain, Schema Explorer)
2019-01-09 Version 1. 5. 0
-
Adds a menu item to the SQL Editor for exporting query results as CSV
-
Improves the performance of the SQL Editor
-
Revamps the infrastructure of the SQL Editor and adds Find/Replace
-
Fixes the display of the
SHOW CREATE
buttons in the Schema Explorer to only show while hovered -
New feedback dialog box integrated with the SingleStore Forums
2018-12-04 Version 1. 4. 0
-
Adds information about Stored Procedures, UDFs, UDAFs and Pipelines to the Schema Explorer
-
Adds the ability to see the
SHOW CREATE
statement of any Pipeline -
Adds new data from query plans in the Visual Explain sidebar
-
Fixes a bug where JSON-type columns were incorrectly displayed in the Schema Tree
-
Updates Visual Explain executor icons
-
Fixes a bug where switching to the Connection tab in the bottom panel would reload certain pages
-
Fixes a bug where the bottom panel’s console was not focused when opened
-
Fixes a bug where the Schema Explorer would not work if there were any UDAFs in the cluster
-
Fixes a bug where the Visual Explain sibling order was not correct for certain plans
2018-11-20 Version 1. 3. 4
-
Fixes a bug where the Schema Explorer would crash on clusters with particular schemas
-
Fixes a bug where reloading the
Nodes Status
page would reset the sorting order of the table
2018-11-05 Version 1. 3. 2
-
Fixes input not being focused when opening console in bottom panel
-
Fixes error when rendering the Sample Tab for a table with a blob type column
-
Adds default order by role in
Nodes Status
page
2018-11-01 Version 1. 3. 1
-
Fixes
/var/lib/memsql-studio
being incorrectly owned by theroot
user in RPM installs -
Fixes error when connecting to a new cluster as a user with a password
2018-10-31 Version 1. 3
-
Adds a Sample Data tab to tables and views in the Schema Explorer
-
The SQL Editor’s buffer is now persisted between page reloads
-
Fixes a bug where the SQL Editor and console connections would not restore after the connection to the MemSQL cluster is dropped
-
Fixes the error codes shown to users in the SQL Editor and the console to match MemSQL’s error codes
-
Shows an error message instead of
No Databases
if fetching schema tree database information fails -
Fixes various small visual inconsistencies in the icons and text of Visual Explain
-
Adds support for clicking on the entire top bar of the bottom panel to resize it
-
Adds CPU Usage as a default column in Resource Usage
2018-10-02 Version 1. 2
-
Adds support for MemSQL 6.
7 clusters -
Adds support for both EXPLAIN and PROFILE plans generated by MemSQL 6.
7 -
Updates Visual Explain icons
-
Fixes bug with parsing subselects in query plans
-
Modals can now be closed by clicking outside them
-
Adds support for reading long cluster titles in the sidebar
-
Clicking on the MemSQL icon now goes to the Dashboard
-
Clicking on the cluster name in the sidebar now opens the Cluster Switcher dropdown
-
Increases the number of results shown per page in the SQL editor to 30
2018-08-31 Version 1. 1
-
Adds Visual Explain — a new feature which allows users to visually analyze query plans (either PROFILE or EXPLAIN outputs)
-
Adds ability to load and save SQL files into the SQL Editor
-
Fixes a bug where users could submit the Add New Cluster form before it was filled in
-
Fixes the calculation of some metrics in Schema Explorer
-
Adds commands to the CLI that return the Studio’s version and commit hash
-
Adds Studio’s commit hash to the UI
-
Fixes the default config file to be valid HCL
-
Fixes small styling issues across all pages
-
Fixes small bugs across all pages
Last modified: June 4, 2024