Showing posts with label wordpress database. Show all posts
Showing posts with label wordpress database. Show all posts

Tuesday, March 11, 2014

MindVisionMedia.net Service Announcement Update!

Hello to all from MindVisionMedia.net. I hope this post finds you well!


This is a service announcement Update for MindVisionMedia.net:

I am glad to report that MindVisionMedia.net now has more resources available to ensure reliable service and consistent up-time!  The high demand was putting a drain on previous resources and I had to update.

I would like to thank everyone for all of the support and patience during my update. 
Feel free to visit the site and take advantage of all the resources available.
 
I look forward to seeing you at MindVisionmedia.net, my MVM Blog or at MVM on YouTube as I continue to provide learning materials for the Internet community.. Thanks again for your patience.
 
Sincerely,
Allan Whitney
Owner/Administrator
MindVisionMedia.net

WordPress Your Sitemap and Google | MindVisionMedia.net

WordPress Your Sitemap and Google | MindVisionMedia.net:

Hello to all from Allan at MindVisionMedia.net and I hope this post finds you well.


Few realize the importance of your sitemap when it comes to Google. The sitemap, for those who are not familiar, is a file that tells Google or some other company, what pages to "fetch" or scan on your website from time to time and it represents a tree or directory to the pages most important in your site to your visitors. 

This file (usually XML) has more than one purpose, it assists in updating the search engines and helps people find you based on your content. This process involves repeated scans or "fetches" by Google which are set at an interval you can modify if needed.

The other purpose of directing your visitors to the pages they want or your sites map, is performed by the same file but displays in a browsers window as the result of a link or button being pressed. One function performs behind the scenes with Google and the other performs on screen as a tool or guide to find your content.

There are many sitemap Plugins that zip out a sitemap for your site or Blog, but you'll want to edit or take the time before-hand to set up some limits before creating the sitemap. The most common form is an XML file but some programs offer a choice of XML or HTML. I use an HTML version for my site visitors and an XML version for Google.

The power of the sitemap is in adding instructions that tell the search engine when and how to check for updates in your content, by date, frequency, by category, by specific page or post, etc. The point here is to make sure you are not including pages that don't relate to your target market directly and maximize the intent of the sitemap to make these Google fetches targeted and effective.

You don't want Google indexing your contact page, image galleries, pages not complete yet or made public, or your privacy statements when there are other more pertinent pages or posts that directly relate to your target niche. Look at these scans by Google as wasted because Google scanned  unnecessary content for nothing, Nada, zilch, of zero benefit to you or I or more importantly, our site.  This includes any information (pages, posts, media file pages, etc) that don't help your search ranking or your seekers find you for the information they need.

Another negative affect to having Google fetch a bunch of extra pages or every page in your site is the impact on your sites resources! That's right, each fetch generates queries in your database. Your query limits could possibly be affected, compiling any other burdens on the database currently by having a bloated sitemap in combination with a high fetch rate. 

You may be faced with a slow loading or inaccessible site as a result and in some cases for large sites, you will have to adjust the fetch rate for Google's Bots, to reduce the time between automatic fetches and minimize the burden on your resources.

A good sitemap will only have the pages or posts most relevant to the content, keyword, niche combination, thus maximizing Google's efforts to index your relevant content which will in turn improve your relevancy in searches. 

 It really is a science, a symbiotic thing when it all works together and for the big guy's, who have marketing firms, web development companies or teams working on site refinement, SEO and Analytics, the end result is amazing, we see their presence everyday. But for the small guy or gal managing their web presence alone, it can be daunting and time consuming. Just when you think you're done, there is something else you need to do to refine your site even more to compete.

Best Practice:
  • Always edit and maintain sitemap to give clear instructions to Google Bot
  • Target your niche in searches and only add relevant content in sitemap that you want indexed
  • Adjust Google fetch rate according to your update frequency and available resources.
So don't neglect, or entrust your sitemap to some free plugin entirely, examine your site's map and you will often notice references on there that are not needed. A little refinement goes a long way and has several benefits as you can see.


By Allan Whitney Owner/Administrator MindVisionMedia.net

Monday, February 17, 2014

WordPress 3.8.1 Revisions feature causes Database issues!

WordPress 3.8.1 Revisions feature causes Database issues!

Hello from Allan at MindVisionMedia.net, I hope this post finds you well.

I love the new WordPress versions, they are full of nice changes and features but I recently started having serious issues with my WordPress website. Load time for everything was beyond forever and most of the time whatever I was trying to accomplish timed out. Logging in was a nightmare, trying to edit a page or post was a nightmare, and dealing with my hosting company over the issues was a nightmare.

In the end here's what I learned:
The new versions (3.8.1) of WordPress have built-in a revisions feature that is great in theory, but in reality, we don't need a copy being saved every minute and we definitely don't need our hosting company trying to charge us for more database space because we have reached our quota which is what I had to deal with in my case. I was exceeding my database quota several times a day and as a result, I could not log in or get any work done, extremely frustrating to say the least.

After going around and around with my hosting company who apparently didn't have a clue when it came to my database, I started doing my own research and discovered that the "revisions" feature is causing problems everywhere. Especially for larger sites or sites with lots of posts or pages such as mine. I then researched some database plugins and settled on 2, "Optimize Database after Deleting Revisions" and also "Revision Removal", both plugins helped me accomplish my goal of deleting all revisions, setting the max revisions to (2) and optimizing the database after reducing its size to less than half its previous size! If you use WordPress, then you are familiar with these words: "Thank God for plugins"

While researching I found numerous people suffering the same issues with their database and there are tons of Google topics on the subject of reducing the database size because of the "revisions" feature in the latest version of WordPress. I am hopeful that WordPress developers will reduce the capability of the revisions feature and limit the revisions to 3-5 max. It appears that no thought was given to the impact of saving so many revisions on the database and I would expect them to correct this very soon.

We all like having a backup copy of our work and the security of knowing that if something happened like a power failure, we would have a revision to fall back on, but in one case I had 115 revisions to just one page alone! Multiply that times 30-40 pages on a site or blog and you end up with hundreds of revisions eating up your database. With so many great features added to the new version, I can't figure out why they overlooked this flaw. After a week of headaches and frustration, hours on the phone and support chat with my hosting company and hours of my own trying to research and solve my slow-loading and hanging problem, I am finally back to normal thanks to those 2 plugins.

So for anybody else experiencing slow page load, slow log in, slow page or post editing, check your revisions, if the numbers are high, it could be that the number of revisions you have is slowing down your database and site and could cause you to be dead in the water as far as getting any work done. So far I love everything about the new WordPress except for the "revisions" feature, it is too much (over-kill) so please WordPress Developers, add options or limit the number of revisions that are saved as well as the time between revisions being saved, and add some built-in controls to delete revisions or set how many revisions you want to keep.

We all need to give our feedback to WordPress so they can resolve this issue ASAP so please chime in on this subject and let them know. Thanks!

By
Allan Whitney
Owner/Administrator
MindVisionMedia.net