I have a number of WordPress websites and ran into a problem at Hostgator since I have a website with a large amount of posts. Here’s what they sent me, which is interesting (I had to fix a little bit of their English):
As MySQL will begin to see performance problems when working with tables which contain over 100,000 rows, we suggest the optimization of the affected databases via the removal of out of date or non critical data from the affected tables or via the addition of indexes in order to help reduce the overall number of rows that must be read when querying the affected tables.
In addition, WordPress starts becoming inefficient at handling the number of posts somewhere between 1500 and 2500 posts and at over about 5000-6000 comments, give or take a little depending on plugin configuration. Once those numbers are doubled, it becomes exceedingly inefficient, performing very poorly and using a lot of CPU resources to process the results coming back from MySQL.
In looking through your WordPress site, you are exceeding those numbers, and this has resulted in increased CPU load, which has contributed to the high resource usage of your site. As such, we would also suggest pruning out of date or non critical posts and comments as well as the affected script is currently seen to contain 6,583 posts and 15,166 comments.
What they want me to do is prune database tables that are too large.
And then here’s some more useful information that I found:
High Traffic Tips For WordPress (codex.wordpress.org)
Like any other web application, WordPress is only able to handle as much traffic as the hardware which runs it can support.
There are two main barriers that can prevent your site from functioning under a high volume of traffic:
MySQL connection rates can be improved by either adjusting MySQL settings, or providing more memory and processing power to the overworked server. Additionally, using query caching and proper indexing can help to improve MySQL performance. There is no single solution for every case, as all sites operate differently.
With a few maintenance tasks, you can clean up WordPress a bit to make it run more efficiently. This page has some resources that are good. One to look at here is “Remove WordPress Post Revisions from the Database” since that will bring down the size of the database. This will also help with the size of your backups, too:
Stupid WordPress Tricks (perishablepress.com)
And then this plugin seems to be rated pretty high, so I’m going to try it:
The WPDBSpringClean plugin identifies unused, WordPress DB tables which have been left over from old plugins you have uninstalled on your site and it then gives you the option of deleting these tables.
Due to regular insertions and deletions in the various DB tables on your system, these tables can quite often hold allocated but unused space. Consequently this can make your DB tables inefficient, fragmented and unoptimized. This plugin will identify unoptimized tables and will allow you to optimize them by deleting the allocated unused space within a particular table. The plugin also optionally allows you to specify search criteria such as the minimum amount of overhead per table and minimum unused space for a table.
If I find more things that help, I’ll post them here. If anyone has some good tips, please post them in the comments.
As the healthcare.gov website launches and has tons of glitches, you have to wonder if people will start to appreciate us good website designers that are out there, who do testing and all the little things that go into website design. Something I’ve never seen is standing in line on a website. That has to be a first and only the U.S. Government would come up with something like that.
President Obama: Expect months of ‘glitches’ (www.politico.com)
Website Design is Easy, Right?
There’s this perception out there that website design is easy. You see these commercials on TV that show a mouse just dragging and dropping things here and there and then it’s done. No, it’s not that easy – let’s make that absolutely clear.
For good website design, you need planning – which involves meetings, outlines, wire frames, designs, responsive designs and so on. After that’s all planned out, you can start on the actual work. As the work is being done and near completion, you have to do testing. You have to test your website on all the different web browsers out there – sometimes even the latest 2 versions of each browser (and Internet Explorer is the worst offender) as well as mobile devices so that everything works right. That’s no easy task.
There’s not only glitch testing but there’s usability testing, too. You might be doing split testing where some website visitors see one version of a page and other people see a different version. There might be a slight change and you have to see which one works better. Once that is done, you do another change. Eventually, you get a final product that performs well.
Website Design is Cheap, Right?
It can be. Just remember, you get what you pay for. If you order cheap website design, you’ll get cheap website design.
For $100, I could make you an ugly, one page website. It might take me 15-30 minutes. I don’t do that, though. I don’t think people want an ugly, one page website. That’s why I don’t do that. Their expectations are higher and my standards are higher, too.
If you want it done right and if you want your website to look right and make the best first impression possible of your company or brand, then no, it’s not cheap. No way.
As you go through the health care website, just think of all that goes into it and see what they haven’t done or tested. Do you complete most of it and get kicked back to the home page, losing all your progress and stuff like that? Well, that’s because it wasn’t done right. To do it right isn’t easy.
I just got some lovely spam email and one message I noticed them saying that they can help get a website of mine on the front page of Google. Hmm…
So you’re calling the first page or results the “front page of Google.” No, I don’t think I’ll be trusting you to handle SEO for me, sorry!
I’ve been doing Internet Marketing for a long time. I got really serious about it back in March of 2009 and I’ve done pretty well at it. It’s fun for me. I like figuring out puzzles, which is why I’m into Bejeweled Blitz and those types of games. They’re really fun for me because I get to figure out the strategy to them.
With Internet Marketing, I have some new goals now that I’m going to work on this year (a little now and more once ski season is out of the way – and I’m not saying I don’t like skiing or don’t want to do it… it’s the opposite – I like it so much that I make a lot of time for it).
Here are my goals for this year:
- Set up more niche websites using the TKA method.
- Set up more authority websites using the Secret Web Assets and SocialMonkee methods.
- Publish more content on my existing niche websites.
- Work on more video tutorials for another website I’m working on.
Last year, I kind of took a short break from all this stuff and just sort of let things sit. I did some work on sites but not much. They still did alright, which was cool but now I’m planning on getting really into things again.
My main goal with everything (all 4 things above) is to work on and create quality content and websites that will pass the test of time. I’ve seen how owning quality websites that rank well is owning assets. The best analogy is to compare it to real estate.
Top Ranking Websites are Like Real Estate
When you have a website that ranks well and when your goal is to run Google AdSense ads or do link building, then that’s like owning an apartment building. If you have an ideal location that people like, you’ll get top dollar rent from your tenants. They pay the going rate because they want to be there. If your website ranks well and is in a location where people want to be (at the top of the search engines), then you’ll get advertisers paying top dollar for ads and clicks.
My goal, then, is to have a whole bunch of these properties… which are assets. They grow in value and it’s your money making money – versus a liability where you pay out every month. The more assets you have, the more wealthy you are (wealthy = having your assets pay you more than your monthly expenses). Instead of buying property (eventually I will), I have virtual property on the web.
And then one more goal I have this year is to build my WorldVentures team. Getting discounts on travel and going on these awesome vacations will be fun. I can’t wait to build a team and help people financially. I’m going to dedicate a lot of time toward this.