MemSQL Studio Release Notes


MemSQL Studio is designed to work with MemSQL 6.5 or later and is only supported on Chrome and Firefox browsers at this time.

Maintenance Release Changelog

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.
Was this article useful?