Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.
sdb-admin snapshot-databasecommand to create database snapshots
sdb-admin restart-nodeand the
sdb-admin stop-nodecommands to create snapshots of databases before restarting or stopping a node
nodes.hclfiles to the output of the
MemoryUsagefields to the backup cache
--onlineflag in the
sudomessage in the Toolbox commands
defaultWorkloadManagementchecker to be more consistent
sdb-report collect --mask-ipcommand that would cause an error when collecting report information for a stopped node
sdb-deploy setup-clustercommand when an environment validation fails due to different users owning data directories of a node
--mask-ipflag to the
sdb-report collectcommand to mask sensitive data in the report files, such as IP addresses, MAC addresses, usernames, and passwords
rolecolumn to the
mv_nodestable for population by the monitoring pipeline
sdb-admin enable-nodes-autostartcommand to enable nodes autostart on system reboot
partitionsStartcollectors in the
memsql-reportcommand to be excluded by default
analyzeTablecollector in the
consistent_maximum_memorychecker from kilobytes (KB) to megabytes (MB)
sdb-deploy setup-clustercommand that would sometimes place the
memsqlctl.hclfile in an incorrect folder
sdb-toolbox-config state, the
sdb-deploy state, the
sdb-admin state, and the
sdb-report statecommands to display the Toolbox state from the
--preinstalled-pathflag to the
sdb-deploy cluster-in-a-box, and the
sdb-deploy setup-clustercommands to specify the folder where a
.tarfile has been extracted as an install target
networdBuffersMaxchecker to the
sdb-reportcommand to check that the
rmem_maxvalues are at least 8MB
--config-fileflag to the
sdb-admin send-alertcommand to specify a YAML file containing both the location and the thresholds as an alternative to using the
--monitoring-versionflag to the
sdb-admin start-monitoringcommand to specify a
memsql-serverversion to pass to the
--batch-intervalflag to the
sdb-admin start-monitoringcommand to specify a time interval between data extractions
--high-cardinality-metricsflags to the
sdb-admin start-monitoringcommand to enable the collection of additional monitoring data
sdb-admin start-monitoringcommand to support features introduced in the SingleStore DB 7.3 version of the
mallocActiveMemorychecker to fail if
malloc_active_memoryis greater than 5GB (up from 2GB)
diskInodesUsagecheckers in the
sdb-report checkcommand to not report high usage on loopback filesystems
sdb-report collectcommand to not output a stack trace when a collection error is encountered
sdb-deploy upgradecommand that would sometimes cause aggregator actions to be displayed in an incorrect order during a dry run
processFilescollector to the
memsql-reportcommand to collect all
/proc/<pid>/*files for the
autoAttachchecker to the
memsql-reportcommand to warn if the
auto_attachengine variable is not set to
--preinstalled-pathflag to the
memsql-deploy upgradecommand to specify the folder as an upgrade target where a
.tarfile has been extracted
memsql-deploy uicommand when registered hosts are detected
osReleasecollector to the
memsql-reportcommand to check that
cgroup memoryis disabled for Red Hat 7.x or later
memsql-report send-alertcommand to automatically run
memsql-report collect-and-checkand alert on fails or warnings
memsql-admin start-monitoringcommand when the exporter host is inaccessible from other hosts
memsql-report collectand the
orchestratorProcesseschecker to include each process in the report only once, even if more than one instance of the process is running on the host
memsql-deploy setup-clustercommand to check that all of the nodes that will be registered have the correct file permissions and owner
schemacollector to include views definitions, and improved how functions, procedures, and error messages are displayed
memsql-deploy setup-clustercommand to set the
secure-file-privengine variable to a default path of
<memsqlctl's-default-install-dir>/db_filesfor each newly-created node
memsq-admin restart-nodecommand that would sometimes display an incorrect error message
clusterMemoryUsagechecker that would produce incorrect output
memsql-admin enable-high-availabilitycommand that would sometimes cause a kernel panic if Toolbox is configured incorrectly
memsql-adminbackup-related commands when the
--repositoryflag contains an invalid value
memsql-report check --validate-envcommand would crash when a host has TarInstallDir defined and
installedPermissionschecker and collector to the
memsql-reportcommand to verify that cluster files and directories have the correct permissions
--skip-validate-envflag was ignored by the
--data-dirflag to the
memsql-deploy setup-clustercommand for specifying the absolute path to each node’s data directory (DataDir)
memsql-deploy uicommand to support pre-deployment environmental checks
memsql-admin restart-node --onlinecommand to inform the user that relevant nodes must be running to perform the restart
memsql-deploy upgradecommand that incorrectly determined that all columnstore tables could be safely upgraded
memsql-admin sync-ldapcommand to synchronize LDAP users and groups with SingleStore DB/MemSQL database users
memsql-report collectcommand that displays the number of collectors that will be executed
memsql-admin query --row-timeoutcommand was not taken into account by the command
clusterMemoryUsagechecker to the
memsql-report checkcommand to determine if there is at least 10% of unused memory left for each node
diskInodesUsagechecker to the
memsql-report checkcommand to determine if there is at least 15% of unused disk inodes left on each host
dmesg -Tcommand was not executed while collecting reports with the
diskLatencyReadchecker to the
memsql-report checkcommand to determine if the disk read latency is below the recommended threshold on each host
diskLatencyWritechecker to the
memsql-report checkcommand to determine if the disk write latency is below the recommended threshold on each host
memsqlctl unregister-nodecommands to unregister nodes in Toolbox
majorPageFaultschecker and collector to the
memsql-reportcommand to verify if the number of major page faults that the system generates per second is lower than a specific threshold
swapUsagechecker and collector to the
memsql-reportcommand to verify if the swap usage is lower than a specific threshold
cpuIdlechecker and the
cpuUtilizationcollector to the
memsql-reportcommand to verify if the percentage of time the CPUs have been idle is higher than a specific threshold
memoryCommittedchecker and collector to the
memsql-reportcommand to verify if the percentage of memory required for a given workload is less than a specific threshold
swapEnabledchecker to the
memsql-report checkcommand to verify if the total swap memory is not less than 10% of the physical memory
vmSwappinesschecker to the
memsql-report checkcommand that checks if the
vm.swappinesskernel setting is greater than
0on each host
--tar-install-dirflag to the
max_memory_settingschecker of the
memsql-report checkcommand to accept a maximum memory use of 91%, up from 90%
memsql-admin querycommand to not require a password for the MemSQL
memsql-admin query, and
memsql-admin register-nodecommands to prompt for a password only after all of the included flags have been verified
memsql-deploy upgrade --precheck-onlycommand
memsql-report checkcommand where messages about unavailable checks were displayed
syncCnfVariableschecker in the
memsql-report checkcommand would inadvertently return incorrect results
memsql-admin querycommand that would ignore the
memsqlctlcommand where some commands that were run with the
--timeoutflag would not exit after the specified timeout
--include memsqlAuditlogsflag to the
memsql-report collectcommand to collect audit logs
memsql-report checkcommand where
maxMemorySettingsreported a failure when a host has more than 10GB of memory free
no_start: trueoption to the
nodesection of a cluster configuration YAML file for use with the
--no-partition-changeflag to the
memsql-admin optimizecommand to skip any changes made to the
memsql-admin enable-high-availabilitycommand that would co-locate nodes on the same host that were in different availability groups
memsql-deploy setup-clustercommand when duplicate hosts are found in the cluster configuration YAML file
memsql-deploy setup-clustercommand to display an error message when a node is specified with an incorrect availability group in the cluster configuration YAML file
memsqlctlcommands was sometimes lost
memsqlctlis an earlier version to verbose output
memsql-admin configure-monitoringcommand that updates the monitoring configuration for the cluster
memsql-admin stop-monitoringcommands to start and stop the collection of monitoring data
memsql-report collect-and-checkcommand that runs both collect and check reports
memsql-deploy setup-clusercommand by pairing leaves of different hosts
memsql-admin enable-high-availabilitycommand where nodes were assigned non-optimal availability groups
memsql-deploy upgradecommand to report all precheck failures
memsql-deploy setup-clustercommand to explain why a clean cluster is required before deploying MemSQL
syncCnfVariableschecker would crash in the
memsql-admin querycommand where
--passwordwas not correctly processed
memsql-deploy upgradecommand to fail
zshtab completion to all Toolbox commands
memsql-admin querycommand where
--passwordwas not correctly processed
memsql-deploy cluster-in-a-box, and
memsql-deploy setup-clustercommands to use the license from the MEMSQL_LICENSE environment variable
memsql-deploy upgradewould fail due to a replicating database
memsql-deploy setup-clustercommand when a host without
memsql-serverinstalled was already part of the cluster
memsql-deploy upgradecommand when using a tar file without specifying
transparentHugepagechecker of the
memsql-report checkcommand to not check defrag if THP is disabled
attachRebalanceDelaychecker to the
memsql-report checkcommand that verifies that attachRebalanceDelay is not set to 86400
memsql-toolbox-config register-hostcommand to validate the
--memsqlctl-pathvalue and added the
--skip-validationflag to skip this validation
memsql-deploy upgradecommand to attempt to attach and detach a leaf under certain error conditions instead of proceeding to an offline upgrade
diskBandwidthchecker to the
memsql-report checkcommand that checks disk read, write, and sync-read bandwidth
informationSchemaMvEventschecker of the
memsql-report checkcommand to order events by time
--disable-spinnerflag to all Toolbox commands to disable the progress spinner, which some terminal sessions/environments may have issues with
memsql-deploy setup-clustercommand to suppress an error if one or more hosts did not have
validLicensechecker of the
memsql-report checkcommand to report in units for clusters with a unit-based license
--base-install-dirflag to the
memsql-deploy setup-clustercommand which sets each node’s base install directory on all hosts
memsql-admin delete-backupcommand to no longer error if a backup name is listed more than once
memsql-deploy uninstall, and
consistentMaxMemorychecker to the
memsql-report checkcommand that confirms the
maximum_memorysetting is consistent across all leaves and aggregators
memsql-deploy destroy-clustercommand that deletes all data, deletes all MemSQL nodes, and unregisters all hosts
memsql-deploy uninstall, and
memsql-deploy setup-clustercommand to accept the case-insensitive role of a node
--allflag to the
memsql-admin describe-nodecommand to list the details for all nodes
--precheck-onlyflag to the
memsql-deploy upgradecommand to check if a cluster is stable and an upgrade is possible without performing an upgrade
memsql-admincommand’s backup/restore functionality to search for a backup in a repository if one isn’t found in a cache
memsql-deploy upgradecommand to compare the target upgrade version against the major version that is already installed
syncCnfVariableschecker of the
memsql-report checkcommand to confirm that its value is equal to the runtime value in
memsql-deploy uicommand fails to run
--bind-addressflags to the
memsql-deploy setup-clustercommands to not allow SSH for localhost
memsql-deploy upgradecommand fails when memsql-server 7.1 is already installed on a host
memsql-deploy upgradecommand that confirms that the active
memsql-serverpackage is the one for the target version
memsql-deploy setup-clustercommand to provide the same output with or without the
--file-pathflag to the
memsql-admin set-licensecommand to allow the license to be stored in, and read from, a file
memsql-deploycommands to prompt for which package manager to use if both
rpmpackage managers are installed
--skip-version-checkflag to the
memsql-deploy upgradecommand that ignores the currently active memsql version and enables downgrading
--force-masterflags to the
memsql-admin create-nodecommand. Refer to the memsql-admin create-node reference page for more information.
memsql-deploy setup-clusterfails when run with the
memsql-deploy cluster-in-a-boxcommand to bind nodes to the address
memsql-deploy uninstall --all-versionscommand to return a
0exit code if there are no versions to uninstall
memsql-deploy uicommand that runs a web UI to install MemSQL and deploy a cluster
syncCnfVariableschecker to the
memsql-report checkcommand that confirms that there are no sync variables values defined in the
memsql.cnffile on a host
memsql-deploy cluster-in-a-boxcommand to deduce the package format when the
--file-pathflag is specified
--force-package-formatflag to the
memsql-deploy list-versionscommand that lists the versions installed by the chosen package manager
memsql-deploy upgradedisplays an error message when attempting to upgrade to the MemSQL version that already installed and activated on the host
memsql-report checkcommand to display results only for checkers that have all needed data, and list those checkers that do not
memsql-admin optimizecommand to display a message when non-uniform memory allocations for leaves are found
--passwordflag to the
memsql-deploy cluster-in-a-boxcommand that sets a password for the MemSQL
memsql-report checkcommand crashes when the
orphanTableschecker does not find specific information in a report
memsql-reportcommand’s error message when it fails to detect whether
memsqlctlis installed on a host
--force-package-formatflag to the
memsql-deploy uninstallcommand which will allow MemSQL to be uninstalled when there are both dpkg and rpm package managers found on a host
memsql-admin enable-high-availabilityfails with MemSQL version below 7.0.6
ANALYZE OPTIMIZER_STATE INTO OUTFILEof the
memsql-report collectcommand to the collector’s section of the
memsql-report checkwould issue a warning on a valid
memsql-deploy list-versionscommand to display its output more quickly
-vvvto be more readable
--remote-temp-dirflag to the
memsql-report collectcommand that allows setting a directory for storing temporary files on a host
validLicensecheck reports a failure on a valid license
memsql-report collectthat saves column and histograms recorded on each table
memsql-deploy setup-cluster --cluster-file
dmesgcollector with timestamps that users can recognize and interpret
memsql-deploy upgradedoes not show an error if the final upgrade step fails
memsql-deploy upgradewould hang if there were orphan databases
--max-column-widthflag to the
memsql-admin querycommand that allows query output columns to be truncated to the specified number of characters
memsql-toolbox-config register-hostcommands that allows hosts with identical SSH host keys to be added to the cluster
memsql-report collecthangs when collecting reports from some hosts
cpuFreqPolicycheck reports a failure on a valid configuration
chronydStatuscollector does not work for a host that does not have
memsql-report check --validate-env
memsql-toolbox-config register-hostis run with
memsql-deploy upgradeincorrectly estimates the disk space required to upgrade from MemSQL 6 to MemSQL 7
memsql-admin delete-backupfaster by deleting multiple backups in parallel
cpuMemoryBandwidthcollector and checker to
memsql-reportthat measures CPU-memory bandwidth on each host and confirms that both bandwidth and latency are within acceptable limits
memsql-report checkthat is required to run performance checks for a cluster
memsql-deploy setup-clustercommands are run with multiple localhosts
FAILeven when set correctly for the
endpoint_urlis missing in a backup command
memsql-report collectfails if some node IDs could not be read
memsql-deploy upgrade --onlinefails to upgrade from MemSQL version 7.0.15
memsql-admin create-backup- backup one or more databases to a repository
memsql-admin delete-backup- delete a backup
memsql-admin list-backups- list all the latest backups
memsql-admin restore-backup- restore a database from a backup
memsql-admin summarize-backups- print summary information for backups
memsql-admin validate-backup- verify that a backup is correct
memsql-deploy setup-clusterfails if the cluster configuration file contains
memsql-deploy setup-clusterthat prevents nodes from sharing the same folder on a host when specified in a cluster configuration file
memsql-deploy upgradethat runs online upgrade for MemSQL.
memsql-deploy setup-clusterwhen the path to the source file is incorrect.
memsql-report collectthat saves the Toolbox’s configuration to a report file.
memsql-report collectthat saves each host’s description to a report file.
memsql-admin enable-high-availabilitydoes not request the correct privilege.
memsql-admin put-filecommand that copies a file to the same path on all hosts.
memsql-admin stop-node --all --forcedid not stop any nodes if one node was unavailable.
memsql-deploy upgradedid not wait for the database to restart after an upgrade is finished.
memsql-admin enable-high-availabilitywhere the command does not work correctly if two leaf nodes on the same host have different hostnames.
memsql-reportthat ensures all cluster hosts have SSD drives.
memsql-reportthat will validate if MemSQL can be installed.
memsql-deploy upgradewaits for node recovery.
memsql-toolbox-configis not able to resolve a state file but returns incorrect error.
memsql-deploydownloaded the package twice for online upgrade.
--ssh-max-sessions) or config file.
memsql-deploy setup-cluster --cluster-file <cluster-file>command returns nodes with Unknown role.
memsql-deploy upgradewithout any flags would perform a rolling restart on the cluster.
memsql-deployto support upgrade to MemSQL 7.0
memsql-report checkfails to check for blocked queries with time 0.
memsql-admin update-config --set-globalto automatically run on the Master Aggregator.
securityLimitscollector to include the output of
numactlchecker to check if the sum of numa node memory capacity exceeds machine memory capacity.
memsql-deploy setup-clusterto accept a YAML file with cluster configurations.
memsql-reportexits with a status of 0 if it fails.
memsql-report collectto be not parsable by
defaultHeartbeatSettingsto be part of
memsql-admin start-nodeto start the nodes by role.
memsql-admin stop-nodeto stop the nodes by role.
Bind Addresscolumn to
memsql-admin delete-nodeto remove leaves and child aggregators from the cluster before deleting them.
memsql-admin list-nodesto be consistent with other commands.
License Expirationfield in
memsql-report collectto not collect procedures from memsql-server version 6.7.11 and above.
memsql-admin delete-nodeto stop the nodes before deleting them.
memsql-admin queryfor querying a node directly.
blockedQueriesalso looks for sleeping threads with open transactions
swappinesschecker. The setting it checked is not required by MemSQL 6.7.
informationSchemaPipelinescollector to include
envcommands to include the resolved
memsql-deploy cluster-in-a-boxto set passwords that are required by
memsqlctl create-nodestarting in MemSQL 6.7.8.
memsql-admin create-nodenow requires the
memsql-report collect --onlyto also include the
memsqlctlInfocollector by default.
memsql-deploy setup-clusterthat prevents enabling High Availability with an odd number of leaves.
memsql-deploy installthat improperly failed the installation if it was unable to add the target user to the
memsqlctlis not installed on the target hosts.
memsql-adminconfirmation messages that incorrectly implied the use of
--passwordwhen it was not used.
memsql-admin update-config --all.
memsql-deploy list-versionswhen there are no hosts registered.
memsqlctlconfiguration to determine the correct user and group for remote commands.