You are viewing an older version of this section. View current production version.
MemSQL Ops has been deprecated
Please follow this guide to learn how to migrate to SingleStore tools.
SingleStore Managed Service does not support this command.
Generate a comprehensive report that contains diagnostic information about your entire cluster for troubleshooting purposes.
The size of the log files to be collected can be specified, as well as the SingleStore nodes from which information should be collected.
The generated report is compressed into a file called
usage: memsql-ops report [--settings-file SETTINGS_FILE] [--async] [--tracelog-mb TRACELOG_MB] [--include-log-archives] [--include-pipelines-debug-info] [--exclude-system-info] [--exclude-processlist] [--include-backtrace | --no-include-backtrace] [--exclude-schema | --include-plancache] [--memsql-ids [MEMSQL_IDS [MEMSQL_IDS ...]]] [--timeout TIMEOUT] Generate a report that contains diagnostic information for MemSQL Ops. optional arguments: --settings-file SETTINGS_FILE A path to a MemSQL Ops settings.conf file. If not set, we will use the file in the same directory as the MemSQL Ops binary. --async If this option is true, we will exit without waiting for the report to be fully built. --tracelog-mb TRACELOG_MB If specified, we will truncate SingleStore DB tracelogs such that all of the tracelogs combined will be less than this size. The default value is 150. --include-log-archives Include the log_archives directory from each agent. --include-pipelines-debug-info Include some debugging information about pipelines. --exclude-system-info If specified, we will not include some system data that is mostly disk related. --exclude-processlist If specified, we will not include the process list of running queries in the report. --include-backtrace If specified, we will include a SingleStore DB backtrace from each node. --no-include-backtrace If specified, we will not include a SingleStore DB backtrace. --exclude-schema If specified, we will not include any information about SingleStore DB database and table schemas in the report. Consequently the plancache and process list will also be excluded. --include-plancache If specified, we will include SingleStore DB plancache files in the report. Note that this flag cannot be used with --exclude-schema because schema information is revealed by the plancache files. --memsql-ids [MEMSQL_IDS [MEMSQL_IDS ...]] A list of SingleStore DB (MemSQL) IDs for which we will gather tracelogs. If not specified, we will gather tracelogs for all SingleStore nodes. --timeout TIMEOUT If specified, we will wait at most this many seconds for a report to be built for each MemSQL Ops agent.