title：ADMIN SHOW TELEMETRY summary：TiDB 数据库中 ADMIN SHOW TELEMETRY 的使用概况。

ADMIN SHOW TELEMETRY

ADMIN SHOW TELEMETRY 语句用于查看通过遥测功能收集到并分享给 PingCAP 的使用信息。

语法图

  1. AdminStmt ::=
  2.     'ADMIN' ( 'SHOW' ( 'DDL' ( 'JOBS' Int64Num? WhereClauseOptional | 'JOB' 'QUERIES' NumList )? | TableName 'NEXT_ROW_ID' | 'SLOW' AdminShowSlow | 'TELEMETRY' ) | 'CHECK' ( 'TABLE' TableNameList | 'INDEX' TableName Identifier ( HandleRange ( ',' HandleRange )* )? ) | 'RECOVER' 'INDEX' TableName Identifier | 'CLEANUP' ( 'INDEX' TableName Identifier | 'TABLE' 'LOCK' TableNameList ) | 'CHECKSUM' 'TABLE' TableNameList | 'CANCEL' 'DDL' 'JOBS' NumList | 'RELOAD' ( 'EXPR_PUSHDOWN_BLACKLIST' | 'OPT_RULE_BLACKLIST' | 'BINDINGS' ) | 'PLUGINS' ( 'ENABLE' | 'DISABLE' ) PluginNameList | 'REPAIR' 'TABLE' TableName CreateTableStmt | ( 'FLUSH' | 'CAPTURE' | 'EVOLVE' ) 'BINDINGS' )

