Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

MemSQL Studio Release Notes

Maintenance Release Changelog

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 SingleStore DB 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
  • (Beta) Adds support for exposing SingleStore DB’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 SingleStore Managed Service clusters. This has no impact for on-premises users of SingleStore DB/MemSQL/MemSQL 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 the memsql-studio server
  • Fixes a bug where MemSQL 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 SingleStore DB 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 MemSQL 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 return
  • 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 clusters via WebSocket
  • Adds a banner notification to alert users when a new version of SingleStore DB is available

2020-05-06 Version 1.9.6

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
  • [On-premise] - Improves error message when Studio is unable to connect a cluster
  • [On-premise] - Improves message when removing cluster from Studio

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

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 SingleStore DB/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 SingleStore DB/MemSQL can be explored
  • Improves the load time of the MemSQL Studio application by a factor of four by compressing static assets with gzip
  • Improves the performance of the Databases page for clusters running MemSQL 6.7.11 or higher
  • Fixes a bug where the Pipelines page would not load on some 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 with nodes
  • 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 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 MemSQL 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 memsql-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-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 the root 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 cluster is dropped
  • Fixes the error codes shown to users in the SQL Editor and the console to match SingleStore DB’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 MemSQL Studio’s version and commit hash
  • Adds MemSQL 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 MemSQL Studio.