On Thursday, November 17, 2016 at 10:32:59 AM UTC+2, Cameron Sparr wrote: > Are you sure the timestamps match? I believe limit 5 will get only the first > 5 measurements. You might want to add a "where time..." Clause to your query. > > > > > > > > > > > > > > > On Thu, 17 Nov 2016 at 05:42 [email protected] <[email protected]> > wrote: > > > > > select "available","free","used","total" from "mem" LIMIT 5 > > name: mem > > time available free used total > > ---- --------- ---- ---- ----- > > 1479290780000000000 4965396480 494465024 3289235456 > 8254631936 > > 1479290790000000000 4964085760 493146112 3290546176 > 8254631936 > > 1479290800000000000 4961816576 490848256 3292815360 > 8254631936 > > 1479290810000000000 4963905536 492933120 3290726400 > 8254631936 > > 1479290830000000000 4966408192 495419392 3288223744 > 8254631936 > > > > > > > > > On Thursday, November 17, 2016 at 11:09:02 AM UTC+5:30, [email protected] > wrote: > > > Here is the output of 'cat /proc/meminfo' > > > > > > $ cat /proc/meminfo > > > MemTotal: 8061164 kB > > > MemFree: 303632 kB > > > Buffers: 321168 kB > > > Cached: 4159668 kB > > > SwapCached: 7672 kB > > > Active: 4480804 kB > > > Inactive: 2718532 kB > > > Active(anon): 1896616 kB > > > Inactive(anon): 826976 kB > > > Active(file): 2584188 kB > > > Inactive(file): 1891556 kB > > > Unevictable: 16 kB > > > Mlocked: 16 kB > > > SwapTotal: 10305532 kB > > > SwapFree: 10221864 kB > > > Dirty: 84 kB > > > Writeback: 0 kB > > > AnonPages: 2711008 kB > > > Mapped: 109832 kB > > > Shmem: 5092 kB > > > Slab: 418160 kB > > > SReclaimable: 380316 kB > > > SUnreclaim: 37844 kB > > > KernelStack: 8768 kB > > > PageTables: 39152 kB > > > NFS_Unstable: 0 kB > > > Bounce: 0 kB > > > WritebackTmp: 0 kB > > > CommitLimit: 14336112 kB > > > Committed_AS: 5330144 kB > > > VmallocTotal: 34359738367 kB > > > VmallocUsed: 173176 kB > > > VmallocChunk: 34359547656 kB > > > HardwareCorrupted: 0 kB > > > AnonHugePages: 2273280 kB > > > HugePages_Total: 0 > > > HugePages_Free: 0 > > > HugePages_Rsvd: 0 > > > HugePages_Surp: 0 > > > Hugepagesize: 2048 kB > > > DirectMap4k: 10240 kB > > > DirectMap2M: 8378368 kB > > > > > > > > > On Wednesday, November 16, 2016 at 10:39:36 PM UTC+5:30, > > [email protected] wrote: > > > > also please include output from "cat /proc/meminfo" > > > > > > > > On Wednesday, November 16, 2016 at 12:44:12 PM UTC, [email protected] > > > wrote: > > > > > I have a machine with cent os in which influxdb and telegraf are > > > > configured. > > > > > The memory usage in "mem" table in 'telegraf' database is ~3136 MB. It > > > > is not matching with the memory usage shown in the output of top/free > > > > command(7451 MB). What could be wrong here? Please suggest. > > > > > > > > > > > use telegraf > > > > > Using database telegraf > > > > > > select "used","total" from "mem" LIMIT 5 > > > > > name: mem > > > > > time used total > > > > > ---- ---- ----- > > > > > 1479290780000000000 3289235456 8254631936 > > > > > 1479290790000000000 3290546176 8254631936 > > > > > 1479290800000000000 3292815360 8254631936 > > > > > 1479290810000000000 3290726400 8254631936 > > > > > 1479290830000000000 3288223744 8254631936 > > > > > > > > > > > > > > > $ free -m > > > > > total used free shared buffers > > > > cached > > > > > Mem: 7872 7451 420 4 311 > > > > 3964 > > > > > -/+ buffers/cache: 3175 4696 > > > > > Swap: 10063 80 9983
LIMIT is not guaranteed to return ordered results. Please add "ORDER BY TIME DESC" before applying the "LIMIT 5" clause. -- Remember to include the version number! --- You received this message because you are subscribed to the Google Groups "InfluxData" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/influxdb. To view this discussion on the web visit https://groups.google.com/d/msgid/influxdb/c0cec898-24cb-4d67-bbd6-ceb931ed98f3%40googlegroups.com. For more options, visit https://groups.google.com/d/optout.
