<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:st1="urn:schemas-microsoft-com:office:smarttags" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered medium)">
<base href="x-msg://185/">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]--><o:SmartTagType
namespaceuri="urn:schemas-microsoft-com:office:smarttags" name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="PostalCode"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="City"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<!--[if !mso]>
<style>
st1\:*{behavior:url(#default#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:blue;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal;
font-family:Arial;
color:navy;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:Arial;
color:navy;}
@page Section1
{size:612.0pt 792.0pt;
margin:72.0pt 90.0pt 72.0pt 90.0pt;}
div.Section1
{page:Section1;}
-->
</style>
</head>
<body lang=EN-US link=blue vlink=blue style='word-wrap: break-word;-webkit-nbsp-mode: space;
-webkit-line-break: after-white-space'>
<div class=Section1>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>For anyone following this:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>The speed problem appears to have been
overcome by running an OPTIMISE command on the database via mysql.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Speed is approximately x37 faster.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Nervous breakdown narrowly averted.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Oliver, Gavin <br>
<b><span style='font-weight:bold'>Sent:</span></b> 06 October 2010 15:02<br>
<b><span style='font-weight:bold'>To:</span></b> dev@ensembl.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> Re: [ensembl-dev] EFG
Array Mapping inconsistent performance</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Hi, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>With the v60 EFG patches applied I have
been looking into these queries more as they are still very slow.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>They take around 66 seconds on my desktop
and 36 seconds on my server. <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>As a reminder, an example of the query
looks like this:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>>SELECT pf.probe_feature_id,
pf.seq_region_id, pf.seq_region_start, pf.seq_region_end, pf.seq_region_strand,
pf.probe_id, pf.analysis_id, pf.mismatches, pf.cigar_line, p.name,
p.probe_set_id FROM (probe_feature pf, probe p, array_chip ac) WHERE ac.array_id
IN (56,52,54,55,53,58,57) and ac.array_chip_id=p.array_chip_id AND
pf.seq_region_id = 581 AND pf.seq_region_start <= 95818078 AND
pf.seq_region_end >= 95815747 AND pf.seq_region_start >= 94655311 AND
pf.probe_id = p.probe_id GROUP by pf.probe_feature_id ORDER BY
pf.seq_region_id, >pf.seq_region_start, pf.probe_feature_id;<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Some details from the sloq query log:<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'># Query_time: 66.536002 Lock_time:
0.000324 Rows_sent: 96 Rows_examined: 13635584<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Explain shows<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'># Using where; Using temporary; Using
filesort<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Apparently ‘filesort’ can mean
a sort on disk or in memory but it indicates that the sort can’t be
performed from an index.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Using the profiling ability in mysql I was
able to see that 99% of the query time is spent "copying to tmp
table".<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>I don't know if this is happening in disk
or memory. I know that there are no TEXT/BLOB fields in the tables being
queried though. Also, I should point out there is no real load on the server.<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'>Does anyone have any thoughts on this?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 color=navy face=Arial><span style='font-size:
10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>
<div>
<div class=MsoNormal align=center style='text-align:center'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'>
<hr size=2 width="100%" align=center tabindex=-1>
</span></font></div>
<p class=MsoNormal><b><font size=2 face=Tahoma><span style='font-size:10.0pt;
font-family:Tahoma;font-weight:bold'>From:</span></font></b><font size=2
face=Tahoma><span style='font-size:10.0pt;font-family:Tahoma'> Nathan Johnson [mailto:njohnson@ebi.ac.uk]
<br>
<b><span style='font-weight:bold'>Sent:</span></b> 15 September 2010 10:59<br>
<b><span style='font-weight:bold'>To:</span></b> Oliver, Gavin<br>
<b><span style='font-weight:bold'>Cc:</span></b> dev@ensembl.org<br>
<b><span style='font-weight:bold'>Subject:</span></b> [SPAM] - Re:
[ensembl-dev] EFG Array Mapping inconsistent performance - Email found in
subject</span></font><o:p></o:p></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Hi Gavin<o:p></o:p></span></font></p>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>For v60 we have now set the cigar_line field to a VARCHAR with a
sensible field length of 50. The current largest cigar_line in human is around
30 characters long.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>This should remove the issue of tmp tables being created on disk.<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>Nath<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
<div>
<div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'>On 25 Aug 2010, at 10:12, Oliver, Gavin wrote:<o:p></o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3
face="Times New Roman"><span style='font-size:12.0pt'><o:p> </o:p></span></font></p>
<span style='orphans: 2;widows: 2;-webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing: 0px;-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto;-webkit-text-stroke-width: 0px;word-spacing:
0px'>
<div link=blue vlink=purple>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi all,<u1:p></u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>I’ve been running some tests on our server, annotating
a test batch of around 50 Affy probesets (25-mer probes, 11 probes per set).<u1:p></u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Running the same batch of probesets has completed in
anywhere from 30 mins to just over 2 hours!<u1:p></u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The load on the server does not seem to be the issue.
I have run a number of mysql tuners to optimize things and the only
complaint I am seeing is that 50% of our temporary tables are being created on
disk rather than in memory. Apparently this is a major cause of
inconsistent mySQL performance. I have increased all relevant variables
but it does not seem to affect the % of temp tables being created on disk.
I know that BLOB and TEXT fields cannot be stored in memory and must be
created on disk so I’m beginning to think this may be the problem.
Has anyone else experienced similar problems or does anyone have any
ideas on how the BLOB and TEXT fields could be redefined to enable in-memory
storage?<u1:p></u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Best,<u1:p></u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><u1:p> </u1:p></span></font><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Gavin</span></font><o:p></o:p></p>
</div>
<u1:p></u1:p>
<div>
<p class=MsoNormal><strong><b><font size=3 color=blue face="Times New Roman"><span
style='font-size:12.0pt;color:blue'> </span></font></b></strong><o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><b><font size=3 color=black face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt;color:black;font-weight:bold'>The contents
of this message and any attachments to it are confidential and may be legally
privileged. If you have received this message in error, you should delete it
from your system immediately and advise the sender.<u1:p></u1:p></span></font><o:p></o:p></b></p>
</div>
<div>
<p class=MsoNormal><b><font size=3 color=black face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt;color:black;font-weight:bold'><u1:p> </u1:p></span></font><o:p></o:p></b></p>
</div>
<div>
<p class=MsoNormal><b><font size=3 color=black face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt;color:black;font-weight:bold'>Almac Group
(UK) Limited, registered no. NI061368. <span class=apple-converted-space> </span>Almac
Sciences Limited, registered no. NI041550. <span
class=apple-converted-space> </span>Almac Discovery Limited, registered
no. NI046249.<span class=apple-converted-space> </span> Almac Pharma
Services Limited, registered no. NI045055. <span
class=apple-converted-space> </span>Almac Clinical Services Limited,
registered no. NI041905. <span class=apple-converted-space> </span>Almac
Clinical Technologies Limited, registered no. NI061202.<span
class=apple-converted-space> </span> Almac Diagnostics Limited,
registered no. NI043067. <span class=apple-converted-space> </span>All
preceding companies are registered in<span class=apple-converted-space> </span><st1:country-region
u2_x003a_st="on" w:st="on">Northern Ireland</st1:country-region><span
class=apple-converted-space> </span>with a registered office address of
Almac House, 20 Seagoe Industrial Estate,<st1:city u2:st="on"><st1:place w:st="on"><st1:City
w:st="on">Craigavon</st1:city></st1:City>,<span class=apple-converted-space> <st1:postalcode u2:st="on"></span><st1:PostalCode
w:st="on">BT63 5QD</st1:postalcode></st1:PostalCode>,<span
class=apple-converted-space> </span><st1:country-region u2_x003a_st="on"
w:st="on">UK</st1:place></st1:country-region></st1:place>.<span
class=apple-converted-space> </span> <u1:p></u1:p></span></font><o:p></o:p></b></p>
</div>
<div>
<p class=MsoNormal><b><font size=3 color=black face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt;color:black;font-weight:bold'><u1:p> </u1:p></span></font><o:p></o:p></b></p>
</div>
<div>
<p class=MsoNormal><b><font size=3 color=black face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt;color:black;font-weight:bold'>Almac Sciences
(<st1:country-region u2_x003a_st="on" w:st="on">Scotland</st1:country-region>)
Limited, registered in<span class=apple-converted-space> </span><st1:place
w:st="on"><st1:country-region u2_x003a_st="on" w:st="on">Scotland</st1:country-region></st1:place><span
class=apple-converted-space> </span>no. SC154034.<u1:p></u1:p></span></font><o:p></o:p></b></p>
</div>
<div>
<p class=MsoNormal><b><font size=3 color=black face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt;color:black;font-weight:bold'><u1:p> </u1:p></span></font><o:p></o:p></b></p>
</div>
<div>
<p class=MsoNormal><b><font size=3 color=black face="Times New Roman"><span
lang=EN-GB style='font-size:12.0pt;color:black;font-weight:bold'>Almac Clinical
Services LLC, Almac Clinical Technologies LLC and Almac Diagnostics LLC are<span
class=apple-converted-space> <st1:state u2:st="on"></span><st1:place
u2_x003a_st="on" w:st="on">Delaware</st1:state></st1:place><span
class=apple-converted-space> </span>limited liability companies and Almac
Group Incorporated is a Delaware Corporation. <span
class=apple-converted-space> </span>More information on the Almac Group
can be found on the Almac website:<a href="http://www.almacgroup.com">www.almacgroup.com</a><u1:p></u1:p></span></font><o:p></o:p></b></p>
</div>
<p class=MsoNormal><font size=4 face=Helvetica><span style='font-size:13.5pt;
font-family:Helvetica'>_______________________________________________<br>
Dev mailing list<br>
<a href="mailto:Dev@ensembl.org">Dev@ensembl.org</a><br>
<a href="http://lists.ensembl.org/mailman/listinfo/dev">http://lists.ensembl.org/mailman/listinfo/dev</a><o:p></o:p></span></font></p>
</div>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'><o:p> </o:p></span></font></p>
</span>
<div><span style='orphans: 2;text-align:auto;widows: 2;-webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing: 0px;-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto;-webkit-text-stroke-width: 0;word-spacing:0px'><span
style='-webkit-border-horizontal-spacing: 0px;-webkit-border-vertical-spacing: 0px;
-webkit-text-decorations-in-effect: none;-webkit-text-size-adjust: auto;
orphans: 2;widows: 2;word-spacing:0px'>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'><span
style='-webkit-border-horizontal-spacing: 0px;-webkit-border-vertical-spacing: 0px;
-webkit-text-decorations-in-effect: none;-webkit-text-size-adjust: auto;
orphans: 2;widows: 2;word-spacing:0px'><span style='-webkit-border-horizontal-spacing: 0px;
-webkit-border-vertical-spacing: 0px;-webkit-text-decorations-in-effect: none;
-webkit-text-size-adjust: auto;orphans: 2;widows: 2;word-spacing:0px'>Nathan
Johnson<o:p></o:p></span></font></p>
</div>
</span>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'>Scientific Programmer<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'>European
Bioinformatics Institute<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'>Wellcome Trust Genome
Campus<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'>Hinxton<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><st1:place w:st="on"><st1:City w:st="on"><font size=1
color=black face=Helvetica><span style='font-size:9.0pt;font-family:Helvetica;
color:black'>Cambridge</span></font></st1:City></st1:place><font size=1
color=black face=Helvetica><span style='font-size:9.0pt;font-family:Helvetica;
color:black'> CB10 1SD<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'>Email: <a
href="mailto:njohnson@ebi.ac.uk">njohnson@ebi.ac.uk</a><o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'>TelNo: (+44)1223
492629<o:p></o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'><o:p> </o:p></span></font></p>
</div>
<div>
<p class=MsoNormal><font size=1 color=black face=Helvetica><span
style='font-size:9.0pt;font-family:Helvetica;color:black'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><font size=3 color=black
face="Times New Roman"><span style='font-size:12.0pt;color:black'><o:p> </o:p></span></font></p>
</div>
<p class=MsoNormal><font size=3 face="Times New Roman"><span style='font-size:
12.0pt'></span><o:p> </o:p></span></font></p>
</div>
</span></span></div>
<!--[object_id=#almacgroup.com#]--><FONT face=Tahoma size=2>
<P class=MsoNormal><STRONG><B><SPAN style="FONT-SIZE: 12pt; COLOR: blue"><FONT face="Times New Roman"> </FONT></P>
<P class=MsoNormal><FONT color=#000000><SPAN lang=EN-GB style="FONT-FAMILY: 'Times New Roman'">The contents of this message and any attachments to it are confidential and may be legally privileged. If you have received this message in error, you should delete it from your system immediately and advise the sender.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="mso-layout-grid-align: none"><SPAN lang=EN-GB style="COLOR: black; FONT-FAMILY: 'Times New Roman'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="mso-layout-grid-align: none"><FONT color=#0000ff><SPAN lang=EN-GB style="COLOR: black; FONT-FAMILY: 'Times New Roman'">Almac Group (UK) Limited, registered no. NI061368.<SPAN style="mso-spacerun: yes"> </SPAN>Almac Sciences Limited, registered no. NI041550.<SPAN style="mso-spacerun: yes"> </SPAN>Almac Discovery Limited, registered no. NI046249. <SPAN style="mso-spacerun: yes"> </SPAN>Almac Pharma Services Limited, registered no. NI045055.<SPAN style="mso-spacerun: yes"> </SPAN>Almac Clinical Services Limited, registered no. NI041905.<SPAN style="mso-spacerun: yes"> </SPAN>Almac Clinical Technologies Limited, registered no. NI061202. <SPAN style="mso-spacerun: yes"> </SPAN>Almac Diagnostics Limited, registered no. NI043067.<SPAN style="mso-spacerun: yes"> </SPAN>All preceding companies are registered in <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" /><st1:country-region w:st="on">Northern Ireland</st1:country-region> with a registered office address of Almac House, 20 Seagoe Industrial Estate, <st1:place w:st="on"><st1:City w:st="on">Craigavon</st1:City>, <st1:PostalCode w:st="on">BT63 5QD</st1:PostalCode>, <st1:country-region w:st="on">UK</st1:country-region></st1:place>. <SPAN style="mso-spacerun: yes"> </SPAN><o:p></o:p></SPAN></FONT></P>
<P class=MsoNormal style="mso-layout-grid-align: none"><SPAN lang=EN-GB style="COLOR: black; FONT-FAMILY: 'Times New Roman'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="mso-layout-grid-align: none"><SPAN lang=EN-GB style="COLOR: black; FONT-FAMILY: 'Times New Roman'">Almac Sciences (<st1:country-region w:st="on">Scotland</st1:country-region>) Limited, registered in <st1:country-region w:st="on"><st1:place w:st="on">Scotland</st1:place></st1:country-region> no. SC154034. <o:p></o:p></SPAN></P>
<P class=MsoNormal style="mso-layout-grid-align: none"><SPAN lang=EN-GB style="COLOR: black; FONT-FAMILY: 'Times New Roman'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal style="mso-layout-grid-align: none"><SPAN lang=EN-GB style="COLOR: black; FONT-FAMILY: 'Times New Roman'">Almac Clinical Services LLC, Almac Clinical Technologies LLC and Almac Diagnostics LLC are <st1:State w:st="on"><st1:place w:st="on">Delaware</st1:place></st1:State> limited liability companies and Almac Group Incorporated is a Delaware Corporation.<SPAN style="mso-spacerun: yes"> </SPAN>More information on the Almac Group can be found on the Almac website: www.almacgroup.com<o:p></o:p></SPAN></P></SPAN></B></STRONG></FONT></body>
</html>