<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" media="screen" href="/~d/styles/rss2full.xsl"?><?xml-stylesheet type="text/css" media="screen" href="http://feeds.feedburner.com/~d/styles/itemcontent.css"?><rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:wfw="http://wellformedweb.org/CommentAPI/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:atom="http://www.w3.org/2005/Atom" xmlns:sy="http://purl.org/rss/1.0/modules/syndication/" xmlns:feedburner="http://rssnamespace.org/feedburner/ext/1.0" version="2.0">

<channel>
	<title>The Bloggers Watch</title>
	
	<link>http://www.bloggerswatch.com</link>
	<description>Where bloggers keep their eyes open to watch what happen</description>
	<pubDate>Tue, 21 Jun 2011 07:05:55 +0000</pubDate>
	<generator>http://wordpress.org/?v=2.7.1</generator>
	<language>en</language>
	<sy:updatePeriod>hourly</sy:updatePeriod>
	<sy:updateFrequency>1</sy:updateFrequency>
			<atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="self" type="application/rss+xml" href="http://feeds.feedburner.com/BloggersWatch" /><feedburner:info uri="bloggerswatch" /><atom10:link xmlns:atom10="http://www.w3.org/2005/Atom" rel="hub" href="http://pubsubhubbub.appspot.com/" /><feedburner:emailServiceId>BloggersWatch</feedburner:emailServiceId><feedburner:feedburnerHostname>http://feedburner.google.com</feedburner:feedburnerHostname><item>
		<title>When You Need a Web Design Company</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/QS81GS1L3fU/</link>
		<comments>http://www.bloggerswatch.com/internet/when-you-need-a-web-design-company/#comments</comments>
		<pubDate>Tue, 21 Jun 2011 07:05:55 +0000</pubDate>
		<dc:creator>Shabu</dc:creator>
		
		<category><![CDATA[Internet]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=660</guid>
		<description><![CDATA[<p><img class="size-full wp-image-661 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2011/06/web-design.jpg" alt="Web Design" width="259" height="194" />A corporate website is a media to introduce what the company has to the prospective clients or customers. In the website, the company may put all the information concerning to the company’s products or services. This is good to promote&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p><img class="size-full wp-image-661 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2011/06/web-design.jpg" alt="Web Design" width="259" height="194" />A corporate website is a media to introduce what the company has to the prospective clients or customers. In the website, the company may put all the information concerning to the company’s products or services. This is good to promote the company since the internet promotion saves much time and energy compared to the other way of promotion. Besides, the result is also more effective. Based on that reason, there is a need for a company to have their own website in which they can explicitly promote what they have to the other people. When your company had agreed with that reason, the next step is to find the web design company who will help the company to design the corporate website.</p>
<p>For this purpose, there is a high need to find the perfect one since making and designing a website is not as easy as we think. A professional touch is badly needed for this matter. That is why; you need to find the company which will really fit with your company’s need. To ease your job on this matter, why don’t you look up this <a title="Web Designers Directory" href="http://www.findwebdesigner.com/" target="_blank">web designers directory</a>? In this directory you are able to find tons of information of <a title="Web Design Companies" href="http://www.findwebdesigner.com/" target="_blank">web design companies</a>, their websites and also their portfolio.</p>
<p>This <a title="Web Designer Directory" href="http://www.findwebdesigner.com/" target="_blank">web designer directory</a> is very helpful for those who need the information within the immediate time since the information provided in the directory has been classified to ease the visitors to find what they need. The way how the website works is so easy. You just have to go to the directory website, have a look on the list they have, find what you need and directly choose the company that fits with your need. It is so simple. Then, what are you waiting for? Visit the website whenever you need any information of specific matter especially on the web design company. It really helps.</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/QS81GS1L3fU" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/internet/when-you-need-a-web-design-company/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/internet/when-you-need-a-web-design-company/</feedburner:origLink></item>
		<item>
		<title>Diagnostic Medical Sonography Online School</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/Ar1_45wZLw0/</link>
		<comments>http://www.bloggerswatch.com/health/diagnostic-medical-sonography-online-school/#comments</comments>
		<pubDate>Thu, 05 May 2011 08:20:40 +0000</pubDate>
		<dc:creator>Shabu</dc:creator>
		
		<category><![CDATA[Health]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=655</guid>
		<description><![CDATA[<p>Online school becomes so popular nowadays because of time flexibility and easiness offered. Diagnostic medical sonography can be taken through online school. The curriculum is to recognize body and health condition and take further decision with medicine and treatments.</p>
<p><em><strong><a title="Diagnosticmedicalsonography.com" href="http://www.diagnosticmedicalsonography.com/" target="_blank">Diagnosticmedicalsonography.com</a></strong></em> offers several&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>Online school becomes so popular nowadays because of time flexibility and easiness offered. Diagnostic medical sonography can be taken through online school. The curriculum is to recognize body and health condition and take further decision with medicine and treatments.</p>
<p><em><strong><a title="Diagnosticmedicalsonography.com" href="http://www.diagnosticmedicalsonography.com/" target="_blank">Diagnosticmedicalsonography.com</a></strong></em> offers several medical categories like cardiology, obstetrics and gynecology, muscular and skeletal imaging, urology, musculoskeletal etc. In cardiology, students will learn to diagnose heart problem by using echocardiography method. This method will give ion radiation to detect heart problems. In obstetrics and gynecology, students will learn to monitor fetus’ development in womb. Usually pregnant women will need this diagnostic to know whether their babies are healthy or not. When pregnant women reach 4 months pregnancy, she can use sonography to know the sex of her baby. At this moment, she can ask to take image of the baby. In Muscular and skeletal imaging, students will learn to find out injured muscles and bones. With x-rays, bones are seen clearly. In musculoskeletal, students can explore about nerves, muscle, ligaments, bone surface, tendons and soft tissue. It is very important to find out certain disease and health problem like muscular tears, bone fractures, sprains and so on. In urology, students will learn about reproduction system of male. It uses high radiation, so it is very important to cover prostate and testes carefully. By mastering advanced technology, students will find disease quickly and take emergency care.</p>
<p>How long do you need to spend time at <em><strong><a title="Sonography Schools" href="http://www.diagnosticmedicalsonography.com/how-to-get-a-diagnostic-medical-sonography-certification.html" target="_blank">sonography schools</a></strong></em>? Mostly 2 years for associate’s degree or 4 years for bachelor’s degree. You can take 1 year program with certification in this website. You will have sufficient knowledge and skill to prepare in the real field. You will get certification through ARDMS or American Registry for Diagnostic Medical Sonography. You can increase better career with this certification.</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/Ar1_45wZLw0" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/health/diagnostic-medical-sonography-online-school/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/health/diagnostic-medical-sonography-online-school/</feedburner:origLink></item>
		<item>
		<title>Promising Career as Vascular Technician</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/qYPlT1fiL9g/</link>
		<comments>http://www.bloggerswatch.com/health/promising-career-as-vascular-technician/#comments</comments>
		<pubDate>Mon, 28 Mar 2011 08:49:51 +0000</pubDate>
		<dc:creator>Shabu</dc:creator>
		
		<category><![CDATA[Health]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=650</guid>
		<description><![CDATA[<p><img class="size-full wp-image-651 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2011/03/vascular-ultrasound-technician2.jpg" alt="Vascular Ultrasound Technician" width="385" height="261" />To have good career and income is what people always want. Unfortunately you need more than just a degree. Skills and full of knowledge is necessary. There are more than a million people who are ready to take your place,&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p><img class="size-full wp-image-651 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2011/03/vascular-ultrasound-technician2.jpg" alt="Vascular Ultrasound Technician" width="385" height="261" />To have good career and income is what people always want. Unfortunately you need more than just a degree. Skills and full of knowledge is necessary. There are more than a million people who are ready to take your place, and they have excellent qualification to work at different field. If you are someone who cares about your future, then this is the perfect time to get yourself the ultimate preparation. It is proved that working at medical fields promise gives good income and career, but you must possess all the qualifications and ability to work. <a title="Vascular Ultrasound Technician" href="http://www.ultrasound-technician.net/the-growing-need-for-vascular-ultrasound-professionals/" target="_blank">Vascular ultrasound technician</a> is for the people who have medical background; the person has to be someone who knows how to use the ultrasound equipment.</p>
<p>The job of <a title="Vascular Technician" href="http://www.ultrasound-technician.net/how-to-become-a-vascular-technologist/" target="_blank">vascular technician</a> is scanning internal body part of the patient. It requires a lot of responsibilities, because you have to be able to perform safe scanning to avoid any damage both for the equipment and the patient. Being a vascular technician is an amazing job; you help doctor in making appropriate diagnosis. It is true that ultrasound machine is safe if it undergoes in appropriate procedures, this is extensively helpful medical equipment, and they are able to document what is in your internal part with no side result for the patient.</p>
<p>There are some requirements that needed, in order to become a vascular technician. Formal training programs is a must, two to three years associate degree, then continued to four years of bachelor degree specializing in anatomy, patients care or physiology. After a long journey of education, you still need to undergo medical training and get licensed. You will need the license to work; by having the license it means that you have the qualification and the responsibilities to use the ultrasound equipment. You can get the license after you pass the examination.</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/qYPlT1fiL9g" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/health/promising-career-as-vascular-technician/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/health/promising-career-as-vascular-technician/</feedburner:origLink></item>
		<item>
		<title>Find SEO Company that is genuine to boost up your position at SERP</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/Gu8bm9ky9vk/</link>
		<comments>http://www.bloggerswatch.com/seo/find-seo-company-that-is-genuine-to-boost-up-your-position-at-serp/#comments</comments>
		<pubDate>Fri, 07 Jan 2011 11:46:57 +0000</pubDate>
		<dc:creator>Shabu</dc:creator>
		
		<category><![CDATA[SEO]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=646</guid>
		<description><![CDATA[<p><img class="size-full wp-image-647 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2011/01/findseos.gif" alt="FindSEOs" width="251" height="148" />A Webmaster or website owner cannot deal alone with the web promotions and online marketing of his brand. Without taking an expert suggestion or proposal Webmasters cannot bring their websites at the every first page of the Google search results.&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p><img class="size-full wp-image-647 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2011/01/findseos.gif" alt="FindSEOs" width="251" height="148" />A Webmaster or website owner cannot deal alone with the web promotions and online marketing of his brand. Without taking an expert suggestion or proposal Webmasters cannot bring their websites at the every first page of the Google search results. You require a genuine and proficient SEO Company that can guide you through the entire process of search engine optimization. Now, the question arises where to <a title="Find SEO company" href="http://www.findseos.com" target="_blank">find SEO company</a> that has competent staff and expert professionals use their skills to optimize your website.</p>
<p>With some valuable time spent on the Internet you can list numerous SEO companies that claim to be the best in their respective fields. However, do not select them on mere claims as you can find SEOs that are complete scam and fraudulent. They only scam your hard earned money leaving you without any fruitful result. Before hiring their service ask for the references and testimonials from their former clients. Search over the Internet for the positive reviews regarding a particular company when you are searching to find SEO services for your website.</p>
<p>You can also find SEOs consultants over the Internet. These consultants work independently and also known as freelancers. They offer their services charging you on the bases on per hour payment system. You can find SEO consultants that are quite practiced in their job and can show positive results regading optimization of your website.</p>
<p>If you want to <a title="Find SEOs" href="http://www.findseos.com" target="_blank">find SEOs</a> you must browse the freelancing websites and forums. You will come across the profiles of various SEO experts including content writers, link builders, website designers, website developers and many other at those freelance websites. You have to register yourself by making your account. After registration you can place your requirements over the specific area of the website. Various SEO companies and SEO expert will place bids on your project. You can select the one that suits you the best in terms of performance and budget.</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/Gu8bm9ky9vk" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/seo/find-seo-company-that-is-genuine-to-boost-up-your-position-at-serp/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/seo/find-seo-company-that-is-genuine-to-boost-up-your-position-at-serp/</feedburner:origLink></item>
		<item>
		<title>Sitting the Throne of your Own Business</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/mmh_ExITfig/</link>
		<comments>http://www.bloggerswatch.com/business/sitting-the-throne-of-your-own-business/#comments</comments>
		<pubDate>Wed, 29 Dec 2010 14:49:57 +0000</pubDate>
		<dc:creator>Shabu</dc:creator>
		
		<category><![CDATA[Business]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=641</guid>
		<description><![CDATA[<p>Becoming the owner of your own business might also give you the taste that you have never got. But it is also true that business is never easy to start even if you have adequate money and patience. Though home&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p>Becoming the owner of your own business might also give you the taste that you have never got. But it is also true that business is never easy to start even if you have adequate money and patience. Though home based small business is much easier to start than other business. If you are ambitious and can sincerely follow the discussions here then you are more like to achieve success.</p>
<p><strong>Set your objective</strong><br />
At first set your goal what types of business you would like to start? Working from home might give you numerous advantages but if you spend more time with your family or of taking a nap in the middle of the day would let you down. So you must make a work schedule and strictly follow it.</p>
<p>Selecting office place<br />
You need a room that is fully equipped with your desired and necessary things. It is not necessary to select a large room rather if your room is one side of your home then it would be good. You can also use your roof top room.</p>
<p><strong>Be professional</strong><br />
Lack of professionalism is a common mistake of many home business owners. You have to remember that success and professionalism are synonymous of every venture. Don’t treat your business like you treat your family.</p>
<p><strong>Unique marketing policy</strong><br />
Home base business is more like a small business. So like other small business you need some promotional activities. For instance if you do business of <a title="Sublimation Mugs" href="http://www.sun-fly-sublimation.com/" target="_blank">sublimation mugs</a>, then corporate houses might be your potential client. Let your target customers know the advantages of <a title="Sublimation" href="http://www.sun-fly-sublimation.com/" target="_blank">sublimation</a> accessories through different promotional campaign like brochure, online ad, local news paper ad etc.</p>
<p><strong>Create a web site</strong><br />
Advantages of online marketing are beyond description. You need a good web site as a part of promotion. Try to make your site search engine friendly through some key words. As I mentioned earlier the business of selling sublimation mug or accessories. So you can choose key words like heat press, sublimation and sublimation accessories. After selecting keywords you would get the help of a SEO company to promote your web site.</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/mmh_ExITfig" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/business/sitting-the-throne-of-your-own-business/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/business/sitting-the-throne-of-your-own-business/</feedburner:origLink></item>
		<item>
		<title>Best SQL Performance Tips from MySQL</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/hcCWebtpS80/</link>
		<comments>http://www.bloggerswatch.com/internet/best-sql-performance-tips-from-mysql/#comments</comments>
		<pubDate>Sat, 21 Aug 2010 09:40:32 +0000</pubDate>
		<dc:creator>Reza</dc:creator>
		
		<category><![CDATA[Internet]]></category>

		<category><![CDATA[database]]></category>

		<category><![CDATA[mysql]]></category>

		<category><![CDATA[tips]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=629</guid>
		<description><![CDATA[<p><img class="alignleft size-full wp-image-632" title="logo-mysql" src="http://www.bloggerswatch.com/wp-content/uploads/2010/08/logo-mysql.jpg" alt="logo-mysql" width="200" height="200" />While moving around on the net for some MySQL solutions, I stopped at forge.mysql.com, wher I found a lot of tips regarding defferent issues in MySQl. So I thought it would be much helpful for those who are new at&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p><img class="alignleft size-full wp-image-632" title="logo-mysql" src="http://www.bloggerswatch.com/wp-content/uploads/2010/08/logo-mysql.jpg" alt="logo-mysql" width="200" height="200" />While moving around on the net for some MySQL solutions, I stopped at forge.mysql.com, wher I found a lot of tips regarding defferent issues in MySQl. So I thought it would be much helpful for those who are new at MySQL, or are looking for some very important and useful information about MySQL and posted them here with the original source link.</p>
<p><strong>Specific Query Performance Tips</strong></p>
<ol>
<li> Use EXPLAIN to profile the query execution plan</li>
<li> Use <a class="external text" title="http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html" rel="nofollow" href="http://dev.mysql.com/doc/refman/5.0/en/slow-query-log.html">Slow Query Log</a> (always have it on!)</li>
<li> Don&#8217;t use DISTINCT when you have or could use GROUP BY</li>
<li> Insert performance
<ol>
<li> Batch INSERT and REPLACE</li>
<li> Use LOAD DATA instead of INSERT</li>
</ol>
</li>
<li> LIMIT m,n may not be as fast as it sounds. Learn how to improve it (if possible): <a class="external free" title="http://www.facebook.com/note.php?note_id=206034210932" rel="nofollow" href="http://www.facebook.com/note.php?note_id=206034210932">http://www.facebook.com/note.php?note_id=206034210932</a></li>
<li> Don&#8217;t use ORDER BY RAND() if you have &gt; ~2K records</li>
<li> Use SQL_NO_CACHE when you are SELECTing frequently updated data or large sets of data</li>
<li> Avoid wildcards at the start of LIKE queries</li>
<li> Avoid correlated subqueries and in select and where clause (try to avoid in)</li>
<li> No calculated comparisons &#8212; isolate indexed columns</li>
<li> ORDER BY and LIMIT work best with equalities and covered indexes</li>
<li> Separate text/blobs from metadata, don&#8217;t put text/blobs in results if you don&#8217;t need them</li>
<li> Derived tables (subqueries in the FROM clause) can be useful  for retrieving BLOBs without sorting them. (Self-join can speed up a  query if 1st part finds the IDs and uses then to fetch the rest)</li>
<li> ALTER TABLE&#8230;ORDER BY can take data sorted chronologically  and re-order it by a different field &#8212; this can make queries on that  field run faster (maybe this goes in indexing?)</li>
<li> Know when to split a complex query and join smaller ones</li>
<li> Delete small amounts at a time if you can</li>
<li> Make similar queries consistent so cache is used</li>
<li> Have good SQL query standards</li>
<li> Don&#8217;t use deprecated features</li>
<li> Turning OR on multiple index fields (&lt;5.0) into UNION may  speed things up (with LIMIT), after 5.0 the index_merge should pick  stuff up.</li>
<li> Don&#8217;t use COUNT * on Innodb tables for every search, do it a  few times and/or summary tables, or if you need it for the total # of  rows, use SQL_CALC_FOUND_ROWS and SELECT FOUND_ROWS()</li>
<li> Use INSERT &#8230; ON DUPLICATE KEY update (INSERT IGNORE) to avoid having to SELECT</li>
<li> use groupwise maximum instead of subqueries</li>
<li> Avoid using IN(&#8230;) when selecting on indexed fields, It will kill the performance of SELECT query.</li>
</ol>
<p><strong>Scaling Performance Tips</strong></p>
<ol>
<li> Use benchmarking</li>
<li> isolate workloads don&#8217;t let administrative work interfere with customer performance. (ie backups)</li>
<li> Debugging sucks, testing rocks!</li>
<li> As your data grows, indexing may change (cardinality and  selectivity change).  Structuring may want to change.  Make your schema  as modular as your code.  Make your code able to scale.  Plan and  embrace change, and get developers to do the same.</li>
</ol>
<p><strong>Network Performance Tips</strong></p>
<ol>
<li> Minimize traffic by fetching only what you need.
<ol>
<li> Paging/chunked data retrieval to limit</li>
<li> Don&#8217;t use SELECT *</li>
<li> Be wary of lots of small quick queries if a longer query can be more efficient</li>
</ol>
</li>
<li> Use multi_query if appropriate to reduce round-trips</li>
<li> Use stored procedures to avoid bandwidth wastage</li>
</ol>
<p><strong>OS Performance Tips</strong></p>
<ol>
<li> Use proper data partitions
<ol>
<li> For Cluster.  Start thinking about Cluster *before* you need them</li>
</ol>
</li>
<li> Keep the database host as clean as possible.  Do you really need a windowing system on that server?</li>
<li> Utilize the strengths of the OS</li>
<li> pare down cron scripts</li>
<li> create a test environment</li>
<li> source control schema and config files</li>
<li> for LVM innodb backups, restore to a different instance of MySQL so Innodb can roll forward</li>
<li> partition appropriately</li>
<li> partition your database when you have real data &#8212; do not assume you know your dataset until you have real data</li>
</ol>
<p><strong>MySQL Server Overall Tips</strong></p>
<ol>
<li> innodb_flush_commit=0 can help slave lag</li>
<li> Optimize for data types, use consistent data types.  Use  PROCEDURE ANALYSE() to help determine the smallest data type for your  needs.</li>
<li> use optimistic locking, not pessimistic locking.  try to use shared lock, not exclusive lock.  share mode vs. FOR UPDATE</li>
<li> if you can, compress text/blobs</li>
<li> compress static data</li>
<li> don&#8217;t back up static data as often</li>
<li> enable and increase the query and buffer caches if appropriate</li>
<li> config params &#8212; <a class="external free" title="http://docs.cellblue.nl/2007/03/17/easy-mysql-performance-tweaks/" rel="nofollow" href="http://docs.cellblue.nl/2007/03/17/easy-mysql-performance-tweaks/">http://docs.cellblue.nl/2007/03/17/easy-mysql-performance-tweaks/</a> is a good reference</li>
<li> Config variables &amp; tips:
<ol>
<li> use one of the supplied config files</li>
<li> key_buffer, unix cache (leave some RAM free), per-connection variables, innodb memory variables</li>
<li> be aware of global vs. per-connection variables</li>
<li> check SHOW STATUS and SHOW VARIABLES (GLOBAL|SESSION in 5.0 and up)</li>
<li> be aware of swapping esp. with Linux, &#8220;swappiness&#8221; (bypass OS  filecache for innodb data files, innodb_flush_method=O_DIRECT if  possible (this is also OS specific))</li>
<li> defragment tables, rebuild indexes, do table maintenance</li>
<li> If you use innodb_flush_txn_commit=1, use a battery-backed hardware cache write controller</li>
<li> more RAM is good so faster disk speed</li>
<li> use 64-bit architectures</li>
</ol>
</li>
<li> &#8211;skip-name-resolve</li>
<li> increase myisam_sort_buffer_size to optimize large inserts (this is a per-connection variable)</li>
<li> look up memory tuning parameter for on-insert caching</li>
<li> increase temp table size in a data warehousing environment  (default is 32Mb) so it doesn&#8217;t write to disk (also constrained by  max_heap_table_size, default 16Mb)</li>
<li> Run in SQL_MODE=STRICT to help identify warnings</li>
<li> /tmp dir on battery-backed write cache</li>
<li> consider battery-backed RAM for innodb logfiles</li>
<li> use &#8211;safe-updates for client</li>
<li> Redundant data is redundant</li>
</ol>
<p><strong>Storage Engine Performance Tips</strong></p>
<ol>
<li> InnoDB ALWAYS keeps the primary key as part of each index, so do not make the primary key very large</li>
<li> Utilize different storage engines on master/slave ie, if you need fulltext indexing on a table.</li>
<li> BLACKHOLE engine and replication is much faster than FEDERATED tables for things like logs.</li>
<li> Know your storage engines and what performs best for your needs, know that different ones exist.
<ol>
<li> ie, use MERGE tables ARCHIVE tables for logs</li>
<li> Archive old data &#8212; don&#8217;t be a pack-rat!  2 common engines for this are ARCHIVE tables and MERGE tables</li>
</ol>
</li>
<li> use row-level instead of table-level locking for OLTP workloads</li>
<li> try out a few schemas and storage engines in your test environment before picking one.</li>
</ol>
<p><strong>Database Design Performance Tips</strong></p>
<ol>
<li> Design sane query schemas.  don&#8217;t be afraid of table joins, often they are faster than denormalization</li>
<li> Don&#8217;t use boolean flags</li>
<li> Use Indexes</li>
<li> Don&#8217;t Index Everything</li>
<li> Do not duplicate indexes</li>
<li> Do not use large columns in indexes if the ratio of SELECTs:INSERTs is low.</li>
<li> be careful of redundant columns in an index or across indexes</li>
<li> Use a clever key and ORDER BY instead of MAX</li>
<li> Normalize first, and denormalize where appropriate.</li>
<li> Databases are not spreadsheets, even though Access really really looks like one.  Then again, Access isn&#8217;t a real database</li>
<li> use INET_ATON and INET_NTOA for IP addresses, not char or varchar</li>
<li> make it a habit to REVERSE() email addresses, so you can  easily search domains (this will help avoid wildcards at the start of  LIKE queries if you want to find everyone whose e-mail is in a certain  domain)</li>
<li> A NULL data type can take more room to store than NOT NULL</li>
<li> Choose appropriate character sets &amp; collations &#8212; UTF16  will store each character in 2 bytes, whether it needs it or not, latin1  is faster than UTF8.</li>
<li> Use Triggers wisely</li>
<li> use min_rows and max_rows to specify approximate data size so  space can be pre-allocated and reference points can be calculated.</li>
<li> Use HASH indexing for indexing across columns with similar data prefixes</li>
<li> Use myisam_pack_keys for int data</li>
<li> be able to change your schema without ruining functionality of your code</li>
<li> segregate tables/databases that benefit from different configuration variables</li>
</ol>
<p><strong>Other</strong></p>
<ol>
<li> Hire a MySQL &#8482; Certified DBA</li>
<li> Know that there are many consulting companies out there that can help, as well as MySQL&#8217;s Professional Services.</li>
<li> Read and post to MySQL Planet at <a class="external free" title="http://www.planetmysql.org" rel="nofollow" href="http://www.planetmysql.org/">http://www.planetmysql.org</a></li>
<li> Attend the yearly MySQL Conference and Expo or other conferences with MySQL tracks (link to the conference here)</li>
<li> Support your local User Group (link to forge page w/user groups here)</li>
</ol>
<p>Source: http://forge.mysql.com/wiki/Top10SQLPerformanceTips</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/hcCWebtpS80" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/internet/best-sql-performance-tips-from-mysql/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/internet/best-sql-performance-tips-from-mysql/</feedburner:origLink></item>
		<item>
		<title>How to Easily Unlock Your Mobile Phone</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/400m65jMNHY/</link>
		<comments>http://www.bloggerswatch.com/technology/how-to-easily-unlock-your-mobile-phone/#comments</comments>
		<pubDate>Tue, 20 Jul 2010 10:50:16 +0000</pubDate>
		<dc:creator>Shabu</dc:creator>
		
		<category><![CDATA[Technology]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=626</guid>
		<description><![CDATA[<p><img class="size-full wp-image-627 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2010/07/unlock_htc_hero.jpg" alt="unlock htc hero" width="160" height="300" />Nowadays, there are many different cell phone services in the market. We usually like to get the newest brand of gadget like a digital camera or the latest cell phone. With this, we constantly like to change service plan and&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p><img class="size-full wp-image-627 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2010/07/unlock_htc_hero.jpg" alt="unlock htc hero" width="160" height="300" />Nowadays, there are many different cell phone services in the market. We usually like to get the newest brand of gadget like a digital camera or the latest cell phone. With this, we constantly like to change service plan and see what it offers. Ideally, with the help of cell phone unlocking, we can change service easily.</p>
<p>First, check if you can unlock your phones easily. Most phones can easily be unlocked like T-mobile or Cingular. But it your phone does not offer a GSM service, for sure you need help to unlock it. The main reason for this is that your phone doesn’t have transferable card and your name and cell phone number is also attached to this card.</p>
<p>With the help of mobile phone unlocking, we can unlock any phone like HTC hero. This is for sure 100% legal that most phone companies don’t want you to know, because they want you to remain as their customer for life. But you have an option, if you like to <a title="unlock HTC" href="http://www.htcsimunlock.com/" target="_blank">unlock HTC</a> phones; there are sites that offer this great service for just a small buck. They can easily unlock it by giving you the unlock code after telling or submitting them your phone IMEI.</p>
<p>Once you <a title="unlock HTC hero" href="http://www.htcsimunlock.com/htc-hero-unlock.html" target="_blank">unlock HTC hero</a>, test it out so you can be sure it really works. You can borrow your friend’s or someone else sim card and try it to your phone. If there’s an error displayed, chances are it didn’t work. But, if the procedure turns out rights, then congratulation you have unlocked your beloved phone. New or experienced cell phone owner can really benefit from this new service. It’s fast and speedy unlocking service that you’ll just sit and wait for the unlock codes, no more hard work.</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/400m65jMNHY" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/technology/how-to-easily-unlock-your-mobile-phone/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/technology/how-to-easily-unlock-your-mobile-phone/</feedburner:origLink></item>
		<item>
		<title>Healthy hair tips: caring for normal hair</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/T6WWPYlAx8o/</link>
		<comments>http://www.bloggerswatch.com/health/healthy-hair-tips-caring-for-normal-hair/#comments</comments>
		<pubDate>Thu, 27 May 2010 19:16:25 +0000</pubDate>
		<dc:creator>Reza</dc:creator>
		
		<category><![CDATA[Health]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=621</guid>
		<description><![CDATA[<p><img class="alignleft size-full wp-image-622" title="long beautiful hair" src="http://www.bloggerswatch.com/wp-content/uploads/2010/05/long_beautiful_hair.jpg" alt="long beautiful hair" width="270" height="254" />The normal hair is one that is not oily or dry or delicate hair type  is perfect because it’s very manageable and does not bring many  maintenance problems.</p>
<p>However, being a hair privileged nature frees him from external  damage and our&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p><img class="alignleft size-full wp-image-622" title="long beautiful hair" src="http://www.bloggerswatch.com/wp-content/uploads/2010/05/long_beautiful_hair.jpg" alt="long beautiful hair" width="270" height="254" />The normal hair is one that is not oily or dry or delicate hair type  is perfect because it’s very manageable and does not bring many  maintenance problems.</p>
<p>However, being a hair privileged nature frees him from external  damage and our occasional mistakes in your care, so here I want to show  the right way to keep it healthy and beautiful:</p>
<p>Wash it with a neutral pH shampoo.<br />
Apply a mild conditioner, especially on the tips and become a circular  massage on the scalp.<br />
Rinse with warm water, never hot because it is very aggressive for the  hair.<br />
Apply a mask for normal hair at least once a month.<br />
If you’ve dyed it, using a special shampoo and conditioner for treated  hair.</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/T6WWPYlAx8o" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/health/healthy-hair-tips-caring-for-normal-hair/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/health/healthy-hair-tips-caring-for-normal-hair/</feedburner:origLink></item>
		<item>
		<title>Stainless Steel Earrings for Fashion and Durability</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/GbVCFFgGyDE/</link>
		<comments>http://www.bloggerswatch.com/fashion/stainless-steel-earrings-for-fashion-and-durability/#comments</comments>
		<pubDate>Thu, 29 Apr 2010 08:29:29 +0000</pubDate>
		<dc:creator>Shabu</dc:creator>
		
		<category><![CDATA[Fashion]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=615</guid>
		<description><![CDATA[<p><img class="size-full wp-image-619 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2010/04/stainless-steel-earrings.jpg" alt="Stainless Steel Earrings" width="244" height="428" />Women love stylish earring just like they love fashionable rings. Earrings are popular; they can be worn by teenagers, adult, women and even men. If you wore <a title="Stainless Steel Jewelry" href="http://www.lynnsfashion.com/" target="_blank">stainless steel jewelry</a> earrings, it can make a statement on what you wear all&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p><img class="size-full wp-image-619 alignleft" src="http://www.bloggerswatch.com/wp-content/uploads/2010/04/stainless-steel-earrings.jpg" alt="Stainless Steel Earrings" width="244" height="428" />Women love stylish earring just like they love fashionable rings. Earrings are popular; they can be worn by teenagers, adult, women and even men. If you wore <a title="Stainless Steel Jewelry" href="http://www.lynnsfashion.com/" target="_blank">stainless steel jewelry</a> earrings, it can make a statement on what you wear all day. It is trendy and most of all its inexpensive.</p>
<p>Here are the benefits if you want to buy and own a stainless steel earring:</p>
<ul>
<li>First is it is highly versatile. It has the shine and luster just like the silver earrings, wearing it will not make you look cheap. It carries the luminosity, and it’s a good alternative for sterling silver. Usually, gold earrings are only worn for showy purposes, but this stainless steel earring can be worn on any occasion, for comfort, style and fashion.</li>
<li>If you’re worried every time you wear your usual gold or silver jewelry for a wear and tear and not comfortable with it. You can replace it with stainless steel jewelry, this kind of jewelry contains alloy, which makes it more durable. You’ll not worry every time you wear it in places you want to go and display your earring.</li>
<li>It is easier to maintain. You won’t have to clean it always unlike the gold and silver ones. You’ll just need to be careful not to scratch it with stronger stainless steel.</li>
<li>It is more way cheaper then gold or silver. You’re in fashion just spending a small amount of your money and you can always buy new ones. If you want it to be cheaper, you can buy it in <a title="Stainless Steel Jewelry Wholesale" href="http://www.lynnsfashion.com/earrings-c-35.html" target="_blank">stainless steel jewelry wholesale </a>earring. In wholesale, you can display different earrings on your different outfits.</li>
</ul>
<p>Stainless steel can be bought online like in lynnsfashion.com, they have lots of affordable earring for your fashion and style needs.</p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/GbVCFFgGyDE" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/fashion/stainless-steel-earrings-for-fashion-and-durability/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/fashion/stainless-steel-earrings-for-fashion-and-durability/</feedburner:origLink></item>
		<item>
		<title>The Porsche 911 GT3</title>
		<link>http://feedproxy.google.com/~r/BloggersWatch/~3/hqm2dAw_7zM/</link>
		<comments>http://www.bloggerswatch.com/automotive/the-porsche-911-gt3/#comments</comments>
		<pubDate>Fri, 23 Apr 2010 08:52:52 +0000</pubDate>
		<dc:creator>Reza</dc:creator>
		
		<category><![CDATA[Automotive]]></category>

		<category><![CDATA[911]]></category>

		<category><![CDATA[911 gt3]]></category>

		<category><![CDATA[automobile]]></category>

		<category><![CDATA[porsche]]></category>

		<category><![CDATA[sports car]]></category>

		<guid isPermaLink="false">http://www.bloggerswatch.com/?p=597</guid>
		<description><![CDATA[<p><img class="alignleft size-full wp-image-600" title="porsche 911 GT3" src="http://www.bloggerswatch.com/wp-content/uploads/2010/04/porche-911-gt3.jpg" alt="porche 911 GT3" width="266" height="181" />The <strong>Porsche 911 GT3 </strong>is one of the most gorgeous<strong> </strong>and powerful car from <strong>Porsche.</strong> It was introduced in 1999 as a high performance version of the first <strong>water-cooled</strong> version of the Porsche 911.</p>
<p>The 2010 GT3 sees a couple of significant upgrades over&#8230;</p>]]></description>
			<content:encoded><![CDATA[<p><img class="alignleft size-full wp-image-600" title="porsche 911 GT3" src="http://www.bloggerswatch.com/wp-content/uploads/2010/04/porche-911-gt3.jpg" alt="porche 911 GT3" width="266" height="181" />The <strong>Porsche 911 GT3 </strong>is one of the most gorgeous<strong> </strong>and powerful car from <strong>Porsche.</strong> It was introduced in 1999 as a high performance version of the first <strong>water-cooled</strong> version of the Porsche 911.</p>
<p>The 2010 GT3 sees a couple of significant upgrades over the previous  GT3, but significantly does not get the direct injection technology  found on nearly every other new Porsche model. The powerplant in the 911  GT3 does displace 3.8 liters, up .2 liters over the former GT3, and  produces 435 bhp, a jump of 20 horses over the outgoing model.</p>
<p>The newly designed front air vents, ahead of the front hood, channel  cooling air to the radiator and, in combination with the front lip  spoiler, provide even more front end downforce. As is typical in  motorsport, all of the cooling air inlets are protected by new air inlet  grilles with a dark grey powder-coated finish.</p>
<p>Now included for the first time is the Porsche Stability Management,  which can be completely disabled in the hands of a professional driver  but will probably save many a driver with the chips for a 2009 911 GT3  without necessarily carrying the skills to take a rear-engined supercar  to its limits.</p>
<p>Stability and traction control systems can also be disabled seperately,  giving a discerning driver the ability to only employ the nannies he or  she needs for a specific situation.</p>
<p>The low-slung front end, featuring a slew of minor changes to the lip  spoiler and lower dams, will lift upon driver command by a full inch for  use on bad roads or over bumps.</p>
<p>The lights on the new 911 GT3 have also been completely  redesigned, with Bi-Xenon™ headlights fitted as standard. Indicators and  LED daytime running lights are harmoniously integrated into the  separate front light units over the outer air intakes.</p>
<p>At the rear, distinctive LED lights are drawn right into the  fascia and taper outwards. Unmistakable – just like the new fixed  bi-plane wing.</p>
<p><strong>2010 Porsche 911 GT3 Specifications</strong><br />
======================================</p>
<p><strong>Drivetrain</strong><br />
Layout    Rear Engine, RWD<br />
Transmission    6 Speed Conventional Manual<br />
Differential    Active Limited Slip</p>
<p><strong>Engine</strong><br />
Type:    Rear-Mounted Flat &#8220;Boxer&#8221; 6<br />
Displacement    3.8 liters<br />
Horsepower    435 bhp<br />
Induction    Naturally Aspirated<br />
<strong>Exterior</strong><br />
Body Type    2 Door, 2 Seat Sport Coupe<br />
<strong> Performance</strong><br />
Acceleration 0-60 mph s:    4.0 seconds<br />
0-100 mph    8.2 seconds<br />
Top Speed    194 mph<br />
<strong>Base Price</strong>: 2010 Porsche 911 GT3: $112,200</p>
<p style="text-align: center;"><img class="size-full wp-image-602 aligncenter" title="2010 Porsche 911 GT3" src="http://www.bloggerswatch.com/wp-content/uploads/2010/04/2010-porche-911-gt3.jpg" alt="2010-porche-911-gt3" width="482" height="253" /></p>
<img src="http://feeds.feedburner.com/~r/BloggersWatch/~4/hqm2dAw_7zM" height="1" width="1"/>]]></content:encoded>
			<wfw:commentRss>http://www.bloggerswatch.com/automotive/the-porsche-911-gt3/feed/</wfw:commentRss>
		<feedburner:origLink>http://www.bloggerswatch.com/automotive/the-porsche-911-gt3/</feedburner:origLink></item>
	</channel>
</rss>

