[Anas User]

أخي الكريم

قامت الشركة بإرسال رسالة إلي موضحة سبب المشكلة قائلة :
-----------
المشكلة أن الـ queries الخاصة بإحدى قواعد البيانات لديك يتم معالجتها ببطء شديد و تستهلك جزء كبير من موار السيرفر server cpu time ...
------------

قاموا أيضاً بإرسال 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

أتمنى أخي الكريم أن تكون الصورة وضحت و أن أجد لديك الرد ...

تحياتي