If you are using wordpress or other cms and have a lot of data in you sql, your site usually will unavailable with common message database error. What actually error on your database? Nothing, this is all about query limitation on your hosting. Your blog will grown in time, say in the last months you got 10,000 readers and in the next month you got 1,000,000 readers. When people access your site it’s continuously reading data again from your database, when it to much some hosting will stop it to executed. This is not good for SEO because your potential readers will gone (robots also can’t indexing full your site). Usually bad hosting will ask you to upgrade into vps or dedicated server. Everyone know it, there is no free lunch, you will have to pay more and more, if you got good revenue maybe it’s fine but how if not?

In this short articles I will give some tips and trick to fix common wordpress database problem. When you’re planning to get a lot of visitors to your site you better looking for a ways to optimize your sql query. There is one options for this, using DB cache so when people coming to your site request the articles server don’t need to re-query database again. You just need to sacrifice some memory and space which may be better in result if you’re not planning to go for vps or dedicated at the moment.

[to_plus]

How to do this? Search on google is good idea, I found many articles for database caching last night, this is the best one. For wordpress users there is a simple solution. Just get and install DB-CACHE-RELOADED plugin, setting it as you need, example you want cache stays for 24 hours or maybe just 10 minutes.

In this sample I set 180 minutes (3 hours). Cache will stay for 3 hours and then when it expired all cache files will deleted from cache folder and generated new cache. The result after using this plugin is better than not using it. When I tested it I have never seen wordpress database error again (of course because when someone read articles again server doesn’t need to re-read again from the sql). If you like this plugin you can spare some money for Ivan for his great works 😀

The effect?? I’m not sure but in the past when I’m using similar plugin like this I have error on feed, when this happen disable the plugin clear all the cache files and reactivate plugin again. But if not then you don’t need to do anything just keep monitors your site availability and traffic. Before I close this articles I want to tell you, you can also combine this plugin with auto cron job to repair and optimize your mysql, just search on my blog you will find the articles. This combination will giving a better result.

That’s share for today, I need back to work on project he he, Have a great day everyone 🙂

[/to_plus]

Similar Posts:

Related Search Terms:

    Digg Del.icio.us StumbleUpon Reddit Twitter RSS

If you're new here, you may want to subscribe to my RSS feed. You may copy or publish this article to your blog or other site as long you give credit link back to this site article. Thanks for visiting my blog!