Forum Replies Created

Viewing 8 replies - 1 through 8 (of 8 total)
  • Thread Starter aigou

    (@aigou)

    i have found this issue’s root cause.
    if you want change smilies after defined the key words,i must to clean up the old words in database.i think the good method is delete the old blank and rewrite the keyword in your wordpress admin panle.

    Forum: Plugins
    In reply to: WP Grins And More Smilies
    Forum: Plugins
    In reply to: Customizing WP-Grins ?!?

    hey,Gatzek,
    i also want to modify grins same as your question #1 ??

    Forum: Plugins
    In reply to: WP-Grins Customizable?

    this maybe useful for you.
    https://aranea.zuavra.net/index.php/20/#ig-1
    i have tryed it , and its working!

    Forum: Fixing WordPress
    In reply to: server overload
    aigou

    (@aigou)

    yes,after upgrading to 2.12 from 2.04

    aigou

    (@aigou)

    thank you.
    the issue is be caused when i updated to wp2.12.
    now i must to promise that the overload is not happen more,so i am waitting the root-solve,maybe wp-cache is be working,i hope.

    Forum: Fixing WordPress
    In reply to: server overload
    aigou

    (@aigou)

    hey,i was met the same issue.
    the sever is being overloading.
    the administrator have provided the slow-log to me as after.

    Most common slow queries:
    1. Time: 10% (775 sec)
    Amount: 9% (48 queries)
    Avg. Query Exec/Lock Time: 16 / 4 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’;

    2. Time: 4% (360 sec)
    Amount: 4% (25 queries)
    Avg. Query Exec/Lock Time: 14 / 2 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT * FROM wp_posts WHERE ID = ‘329’ LIMIT 1;

    3. Time: 4% (326 sec)
    Amount: 4% (22 queries)
    Avg. Query Exec/Lock Time: 14 / 3 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN(137) ORDER BY post_id, meta_key;

    4. Time: 2% (209 sec)
    Amount: 2% (14 queries)
    Avg. Query Exec/Lock Time: 14 / 3 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT comment_date_gmt FROM wp_comments WHERE comment_author_IP = ‘195.225.177.20’ OR comment_author_email = ” ORDER BY comment_date DESC LIMIT 1;

    5. Time: 2% (164 sec)
    Amount: 2% (14 queries)
    Avg. Query Exec/Lock Time: 11 / 0 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT comment_ID FROM wp_comments WHERE comment_post_ID = ‘544’ AND ( comment_author = ‘Business Loans’ ) AND comment_content = ‘Business Loans… nice blog!!…’ LIMIT 1;

    6. Time: 2% (189 sec)
    Amount: 2% (14 queries)
    Avg. Query Exec/Lock Time: 13 / 2 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT ID, post_title, post_date FROM wp_posts WHERE ID = 142 AND post_status = ‘publish’ LIMIT 1;

    7. Time: 2% (201 sec)
    Amount: 2% (13 queries)
    Avg. Query Exec/Lock Time: 15 / 3 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; DELETE FROM wp_comments WHERE DATE_SUB(‘2007-03-10 09:55:58’, INTERVAL 15 DAY) > comment_date_gmt AND comment_approved = ‘spam’;

    8. Time: 2% (201 sec)
    Amount: 2% (12 queries)
    Avg. Query Exec/Lock Time: 16 / 4 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT ID, post_title, post_date, post_content FROM wp_posts WHERE post_status = ‘publish’ AND post_password =” ORDER BY RAND() LIMIT 5;

    aigou

    (@aigou)

    hey,i was met the same issue.
    the sever is being overloading.
    the administrator have provided the slow-log to me as after.

    Most common slow queries:
    1. Time: 10% (775 sec)
    Amount: 9% (48 queries)
    Avg. Query Exec/Lock Time: 16 / 4 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT option_value FROM wp_options WHERE option_name = ‘siteurl’;

    2. Time: 4% (360 sec)
    Amount: 4% (25 queries)
    Avg. Query Exec/Lock Time: 14 / 2 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT * FROM wp_posts WHERE ID = ‘329’ LIMIT 1;

    3. Time: 4% (326 sec)
    Amount: 4% (22 queries)
    Avg. Query Exec/Lock Time: 14 / 3 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT post_id, meta_key, meta_value FROM wp_postmeta WHERE post_id IN(137) ORDER BY post_id, meta_key;

    4. Time: 2% (209 sec)
    Amount: 2% (14 queries)
    Avg. Query Exec/Lock Time: 14 / 3 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT comment_date_gmt FROM wp_comments WHERE comment_author_IP = ‘195.225.177.20’ OR comment_author_email = ” ORDER BY comment_date DESC LIMIT 1;

    5. Time: 2% (164 sec)
    Amount: 2% (14 queries)
    Avg. Query Exec/Lock Time: 11 / 0 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT comment_ID FROM wp_comments WHERE comment_post_ID = ‘544’ AND ( comment_author = ‘Business Loans’ ) AND comment_content = ‘Business Loans… nice blog!!…’ LIMIT 1;

    6. Time: 2% (189 sec)
    Amount: 2% (14 queries)
    Avg. Query Exec/Lock Time: 13 / 2 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT ID, post_title, post_date FROM wp_posts WHERE ID = 142 AND post_status = ‘publish’ LIMIT 1;

    7. Time: 2% (201 sec)
    Amount: 2% (13 queries)
    Avg. Query Exec/Lock Time: 15 / 3 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; DELETE FROM wp_comments WHERE DATE_SUB(‘2007-03-10 09:55:58’, INTERVAL 15 DAY) > comment_date_gmt AND comment_approved = ‘spam’;

    8. Time: 2% (201 sec)
    Amount: 2% (12 queries)
    Avg. Query Exec/Lock Time: 16 / 4 sec.
    Used databases: [whutaig_wordpress]
    Query example: use whutaig_wordpress; SELECT ID, post_title, post_date, post_content FROM wp_posts WHERE post_status = ‘publish’ AND post_password =” ORDER BY RAND() LIMIT 5;

Viewing 8 replies - 1 through 8 (of 8 total)