示例

  1. ADMIN SHOW TELEMETRY\G
  1. *************************** 1. row ***************************
  2.  TRACKING_ID: a1ba1d97-b940-4d5b-a9d5-ddb0f2ac29e7
  3.  LAST_STATUS: {
  4.   "check_at": "2021-08-11T08:23:38+02:00",
  5.   "is_error": false,
  6.   "error_msg": "",
  7.   "is_request_sent": true
  8. }
  9. DATA_PREVIEW: {
  10.   "hardware": [
  11.     {
  12.       "instanceType": "tidb",
  13.       "listenHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  14.       "listenPort": "4000",
  15.       "cpu": {
  16.         "cache": "8192",
  17.         "cpuFrequency": "2301.00MHz",
  18.         "cpuLogicalCores": "8",
  19.         "cpuPhysicalCores": "4"
  20.       },
  21.       "memory": {
  22.         "capacity": "16410021888"
  23.       },
  24.       "disk": {
  25.         "ebbca862689fa9fef7c55c3112e375c4ce575fe4": {
  26.           "deviceName": "ebbca862689fa9fef7c55c3112e375c4ce575fe4",
  27.           "free": "624438726656",
  28.           "freePercent": "0.61",
  29.           "fstype": "btrfs",
  30.           "opts": "bind,rw,relatime",
  31.           "path": "fb365c1216b59e1cfc86950425867007a60f4435",
  32.           "total": "1022488477696",
  33.           "used": "397115568128",
  34.           "usedPercent": "0.39"
  35.         },
  36.         "nvme0n1p1": {
  37.           "deviceName": "nvme0n1p1",
  38.           "free": "582250496",
  39.           "freePercent": "0.93",
  40.           "fstype": "vfat",
  41.           "opts": "rw,relatime",
  42.           "path": "0fc8c8d71702d81a02e216fb6ef19f4dda4973df",
  43.           "total": "627900416",
  44.           "used": "45649920",
  45.           "usedPercent": "0.07"
  46.         },
  47.         "nvme0n1p2": {
  48.           "deviceName": "nvme0n1p2",
  49.           "free": "701976576",
  50.           "freePercent": "0.74",
  51.           "fstype": "ext4",
  52.           "opts": "rw,relatime",
  53.           "path": "/boot",
  54.           "total": "1023303680",
  55.           "used": "250863616",
  56.           "usedPercent": "0.26"
  57.         }
  58.       }
  59.     },
  60.     {
  61.       "instanceType": "pd",
  62.       "listenHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  63.       "listenPort": "2379",
  64.       "cpu": {
  65.         "cache": "8192",
  66.         "cpuFrequency": "2301.00MHz",
  67.         "cpuLogicalCores": "8",
  68.         "cpuPhysicalCores": "4"
  69.       },
  70.       "memory": {
  71.         "capacity": "16410021888"
  72.       },
  73.       "disk": {
  74.         "ebbca862689fa9fef7c55c3112e375c4ce575fe4": {
  75.           "deviceName": "ebbca862689fa9fef7c55c3112e375c4ce575fe4",
  76.           "free": "624438726656",
  77.           "freePercent": "0.61",
  78.           "fstype": "btrfs",
  79.           "opts": "bind,rw,relatime",
  80.           "path": "fb365c1216b59e1cfc86950425867007a60f4435",
  81.           "total": "1022488477696",
  82.           "used": "397115568128",
  83.           "usedPercent": "0.39"
  84.         },
  85.         "nvme0n1p1": {
  86.           "deviceName": "nvme0n1p1",
  87.           "free": "582250496",
  88.           "freePercent": "0.93",
  89.           "fstype": "vfat",
  90.           "opts": "rw,relatime",
  91.           "path": "0fc8c8d71702d81a02e216fb6ef19f4dda4973df",
  92.           "total": "627900416",
  93.           "used": "45649920",
  94.           "usedPercent": "0.07"
  95.         },
  96.         "nvme0n1p2": {
  97.           "deviceName": "nvme0n1p2",
  98.           "free": "701976576",
  99.           "freePercent": "0.74",
  100.           "fstype": "ext4",
  101.           "opts": "rw,relatime",
  102.           "path": "/boot",
  103.           "total": "1023303680",
  104.           "used": "250863616",
  105.           "usedPercent": "0.26"
  106.         }
  107.       }
  108.     },
  109.     {
  110.       "instanceType": "tikv",
  111.       "listenHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  112.       "listenPort": "20160",
  113.       "cpu": {
  114.         "cpuFrequency": "3730MHz",
  115.         "cpuLogicalCores": "8",
  116.         "cpuPhysicalCores": "4",
  117.         "cpuVendorId": "GenuineIntel",
  118.         "l1CacheLineSize": "64",
  119.         "l1CacheSize": "32768",
  120.         "l2CacheLineSize": "64",
  121.         "l2CacheSize": "262144",
  122.         "l3CacheLineSize": "64",
  123.         "l3CacheSize": "8388608"
  124.       },
  125.       "memory": {
  126.         "capacity": "16803861504"
  127.       },
  128.       "disk": {
  129.         "36e7dfacbb83843f83075d78aeb4cf850a4882a1": {
  130.           "deviceName": "36e7dfacbb83843f83075d78aeb4cf850a4882a1",
  131.           "free": "624438726656",
  132.           "freePercent": "0.61",
  133.           "fstype": "btrfs",
  134.           "path": "fb365c1216b59e1cfc86950425867007a60f4435",
  135.           "total": "1022488477696",
  136.           "used": "398049751040",
  137.           "usedPercent": "0.39"
  138.         },
  139.         "nvme0n1p1": {
  140.           "deviceName": "nvme0n1p1",
  141.           "free": "582250496",
  142.           "freePercent": "0.93",
  143.           "fstype": "vfat",
  144.           "path": "0fc8c8d71702d81a02e216fb6ef19f4dda4973df",
  145.           "total": "627900416",
  146.           "used": "45649920",
  147.           "usedPercent": "0.07"
  148.         },
  149.         "nvme0n1p2": {
  150.           "deviceName": "nvme0n1p2",
  151.           "free": "701976576",
  152.           "freePercent": "0.69",
  153.           "fstype": "ext4",
  154.           "path": "/boot",
  155.           "total": "1023303680",
  156.           "used": "321327104",
  157.           "usedPercent": "0.31"
  158.         }
  159.       }
  160.     },
  161.     {
  162.       "instanceType": "tiflash",
  163.       "listenHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  164.       "listenPort": "3930",
  165.       "cpu": {
  166.         "cpuFrequency": "3400MHz",
  167.         "cpuLogicalCores": "8",
  168.         "cpuPhysicalCores": "4",
  169.         "l1CacheLineSize": "64",
  170.         "l1CacheSize": "32768",
  171.         "l2CacheLineSize": "64",
  172.         "l2CacheSize": "262144",
  173.         "l3CacheLineSize": "64",
  174.         "l3CacheSize": "8388608"
  175.       },
  176.       "memory": {
  177.         "capacity": "16410021888"
  178.       },
  179.       "disk": {
  180.         "36e7dfacbb83843f83075d78aeb4cf850a4882a1": {
  181.           "deviceName": "36e7dfacbb83843f83075d78aeb4cf850a4882a1",
  182.           "free": "624438726656",
  183.           "freePercent": "0.61",
  184.           "fstype": "btrfs",
  185.           "path": "fb365c1216b59e1cfc86950425867007a60f4435",
  186.           "total": "1022488477696",
  187.           "used": "398049751040",
  188.           "usedPercent": "0.39"
  189.         }
  190.       }
  191.     }
  192.   ],
  193.   "instances": [
  194.     {
  195.       "instanceType": "tidb",
  196.       "listenHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  197.       "listenPort": "4000",
  198.       "statusHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  199.       "statusPort": "10080",
  200.       "version": "5.1.1",
  201.       "gitHash": "797bddd25310ed42f0791c8eccb78be8cce2f502",
  202.       "startTime": "2021-08-11T08:23:38+02:00",
  203.       "upTime": "22.210217487s"
  204.     },
  205.     {
  206.       "instanceType": "pd",
  207.       "listenHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  208.       "listenPort": "2379",
  209.       "statusHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  210.       "statusPort": "2379",
  211.       "version": "5.1.1",
  212.       "gitHash": "7cba1912b317a533e18b16ea2ba9a14ed2891129",
  213.       "startTime": "2021-08-11T08:23:32+02:00",
  214.       "upTime": "28.210220368s"
  215.     },
  216.     {
  217.       "instanceType": "tikv",
  218.       "listenHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  219.       "listenPort": "20160",
  220.       "statusHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  221.       "statusPort": "20180",
  222.       "version": "5.1.1",
  223.       "gitHash": "4705d7c6e9c42d129d3309e05911ec6b08a25a38",
  224.       "startTime": "2021-08-11T08:23:33+02:00",
  225.       "upTime": "27.210221447s"
  226.     },
  227.     {
  228.       "instanceType": "tiflash",
  229.       "listenHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  230.       "listenPort": "3930",
  231.       "statusHostHash": "4b84b15bff6ee5796152495a230e45e3d7e947d9",
  232.       "statusPort": "20292",
  233.       "version": "v5.1.1",
  234.       "gitHash": "c8fabfb50fe28db17cc5118133a69be255c40efd",
  235.       "startTime": "2021-08-11T08:23:40+02:00",
  236.       "upTime": "20.210222452s"
  237.     }
  238.   ],
  239.   "hostExtra": {
  240.     "cpuFlags": [
  241.       "fpu",
  242.       "vme",
  243.       "de",
  244.       "pse",
  245.       "tsc",
  246.       "msr",
  247.       "pae",
  248.       "mce",
  249.       "cx8",
  250.       "apic",
  251.       "sep",
  252.       "mtrr",
  253.       "pge",
  254.       "mca",
  255.       "cmov",
  256.       "pat",
  257.       "pse36",
  258.       "clflush",
  259.       "dts",
  260.       "acpi",
  261.       "mmx",
  262.       "fxsr",
  263.       "sse",
  264.       "sse2",
  265.       "ss",
  266.       "ht",
  267.       "tm",
  268.       "pbe",
  269.       "syscall",
  270.       "nx",
  271.       "pdpe1gb",
  272.       "rdtscp",
  273.       "lm",
  274.       "constant_tsc",
  275.       "art",
  276.       "arch_perfmon",
  277.       "pebs",
  278.       "bts",
  279.       "rep_good",
  280.       "nopl",
  281.       "xtopology",
  282.       "nonstop_tsc",
  283.       "cpuid",
  284.       "aperfmperf",
  285.       "pni",
  286.       "pclmulqdq",
  287.       "dtes64",
  288.       "monitor",
  289.       "ds_cpl",
  290.       "vmx",
  291.       "est",
  292.       "tm2",
  293.       "ssse3",
  294.       "sdbg",
  295.       "fma",
  296.       "cx16",
  297.       "xtpr",
  298.       "pdcm",
  299.       "pcid",
  300.       "sse4_1",
  301.       "sse4_2",
  302.       "x2apic",
  303.       "movbe",
  304.       "popcnt",
  305.       "tsc_deadline_timer",
  306.       "aes",
  307.       "xsave",
  308.       "avx",
  309.       "f16c",
  310.       "rdrand",
  311.       "lahf_lm",
  312.       "abm",
  313.       "3dnowprefetch",
  314.       "cpuid_fault",
  315.       "epb",
  316.       "invpcid_single",
  317.       "ssbd",
  318.       "ibrs",
  319.       "ibpb",
  320.       "stibp",
  321.       "ibrs_enhanced",
  322.       "tpr_shadow",
  323.       "vnmi",
  324.       "flexpriority",
  325.       "ept",
  326.       "vpid",
  327.       "ept_ad",
  328.       "fsgsbase",
  329.       "tsc_adjust",
  330.       "sgx",
  331.       "bmi1",
  332.       "avx2",
  333.       "smep",
  334.       "bmi2",
  335.       "erms",
  336.       "invpcid",
  337.       "mpx",
  338.       "rdseed",
  339.       "adx",
  340.       "smap",
  341.       "clflushopt",
  342.       "intel_pt",
  343.       "xsaveopt",
  344.       "xsavec",
  345.       "xgetbv1",
  346.       "xsaves",
  347.       "dtherm",
  348.       "ida",
  349.       "arat",
  350.       "pln",
  351.       "pts",
  352.       "hwp",
  353.       "hwp_notify",
  354.       "hwp_act_window",
  355.       "hwp_epp",
  356.       "md_clear",
  357.       "flush_l1d",
  358.       "arch_capabilities"
  359.     ],
  360.     "cpuModelName": "Intel(R) Core(TM) i7-10510U CPU @ 1.80GHz",
  361.     "os": "linux",
  362.     "platform": "fedora",
  363.     "platformFamily": "fedora",
  364.     "platformVersion": "34",
  365.     "kernelVersion": "5.13.5-200.fc34.x86_64",
  366.     "kernelArch": "x86_64",
  367.     "virtualizationSystem": "kvm",
  368.     "virtualizationRole": "host"
  369.   },
  370.   "reportTimestamp": 1628663040,
  371.   "trackingId": "a1ba1d97-b940-4d5b-a9d5-ddb0f2ac29e7",
  372.   "featureUsage": {
  373.     "txn": {
  374.       "asyncCommitUsed": true,
  375.       "onePCUsed": true,
  376.       "txnCommitCounter": {
  377.         "twoPC": 9,
  378.         "asyncCommit": 0,
  379.         "onePC": 0
  380.       }
  381.     },
  382.     "clusterIndex": {},
  383.     "temporaryTable": false,
  384.     "cte": {
  385.       "nonRecursiveCTEUsed": 0,
  386.       "recursiveUsed": 0,
  387.       "nonCTEUsed": 13
  388.     }
  389.   },
  390.   "windowedStats": [],
  391.   "slowQueryStats": {
  392.     "slowQueryBucket": {}
  393.   }
  394. }
  395. 1 row in set (0.0259 sec)

MySQL 兼容性

ADMIN 语句是 TiDB 对 MySQL 语法的扩展。

另请参阅