Outdated Version
You are viewing an older version of this section. View current production version.
MemSQL Studio Release Notes
Maintenance Release Changelog
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
- Fixes icon for Prometheus pipelines in the Pipelines page
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 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 thememsql-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 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 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 theroot
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.