أخي الكريم شكراً على ردك
المشكلة أن المنتدى كان يعمل طبيعياً لأكثر من شهر و نصف
ثم فجأة حصلت هذه المشكلة و قالوا أن سببها هو أن هناك بعض الـ queries في قاعدة بيانات المنتدى يتم معالجتها ببط شديد جداً و هذا يسبب ضغطاً شديداً و overloading على موار السيرفر مما يجعله يتعطل و يعطي الخطأ 503 " Services Temporary Unavailable" ....
أيضاً قاموا بإرسال هذا الـ log عن الـ queries التي تسبب مشاكل و تتم معالجتها ببطء شديد :
# Time: 060908 20:31:54
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 47 Lock_time: 0
Rows_sent: 27384 Rows_examined: 27384
use algam3a_forumdb;
SELECT /*!40001 SQL_NO_CACHE */ * FROM
`ibf_mail_error_logs`;
# Time: 060908 20:32:01
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 7
Lock_time: 0 Rows_sent: 1715 Rows_examined: 1715
SELECT /*!40001 SQL_NO_CACHE */ * FROM
`ibf_member_extra`;
# Time: 060908 20:32:11
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 10
Lock_time: 0 Rows_sent: 1715 Rows_examined: 1715
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_members`;
#
Time: 060908 20:32:13
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 2 Lock_time: 0
Rows_sent: 1715 Rows_examined: 1715
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_members_converge`;
# Time:
060908 20:32:49
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 36 Lock_time: 0 Rows_sent:
4775 Rows_examined: 4775
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_message_text`;
# Time: 060908
20:32:52
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 3 Lock_time: 0 Rows_sent: 4867
Rows_examined: 4867
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_message_topics`;
# Time: 060908 20:32:57
#
User@Host: algam3a[algam3a] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1885 Rows_examined:
1885
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_moderator_logs`;
# Time: 060908 20:33:20
# User@Host:
algam3a[algam3a] @ localhost []
# Query_time: 17 Lock_time: 0 Rows_sent: 2020 Rows_examined: 2020
SELECT
/*!40001 SQL_NO_CACHE */ * FROM `ibf_pm_logs`;
# Time: 060908 20:52:36
# User@Host: algam3a[algam3a] @
localhost []
# Query_time: 1156 Lock_time: 0 Rows_sent: 59010 Rows_examined: 59010
SELECT /*!40001
SQL_NO_CACHE */ * FROM `ibf_posts`;
# Time: 060908 20:52:43
# User@Host: algam3a[algam3a] @ localhost []
#
Query_time: 3 Lock_time: 0 Rows_sent: 1579 Rows_examined: 1579
SELECT /*!40001 SQL_NO_CACHE */ * FROM
`ibf_shoutbox`;
# Time: 060908 20:52:46
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 3
Lock_time: 0 Rows_sent: 8 Rows_examined: 8
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_skin_sets`;
#
Time: 060908 20:53:08
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 18 Lock_time: 0
Rows_sent: 1612 Rows_examined: 1612
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_skin_templates`;
# Time:
060908 20:54:06
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 54 Lock_time: 0 Rows_sent: 273
Rows_examined: 273
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_skin_templates_cache`;
# Time: 060908
20:54:17
# User@Host: algam3a[algam3a] @ localhost []
# Query_time: 7 Lock_time: 0 Rows_sent: 7187
Rows_examined: 7187
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_spider_logs`;
# Time: 060908 20:54:30
#
User@Host: algam3a[algam3a] @ localhost []
# Query_time: 13 Lock_time: 0 Rows_sent: 11027
Rows_examined: 11027
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_task_logs`;
# Time: 060908 20:55:07
#
User@Host: algam3a[algam3a] @ localhost []
# Query_time: 37 Lock_time: 0 Rows_sent: 6087 Rows_examined:
6087
SELECT /*!40001 SQL_NO_CACHE */ * FROM `ibf_topic_markers`;
# Time: 060908 20:55:38
# User@Host:
algam3a[algam3a] @ localhost []
# Query_time: 23 Lock_time: 0 Rows_sent: 6077 Rows_examined: 6077
أيضاً هذه هي حالة السيرفر :
cpsrvd up
Server Load 2.07 (4 cpus)
Memory Used 22.5 %
Swap Used 2.20 %
Disk sda5 (/) 63 %
Disk sda1 (/boot) 14 %
Disk sda3 (/tmp) 8 %
Disk sdb1 (/sdb/mysql) 15 %
أتمنى أن تكون الصورة وضحت لديكم و أتمنى أن أجد لديكم الرد ...
تحياتي