WordPress.org

1. habboubih
   Member
   Posted 1 year ago #

   Hello ...

   Since I installed the wordpress on my website and I am getting CPU overload and my server is stopping frequently.

   I've tried everything, but still facing the problem and I started to lose visitors.

   Some information that might help:

   1. my wordpress is installed on a subdirectoy

   2. list of plugins that I am using:
   - AdSense Manager
   - Akismet
   - All in One SEO Pack
   - Collapsing Categories
   - Contact Form 7
   - Digg This Button
   - Evermore
   - Facebook Like
   - Google Analyticator
   - Google XML Sitemaps
   - Health Check
   - Really Simple CAPTCHA
   - Redirection
   - SEO Slugs
   - SexyBookmarks
   - SI CAPTCHA Anti-Spam
   - TweetMeme Retweet Button
   - Twitter Friendly Links
   - Wickett Twitter Widget
   - WordPress.com Stats
   - WordPress Popular Posts
   - WP-Ban
   - WP Google-buzz
   - WP Robot 3 (original)
   - WP Super Cache
   - WPtouch iPhone Theme
   - Yet Another Related Posts Plugin

   3. WP Robot 3:
   I am using the cpanel cron jobs and set to post every 10 mins

   4. WP Super Cache
   Due to the server overload I am unable to install this plug-in automatically. I installed this plugin manually but receive this message when making a "Test Cache"
   The pages do not match! Timestamps differ or were not found!

   5. This is my server specifications:

   Quad Core Xeon® X3430 Processor
   4 x 2.4 GHz Cores
   8 MB L3 Cache, 1333 MHz FSB
   4 GB 1333MHz DDR3 Memory
   500 GB Usable Storage
   6 TB Monthly Transfer
   100 Mbps Uplink Port
   CentOS 5 Operating System
   Unlimited Domains and User Accounts

   6. I have 7 domains installed on 5 IPs. Non of the 7 websites are making problems except the wordpress website.

   7. I contacted the company of my server and this is what they sadi:
   Most active database is database_wordpress, specifically these tables:
   wp_term_taxonomy, wp_terms, wp_posts, wp_term_relationships

   Any idea how to solve this ??? please help. this is urgent ...

   Thank you...

2. James
   Happiness Engineer
   Posted 1 year ago #

   Generally, I recommend WP Super Cache, but since that isn't working for you, try this one instead:

   http://wordpress.org/extend/plugins/w3-total-cache/

   Also, this article may help:

   http://codex.wordpress.org/WordPress_Optimization#Virtual_.2F_Dedicated_Server

3. dcannon1
   Member
   Posted 1 year ago #

   WP Robot can use a ton of resources depending on what you're posting with it. Running it every 10 minutes is a lot, especially considering you're running quite a few other plugins as well. I would cut WP-Robot back to a couple of times a day at most.

   Google XML sitemaps could also be using a lot of resources in conjunction with WP-Robot. WP-Robot uses resources while it's running, and at the same time Google XML sitemaps is trying to build a new sitemap file to accommodate the new posts.

   Also, the advice about W3 Total Cache is good as well.

4. habboubih
   Member
   Posted 1 year ago #

   James (MacManX)
   Thank you for the info. Going through them now.

   dcannon1
   Well, never tried to use W3 total cache. I will install it now and see the difference. Regarding WP Robot, I will set the cron to be ran every 3 hours.

   Google XML sitemaps
   I cant see any feature so I can control the process timings.

5. James
   Happiness Engineer
   Posted 1 year ago #

   Google XML sitemaps
   I cant see any feature so I can control the process timings.

   At Settings/XML-Sitemap in your admin panel, uncheck "Rebuild sitemap if you change the content of your blog" and check "Enable manual sitemap building via GET Request". You can then use a cron script to access the rebuild URL however often you schedule it to.

6. habboubih
   Member
   Posted 1 year ago #

   You can then use a cron script to access the rebuild URL however often you schedule it to.

   should I use the provided link for cron ?

7. James
   Happiness Engineer
   Posted 1 year ago #

   Yes

8. habboubih
   Member
   Posted 1 year ago #

   Ok..

   I uninstalled the google xml sitemap
   I installed W3 Total Cache

   and I am still getting CPU overload

   I took a look at my database and noticed that tables are using different Collation

   Some of them are using utf8_general_ci (main wordpress tables)
   and some of them are using latin1_swedish_ci (mostly plugins)

   I dont know how this happened but I think that this might be the issue.

   If this is the issue, how can I change all Collation to be utf8_general_ci ???

