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.

this maybe useful for you.
https://aranea.zuavra.net/index.php/20/#ig-1

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

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

yes,after upgrading to 2.12 from 2.04

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.

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;

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;