Chinaunix

标题: 读取log文档，利用行首建表的问题 [打印本页]

作者: bighead0088 时间: 2015-06-23 14:56
标题: 读取log文档，利用行首建表的问题
文件内容大概如下：
BBBC,021,hdisk0       00f61a0489cfa916                   rootvg       active
BBBC,022,hdisk1       00f61a043c020771                   oradatavg1
BBBC,023,hdisk2       00f61a0439e8d52e                   None
BBBC,024,hdisk3       none                               None
BBBC,025,hdisk4       none                               None
BBBC,026,hdisk5       none                               None
BBBC,027,hdisk6       none                               None
BBBV,000,VOLUME GROUP:    rootvg                VG IDENTIFIER:  00f61a0400004c000000014692d70ac7
BBBV,001,VG STATE:          active                PP SIZE:       128 megabyte(s)
BBBV,002,VG PERMISSION:    read/write             TOTAL PPs:    799 (102272 megabytes)
BBBV,003,MAX LVs:          256                   FREE PPs:    4 (512 megabytes)
BBBV,004,LVs:             19                      USED PPs:    795 (101760 megabytes)
BBBV,005,OPEN LVs:          16                      QUORUM:       2 (Enabled)
BBBV,006,TOTAL PVs:       1                      VG DESCRIPTORS: 2
BBBV,007,STALE PVs:       0                      STALE PPs:    0
BBBV,008,ACTIVE PVs:       1                      AUTO ON:       yes
BBBV,009,MAX PPs per VG:    32512
BBBV,010,MAX PPs per PV:    1016                   MAX PVs:       32
BBBV,011,LTG size (Dynamic): 256 kilobyte(s)       AUTO SYNC:    no
BBBV,012,HOT SPARE:       no                      BB POLICY:    relocatable
BBBV,013,PV RESTRICTION:    none                   INFINITE RETRY: no
CPU_ALL,CPU Total test1,User%,Sys%,Wait%,Idle%,Busy,PhysicalCPUs
PCPU_ALL,PCPU Total test1,User  ,Sys  ,Wait  ,Idle  , Entitled Capacity
SCPU_ALL,SCPU Total test1,User  ,Sys  ,Wait  ,Idle
CPU01,CPU 1 test1,User%,Sys%,Wait%,Idle%
CPU02,CPU 2 test1,User%,Sys%,Wait%,Idle%
CPU03,CPU 3 test1,User%,Sys%,Wait%,Idle%
CPU04,CPU 4 test1,User%,Sys%,Wait%,Idle%
CPU05,CPU 5 test1,User%,Sys%,Wait%,Idle%
CPU06,CPU 6 test1,User%,Sys%,Wait%,Idle%
CPU07,CPU 7 test1,User%,Sys%,Wait%,Idle%
CPU08,CPU 8 test1,User%,Sys%,Wait%,Idle%
PCPU01,PCPU 1 test1,User ,Sys ,Wait ,Idle
PCPU02,PCPU 2 test1,User ,Sys ,Wait ,Idle
PCPU03,PCPU 3 test1,User ,Sys ,Wait ,Idle
PCPU04,PCPU 4 test1,User ,Sys ,Wait ,Idle

log文档如上：现在想利用shell，把每个行首生成BBBC，BBBV，CPU，PCPU，SCPU，CPU的mysql数据库的表文件，并把每行写入对应行首的信息（如果可以根据每一个第一次行首的分隔符建列那就更好了）

作者: hjfeng1988 时间: 2015-06-23 15:21
好奇怪的要求

欢迎光临 Chinaunix (http://bbs.chinaunix.net/)