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

ADMIN SHOW TELEMETRY

ADMIN SHOW TELEMETRY

语法图

示例

MySQL 兼容性

另请参阅