You are viewing an older version of this section. View current production version.
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 could not connect to Helios clusters. This has no impact for on-premises users of 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 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 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 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

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

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