Maintenance Release Changelog

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 with SingleStore DB Monitoring.
• 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
• (Beta) 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 SingleStore Managed Service 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 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 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.