SingleStoreDB Studio Release Notes
Maintenance Release Changelog
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 SingleStoreDB versions earlier than 7.1
2022-12-05 Version 4.0.10
Fixes connection validations for SingleStoreDB Self-Managed users.
2022-11-29 Version 4.0.9
Fixes connection validations for SingleStoreDB Cloud users. This has no impact for self-managed users of Studio.
2022-10-06 Version 4.0.8
Fixes a bug where some data would not be displayed on the Pipelines page
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 SingleStoreDB 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 SingleStoreDB clusters
Minor style fixes
2022-01-31 Version 4.0.3
Fixes a bug where the databases page would not load for clusters running SingleStoreDB 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 SingleStoreDB 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-30 Version 3.2.11
Fixes a bug where the Active Queries page was not displaying all queries
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_schema
database would crash the Databases pageFixes 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.7
Fixes a bug in the Help menu
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 SingleStoreDB 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 limitAdds 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-18 Version 3.2.4
Fixes a bug where the automatic SQL Editor reconnection could fail.
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. We recommend saving it so you can manually restore it.
Adds support for historical Activity Resource Usage via SingleStoreDB 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.memsql.com
could not connect to SingleStoreDBclusters. 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” and “Hosts” pages would not be displayed
Fixes errors related to preloading static assets
Adds Prometheus
/api/metrics
endpoint to thesinglestoredb-studio
serverFixes 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 querying
INFORMATION_SCHEMA.COLUMN_STATISTICS
would typically take an extended time to returnFixes 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 the “Databases” 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” and “rows 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-03 Version 1.6.1
Fixes visual bug with long cluster titles on the sidebar
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 configFixes 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 hoveredNew 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 PipelineAdds 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-06 Version 1.3.3
Fixes binary data conversions
Added support for displaying free licenses
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 installsFixes 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
2018-08-06 Version 1.0.1
Initial release of SingleStoreDB Studio.