1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
|
DROP TABLE IF EXISTS t1;
CREATE TABLE t1 (a int) ENGINE=FILESYSTEM,FILE="../../filesystem_ln/select_meminfo.data",FORMAT="KEY_VALUE",COL_SEPARATOR=": ";
SELECT * FROM t1;
Active AnonPages Bounce Buffers Cached CommitLimit Committed_AS DirectMap2M DirectMap4k Dirty HugePages_Free HugePages_Rsvd HugePages_Surp HugePages_Total Hugepagesize Inactive Mapped MemFree MemTotal NFS_Unstable PageTables SReclaimable SUnreclaim Slab SwapCached SwapFree SwapTotal VmallocChunk VmallocTotal VmallocUsed Writeback WritebackTmp
1526364 198768 0 221004 2829356 2600136 495728 4186112 7040 1916 0 0 0 0 2048 1722772 51064 502844 4059680 0 27124 198000 12076 210076 0 570296 570296 34359655499 34359738367 82808 0 0
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`Active` VARCHAR(8),
`AnonPages` VARCHAR(7),
`Bounce` VARCHAR(2),
`Buffers` VARCHAR(7),
`Cached` VARCHAR(8),
`CommitLimit` VARCHAR(8),
`Committed_AS` VARCHAR(7),
`DirectMap2M` VARCHAR(8),
`DirectMap4k` VARCHAR(5),
`Dirty` VARCHAR(5),
`HugePages_Free` VARCHAR(2),
`HugePages_Rsvd` VARCHAR(2),
`HugePages_Surp` VARCHAR(2),
`HugePages_Total` VARCHAR(2),
`Hugepagesize` VARCHAR(5),
`Inactive` VARCHAR(8),
`Mapped` VARCHAR(6),
`MemFree` VARCHAR(7),
`MemTotal` VARCHAR(8),
`NFS_Unstable` VARCHAR(2),
`PageTables` VARCHAR(6),
`SReclaimable` VARCHAR(7),
`SUnreclaim` VARCHAR(6),
`Slab` VARCHAR(7),
`SwapCached` VARCHAR(2),
`SwapFree` VARCHAR(7),
`SwapTotal` VARCHAR(7),
`VmallocChunk` VARCHAR(12),
`VmallocTotal` VARCHAR(12),
`VmallocUsed` VARCHAR(6),
`Writeback` VARCHAR(2),
`WritebackTmp` VARCHAR(2)
) ENGINE=FILESYSTEM FILE='../../filesystem_ln/select_meminfo.data', FORMAT='KEY_VALUE', COL_SEPARATOR=': ' COLLATE = utf8_general_ci
DROP TABLE t1;
|