2023年12月18日发(作者：)

LOAD DATA INFILE '/proc/stat'IGNORE INTO TABLE _statFIELDS TERMINATED BY''(@value,@val1,@val2,@val3,@val4,@val5,@val6,@val7,@val8,@val9,@val10)SETvalue=@value,user=IF(@value NOT LIKE 'cpu%', NULL,IF(@value！='cpu',IFNULL(@val1,0),IFNULL(@val2,0))),nice=IF(@value NOT LIKE 'cpu%',NULL,IF(@value！='cpu',IFNULL(@val2,0),IFNULL(@val3,0))),system=IF(@value NOT LIKE 'cpu%',NULL,IF(@value！='cpu',IFNULL(@val3,0),IFNULL(@val4,0))),idle=IF(@value NOT LIKE 'cpu%',NULL,IF(@value！='cpu',IFNULL(@val4,0),IFNULL(@val5,0))),iowait=IF(@value NOT LIKE 'cpu%',NULL,IF(@value！='cpu',IFNULL(@val5,0),IFNULL(@val6,0))),irq=IF(@value NOT LIKE 'cpu%',NULL,IF(@value！='cpu',IFNULL(@val6,0),IFNULL(@val7,0))),softirq=IF(@value NOT LIKE 'cpu%',NULL,IF(@value！='cpu',IFNULL(@val7,0),IFNULL(@val8,0))),steal=IF(@value NOT LIKE 'cpu%',NULL,IF(@value！='cpu',IFNULL(@val8,0),IFNULL(@val9,0))),guest=IF(@value NOT LIKE 'cpu%',NULL,IF(@value！='cpu',IFNULL(@val9,0),IFNULL(@val10,0))),other=IF(@value like 'cpu%',user+nice+system+idle+iowait+irq+softirq+steal+guest,@val1),time=now();接着查看表cpu_stat，可以看到类似如下的内容：select * from cpu_statG******************************************************id：1value：cpuuser：2632896nice：67761system：688488idle：4136329105iowait：1468238irq：0softirq：106303steal：148300guest：0other：4141441091time：2010-09-10 12：01：04******************************************************