9. James
   Happiness Engineer
   Posted 1 year ago #

   It's a complicated process, but it may solve your problem. Fortunately, I did a quick write-up a few months ago:

   http://www.macmanx.com/2010/04/easily-convert-database-character-sets/

   The instructions are Mac-specific using the plain text editor Fraise, but they can be easily reinterpreted using any Windows or Linux-based plain text editor.

10. habboubih
    Member
    Posted 1 year ago #

    Nothing happened even when I changed Collation.

    I've also upgraded to version 3.0.1

    I've also reinstalled all plugins

    I set the cron for WPROBOT to post every 2 hours

11. habboubih
    Member
    Posted 1 year ago #

    here is the process of my database that is causing the issue:

    +-------+---------------+-----------+---------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | Id | User | Host | db | Command | Time | State | Info |
    +-------+---------------+-----------+---------------------+---------+------+----------------------+------------------------------------------------------------------------------------------------------+
    | 26309 | admin_user | localhost | wordpress_DB | Query | 7061 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26322 | admin_user | localhost | wordpress_DB | Query | 7060 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26326 | admin_user | localhost | wordpress_DB | Query | 7050 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26335 | admin_user | localhost | wordpress_DB | Query | 7038 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26343 | admin_user | localhost | wordpress_DB | Query | 7009 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26352 | admin_user | localhost | wordpress_DB | Query | 6981 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26387 | admin_user | localhost | wordpress_DB | Query | 6908 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26392 | admin_user | localhost | wordpress_DB | Query | 6898 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26448 | admin_user | localhost | wordpress_DB | Query | 6373 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26449 | admin_user | localhost | wordpress_DB | Query | 5709 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26459 | admin_user | localhost | wordpress_DB | Query | 6373 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26461 | admin_user | localhost | wordpress_DB | Query | 6293 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26465 | admin_user | localhost | wordpress_DB | Query | 6362 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26472 | admin_user | localhost | wordpress_DB | Query | 6316 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26483 | admin_user | localhost | wordpress_DB | Query | 6597 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26485 | admin_user | localhost | wordpress_DB | Query | 6313 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26484 | admin_user | localhost | wordpress_DB | Query | 6362 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26486 | admin_user | localhost | wordpress_DB | Query | 6329 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26493 | admin_user | localhost | wordpress_DB | Query | 6376 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26498 | admin_user | localhost | wordpress_DB | Query | 5711 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26500 | admin_user | localhost | wordpress_DB | Query | 6346 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26501 | admin_user | localhost | wordpress_DB | Query | 6344 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26502 | admin_user | localhost | wordpress_DB | Query | 6344 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26503 | admin_user | localhost | wordpress_DB | Query | 6346 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26505 | admin_user | localhost | wordpress_DB | Query | 6319 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26507 | admin_user | localhost | wordpress_DB | Query | 6383 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26508 | admin_user | localhost | wordpress_DB | Query | 6301 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26509 | admin_user | localhost | wordpress_DB | Query | 6284 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26510 | admin_user | localhost | wordpress_DB | Query | 6273 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26511 | admin_user | localhost | wordpress_DB | Query | 6293 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26514 | admin_user | localhost | wordpress_DB | Query | 6346 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26515 | admin_user | localhost | wordpress_DB | Query | 6346 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26517 | admin_user | localhost | wordpress_DB | Query | 6390 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26519 | admin_user | localhost | wordpress_DB | Query | 6159 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26522 | admin_user | localhost | wordpress_DB | Query | 6352 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26523 | admin_user | localhost | wordpress_DB | Query | 6362 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26525 | admin_user | localhost | wordpress_DB | Query | 6390 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26634 | admin_user | localhost | wordpress_DB | Query | 6147 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26636 | admin_user | localhost | wordpress_DB | Query | 5807 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26645 | admin_user | localhost | wordpress_DB | Query | 6159 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26649 | admin_user | localhost | wordpress_DB | Query | 6163 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26672 | admin_user | localhost | wordpress_DB | Query | 5832 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26678 | admin_user | localhost | wordpress_DB | Query | 5852 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26681 | admin_user | localhost | wordpress_DB | Query | 5961 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26682 | admin_user | localhost | wordpress_DB | Query | 6113 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26709 | admin_user | localhost | wordpress_DB | Query | 5790 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26748 | admin_user | localhost | wordpress_DB | Query | 5854 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26750 | admin_user | localhost | wordpress_DB | Query | 5825 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26754 | admin_user | localhost | wordpress_DB | Query | 5844 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26765 | admin_user | localhost | wordpress_DB | Query | 5793 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26770 | admin_user | localhost | wordpress_DB | Query | 5795 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26773 | admin_user | localhost | wordpress_DB | Query | 5847 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26784 | admin_user | localhost | wordpress_DB | Query | 5834 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26798 | admin_user | localhost | wordpress_DB | Query | 5802 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26812 | admin_user | localhost | wordpress_DB | Query | 5794 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26846 | admin_user | localhost | wordpress_DB | Query | 5772 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26914 | admin_user | localhost | wordpress_DB | Query | 5734 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26926 | admin_user | localhost | wordpress_DB | Query | 5729 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26978 | admin_user | localhost | wordpress_DB | Query | 5669 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 26980 | admin_user | localhost | wordpress_DB | Query | 5638 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27028 | admin_user | localhost | wordpress_DB | Query | 5554 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27058 | admin_user | localhost | wordpress_DB | Query | 5538 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27111 | admin_user | localhost | wordpress_DB | Query | 5494 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27115 | admin_user | localhost | wordpress_DB | Query | 5493 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27123 | admin_user | localhost | wordpress_DB | Query | 5476 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27134 | admin_user | localhost | wordpress_DB | Query | 5471 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27157 | admin_user | localhost | wordpress_DB | Query | 5434 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27177 | admin_user | localhost | wordpress_DB | Query | 5394 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27199 | admin_user | localhost | wordpress_DB | Query | 5351 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27229 | admin_user | localhost | wordpress_DB | Query | 5299 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27238 | admin_user | localhost | wordpress_DB | Query | 5289 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27265 | admin_user | localhost | wordpress_DB | Query | 5214 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27272 | admin_user | localhost | wordpress_DB | Query | 5210 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27309 | admin_user | localhost | wordpress_DB | Query | 5171 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27315 | admin_user | localhost | wordpress_DB | Query | 5163 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27322 | admin_user | localhost | wordpress_DB | Query | 5138 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27336 | admin_user | localhost | wordpress_DB | Query | 5041 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27367 | admin_user | localhost | wordpress_DB | Query | 4992 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27382 | admin_user | localhost | wordpress_DB | Query | 4967 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27392 | admin_user | localhost | wordpress_DB | Query | 4920 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27394 | admin_user | localhost | wordpress_DB | Query | 4924 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27418 | admin_user | localhost | wordpress_DB | Query | 4889 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27439 | admin_user | localhost | wordpress_DB | Query | 4836 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27463 | admin_user | localhost | wordpress_DB | Query | 4810 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27494 | admin_user | localhost | wordpress_DB | Query | 4747 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27504 | admin_user | localhost | wordpress_DB | Query | 4735 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27512 | admin_user | localhost | wordpress_DB | Query | 4713 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27521 | admin_user | localhost | wordpress_DB | Query | 4714 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27529 | admin_user | localhost | wordpress_DB | Query | 4714 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27575 | admin_user | localhost | wordpress_DB | Query | 4630 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27576 | admin_user | localhost | wordpress_DB | Query | 4630 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27578 | admin_user | localhost | wordpress_DB | Query | 4619 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27581 | admin_user | localhost | wordpress_DB | Query | 4592 | Sending data | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27603 | admin_user | localhost | wordpress_DB | Query | 4555 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27605 | admin_user | localhost | wordpress_DB | Query | 4555 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27606 | admin_user | localhost | wordpress_DB | Query | 4554 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27607 | admin_user | localhost | wordpress_DB | Query | 4546 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27609 | admin_user | localhost | wordpress_DB | Query | 4546 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27610 | admin_user | localhost | wordpress_DB | Query | 4546 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27615 | admin_user | localhost | wordpress_DB | Query | 4536 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27616 | admin_user | localhost | wordpress_DB | Query | 4535 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27617 | admin_user | localhost | wordpress_DB | Query | 4533 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27618 | admin_user | localhost | wordpress_DB | Query | 4533 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27619 | admin_user | localhost | wordpress_DB | Query | 4531 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27620 | admin_user | localhost | wordpress_DB | Query | 4529 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27621 | admin_user | localhost | wordpress_DB | Query | 4529 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27622 | admin_user | localhost | wordpress_DB | Query | 4525 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27623 | admin_user | localhost | wordpress_DB | Query | 4515 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27625 | admin_user | localhost | wordpress_DB | Query | 4509 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27630 | admin_user | localhost | wordpress_DB | Query | 4498 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27635 | admin_user | localhost | wordpress_DB | Query | 4483 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27639 | admin_user | localhost | wordpress_DB | Query | 4455 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27645 | admin_user | localhost | wordpress_DB | Query | 4443 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27714 | admin_user | localhost | wordpress_DB | Query | 4360 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27715 | admin_user | localhost | wordpress_DB | Query | 4370 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27737 | admin_user | localhost | wordpress_DB | Query | 4357 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27740 | admin_user | localhost | wordpress_DB | Query | 4349 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27752 | admin_user | localhost | wordpress_DB | Query | 4343 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27773 | admin_user | localhost | wordpress_DB | Query | 4295 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27842 | admin_user | localhost | wordpress_DB | Query | 4215 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27863 | admin_user | localhost | wordpress_DB | Query | 4138 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 27880 | farfosh_admin | localhost | rapdishare_search_DB | Query | 4069 | Sending data | SELECT COUNT(*) FROM v2links WHERE MATCH (caption) AGAINST ('NASA World') |
    | 27892 | admin_user | localhost | wordpress_DB | Query | 3247 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28042 | admin_user | localhost | wordpress_DB | Query | 3145 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28069 | admin_user | localhost | wordpress_DB | Query | 2690 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28080 | admin_user | localhost | wordpress_DB | Query | 2642 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28088 | admin_user | localhost | wordpress_DB | Query | 2563 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28126 | admin_user | localhost | wordpress_DB | Query | 2438 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28168 | admin_user | localhost | wordpress_DB | Query | 2393 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28174 | admin_user | localhost | wordpress_DB | Query | 2360 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28185 | admin_user | localhost | wordpress_DB | Query | 2360 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28193 | admin_user | localhost | wordpress_DB | Query | 2339 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28194 | admin_user | localhost | wordpress_DB | Query | 2350 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28206 | farfosh_admin | localhost | vbulletin_DB | Query | 2361 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
    thread.postusername, thread.da |
    | 28209 | farfosh_admin | localhost | vbulletin_DB | Query | 2338 | Sending data | SELECT *, thread.title AS threadtitle
    FROM rsslog AS rsslog
    INNER JOIN rssfeed AS rssfeed ON(rssfe |
    | 28216 | admin_user | localhost | wordpress_DB | Query | 2316 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28247 | admin_user | localhost | wordpress_DB | Query | 2228 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28252 | admin_user | localhost | wordpress_DB | Query | 2252 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28279 | admin_user | localhost | wordpress_DB | Query | 2194 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28283 | admin_user | localhost | wordpress_DB | Query | 2190 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28308 | admin_user | localhost | wordpress_DB | Query | 2143 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28313 | farfosh_admin | localhost | vbulletin_DB | Query | 2108 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
    thread.postusername, thread |
    | 28341 | admin_user | localhost | wordpress_DB | Query | 2094 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28349 | admin_user | localhost | wordpress_DB | Query | 2085 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28350 | admin_user | localhost | wordpress_DB | Query | 541 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28381 | admin_user | localhost | wordpress_DB | Query | 2014 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28388 | admin_user | localhost | wordpress_DB | Query | 2006 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28391 | farfosh_admin | localhost | vbulletin_DB | Query | 1971 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
    thread.postusername, thread |
    | 28393 | admin_user | localhost | wordpress_DB | Query | 1989 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28394 | admin_user | localhost | wordpress_DB | Query | 1978 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28472 | farfosh_admin | localhost | vbulletin_DB | Query | 1800 | Sending data | SELECT *, thread.title AS threadtitle
    FROM rsslog AS rsslog
    INNER JOIN rssfeed AS rssfeed ON(rssfe |
    | 28498 | farfosh_admin | localhost | rapdishare_search_DB | Query | 1722 | Sending data | SELECT COUNT(*) FROM v2links WHERE MATCH (caption) AGAINST ('axxo') |
    | 28527 | farfosh_admin | localhost | rapdishare_search_DB | Query | 1551 | Sending data | SELECT COUNT(*) FROM v2links WHERE MATCH (caption) AGAINST ('axxo') |
    | 28533 | admin_user | localhost | wordpress_DB | Query | 1362 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28540 | admin_user | localhost | wordpress_DB | Query | 1252 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28547 | farfosh_admin | localhost | rapdishare_search_DB | Query | 1195 | Sending data | SELECT COUNT(*) FROM v2links WHERE MATCH (caption) AGAINST ('axxo') |
    | 28549 | admin_user | localhost | wordpress_DB | Query | 1144 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28561 | admin_user | localhost | wordpress_DB | Query | 762 | Copying to tmp table | select ID, slug, date(post_date) as date, post_status,
    post_date, post_author, post_title, |
    | 28585 | farfosh_admin | localhost | rapdishare_search_DB | Query | 286 | Sending data | SELECT COUNT(*) FROM v2links WHERE MATCH (caption) AGAINST ('NASA World') |
    | 28586 | farfosh_admin | localhost | vbulletin_DB | Query | 269 | Copying to tmp table | SELECT thread.threadid, thread.title, thread.prefixid, post.attach,
    thread.postusername, thread.da |

    as shown, wordpress database is using the most of the CPU and is causing server overload therefore shuts other services off
    Any solution ?

12. loveguru1911
    Member
    Posted 1 year ago #

    Optimize your tables too..

13. habboubih
    Member
    Posted 1 year ago #

    already optimized and repaired..

14. habboubih
    Member
    Posted 1 year ago #

    Any news ?

    Please take this under consideration.

    Thank you..

15. pkenjora
    Member
    Posted 1 year ago #

    Table optimization won't solve this alone, you're running into a thrashing problem.

    Off the bat try disabling: All in One SEO Pack, its been having issues lately with bringing servers down due to inefficient code. See if that makes a difference.

    Second, YARPP is a bit of a CPU/Memory hog on larger sites. It computes alot of different variables. Try this to see if it helps.

    Third, make sure that your Google Sitemaps is running in the background. Its one of the options, running it in the foreground could kill your machine.

    Those are the top 3 culprits, if that does the trick you need a bigger machine or live without those plugins. If not then you definately have an issue with your DB or hardware.

    Keep in mind even machines have limits, don'r try to run thousands of visitors an hour from a $7.99 a month hosting account.

16. Samuel B
    moderator
    Posted 1 year ago #

    pkenjora
    Quit knocking Yaarp and hyping your plugin - enough is enough
    and some posts you resurrected from 8 months ago

17. pkenjora
    Member
    Posted 1 year ago #

    I didn't knock YARPP in this one, and I didn't plug anything here...

    Mitcho himself has commented on this, see comments:

    http://www.mattcutts.com/blog/wordpress-plugin-related-posts/

    I happen to know a thing or two about this arena of WordPress so I'm trying to help. I think I've actually left tips for people that have nothing to do with YARPP or my plugin in the past few hours.

    I noticed you removed the other post where I suggested an alternative so I haven't been suggesting any since. I got the hint.

    I do however think habboubih should try my suggestion as it is a reasonable thing to do.

    Theres a difference between knocking YARPP and trying to help this guy get his site running.

18. habboubih
    Member
    Posted 1 year ago #

    Table optimization won't solve this alone, you're running into a thrashing problem.

    Off the bat try disabling: All in One SEO Pack, its been having issues lately with bringing servers down due to inefficient code. See if that makes a difference.

    Second, YARPP is a bit of a CPU/Memory hog on larger sites. It computes alot of different variables. Try this to see if it helps.

    Third, make sure that your Google Sitemaps is running in the background. Its one of the options, running it in the foreground could kill your machine.

    Those are the top 3 culprits, if that does the trick you need a bigger machine or live without those plugins. If not then you definately have an issue with your DB or hardware.

    Keep in mind even machines have limits, don'r try to run thousands of visitors an hour from a $7.99 a month hosting account.

    Done all what you told me. CPU usage after the changes between 15% and 40%
    Actually I am paying $200/mo on my VPS.
    I am going to monitor the server for a couple of hours and check if his helps.
    Thank you

    pkenjora
    Quit knocking Yaarp and hyping your plugin - enough is enough
    and some posts you resurrected from 8 months ago

    I just want my server to run normally with or without YAARP. :)
    Thank you

19. ioloman
    Member
    Posted 1 year ago #

    Same problem here !! WordPress admin is rightly slow as hell, and causing CPU overload.

20. songdogtech
    Member
    Posted 1 year ago #

    @ioloman; replying to months-old threads will help little. Start a new thread with details on who your host is, linux or windows, if you've checked your sites via other networks and PCs, and URLs so people can see the site speed themselves.

Topic Closed

This topic has been closed to new replies.