لدينا موقع يواجه المشكله التاليه حسب الرساله الواردة من المستضيف
لاحظنا وأنظمة المراقبة لدينا وجود ضغط علي خادم قواعد البيانات بالسيرفر
بسبب قاعدة البيانات الخاصة بك الموجوده في موقعك بإسم
anpoe_diw
تقوم قاعده البيانات بتنفيذ إستعلامات كثيره تاخذ في تنفيذها وقت طويل وتعيد تكرار نفسها بعد إنتهاء الوقت
وهذا بدوره يؤثر سلبا علي السيرفر وعلي أداءه بشكل كامل
إليك الإستعلامات التي يتم تنفيذها بداخل القاعدة
+---------+----------------+-----------+----------------+---------+------+------
----------------+---------------------------------------------------------------
---------------------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+---------+----------------+-----------+----------------+---------+------+------
----------------+---------------------------------------------------------------
---------------------------------------+
| 1793584 | anpoe_diw | localhost | anpoe_diw | Query | 70 | Copyi
ng to tmp table | SELECT u.*, m.properties, COUNT(p.id) AS n_poems FROM users AS
u LEFT JOIN media AS m ON (u.id=m.use |
| 1793961 | anpoe_diw| localhost | anpoe_diw | Query | 24 | Locke
d | SELECT COUNT(*) FROM poems WHERE diwan_id=436 AND active='1'
|
| 1794023 | anpoe_diw | localhost | anpoe_diw | Query | 70 | Copyi
ng to tmp table | SELECT u.*, m.properties, COUNT(p.id) AS n_poems FROM users AS
u LEFT JOIN media AS m ON (u.id=m.use |
| 1794106 | anpoe_diw| localhost | anpoe_diw| Query | 69 | Copyi
ng to tmp table | SELECT u.*, m.properties, COUNT(p.id) AS n_poems FROM users AS
u LEFT JOIN media AS m ON (u.id=m.use |
| 1794677 | anpoe_diw| localhost | anpoe_diw| Query | 24 | Locke
+---------+------------------+-----------+----------------+---------+------+----
------------------+-------------------------------------------------------------
-----------------------------------------+
| Id | User | Host | db | Command | Time | Sta
te | Info
|
+---------+------------------+-----------+----------------+---------+------+----
------------------+-------------------------------------------------------------
-----------------------------------------+
| 1794677 | anpoe_diw| localhost | anpoe_diw| Query | 47 | Cop
ying to tmp table | SELECT s.*, COUNT(p.name) AS n_poems FROM section AS s LEFT
JOIN diwan AS d ON (d.section_id=s.id) L |
| 1794681 | anpoe_diw| localhost | anpoe_diw| Query | 47 | Cop
ying to tmp table | SELECT s.*, COUNT(p.name) AS n_poems FROM section AS s LEFT
JOIN diwan AS d ON (d.section_id=s.id) L |
| 1794723 | anpoe_diw| localhost | anpoe_diw| Query | 9 | Loc
ked | SELECT u.*, m.properties, COUNT(p.id) AS n_poems FROM users
AS u LEFT JOIN media AS m ON (u.id=m.use |
| 1794738 | anpoe_diw| localhost | anpoe_diw| Query | 10 | Cop
ying to tmp table | SELECT s.*, COUNT(p.name) AS n_poems FROM section AS s LEFT
JOIN diwan AS d ON (d.section_id=s.id) L |
+---------+----------------+-----------+-------------------+---------+------+---
-------------------+------------------------------------------------------------
------------------------------------------+
| Id | User | Host | db | Command | Time | St
ate | Info
|
+---------+----------------+-----------+-------------------+---------+------+---
-------------------+------------------------------------------------------------
------------------------------------------+
|
| 1795259 | anpoe_diw| localhost | anpoe_diw| Query | 72 | Co
pying to tmp table | SELECT u.*, m.properties, COUNT(p.id) AS n_poems FROM users
AS u LEFT JOIN media AS m ON (u.id=m.use |
| 1795333 | anpoe_diw| localhost | anpoe_diw| Query | 12 | Lo
cked | SELECT COUNT(id) FROM poems WHERE BINARY active=1
|
| 1795336 | anpoe_diw| localhost | anpoe_diw| Query | 21 | Lo
cked | SELECT s.*, COUNT(p.name) AS n_poems FROM section AS s LEFT
JOIN diwan AS d ON (d.section_id=s.id) L |
| 1795649 | anpoe_diw| localhost | anpoe_diw| Query | 21 | Lo
+---------+----------------+-----------+----------------+---------+------+------
----------------+---------------------------------------------------------------
---------------------------------------+
| Id | User | Host | db | Command | Time | State
| Info
|
+---------+----------------+-----------+----------------+---------+------+------
----------------+---------------------------------------------------------------
---------------------------------------+
| 1795675 | anpoe_diw| localhost | anpoe_diw| Query | 20 | Locke
d | SELECT COUNT(*) FROM poems WHERE diwan_id=440 AND active='1'
|
| 1795676 | anpoe_diw| localhost | anpoe_diw| Query | 63 | Copyi
ng to tmp table | SELECT u.*, m.properties, COUNT(p.id) AS n_poems FROM users AS
u LEFT JOIN media AS m ON (u.id=m.use |
| 1795868 | anpoe_diw| localhost | anpoe_diw| Query | 20 | Locke
d | SELECT COUNT(*) FROM poems WHERE diwan_id=397 AND active='1'
|
| 1796024 | anpoe_diw| localhost | anpoe_diw| Query | 19 | Locke
d | SELECT COUNT(*) FROM poems WHERE diwan_id=397 AND active='1'
|
| 1796030 | anpoe_diw| localhost | anpoe_diw| Query | 10 | Locke
فضلا حل مشكلة قاعده البيانات
ارجو من لديه خبره بحل المشكله ان يوافينا بها