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 语法的扩展。

另请参阅