501.65 * .89 exchange = 446.4685 * 1.05 = 468.791925 US
 nnnnnnnnn  
 
 
 NOTABLE: The Institute for Integrative Genome Biology at UC Riverside will
offer the next intensive workshop on "Next Generation Data Analysis" on Dec
5-8, 2014. Detailed information about this event and sign in instructions
are available on this site:

http://manuals.bioinformatics.ucr.edu/workshops

Due to the high demand for these event, please sign up as soon as possible.
These are not free, but are VERY good courses.

-----------------------------------------------------------------------------

select filename from location loc where loc.fsize > 3000 and loc.fsize < 10000 
and content.content 

SELECT filename FROM location loc where loc.fsize > 3000 and loc.fsize < 10000  


select filename from content c WHERE c.content REGEXP '\bBDUC\b';

select filename from content c  WHERE c.content like '%BDUC%' and c.content like 
'%dabrick%' ;

sqlite> select count(*) from (select filename from content c  WHERE c.content 
like '%BDUC%' or c.content like '%dabrick%') ;
38

And when we use 'and' instead of 'or':
sqlite> select count(*) from (select filename from content c  WHERE c.content 
like '%BDUC%' and  content.content like '%dabrick%') ;
1

sqlite> select content.filename, location.fsize from content join  location on
content.filename = location.filename WHERE content.content like '%BDUC%';




[root@compute-2-1 ~]# for II in b c d e f; do echo; echo == /dev/sd${II} == 
;smartctl -a /dev/sd${II} | grep 'Serial Number' ; done

== /dev/sdb ==
Serial Number:    W1F0BZLE

== /dev/sdc ==
Serial Number:    W1F04GQA

== /dev/sdd ==
Serial Number:    W1F0ABTL

== /dev/sde ==

== /dev/sdf ==
Serial Number:    W1F0BX14


[root@compute-2-1 ~]# mdadm --manage /dev/md0 --fail /dev/sde
mdadm: set /dev/sde faulty in /dev/md0
[root@compute-2-1 ~]# mdadm --manage /dev/md0 --remove /dev/sde
mdadm: hot removed /dev/sde from /dev/md0

[root@compute-2-1 ~]# cat /proc/mdstat
Personalities : [raid6] [raid5] [raid4] 
md0 : active raid5 sdd[2] sdf[5] sdb[0] sdc[1]
      11721064448 blocks super 1.0 level 5, 1024k chunk, algorithm 2 [5/4] 
[UUU_U]

mdadm --manage /dev/md0 --add /dev/sde
[root@compute-2-1 ~]# mdadm --manage /dev/md0 --add /dev/sde
mdadm: added /dev/sde
[root@compute-2-1 ~]# cat /proc/mdstat 
Personalities : [raid6] [raid5] [raid4] 
md0 : active raid5 sde[6] sdd[2] sdc[1] sdf[5] sdb[0]
      11721064448 blocks super 1.0 level 5, 1024k chunk, algorithm 2 [5/4] 
[UUU_U]
      [>....................]  recovery =  0.0% (984576/2930266112) 
finish=446.2min speed=109397K/sec