> show measurementsname:measurementsname----cpudiskdiskiokernelmemprocessesswapsystem
显示列/字段键
字段键就像数据库的 列
> show field keysname:cpufieldKeyfieldType-----------------usage_guestfloatusage_guest_nicefloatusage_idlefloatusage_iowaitfloatname:diskfieldKeyfieldType-----------------freeintegerinodes_freeintegerinodes_totalintegerinodes_usedinteger[ ... more keys ...]
Dump Table
最后,您可以通过执行以下操作来转储表:
select * from cpuname:cputime cpu host usage_guest usage_guest_nice usage_idle usage_iowait usage_irq usage_nice usage_softirq usage_steal usage_system usage_user-----------------------------------------------------------------------------------------------------------------------------1497018760000000000cpu-totalubuntu0099.297893681046000000.351053159478424140.351053159478424141497018760000000000cpu1ubuntu0099.69909729188728000000.200601805416222020.10030090270811101
在某些使用身份验证绕过的测试中,注意到表的名称需要用双引号括起来,例如:select * from "cpu"