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