5 Tips to Help Your Slow or Sluggish Blog or Web Site (Wordpress Especially) 5个窍门，以帮助您慢或呆滞的博客或网站（尤其是在WordPress ）
1,850 views - 1850的意见-作Posted in: 张贴在：
1,850 views 1850的意见
Please note: This page was originally written in English.请注意：此页中，原本在书面英语。
The original post can be viewed原来的文章可以看 here这里 . 。
Please note: This page was originally written in English.
The text has been translated using an online service such as Google or Babelfish.
The original post can be viewed here.
Do you have a slow or sluggish web site or blog?你有一个缓慢或呆滞的网站或博客？ I’m going to give you 5 things you should check that can help quite a bit.我要去给你五的东西，您应该检查，可以帮助不少位。 Also - I’ll have a few tips specifically for Wordpress sites.还-我将有几个要诀专门为在W ordPress网站。
In my previous post about我在以前的职位约 importing large mySQL databases进口大型的MySQL数据库 I showed you how to use the command line to import to get big data dumps in a fresh database. i表明你如何使用命令行来的进口，以获得大数据堆放在一个新的数据库。 In that particular situation I was moving from one web host to another.在这方面的具体情况我是从一网页主机到另一个。 But sometimes you might have a different reason for wanting to move a web site to a new database.但有时候你也许有不同的原因，要提出一个网站到一个新的数据库。
I’ve had web sites before that seemed to get slower over time.我已网站之前，这似乎是获得慢一段时间。 There are a number of factors that could be causing this.有许多因素可能导致此。 If you notice your web site taking longer to load, becoming sluggish, or even producing random errors (like ‘mySQL server went away’), there are some things you should investigate.如果您发现您的网站以更长的时间才能负荷，成为疲弱，或什至产生随机误差（如' MySQL服务器到远离' ） ，有一些东西，你应该进行调查。
Here’sa list of things to think about:以下是名单上的东西，想一想：
- Are you getting more traffic ? 您是否获得更多的流量 ？ Check your stats for your site and see if you’ve had a sudden spike in traffic.检查您的统计信息为您的网站看到，如果您有一个突然穗在交通。 If you are where is it coming from?如果您是在哪里，它来自哪里？ Is it coming from a particular article or page?它是从某一特定的文章或网页？ Is it from just one referrer or many?它是从刚才一引荐或许多？ Is a robot or crawler hitting your site too much?是一个机器人或履带打您的网站太多了？
- Do you have too many external calls ? 你是否有太多的对外通话 ？ When your site loads in a brower, watch the bottom status bar to see (while it loads) where it’s hanging up and waiting for data to come back.当您的网站负载在一个浏览器，观赏底部的状态栏上看到的（虽然它加载）凡的挂起来，等待数据回来。 Do you have items from Amazon, eBay, other affiliate sites, chiclets, technorati tags, mybloglog data, feedburner calls, or other items that come from outside your site?你有没有项目，从亚马逊，易趣，其他联盟网站， chiclets ， Technorati标记， to limit a search 。数据， feedburner要求，或其他物品来自外部您的网站？ Try commenting them out one by ond and seeing how much faster your page loads尝试在评论他们出一个由唯一的和看到的速度会提高多少？您的网页加载
- Are your graphics optimized? ? 是您的图形优化吗？ Do you have any graphics on your pages that are excessive in size?你有什么图形在您的网页上是过分的大小？ Are you calling any graphics on remote sites that you could host in your site?是您的来电任何图形的远程站点，你可以东道国在您的网站？ Do all you graphics contain a height and width tag?尽一切您的图形包含一个高度和宽度标记吗？
- Have you optimized your database ? 你优化你的数据库呢？ A web site database gets thousands of transactions per day.一个网站，数据库获得成千上万的交易，每天。 Think of it like a moving piece of machinery - at one time or another something will break or get clogged up.认为这就像一个移动一块机械-在同一时间或其他东西将打破或得到堵塞。 Every now and again you should login to your web admin control panel and use your myPhpAdmin (or other mySQL tool) to optimize your db.现在，你应该再次登录到您的Web管理员控制面板，并使用您的myphpadmin （或其他MySQL的工具） ，优化您的分贝。 Select all the tables, and then “repair” and “optimize” and watch the results to see what it did.选择所有表，然后“修复”和“优化”和观赏的结果，看看有什么这样做。 You would be surprised how well this trick might work.你会感到十分惊讶如何，以及这一招可能的工作。
- Is your web or database server overloaded ? 是您的Web或数据库服务器超载 ？ This can be a tricky one to figure out.这可能是一个棘手的一个数字。 If you don’t have telnet access, you need to call support for your web host and find out what the CPU and memory utilization is for the server you’re on.如果您没有的Telnet访问，您需要调用的支持，您的网页主机，并找出什么CPU和内存使用率为服务器您对。 If it’s really high you may want to request to be moved to a new one.如果它真的高您可能想要要求被转移到了一个新的1 。 Most companies monitor this, so more than likely it could be your database mySQL server.大部分的公司监控，所以更可能比它可能是您的数据库MySQL服务器。 Your myPHPAdmin tool might already have a tab or tool to bring up the server memory utilization, so you can see how high it is.您的myphpadmin的工具，可能已经有标签或工具，带来了服务器内存利用，所以你可以看到有多高，这是。 If it’s not high, find out if your web host has a limit on concurrent connections (some limit to 150 or less) and watch your visitors per hour.如果它不高，找出如果您的网页主机有一个限制，并行连接（有些限制到150或更少）和观赏您的访客每小时。 Many times though, there are a just a few web sites hogging all the resources on a db server很多次，虽然，有一在短短数网站荒加工的所有资源对一分贝服务器
If you have a Wordpress site, I would also additionally check your WP theme and your WP plugins .如果您有一个在WordPress网站，我也另外请检查您的可湿性粉剂的主题和您的可湿性粉剂插件 。 First - remove any plugins that you aren’t using.首-消除任何插件你是不使用。 Deactivate them and physically delete them from your web server.关闭他们的身体和删除它们从您的网络服务器。 I read once that even deactivated plugins affect the speed of a site because the Wordpress loop checks to see if they are activated or not.我看过一次，即使停用插件影响速度的一个网站，因为在WordPress回路检查，以了解他们是否被激活或没有。 If you have plugins you specifically don’t need or use - get rid of them .如果您有插件，你具体不需要或使用-摆脱他们。 You want your plugin page in the admin panel to have only plugins that are essential to your blog and they should all be active.您希望您的插件的网页在管理面板有只插件是必不可少的到您的博客，他们都应该是积极的。 If they aren’t - delete them from the server until you need them.如果他们没有-删除它们从服务器，直到你需要他们。 Also, check your theme if you don’t write your own.此外，检查您的主题，如果你不写自己的。 Validate the code at W3C验证代码的W3C or another site and make sure that there aren’t major errors that are slowing the browser down.或另一个网站，并且一定要知道有没有重大的错误，它们会减慢浏览器。 Just because you have a nice looking theme, (if you didn’t code it yourself) it doesn’t mean that the coder that made it had the most efficient code.只是因为你有一个很好看的主题， （如果你没有代码，它自己） ，这并不表示该编码器，使得它有最有效的代码。 If you have a lot of errors - maybe you should consider reworking it or just plain get another theme.如果您有很多的错误-也许你应该考虑改造它，或只是平原得到的另一个主题。
In my particular instance I thought I had my mySQL database hosted on a server that was too busy.在我的，特别是例如我想我已我的MySQL数据库托管的服务器，这是太忙。 At my host they have multiple database servers and when you create a new one it’s assigned at random.在我的东道国，他们有多个数据库服务器，当你创建一个新的，它的分配，在随机的。 So I created a new fresh database - and of course it was on a different server.因此，我创建了一个新的新鲜数据库-当然这是对不同的服务器。 Then I exported my web site using myPHPAdmin, and I was going to import it in the fresh database using myPHPAdmin as well.然后我出口我的网站使用myphpadmin ，我要进口，它在新鲜数据库使用myphpadmin以及。 But as it turned out my SQL file was 11MB, and some of the INSERT rows were very, very long.但由于原来我的SQL文件是11mb ，和部分的插入行非常，非常长。 The import failed.进口失败。 But as I mentioned before - it was easy enough to use但正如我以前所说-它是很容易足够使用 BigDump large mySQL db database import script for free bigdump大分贝的MySQL数据库的进口脚本免费 to do the heavy work for me.这样做粗重工作，为我。 In seconds I had a brand new copy of my site on another database server.在几秒钟我有一个全新的副本，我的网站上的另一个数据库服务器。 So I changed my config file, and was up and running on another server quickly.因此，我改变了我的config档案，并和运行在另一台服务器上迅速。 In my situation this new server seemed to perform a bit better than the old one.在我的情况，这似乎是新的服务器来执行位优于旧1 。
If you’ve experienced your web site or blog (especially Wordpress) getting slow, bogged down, or getting random errors - try my list above first.如果您经历了您的网站或博客（尤其是在WordPress ）越来越缓慢，停滞不前，或获取随机误差-尝试我的名单上述第一。 If you’ve found your own solution, or experienced a problem that you can’t fix - please add it in the comments below now!如果您发现自己的解决方案，或遇到了问题，您不能修复-请添加它在评论下面现在！
January 17th, 2008 at 11:32 am 2008年1月17日在上午11时32分
Some good tips here, but when you mention to watch your browser to see about external calls, you really need to be using Firefox with the add-on Firebug.一些好的提示这里，但是当你所提到的观赏您的浏览器，看看有关对外通话，你真的需要加以使用Firefox与添加-关于萤火虫。 This will give you a wealth of info on your site, and what’s taking time to load.这会给你了丰富的信息在您的网站上，和什么的抽出时间来载入。
Your point about optimizing images is key, there are plenty of online sites that will do it for you for free (something nice if you’re at work and don’t have access to PS or The Gimp).您的点，优化图像是关键，有很多网站将做它为您免费的（一些尼斯如果您在工作和没有获得PS或有关的gimp ） 。
You mention tuning your DB, but how about ensuring that the new database is created as InnDB?你所提到的微调您的分贝，但如何确保新的数据库创建为inndb ？ That’ll help, and I think is default for anything +5.2.x.这将帮助，我认为是默认的事情5.2 。十。 Also, while most won’t have access, you can really improve things in MySQL by modifying the my.cnf conf file on your server.此外，虽然大部分将无法使用，您可以真正改善的东西，在MySQL中修改my.cnf配置文件在您的服务器上。 Upping memory usage and enabling caching are key here. `的记忆体使用量，并使缓存是这里的关键。
Other ideas that I use, but are only applicable if you have your own server or access:其他的想法，我使用，但只适用于如果你有自己的服务器或访问：
webserver - instead of Apache, use Lighttpd, it’s faster and ‘lighter’.网页伺服器-而不是A pache时，使用l ighttpd，它的速度更快和'轻' 。 if you’re extra l33t, try out nginx!如果您额外l33t ，尝试nginx ！
php - ensure you have some kind of php accelerator - I’ve used eAccelerator (a fork of the old MMTurke Cache) for years, but I’ve recently been using Xcache (created by a developer of Lighttpd) and have been happy with it so far. PHP的-确保你有一些种的P HP加速器-我已经用e a ccelerator（一交岔路口的旧m m turke快取记忆体）多年，但我最近一直在使用xc ache（所创造的开发li ghttpd），并已很乐意与它到目前为止。
reverse-proxy - a big one if you get a lot of traffic, but still helpful if you don’t.反向代理-一个大1如果你得到了很多的交通，但仍帮助如果您没有。 Squid has always been the choice, but again, I’ve gone with a newer app, Varnish.鱿鱼一直是选择，但再次，我已经经历了一个较新的应用程序，研磨剂。 I’ve done tests in production areas at my work, and believe the hype, Varnish will stand up and really help, esp if you ever get a Digg’ing.我已经做了试验，在生产领域，在我的工作，并相信天花乱坠的研磨剂会站起来，和真正的帮助，电除尘器如果您以往任何时候都得到digg'ing 。 It is fast, and old Squid just dosen’t compare.这是快速，旧鱿鱼刚才的doesn't比较。
Lastly, within Wordpress add WP Cache, or the newer/updated fork, WP Super Cache - it speeds things up nicely.最后，在WordPress添加可湿性粉剂快取记忆体，或较新的/更新的交岔路口，可湿性粉剂超高速缓存-它的速度东西很好。 Yes, you can have all of these layers of caching (reverse proxy, php opticode, wp-cache) working together.是的，您可以有所有这些层次的缓存（反向Proxy ， PHP的opticode ，可湿性粉剂-快取记忆体）一起工作。
So these are just some of my geekier suggestions, it’s funny, I’ve run my server online from home since 2001, but it’s only been the last 3 months I’ve looked at monetizing sites; it’s good fun, and sites like yours give a good start to a ‘n00b’ like me!因此，这些都只是我的一些geekier建议，它的搞笑，我已经运行我的服务器在线从家里自2001年以来，但它的只有最近3个月我查看了货币的网站，它的好好玩和网站一样，你提供一个良好的开端，一个' n00b '和我一样！
Hope my tips help, gimme a shout if you have any questions.希望我的提示帮助，给我一喊如果您有任何问题。 I’m hoping to be able to contribute to the whole online marketing world soon much as you are now.我希望能够有助于整个线上行销世界，尽快高达你现在。
Thanks.谢谢。
fak3r’s last blog post.. fak3r的最后的博客帖子.. Do the collage - the art of Bob Pollard 这样做拼贴-艺术鲍勃波拉德
April 3rd, 2008 at 12:42 pm 2008年4月3日在下午12时42分
I never really thought of optimizing images on my blog..我从来没有真的认为优化图像，我的博客..![= ） ]](http://www.jtpratt.com/wp-includes/images/smilies/4.gif)
I just made a custom theme and decided to see where that took me!我刚才提出的自订主题，并决定在那里看到了我！
BradBlogging.com - Increase Website Traffic With Easy To Follow Steps’s last blog post.. bradblogging.com -增加网站流量与容易的后续步骤的最后的博客帖子. . 1000 Entrecard Credits + More Up For Grabs! 1000 entrecard学分+更多为抓住！ Details Inside.. 详情..
April 23rd, 2008 at 4:54 am 2008年4月23日在上午04时54分
[...] 5 Tips to Help Your Slow or Sluggish Blog or Web Site (Wordpress Especially) [...] [ … … ]的5个窍门，以帮助您慢或呆滞的博客或网站（尤其是在WordPress ） [ … … ]
June 14th, 2008 at 10:24 am 2008年6月14日在上午10时24分
If a website is sluggish due to numerous mySQL queries that take longer than 1 second to execute, then who or which company do you recommend to optimize mySQL?如果一个网站是呆滞，由于众多的MySQL查询，需要较长时间超过1秒执行，那么谁或哪个公司，你推荐的优化MySQL的？
Shop Networks last blog post..店网络上的博客帖子.. Fossil Watch - Black Dial Analog化石观赏-黑色拨号模拟
June 14th, 2008 at 8:41 pm 2008年6月14日在下午8时41分
@Shop Network - it depends on what you’re talking about. @店网络-这取决于你在说些什么。 If it’s Wordpress I’d first try and deactivate all plugins.如果它的WordPress我要第一次尝试，并停用所有插件。 If you get your speed back it’sa plugin conflict, add them back one by one to find it.如果您收到您的速度回到这插件冲突，将它们加回了一个又一个找到它。 If it’sa custom site or something, or another problem find a database expert on eLance - you can get your issue resolved for a pretty reasonable rate.如果这是自订的网站或东西，或另一个问题，找到一个数据库，专家对elance -您可以将问题解决的相当合理的利率。
June 15th, 2008 at 8:30 am 2008年6月15日上午8时30分
@Shop Network - if you have access to them, get a look at the mysql.err.logs, then work on tweaking the mysql conf file to use more cache for its queries. @店网络-如果您有与他们接触，获得看看在m ysql.err.logs，然后工作，调整M ySQL的配置文件来使用更多的快取记忆体供其查询。 Lastly do what I’m doing, if your system is overloaded and working in swap a lot, upgrade to a new box that can hold more RAM, we’ll see, but I think this is going to help me immensely - but before that, do some Googling, you’ll likely see big improvements over the default configs.最后做什么，我这样做，如果您的系统是超载和工作在互换了很多，提升到一个新的方块，可以容纳更多的RAM ，我们将看到，但我认为这将会是我莫大的帮助-但在此之前，做一些使用Google ，您可能会看到大的改善，默认configs 。
July 18th, 2008 at 5:22 pm 2008年7月18日在下午5时22分
Although this article is somewhat old, it still has some good information and things that can be applied to speed up a site nicely.虽然这条有点老，但仍有一些良好的信息和事情，可用于加快网站皆大欢喜。 Thank you for what you do.谢谢你什么你怎么做。
Tom Sawyers last blog post..汤姆sawyers最后的博客帖子.. Really Jesse, the Mic is Still On!真的杰西，麦克风仍在进行中！
September 12th, 2008 at 10:20 pm 2008年9月12日在下午10时20分
Thanks for the article.感谢文章。 I have a really dumb question as I ponder setting up a WordPress installation for my business.我有一个真正的哑巴的问题，正如我思考设立的WordPress安装适合我的企业。
I notice many web hosts only allow 5-10 MySQL databases.我看到许多Web主机只允许5月10日的MySQL数据库。 Doesn’t that pose a problem for the many plug-ins in WordPress that want to use a MySQL database?不构成一个问题的许多插件在WordPress认为，要使用一个MySQL数据库？ I guess I’m assuming they all just start their own, or at least many of them do.我猜我假设他们都刚刚开始自己的，或者至少是他们中的许多做的。
Thanks for your help.感谢您的帮助。 Good site.良好的工地。
Jim吉姆
September 13th, 2008 at 8:40 am 2008年9月13日在上午8时40分
@Jim - first of all, never EVER sign up for a web host that limits databases, emails, subdomains - or about anything. @吉姆-首先，从未注册一个W eb主机的限制，数据库，电子邮件，子网域-或什么。 Over a year ago I switched totally everything on my shared accounts from goDaddy to较一年前，我完全转一切对我共享帐户，以从godaddy Hostgator hostgator and I couldn’t be happier!我无法幸福！ I can have unlimited web sites, databases, or whatever I want for a very reasonable price.我可以有无限的网站，数据库，或什么，我想了很合理的价格。
Secondly though, no plugins don’t require additional databases - they just create new tables in your existing Wordpress database.其次，虽然，没有插件并不需要额外的数据库-他们只是创造新的表在您现有的W ordPress数据库。 The problem installing (and removing) dozens of tables into a Wordpress database poses is that usually when a plugin is deleted, the tables and data it created are left behind - leaving your to manually remove them and clean it up.问题的安装（和消除）几十个表成为一个在WordPress数据库构成的是，通常当一个插件被删除，表和数据，它创造了有遗留下来的-离开您的手动删除他们和清洁了。 Some of the better plugins do clean up after themselves or have a “completely uninstall” option.一些更好的插件做清理后，自己或有一个“完全卸载”选项。