hi all
i all
I face big problem with my host server doing to mysql database
I have script and my host server message me that my database excute allot of queries and take along time to excute it and returnto repeat it self and doing to this they stop my site.and this thier report
±--------±---------------±----------±---------------±--------±-----±-----
----------------±--------------------------------------------------------------
---------------------------------------+
| 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
how can I solve this since the person who create the script not avialable now
please help me