<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" 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)">
<style>
<!--
/* 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:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:Arial;
color:windowtext;}
@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=purple>
<div class=Section1>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hi all, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<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).<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<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!<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<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?<o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Best, <o:p></o:p></span></font></p>
<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'><o:p> </o:p></span></font></p>
<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>
<!--[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>