<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en" dir="ltr">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Compose tips</title>
<link rel="alternate" type="application/rss+xml" title="Everita" href="http://www.mysqlperformancetuning.com/rss.xml" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="shortcut icon" href="/sites/everita.com/files/everita_favicon_0.ico" type="image/x-icon" />
<link type="text/css" rel="stylesheet" media="all" href="/sites/everita.com/files/css/css_210a69fe2e8822601a3864dd8df649e3.css" />
<!--[if lte IE 7]>
<link type="text/css" rel="stylesheet" media="all" href="/sites/everita.com/files/ie.css" />
<![endif]-->
<meta name="geo.placename" content="Oxford" />
<meta name="geo.region" content="GB" />
</head>
<body id="b">
<div id="container">
<div id="header">
<ul id="navbar">
<li class="logo ">
<a href="/" title="Our Home Page">Everita</a>
</li>
<!--
<li class="">
<a href="/how-the-newton-virus-was-made" title="The Newton Virus: How It Was Made">Newton Virus</a>
</li>
-->
<li class="">
<a href="http://www.mysqlperformancetuning.com/mysql-lamp-and-drupal-performance-optimization" title="Everita: A MySQL, LAMP and Drupal Performance Consultancy">Performance Consultancy</a>
</li>
<li class="">
<a href="/software-design-and-development-in-oxford-and-reading" title="Everita: Boutique Software Design And Development">Development</a>
</li>
<li class="">
<a href="/iphone-app-and-mobile-phone-development" title="Everita: Phone And Mobile Phone Application Development">iPhone</a>
</li>
<li class="">
<a href="/mysql-lamp-and-drupal-services-from-everita" title="Everita: Request MySQL, LAMP And Drupal Services ">Services</a>
</li>
<li class="">
<a href="/about-everita" title="Dial 'E' For Everita">About Us</a>
</li>
</ul>
<hr class="div" />
<div id="mast">
<div id="back">
<div id="leada" class="lead">
<img src="http://images.everita.com/sites/all/themes/everita/images/tipus-itiger-logo-small-new.png" alt="Tipu's iTiger" />
<h2><a href="/lightwave-collada-and-opengles-on-the-iphone">Tipu's iTiger</a></h2>
<p>Stunning 3D graphics<br /> on the iPhone</p>
</div>
<div id="leadb" class="lead">
<img src="http://images.everita.com/sites/all/themes/everita/images/newton-virus-icon-small.png" alt="Newton Virus" />
<h2><a href="/how-the-newton-virus-was-made">Newton Virus</a></h2>
<p>Learn how the acclaimed Newton Virus was made</p>
</div>
<div id="subleads">
<h2><a href="http://www.mysqlperformancetuning.com">MySQL Performance Tuning</a></h2>
<ul>
<li><a href="http://www.mysqlperformancetuning.com/how-to-speed-up-mysql-by-optimization"><strong>Speed Up MySQL</strong></a> An introduction to optimization</li>
<li><a href="http://www.mysqlperformancetuning.com/how-to-reduce-table_locks_waited-in-mysql-myisam"><strong>Table Locks</strong></a> Why they happen, and how to reduce them</li>
<li><a href="http://www.mysqlperformancetuning.com/mysql-lamp-and-drupal-performance-optimization"><strong>Reduce Costs</strong></a> Make better use of your server hardware</li>
</ul>
</div>
</div>
</div>
</div>
<div class="wrapper">
<div class="left1">
<ul class="tips"><li id="filter-filter-2">Web page addresses and e-mail addresses turn into links automatically.</li><li id="filter-filter-0"><p>Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd></p>
<p>This site allows HTML content. While learning all of HTML may feel intimidating, learning how to use a very small number of the most basic HTML "tags" is very easy. This table provides examples for each tag that is enabled on this site.</p>
<p>For more information see W3C's <a href="http://www.w3.org/TR/html/">HTML Specifications</a> or use your favorite search engine to find other sites that explain HTML.</p><table class="sticky-enabled">
<thead><tr><th>Tag Description</th><th>You Type</th><th>You Get</th> </tr></thead>
<tbody>
<tr class="odd"><td class="description">Anchors are used to make links to other pages.</td><td class="type"><code><a href="http://www.everita.com">Everita : MySQL Performance Tuning</a></code></td><td class="get"><a href="http://www.everita.com">Everita : MySQL Performance Tuning</a></td> </tr>
<tr class="even"><td class="description">Emphasized</td><td class="type"><code><em>Emphasized</em></code></td><td class="get"><em>Emphasized</em></td> </tr>
<tr class="odd"><td class="description">Strong</td><td class="type"><code><strong>Strong</strong></code></td><td class="get"><strong>Strong</strong></td> </tr>
<tr class="even"><td class="description">Cited</td><td class="type"><code><cite>Cited</cite></code></td><td class="get"><cite>Cited</cite></td> </tr>
<tr class="odd"><td class="description">Coded text used to show programming source code</td><td class="type"><code><code>Coded</code></code></td><td class="get"><code>Coded</code></td> </tr>
<tr class="even"><td class="description">Unordered list - use the <li> to begin each list item</td><td class="type"><code><ul> <li>First item</li> <li>Second item</li> </ul></code></td><td class="get"><ul> <li>First item</li> <li>Second item</li> </ul></td> </tr>
<tr class="odd"><td class="description">Ordered list - use the <li> to begin each list item</td><td class="type"><code><ol> <li>First item</li> <li>Second item</li> </ol></code></td><td class="get"><ol> <li>First item</li> <li>Second item</li> </ol></td> </tr>
<tr class="even"><td class="description">Definition lists are similar to other HTML lists. <dl> begins the definition list, <dt> begins the definition term and <dd> begins the definition description.</td><td class="type"><code><dl> <dt>First term</dt> <dd>First definition</dd> <dt>Second term</dt> <dd>Second definition</dd> </dl></code></td><td class="get"><dl> <dt>First term</dt> <dd>First definition</dd> <dt>Second term</dt> <dd>Second definition</dd> </dl></td> </tr>
</tbody>
</table>
<p>Most unusual characters can be directly entered without any problems.</p>
<p>If you do encounter problems, try using HTML character entities. A common example looks like &amp; for an ampersand & character. For a full list of entities see HTML's <a href="http://www.w3.org/TR/html4/sgml/entities.html">entities</a> page. Some of the available characters include:</p><table class="sticky-enabled">
<thead><tr><th>Character Description</th><th>You Type</th><th>You Get</th> </tr></thead>
<tbody>
<tr class="odd"><td class="description">Ampersand</td><td class="type"><code>&amp;</code></td><td class="get">&</td> </tr>
<tr class="even"><td class="description">Greater than</td><td class="type"><code>&gt;</code></td><td class="get">></td> </tr>
<tr class="odd"><td class="description">Less than</td><td class="type"><code>&lt;</code></td><td class="get"><</td> </tr>
<tr class="even"><td class="description">Quotation mark</td><td class="type"><code>&quot;</code></td><td class="get">"</td> </tr>
</tbody>
</table>
</li><li id="filter-filter-1">Lines and paragraphs are automatically recognized. The <br /> line break, <p> paragraph and </p> close paragraph tags are inserted automatically. If paragraphs are not recognized simply add a couple blank lines.</li></ul><br /> </div>
<div class="left2">
<div class="box" id="mysql">
<h2>Having MySQL <strong>performance</strong> issues?</h2>
<p>
We're experts at tuning MySQL and offer a MySQL performance consulting service.
</p>
<form action="">
<input type="button" class="button" value="Request Consultancy" onclick="document.location.href='/mysql-lamp-and-drupal-services-from-everita';" />
</form>
</div>
<div class="box" id="lamp">
<h2>LAMP stack not <strong>performing</strong> as you'd hoped?</h2>
<p>
Everita is experienced at getting the most out of your Linux, Apache, MySQL and Perl, PHP or Python setup. We're Drupal Experts.
</p>
<form action="">
<input type="button" class="button" value="Request Consultancy" onclick="document.location.href='/mysql-lamp-and-drupal-services-from-everita';" />
</form>
</div>
<div class="box rec" id="test">
<h2>Client Testimonials</h2>
<div id="cla">
<p style="font-style: italic; line-height: 1.1em; text-indent: -7px;">
<span class="quotemark">“</span>Steve was knowledgeable and diligent in helping us identify application characteristics which were impacting MySQL's efficiency.
</p>
<p style="font-style: italic; line-height: 1.1em">
I would recommend him to anyone needing help optimising MySQL server and look forward to working with him in the future.<span class="quotemark">”</span>
</p>
<p style="font-weight: bold; font-style: italic; line-height: 1.1em">
Richard Ainley<br />
Performance Tester<br />
WorkPlace Systems PLC
</p>
<p style="text-align: right; margin-top: -5px;">
<a href="#" onclick="javascript:showlayer('cla'); showlayer('clb'); return false;">Next »</a>
</p>
</div>
<div id="clb" style="display: none;">
<p style="font-style: italic; line-height: 1.1em; text-indent: -7px;">
<span class="quotemark">“</span>We have worked with Steve on a number of interactive public installations and web-based programming projects.
</p>
<p style="font-style: italic; line-height: 1.1em">
We're always impressed by his speedy problem solving, and ability to create complex, fail-safe solutions in unchartered domains.
</p>
<p style="font-style: italic; line-height: 1.1em">
I regularly recommend Steve and will continue to do so.<span class="quotemark">”</span>
</p>
<p style="font-weight: bold; font-style: italic; line-height: 1.1em">
Tim Simpson<br />
Studio Glithero
</p>
<p style="text-align: right; margin-top: -5px;">
<a href="#" onclick="javascript:showlayer('clb'); showlayer('clc'); return false;">Next »</a>
</p>
</div>
<div id="clc" style="display: none;">
<p style="font-style: italic; line-height: 1.1em; text-indent: -7px;">
<span class="quotemark">“</span>Steve did an excellent job with us helping to optimise our system. He was efficient, reasonable, and delivered on time.
</p>
<p style="font-style: italic; line-height: 1.1em">
I would recommend him to anyone who needs help with a LAMP system and will certainly continue working with him.<span class="quotemark">”</span>
</p>
<p style="font-weight: bold; font-style: italic; line-height: 1.1em">
David Coarsey<br />
CEO, Guided e-Learning
</p>
<p style="text-align: right; margin-top: -5px;">
<a href="#" onclick="javascript:showlayer('clc'); showlayer('cld'); return false;">Next »</a>
</p>
</div>
<div id="cld" style="display: none;">
<p style="font-style: italic; line-height: 1.1em; text-indent: -7px;">
<span class="quotemark">“</span>Stephen reacted really quickly to our call for help, and within hours our MySQL server was 80% more efficient.
</p>
<p style="font-style: italic; line-height: 1.1em">
I would personally recommend him to anyone who needs help optimising a MySQL server and have more plans for his valuable time in the future!<span class="quotemark">”</span>
</p>
<p style="font-weight: bold; font-style: italic; line-height: 1.1em">
Dominic Hayhoe<br />
MD, Forces Reunited
</p>
<p style="text-align: right; margin-top: -5px;">
<a href="#" onclick="javascript:showlayer('cld'); showlayer('cla'); return false;">Next »</a>
</p>
</div>
</div>
<script type="text/javascript">//<![CDATA[
var m = new Array("mysql","lamp");
m.sort(function() {return 0.5 - Math.random()});
document.getElementById(m[1]).style.display = "block";
//]]></script>
<script type="text/javascript">//<![CDATA[
function showlayer(layer){
var myLayer = document.getElementById(layer).style.display;
if(myLayer=="none"){
document.getElementById(layer).style.display="block";
document.getElementById(layer).style.visibility="visible";
} else {
document.getElementById(layer).style.display="none";
document.getElementById(layer).style.visibility="hidden";
}
}
//]]></script>
<script type="text/javascript" src="http://javascript.everita.com/javascript/jquery-1.2.6.min.js"></script>
<script type="text/javascript" src="http://javascript.everita.com/javascript/jquery.validate.js"></script>
<script type="text/javascript" src="http://javascript.everita.com/javascript/jquery.form.js"></script>
<script type="text/javascript" src="http://javascript.everita.com/javascript/xs.js"></script>
<!-- Begin MailChimp Signup Form -->
<div class="box">
<div id="mc_embed_signup">
<h2>Subscribe</h2>
<p>
Enter your email address below to receive a very occasional message when something significant is published on the site.
</p>
<p>
You can unsubscribe at any time and we'll never share your address.
</p>
<form action="http://everita.list-manage.com/subscribe/post?u=7c4c03c64002b1c0e77ffafaa&id=e99545b2fc" method="post" id="mc-embedded-subscribe-form" name="mc-embedded-subscribe-form" class="validate" target="_blank">
<fieldset>
<div class="mc-field-group">
<label for="mce-EMAIL" style="display: none;">Email Address:</label>
<input type="text" value="" name="EMAIL" class="required email" id="mce-EMAIL" />
</div>
<div id="mce-responses">
<div class="response" id="mce-error-response" style="display:none"></div>
<div class="response" id="mce-success-response" style="display:none"></div>
</div>
<div style="margin-bottom: 0; padding-bottom: 0;">
<input type="submit" value="Subscribe" name="subscribe" id="mc-embedded-subscribe" class="btn button" />
</div>
</fieldset>
</form>
</div>
</div><!--mc_embed_signup-->
</div>
<div class="right">
<div class="box" id="contactus">
<h2>Contact Us</h2>
<p>
E: <a href="mailto:info@everita.com">info@everita.com</a><br />
L: Reading, United Kingdom
<!-- T: <a rel="nofollow" href="http://twitter.com/stephenjayna">Follow us on Twitter</a><br />
L: <a href="http://www.linkedin.com/in/stephenjayna">LinkedIn</a>-->
</p>
<form action="">
<input type="button" value="Contact Everita" onclick="document.location.href='/contact-everita';" class="button" />
</form>
</div>
<div class="box" style="text-align: center;">
<h2>Linux & Mac Specialists</h2>
</div>
<script type="text/javascript">//<![CDATA[
var m = new Array();
m[1]="/sites/all/themes/everita/images/gallery/fabric-sculpture-untitled-08-rowan-mersh-1.jpg";
m[2]="/sites/all/themes/everita/images/gallery/fabric-sculpture-untitled-08-rowan-mersh-2.jpg";
m[3]="/sites/all/themes/everita/images/gallery/future-landscapes-2007-rowan-mersh-5.jpg";
m[4]="/sites/all/themes/everita/images/gallery/fabric-sculpture-series-2-rowan-mersh-2.jpg";
m[5]="/sites/all/themes/everita/images/gallery/fabric-sculpture-series-2-rowan-mersh-4.jpg";
m[6]="/sites/all/themes/everita/images/gallery/future-landscapes-2007-rowan-mersh-3.jpg";
m[7]="/sites/all/themes/everita/images/gallery/fabric-sculpture-exhibition-extract-rowan-mersh-2.jpg";
m[8]="/sites/all/themes/everita/images/gallery/fabric-sculpture-exhibition-extract-rowan-mersh-4.jpg";
m[9]="/sites/all/themes/everita/images/gallery/fabric-sculpture-series-2-rowan-mersh-1.jpg";
m[10]="/sites/all/themes/everita/images/gallery/future-landscapes-2007-rowan-mersh-2.jpg";
m[11]="/sites/all/themes/everita/images/gallery/future-landscapes-2007-rowan-mersh-1.jpg";
m[12]="/sites/all/themes/everita/images/gallery/fabric-sculpture-series-2-rowan-mersh-5.jpg";
m[13]="/sites/all/themes/everita/images/gallery/fabric-sculpture-untitled-08-rowan-mersh-3.jpg";
m[14]="/sites/all/themes/everita/images/gallery/fabric-sculpture-exhibition-extract-rowan-mersh-3.jpg";
m[15]="/sites/all/themes/everita/images/gallery/future-landscapes-2007-rowan-mersh-6.jpg";
m[16]="/sites/all/themes/everita/images/gallery/fabric-sculpture-untitled-08-rowan-mersh-4.jpg";
m[17]="/sites/all/themes/everita/images/gallery/fabric-sculpture-exhibition-extract-rowan-mersh-1.jpg";
m[18]="/sites/all/themes/everita/images/gallery/fabric-sculpture-series-2-rowan-mersh-3.jpg";
m[19]="/sites/all/themes/everita/images/gallery/future-landscapes-2007-rowan-mersh-4.jpg";
m[20]="/sites/all/themes/everita/images/gallery/fabric-sculpture-untitled-06-rowan-mersh-1.jpg";
m[21]="/sites/all/themes/everita/images/gallery/fabric-sculpture-series-2-rowan-mersh-7.jpg";
m[22]="/sites/all/themes/everita/images/gallery/fabric-sculpture-series-2-rowan-mersh-6.jpg";
m.sort(function() {return 0.5 - Math.random()});
for (i=1;i<=2;i++){
var alt = m[i];
myregexp = /.*\/(.*?)\..*/;
mymatch = myregexp.exec(alt);
document.write('<a rel="nofollow" href='+'"http://www.rowanmersh.com"'+'><img src="http://images.everita.com'+m[i]+'" alt="'+mymatch[1]+'" class="si" /></a>');
}
//]]></script>
<p class="right">Images courtesy of <a rel="nofollow" href="http://www.rowanmersh.com">Rowan Mersh</a></p> </div>
</div>
<div id="footer">
<div id="search">
<!--
<form action="http://www.everita.com/search-results" id="cse-search-box">
<fieldset>
<h3>Search Everita</h3>
<div>
<input type="hidden" name="cx" value="009274244583930316296:_czdwjclada" />
<input type="hidden" name="cof" value="FORID:9" />
<input type="hidden" name="ie" value="UTF-8" />
<label for="query" style="display: none;">Search Everita</label>
<input type="text" name="as_q" size="31" id="query" />
<input type="submit" name="sa" value="Search" />
</div>
</fieldset>
</form>
-->
<div id="copyright" style="margin-top: 80px;">
© 2004-2011 Everita Ltd. All rights reserved.
</div>
<div id="based">
Based in Oxford and Reading, UK.
</div>
</div>
<div id="footermenua">
<h3>Main Navigation</h3>
<ul>
<li><a href="http://www.mysqlperformancetuning.com/mysql-lamp-and-drupal-performance-optimization">MySQL, LAMP And Drupal Performance Consulting</a></li>
<li><a href="/software-design-and-development-in-oxford-and-reading">Software Design and Development in Oxford and Reading</a></li>
<li><a href="/iphone-app-and-mobile-phone-development">Everita: iPhone And Mobile Phone Application Development</a></li>
<li><a href="/mysql-lamp-and-drupal-services-from-everita">Request MySQL, LAMP And Drupal Services From Everita</a></li>
<li><a href="/about-everita">Dial “E” for Everita</a></li>
</ul>
</div>
<br style="clear: both;" />
</div>
</div>
<script type="text/javascript" src="http://javascript.everita.com/sites/all/modules/jquery_update/replace/jquery.min.js?7"></script>
<script type="text/javascript" src="http://javascript.everita.com/misc/drupal.js?7"></script>
<script type="text/javascript" src="http://javascript.everita.com/misc/tableheader.js?7"></script>
<script type="text/javascript">
<!--//--><![CDATA[//><!--
jQuery.extend(Drupal.settings, { "basePath": "/" });
//--><!]]>
</script>
<script type="text/javascript" src="http://javascript.everita.com/javascript/dojo.xd.js">
</script>
<script type="text/javascript">
dojo.addOnLoad(function(){
setTimeout(function(){
dojo.require("dojox.analytics.Urchin");
dojo.addOnLoad(function(){
var tracker = new dojox.analytics.Urchin({
acct: "UA-2290068-1"
});
});
}, 100);
});
</script>
<script type="text/javascript">
function rotateTest(a,b) {
$(a).fadeOut(1000);
$(b).animate({opacity: 1.0}, 1250).css("visibility","visible");
$(b).fadeIn(1000);
};
setTimeout('rotateTest("#cla","#clb")',12000);
setTimeout('rotateTest("#clb","#clc")',24000);
setTimeout('rotateTest("#clc","#cld")',36000);
setTimeout('rotateTest("#cld","#cla")',48000);
</script>
</body>
</html>