数据库批量转化

加班转数据

[wds@root ~]# cat /proc/cpuinfo  | grep "physical id" | sort |uniq | wc -l
2

[wds@root ~]# cat /proc/cpuinfo  | grep "processor" | sort |uniq | wc -l
8

 

[wds@root ~]# cat /proc/cpuinfo  | grep "cache size"  | tail -1

cache size      : 6144 KB

[wds@root ~]# cat /proc/meminfo  | grep MemTotal
MemTotal:     16432304 kB

[wds@root ~]# uptime
 02:12:37 up 206 days, 11:25,  1 user,  load average: 1.00, 1.00, 1.00

数据增加字段
alter table wds add pwd_1 char(40) not null after pwd, add pwd_2 char(32) not null after pwd,add pwd_3 char(40) not null after id;   8.81 sec

 

转化
update wds set pwd_1=md5(pwd), pwd2=sha1(left(pwd,10)) ,pwd_3=sha1(pwd); #17.38 sec

全程耗时2小时30分钟，近5亿数据。