> select "available","free","used","total" from "mem" ORDER BY time DESC
LIMIT 5
name: mem
time available free
used total
---------------------- --------- ----
---- -----
1479383950000000000 5497937920 931053568 2756694016
8254631936
1479383940000000000 5498200064 931323904 2756431872
8254631936
1479383930000000000 5500416000 933548032 2754215936
8254631936
1479383920000000000 5500149760 933294080 2754482176
8254631936
1479383910000000000 5500268544 933421056 2754363392
8254631936
*$ cat /proc/meminfo*
MemTotal: 8061164 kB
MemFree: 824692 kB
Buffers: 321176 kB
Cached: 4138812 kB
SwapCached: 7440 kB
Active: 4296360 kB
Inactive: 2404148 kB
Active(anon): 1769156 kB
Inactive(anon): 476456 kB
Active(file): 2527204 kB
Inactive(file): 1927692 kB
Unevictable: 16 kB
Mlocked: 16 kB
SwapTotal: 10305532 kB
SwapFree: 10218244 kB
Dirty: 39788 kB
Writeback: 0 kB
AnonPages: 2233480 kB
Mapped: 112284 kB
Shmem: 5092 kB
Slab: 395252 kB
SReclaimable: 356228 kB
SUnreclaim: 39024 kB
KernelStack: 9312 kB
PageTables: 39168 kB
NFS_Unstable: 0 kB
Bounce: 0 kB
WritebackTmp: 0 kB
CommitLimit: 14336112 kB
Committed_AS: 6043036 kB
VmallocTotal: 34359738367 kB
VmallocUsed: 173176 kB
VmallocChunk: 34359547656 kB
HardwareCorrupted: 0 kB
AnonHugePages: 1726464 kB
HugePages_Total: 0
HugePages_Free: 0
HugePages_Rsvd: 0
HugePages_Surp: 0
Hugepagesize: 2048 kB
DirectMap4k: 10240 kB
DirectMap2M: 8378368 kB
*$ free*
total used free shared buffers
cached
Mem: 8061164 7147720 913444 5092 321176 4139012
-/+ buffers/cache: 2687532 5373632
Swap: 10305532 87288 10218244
On Thu, Nov 17, 2016 at 3:21 PM, <[email protected]> wrote:
> 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.
--
Thanks & Regards
Veera Reddy Ganta
--
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/CALOPAeBBazPDJrCmm%2BizMkNP3D53Xy6VYaixCG%2BBPZvWjH%2BjNw%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
