الموضوع: قواعد البيانات و الإستضافة العادية
عرض مشاركة مفردة
 
  #9  
قديم 09-09-2006, 07:33 AM
Anas User Anas User غير متصل
عضو
  
تاريخ التسجيل: Jul 2006
مشاركة: 19
مستوى تقييم العضوية: 0
Anas User is on a distinguished road
الافتراضي
أخي الكريم

قامت الشركة بإرسال رسالة إلي موضحة سبب المشكلة قائلة :
-----------
المشكلة أن الـ 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


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

تحياتي