sql
Use these commands to diagnose the SQL database.
Syntax
diagnose sql config auto-cache-delay [set <seconds>| reset]
diagnose sql config debug-filter [set | test] [string]
diagnose sql config deferred-index-timespan [set <value>]
diagnose sql config hcache-agg-step [reset | set <integer>]
diagnose sql config hcache-base-trim-interval [reset | set <integer>]
diagnose sql config hcache-max-fv-row [reset | set <integer>]
diagnose sql config hcache-max-rpt-row [reset | set <integer>]
diagnose sql config sampling-max-row [reset | set <integer>]
diagnose sql config sampling-status [reset | set <integer>]
diagnose sql config sampling-type [reset | set <integer>]
diagnose sql hcache add-task agg <adom> <norm-query-hash> <agg-level> <timestamp> <num-of-days>
diagnose sql hcache add-task agg-update <adom> <hid>
diagnose sql hcache aggregate debug {on | off}
diagnose sql hcache aggregate debug-file {show | delete | upload <ftp host> <ftp dir> <ftp user name> <ftp password>}
diagnose sql hcache aggregate status <adom> <query-hash/tag> <detail>
diagnose sql hcache dump-task <filter>
diagnose sql hcache list <adom> <start-time> <end-time> <query-tag/norm-qry-hash/sql> <is-fortiview> <max-time-scale>
diagnose sql hcache rebuild-both <start-time> <end-time>
diagnose sql hcache rebuild-fortiview <start-time> <end-time>
diagnose sql hcache rebuild-report <start-time> <end-time>
diagnose sql hcache rebuild-status
diagnose sql hcache show hcache <adom> <id>
diagnose sql hcache show time <time> <time> <time> <time>
diagnose sql hcache status {all | <adom>}
diagnose sql process kill <pid>
diagnose sql process list [full]
diagnose sql remove {hcache <adom> [fast] | query-cache | rebuild-db-flag | tmp-tabe}
diagnose sql show {db-size | hcache-size | log-filters | log-stfile <device-id> <vdom> | policy info <adom> }
diagnose sql status {rebuild-adom <adom> | rebuild-db | run_sql_rpt | sqlplugind | sqlreportd}
diagnose sql upload {ftp | tftp} <host> <directory> <user_name> <password>
|
Variable |
Description |
|---|---|
|
config auto-cache-delay [set <seconds>| reset] |
Show, set, or reset the auto-cache delay, in seconds (default = 300). |
|
config debug-filter {set | test} <string> |
Set or test the SQL plugin debug filter. |
|
config deferred-index-timespan [set <value>] |
View or set the time span for the deferred index (default = 10000). |
|
config hcache-agg-step [reset | set <integer>] |
Show, set, or reset the hcache aggregation step (default = 10). |
|
config hcache-base-trim-interval [reset | set <integer>] |
Show, set, or reset the hcache base trim interval (default = 172800). |
|
config hcache-max-fv-row [reset | set <integer>] |
Show, set, or reset max row number for fortiview hcache (default = 100000). |
|
config hcache-max-rpt-row [reset | set <integer>] |
Show, set, or reset max row number for report hcache (default = 18000). |
|
config sampling-max-row [reset | set <integer>] |
Show, set, or reset max row number for sampling (default = 1000000). |
|
config sampling-status [reset | set <integer>] |
Show, set, or reset the sampling status. Enter 0 for disabling and 1 for enabling the sample status (default = 1). |
|
config sampling-type [reset | set <integer>] |
Show, set, or reset the type of sampling (default = 0). |
|
hcache add-task agg <adom> <norm-query-hash> <agg-level> <timestamp> <num-of-days> |
Add an hcache agg task:
|
|
hcache add-task agg-update <adom> <hid> |
Add an hcache agg update task:
|
|
hcache aggregate debug {on | off} |
Turn debug on or off. |
|
hcache aggregate debug-file {show | delete | upload <ftp host> <ftp dir> <ftp user name> <ftp password>} |
Delete, show, or upload the debug file. The following input is required when uploading the debug file:
|
|
hcache aggregate status <adom> <query-hash/tag> <detail> |
Show hcache aggregation info:
|
|
hcache dump-task <filter> |
Dump hcache tasks. Enter the task filter. |
|
hcache list <adom> <start-time> <end-time> <query-tag/norm-qry-hash/sql> <is-fortiview> <max-time-scale> |
List hcaches:
|
|
hcache rebuild-both <start-time> <end-time> |
Rebuild hcache for both report and FortiView. Start and end times are in the format yyyy-mm-dd hh:mm:ss. |
|
hcache rebuild-fortiview <start-time> <end-time> |
Rebuild hcache for FortiView only. Start and end times are in the format yyyy-mm-dd hh:mm:ss. |
|
hcache rebuild-report <start-time> <end-time> |
Rebuild hcache for report only. Start and end times are in the format yyyy-mm-dd hh:mm:ss. |
|
hcache rebuild-status |
Show report hcache rebuild/check status. |
|
hcache show hcache <adom> <id> |
Show hcache information. Enter the ADOM name and hcache ID. |
|
hcache show time <time> <time> <time> <time> |
Show hcache time. Enter up to four timestamps. |
|
process kill <pid> |
Kill a running query. |
|
process list [full] |
List running query processes. |
|
remove {hcache <adom> [fast] | query-cache | rebuild-db-flag | tmp-table} |
Remove the selected information:
|
|
show {db-size | hcache-size | log-filters | log-stfile <device-id> <vdom> | policy-info <adom>} |
Show the database, hcache size, log filters, or log status file:
|
|
status {rebuild-adom <adom> | rebuild-db | run_sql_rpt | sqlplugind | sqlreportd} |
Show the status:
|
|
upload {ftp | tftp} <host> <directory> <user_name> <password> |
Upload sqlplugind messages / pgsvr logs with FTP or TFTP. |