Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.
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 SingleStore DB
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
default_partition_per_leafSingleStore DB/MemSQL variable
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 SingleStore DB/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 SingleStore 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 SingleStore DB 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 SingleStore DB
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 SingleStore DB.
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.