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-database
command to create database snapshots--snapshot
to the sdb-admin restart-node
and the sdb-admin stop-node
commands to create snapshots of databases before restarting or stopping a nodememsqlctl.hcl
and the nodes.hcl
files to the output of the memsqlcltInfo
collectorServerVersion
and the MemoryUsage
fields to the backup cache--online
flag in the memsql-deploy upgrade
commandsudo
message in the Toolbox commandsdefaultWorkloadManagement
checker to be more consistentsdb-report collect --mask-ip
command that would cause an error when collecting report information for a stopped nodesdb-deploy setup-cluster
command when an environment validation fails due to different users owning data directories of a node--mask-ip
flag to the sdb-report collect
command to mask sensitive data in the report files, such as IP addresses, MAC addresses, usernames, and passwordsrole
column to the mv_nodes
table for population by the monitoring pipelinesdb-admin enable-nodes-autostart
command to enable nodes autostart on system rebootchronydStatus
and the partitionsStart
collectors in the memsql-report
command to be excluded by defaultanalyzeTable
collector in the memsql-report
commandconsistent_maximum_memory
checker from kilobytes (KB) to megabytes (MB)sdb-deploy setup-cluster
command that would sometimes place the memsqlctl.hcl
file in an incorrect foldersdb-toolbox-config state
, the sdb-deploy state
, the sdb-admin state
, and the sdb-report state
commands to display the Toolbox state from the toolbox-state.hcl
file--preinstalled-path
flag to the sdb-deploy install
, sdb-deploy cluster-in-a-box
, and the sdb-deploy setup-cluster
commands to specify the folder where a memsql-server
.tar
file has been extracted as an install targetnetwordBuffersMax
checker to the sdb-report
command to check that the wmem_max
and the rmem_max
values are at least 8MB--config-file
flag to the sdb-admin send-alert
command to specify a YAML file containing both the location and the thresholds as an alternative to using the --alert-location
and the --thresholds
flags--monitoring-version
flag to the sdb-admin start-monitoring
command to specify a memsql-server
version to pass to the memsql-exporter
--batch-interval
flag to the sdb-admin start-monitoring
command to specify a time interval between data extractions--sample-queries
and the --high-cardinality-metrics
flags to the sdb-admin start-monitoring
command to enable the collection of additional monitoring datasdb-admin start-monitoring
command to support features introduced in the SingleStore DB 7.3 version of the memsql-exporter
mallocActiveMemory
checker to fail if malloc_active_memory
is greater than 5GB (up from 2GB)diskUsage
and the diskInodesUsage
checkers in the sdb-report check
command to not report high usage on loopback filesystemssdb-report collect
command to not output a stack trace when a collection error is encounteredsdb-deploy upgrade
command that would sometimes cause aggregator actions to be displayed in an incorrect order during a dry runprocessFiles
collector to the memsql-report
command to collect all /proc/<pid>/*
files for the memsqld
and the memsqld_safe
processesautoAttach
checker to the memsql-report
command to warn if the auto_attach
engine variable is not set to ON
--preinstalled-path
flag to the memsql-deploy upgrade
command to specify the folder as an upgrade target where a memsql-server
.tar
file has been extractedmemsql-deploy ui
command when registered hosts are detectedcgroupDisabled
checker and osRelease
collector to the memsql-report
command to check that cgroup memory
is disabled for Red Hat 7.x or latermemsql-report send-alert
command to automatically run memsql-report collect-and-check
and alert on fails or warningsmemsql-report
commandmemsql-admin change-root-password
commandmemsql-admin change-root-password
commandmemsql-admin start-monitoring
command when the exporter host is inaccessible from other hostsmemsql-report collect
and the memsql-deploy setup-cluster
commandsorchestratorProcesses
checker to include each process in the report only once, even if more than one instance of the process is running on the hostmemsql-deploy setup-cluster
command to check that all of the nodes that will be registered have the correct file permissions and ownerschema
collector to include views definitions, and improved how functions, procedures, and error messages are displayedmemsql-deploy setup-cluster
command to set the secure-file-priv
engine variable to a default path of <memsqlctl's-default-install-dir>/db_files
for each newly-created nodememsq-admin restart-node
command that would sometimes display an incorrect error messageclusterMemoryUsage
checker that would produce incorrect outputmemsql-admin enable-high-availability
command that would sometimes cause a kernel panic if Toolbox is configured incorrectlymemsql-admin
backup-related commands when the --repository
flag contains an invalid valuememsql-report check --validate-env
command would crash when a host has TarInstallDir defined and memsql-server
installedinstalledPermissions
checker and collector to the memsql-report
command to verify that cluster files and directories have the correct permissions--skip-validate-env
flag was ignored by the memsql-deploy setup-cluster
command--data-dir
flag to the memsql-deploy setup-cluster
command for specifying the absolute path to each node’s data directory (DataDir)memsql-deploy ui
command to support pre-deployment environmental checksmemsql-admin restart-node --online
command to inform the user that relevant nodes must be running to perform the restartmemsql-deploy upgrade
command that incorrectly determined that all columnstore tables could be safely upgradedmemsql-admin sync-ldap
command to synchronize LDAP users and groups with SingleStore DB/MemSQL database usersmemsql-report collect
command that displays the number of collectors that will be executedmemsql-admin query --row-timeout
command was not taken into account by the commandclusterMemoryUsage
checker to the memsql-report check
command to determine if there is at least 10% of unused memory left for each nodediskInodesUsage
checker to the memsql-report check
command to determine if there is at least 15% of unused disk inodes left on each hostdmesg -T
command was not executed while collecting reports with the memsql-report collect
commanddiskLatencyRead
checker to the memsql-report check
command to determine if the disk read latency is below the recommended threshold on each hostdiskLatencyWrite
checker to the memsql-report check
command to determine if the disk write latency is below the recommended threshold on each hostmemsql-admin unregister-node
and memsqlctl unregister-node
commands to unregister nodes in ToolboxmajorPageFaults
checker and collector to the memsql-report
command to verify if the number of major page faults that the system generates per second is lower than a specific thresholdswapUsage
checker and collector to the memsql-report
command to verify if the swap usage is lower than a specific thresholdcpuIdle
checker and the cpuUtilization
collector to the memsql-report
command to verify if the percentage of time the CPUs have been idle is higher than a specific thresholdmemoryCommitted
checker and collector to the memsql-report
command to verify if the percentage of memory required for a given workload is less than a specific thresholdswapEnabled
checker to the memsql-report check
command to verify if the total swap memory is not less than 10% of the physical memoryvmSwappiness
checker to the memsql-report check
command that checks if the vm.swappiness
kernel setting is greater than 0
on each hostmemsql-deploy setup-cluster
command--tar-install-dir
flag to the memsql-deploy cluster-in-a-box
commandmax_memory_settings
checker of the memsql-report check
command to accept a maximum memory use of 91%, up from 90%memsql-admin query
command to not require a password for the MemSQL root
usermemsql-admin change-root-password
, memsql-admin create-node
, memsql-admin query
, and memsql-admin register-node
commands to prompt for a password only after all of the included flags have been verifiedmemsql-deploy upgrade --precheck-only
commandmemsql-report check
command where messages about unavailable checks were displayedsyncCnfVariables
checker in the memsql-report check
command would inadvertently return incorrect resultsmemsql-admin query
command that would ignore the --user
flagmemsqlctl
command where some commands that were run with the --timeout
flag would not exit after the specified timeout--include memsqlAuditlogs
flag to the memsql-report collect
command to collect audit logsmemsql-report check
command where maxMemorySettings
reported a failure when a host has more than 10GB of memory freeno_start: true
option to the node
section of a cluster configuration YAML file for use with the memsql-deploy setup-cluster
command--no-partition-change
flag to the memsql-admin optimize
command to skip any changes made to the default_partition_per_leaf
MemSQL variablememsql-admin enable-high-availability
command that would co-locate nodes on the same host that were in different availability groupsmemsql-deploy setup-cluster
command when duplicate hosts are found in the cluster configuration YAML file--json
flagmemsql-deploy setup-cluster
command to display an error message when a node is specified with an incorrect availability group in the cluster configuration YAML filememsqlctl
commands was sometimes lostmemsqlctl
is an earlier version to verbose outputmemsql-admin configure-monitoring
command that updates the monitoring configuration for the clustermemsql-admin start-monitoring
and memsql-admin stop-monitoring
commands to start and stop the collection of monitoring datamemsql-report collect-and-check
command that runs both collect and check reportsmemsql-deploy setup-cluser
command by pairing leaves of different hostsmemsql-admin enable-high-availability
command where nodes were assigned non-optimal availability groupsmemsql-deploy upgrade
command to report all precheck failuresmemsql-deploy setup-cluster
command to explain why a clean cluster is required before deploying MemSQLsyncCnfVariables
checker would crash in the memsql-report check
commandmemsql-admin query
command where --password
was not correctly processedmemsql-deploy upgrade
command to failbash
and zsh
tab completion to all Toolbox commandsmemsql-admin query
command where --password
was not correctly processedmemsql-admin bootstrap-aggregator
, memsql-admin create-node
, memsql-admin set-license
, memsql-deploy cluster-in-a-box
, and memsql-deploy setup-cluster
commands to use the license from the MEMSQL_LICENSE environment variablememsql-deploy upgrade
would fail due to a replicating databasememsql-admin
backup-related commandsmemsql-deploy setup-cluster
command when a host without memsql-server
installed was already part of the clustermemsql.cnf
file manuallysudo
promptingmemsql-deploy upgrade
command when using a tar file without specifying tar-install-dir
transparentHugepage
checker of the memsql-report check
command to not check defrag if THP is disabledattachRebalanceDelay
checker to the memsql-report check
command that verifies that attachRebalanceDelay is not set to 86400memsql-deploy upgrade
commandmemsql-toolbox-config register-host
command to validate the --memsqlctl-path
value and added the--skip-validation
flag to skip this validationmemsql-deploy upgrade
command to attempt to attach and detach a leaf under certain error conditions instead of proceeding to an offline upgradediskBandwidth
checker to the memsql-report check
command that checks disk read, write, and sync-read bandwidthinformationSchemaMvEvents
checker of the memsql-report check
command to order events by time--disable-spinner
flag to all Toolbox commands to disable the progress spinner, which some terminal sessions/environments may have issues withmemsql-deploy setup-cluster
command to suppress an error if one or more hosts did not have memsqlctl
installedvalidLicense
checker of the memsql-report check
command to report in units for clusters with a unit-based license--base-install-dir
flag to the memsql-deploy setup-cluster
command which sets each node’s base install directory on all hostsmemsql-admin delete-backup
command to no longer error if a backup name is listed more than oncememsql-admin delete-node
, memsql-deploy uninstall
, and memsql-toolbox-config unregister-host
commandsconsistentMaxMemory
checker to the memsql-report check
command that confirms the maximum_memory
setting is consistent across all leaves and aggregatorsmemsql-deploy destroy-cluster
command that deletes all data, deletes all MemSQL nodes, and unregisters all hostsmemsql-admin delete-node
, memsql-deploy uninstall
, and memsql-toolbox-config unregister-host
commandsmemsql-deploy setup-cluster
command to accept the case-insensitive role of a node--all
flag to the memsql-admin describe-node
command to list the details for all nodes--precheck-only
flag to the memsql-deploy upgrade
command to check if a cluster is stable and an upgrade is possible without performing an upgradememsql-admin
command’s backup/restore functionality to search for a backup in a repository if one isn’t found in a cachememsql-deploy upgrade
command to compare the target upgrade version against the major version that is already installedsyncCnfVariables
checker of the memsql-report check
command to confirm that its value is equal to the runtime value in memsql-server
memsql-deploy ui
command fails to run--master-port
, --leaf-port
, and --bind-address
flags to the memsql-deploy cluster-in-a-box
commandmemsql-deploy setup-cluster
commands to not allow SSH for localhostmemsql-deploy upgrade
command fails when memsql-server 7.1 is already installed on a hostsudo
passwordmemsql-deploy upgrade
command that confirms that the active memsql-server
package is the one for the target versionmemsql-deploy setup-cluster
command to provide the same output with or without the --config-file
flagmemsql-deploy upgrade
command--file-path
flag to the memsql-admin set-license
command to allow the license to be stored in, and read from, a filememsql-deploy
commands to prompt for which package manager to use if both deb
and rpm
package managers are installedmemsql-deploy upgrade
command--skip-version-check
flag to the memsql-deploy upgrade
command that ignores the currently active memsql version and enables downgrading--role
, --license
, --user
, --user-password
, --availability-group
, and --force-master
flags to the memsql-admin create-node
command. Refer to the memsql-admin create-node reference page for more information.memsql-report
commandsmemsql-deploy setup-cluster
fails when run with the --cluster-file
flagmemsql-deploy cluster-in-a-box
command to bind nodes to the address 127.0.0.1
instead of 0.0.0.0
memsql-deploy uninstall --all-versions
command to return a 0
exit code if there are no versions to uninstallmemsql-deploy ui
command that runs a web UI to install MemSQL and deploy a clustersyncCnfVariables
checker to the memsql-report check
command that confirms that there are no sync variables values defined in the memsql.cnf
file on a hostmemsql-deploy cluster-in-a-box
command to deduce the package format when the --file-path
flag is specified--force-package-format
flag to the memsql-deploy list-versions
command that lists the versions installed by the chosen package managermemsql-deploy upgrade
displays an error message when attempting to upgrade to the MemSQL version that already installed and activated on the hostmemsql-report check
command to display results only for checkers that have all needed data, and list those checkers that do notmemsql-admin optimize
command to display a message when non-uniform memory allocations for leaves are foundmemsql-admin put-file
command--password
flag to the memsql-deploy cluster-in-a-box
command that sets a password for the MemSQL root
usermemsql-report check
command crashes when the orphanTables
checker does not find specific information in a reportmemsql-report
command’s error message when it fails to detect whether memsqlctl
is installed on a hostmemsql-report collect
commandfile
protocol for memsql-admin
backup functionality--force-package-format
flag to the memsql-deploy uninstall
command which will allow MemSQL to be uninstalled when there are both dpkg and rpm package managers found on a hostmemsql-admin enable-high-availability
fails with MemSQL version below 7.0.6ANALYZE OPTIMIZER_STATE INTO OUTFILE
of the memsql-report collect
command to the collector’s section of the analyzeTables
reportmemsql-report check
would issue a warning on a valid distributed_keepalive_timeout
valuememsql-deploy list-versions
command to display its output more quickly-vvv
to be more readable--remote-temp-dir
flag to the memsql-report collect
command that allows setting a directory for storing temporary files on a hostvalidLicense
check reports a failure on a valid licenseanalyzeTables
collector to memsql-report collect
that saves column and histograms recorded on each tablememsql-deploy setup-cluster --cluster-file
dmesg
collector with timestamps that users can recognize and interpretmemsql-deploy upgrade
does not show an error if the final upgrade step failsmemsql-deploy upgrade
would hang if there were orphan databases--max-column-width
flag to the memsql-admin query
command that allows query output columns to be truncated to the specified number of characters--allow-duplicate-host-fingerprints
flag to memsql-deploy setup-cluster
and memsql-toolbox-config register-host
commands that allows hosts with identical SSH host keys to be added to the clustermemsql-report collect
hangs when collecting reports from some hostscpuFreqPolicy
check reports a failure on a valid configurationchronydStatus
collector does not work for a host that does not have pgrep
maxOpenFiles
and filesystemType
checks from memsql-report check --validate-env
memsql-toolbox-config register-host
is run with --localhost
and --host 127.0.0.1
memsql-deploy upgrade
incorrectly estimates the disk space required to upgrade from MemSQL 6 to MemSQL 7memsql-admin delete-backup
faster by deleting multiple backups in parallelcpuMemoryBandwidth
collector and checker to memsql-report
that measures CPU-memory bandwidth on each host and confirms that both bandwidth and latency are within acceptable limits--include-performance
flag to memsql-report collect
and memsql-report check
that is required to run performance checks for a clustermemsql-toolbox-config register-host
and memsql-deploy setup-cluster
commands are run with multiple localhostsmemsql-report collect
and memsql-report check
commands:
memsqld
processeschronyd
servicechronyd
is disabledulimit
checker reports FAIL
even when set correctly for the memsql
userregion
or endpoint_url
is missing in a backup commandmemsql-report collect
fails if some node IDs could not be readmemsql-deploy upgrade --online
fails to upgrade from MemSQL version 7.0.15memsql-admin create-backup
- backup one or more databases to a repositorymemsql-admin delete-backup
- delete a backupmemsql-admin list-backups
- list all the latest backupsmemsql-admin restore-backup
- restore a database from a backupmemsql-admin summarize-backups
- print summary information for backupsmemsql-admin validate-backup
- verify that a backup is correctmemsql-deploy setup-cluster
fails if the cluster configuration file contains skip_install:true
memsql-deploy setup-cluster
that prevents nodes from sharing the same folder on a host when specified in a cluster configuration file--online
flag for memsql-deploy upgrade
that runs online upgrade for MemSQL.memsql-deploy setup-cluster
when the path to the source file is incorrect.memsql-report collect
that saves the Toolbox’s configuration to a report file.memsql-report collect
that saves each host’s description to a report file.memsql-admin enable-high-availability
does not request the correct privilege.memsql-deploy upgrade
:
memsql-admin put-file
command that copies a file to the same path on all hosts.memsql-admin stop-node --all --force
did not stop any nodes if one node was unavailable.memsql-deploy upgrade
did not wait for the database to restart after an upgrade is finished.memsql-admin enable-high-availability
where the command does not work correctly if two leaf nodes on the same host have different hostnames.memsql-report
that ensures all cluster hosts have SSD drives.--validate-env
option to memsql-report
that will validate if MemSQL can be installed.memsql-deploy upgrade
waits for node recovery.memsql-toolbox-config
is not able to resolve a state file but returns incorrect error.memsql-deploy
downloaded the package twice for online upgrade.memsqlctl
client.--ssh-max-sessions
) or config file.memsql-deploy setup-cluster --cluster-file <cluster-file>
command returns nodes with Unknown role.--parallelism
flag.memsql-deploy upgrade
without any flags would perform a rolling restart on the cluster.memsql-deploy
to support upgrade to MemSQL 7.0memsql-report check
fails to check for blocked queries with time 0.memsql-admin update-config --set-global
to automatically run on the Master Aggregator.securityLimits
collector to include the output of /etc/security/limits.d
and /proc/PID/limits
numactl
checker to check if the sum of numa node memory capacity exceeds machine memory capacity.memsql-report collect
:
top
informationSchemaMvBackupHistory
memsql-report check
:
orphanTables
memsql-deploy setup-cluster
to accept a YAML file with cluster configurations.memsql-report
exits with a status of 0 if it fails.memsql-report collect
to be not parsable by memsql-report check
memsql-report collect
:
uptime
shutdownTime
rebootTime
memsql-report check
:
tracelogOOM
tracelogOOD
explainRebalancePartitionsChecker
longRunningQueries
detectCrashStackTraces
defaultVariables
defaultKeepaliveSettings
and defaultHeartbeatSettings
to be part of defaultVariables
checker--role
flag to memsql-admin start-node
to start the nodes by role.--role
flag to memsql-admin stop-node
to stop the nodes by role.Bind Address
column to memsql-admin list-nodes
output.memsql-admin delete-node
to remove leaves and child aggregators from the cluster before deleting them.memsql-admin list-nodes
to be consistent with other commands.License Expiration
field in memsql-admin show-license
.schema
collector in memsql-report collect
to not collect procedures from memsql-server version 6.7.11 and above.memsql-report collect
:
explainRestoreRedundancy
explainRebalancePartitions
showClusterStatus
memsql-report check
:
delayedThreadLaunches
--stop
flag to memsql-admin delete-node
to stop the nodes before deleting them.--host
, --port
, --user
, and --password
flags to memsql-admin query
for querying a node directly.disconnectedReplicationSlaves
interpreterMode
leafAverageRoundtripLatency
runningBackup
secondaryDatabases
validLicense
blockedQueries
also looks for sleeping threads with open transactionsofflineLeaves
renamed to leavesNotOnline
memsql-admin query
command.memsql-admin list-nodes
and memsql-admin describe-node
.swappiness
checker. The setting it checked is not required by MemSQL 6.7.informationSchemaPipelines
collector to include information_schema.PIPELINES_CURSORS
and information_schema.PIPELINES_FILES
.memsql-report collect
:
explainOrphanDatabases
informationSchemaMvQueries
licenseMetadata
memsql-report check
:
defaultHeartbeatSettings
defaultKeepaliveSettings
defaultWorkloadManagement
defunctProcesses
duplicatePartitionDatabase
failedCodegen
offlineAggregators
offlineLeaves
pendingDatabases
queuedQueries
userDatabaseRedundancy
versionHashes
env
commands to include the resolved configFile
location.memsql-deploy cluster-in-a-box
to set passwords that are required by memsqlctl create-node
starting in MemSQL 6.7.8.memsql-admin create-node
now requires the --password
flag.--base-install-dir
flag to memsql-admin create-node
.memsql-report collect --only
to also include the memsqlctlInfo
collector by default.memsql-deploy setup-cluster
that prevents enabling High Availability with an odd number of leaves.--skip-disk-check
flag to memsql-admin enable-high-availability
.memsql-admin register-node
.memsql-deploy install
that improperly failed the installation if it was unable to add the target user to the memsql
Linux group.memsql-report collect-local
.memsql-report check
when memsqlctl
is not installed on the target hosts.memsql-admin change-root-password
.memsql-toolbox-config register-host
.memsql-report collect
.memsql-report collect
and memsql-report collect-local
.memsql-admin
confirmation messages that incorrectly implied the use of --password
when it was not used.memsql-admin update-config --all
.memsql-admin describe-node
output.memsql-deploy list-versions
when there are no hosts registered.memsqlctl
configuration to determine the correct user and group for remote commands.