mahdy_sharifi

Well-Known Member
Feb 26, 2012
214
1
68
cPanel Access Level
Root Administrator
Hi :

How Can optimize Slow query ? for example we have any slow query on our server but how can optimize it ?

Code:
# Query_time: 10.734189  Lock_time: 0.000084 Rows_sent: 1  Rows_examined: 656958
SET timestamp=1385379910;
SELECT COUNT(c.c_id) AS confirmed, (SELECT COUNT(p.post_id) FROM nuke_bb3posts AS p WHERE (p.post_id = '5462281' AND p.poster_id = '1')) AS allowconfirm FROM nuke_bb3c
onfirms AS c WHERE (c.post_id = '5462281' AND c.confirmer_id = '1');
Thank You
 

MikeDVB

Well-Known Member
PartnerNOC
Jun 4, 2008
218
3
68
Indiana, USA
cPanel isn't generating the queries - cPanel is just a control panel.

For example - if you were to uninstall the script - you will see no more slow queries from it even though cPanel is still installed and working.

In short - contact the script developer responsible for crafting the query and not the control panel that runs on the server.

Hopefully this makes sense for you.