I have been using Vb5 for over a year now. For the first year up until my last upgrade to 5.2.3 I got away with 2 CPUs 3.0ghz and 2 Gigs of Ram. I noticed that the evening I installed Vb 5.2.3 that the site would return a 503 error (server unreachable) because it reached its overhead max. I gave it 1 more gig of ram, the problem persisted, and now I'm at a total of 5 gigs of ram on a scalable server. Mind you, my traffic hasn't gone up.
I contacted the host and they did some research and said that my site is using a massive amount of queries on page load 200+. I don't know anything about that. My question is how do I minimize queries and make the site run more efficiently? Is this a normal amount of queries? Here's what my host had to say in our last correspondence:
I contacted the host and they did some research and said that my site is using a massive amount of queries on page load 200+. I don't know anything about that. My question is how do I minimize queries and make the site run more efficiently? Is this a normal amount of queries? Here's what my host had to say in our last correspondence:
I have analyzed your account and found the following problems:
1. It appears that there are too many executions which are eating up too much of the server resources. Below you can see which of your Scripts are causing that issue to happen and the nuber of the executions each of those scripts have:
Code:
/home/religio9/public_html/index.php 12653
What I would recommend you to do is reducing the number of the executions of your site. Here is how you can see how you can do that easily:
https://www.siteground.com/tutorials...executions.htm
2. The second thing I notices, and most probably the reason for the issue, was that there is a lot of bandwidth generated by:
Code:
Other logins (and/or anonymous users)
You can check that from your AwStats tool in your cPanel account.
In most cases the issue is caused by malware and for this reason I have made a thorough scan of your account. You can see the output below:
Code:
Scanning [/home] ...se wait...
[GEN]eval_base64decode [01/03/13] /home/xxx/tmp/awstats/awstats022013.religiousverse.com.txt
[HEX]eval_base64_mixed [02/08/16] /home/xxx/public_html/core/includes/adminfunctions_template.php
[STR]google_referer [03/08/16] /home/xxx/public_html/.htaccess
-----------------------------------------
Scanned Files: 52463
Scanner Hits: 3
Time Taken: 62 (sec)
Scan Report: report-040816-024140
As you can see there are 3 files marked as infected. They look like false positive, but just in case I would recommend to review and if possible delete them. Be careful with the .htaccess file as deleting may cause problems with the internal links of your site. Would recommend to ask your developer to review it.
Also I please review the links below which can give more details about such other logins and hints on how you can solve the problem:
https://forums.cpanel.net/threads/aw...d-users.25934/
https://forums.totalchoicehosting.co...howtopic=33739
https://sourceforge.net/p/awstats/di...read/acf12ba2/
Additionally I have gone through the guardian server logs and it seems that there are some reports related to the IDLE email processes:
Code:
Aug 04 00:44:33 Killed long proc(21662) owner(dovenull) :: dovecot/imap-login
Aug 04 00:44:33 Killed long proc(21656) owner(dovenull) :: dovecot/imap-login
What you could do is disable those from your email clients as it seems they contribute to the issue in question:
https://www.siteground.com/kb/disabl...-mail-clients/
Something else that you could optimize is your databases as there are slow database queries reported:
Code:
=== TOP 10 of 154 (total) Slow Queries for the past 24 hours ==========
1. Executed 11h 49m 45s ago for 145.200913 sec on Database --> xxx
Date: 2016-08-03 14:51:10 Query_time: 145.200913 Rows_examined: 1: Rows_sent 1 Lock_time: 5.599920
SELECT * FROM session WHERE `userid` = 0 AND `host` = '37.60.239.48' AND `idhash` = 'xxx' LIMIT 1;
--------------------------------------------------------------------------------------------------
2. Executed 22h 27m 56s ago for 139.601014 sec on Database --> xxx
Date: 2016-08-03 04:12:59 Query_time: 139.601014 Rows_examined: 1: Rows_sent 1 Lock_time: 132.401278
SELECT * FROM cache WHERE `cacheid` IN ('vB_UserPerms0');
----------------------------------------------------------------------------------------------------
3. Executed 22h 27m 56s ago for 139.600965 sec on Database --> xxx
Date: 2016-08-03 04:12:59 Query_time: 139.600965 Rows_examined: 1: Rows_sent 1 Lock_time: 116.499943
SELECT * FROM cache WHERE `cacheid` IN ('vB_UserPerms0');
----------------------------------------------------------------------------------------------------....
There can be many reasons for slow database queries, but the following 3 are the most common ones:
1. Large database
2. Not well written scripts
3. Large number of internal links that query the database directly.
What you should do is optimising it. Here are some hints which you can use to do that:
https://www.siteground.com/kb/how_to...ysql_database/
https://www.siteground.com/kb/how_to...ng_phpmyadmin/
Please be informed that the website/database optimization is a complex on-going activity which is best when performed by a professional developer.
Please do check it from your end and do let us know if you have any further comments or require any further assistance.
We are always here to help you.
Best Regards,
Tech Support
1. It appears that there are too many executions which are eating up too much of the server resources. Below you can see which of your Scripts are causing that issue to happen and the nuber of the executions each of those scripts have:
Code:
/home/religio9/public_html/index.php 12653
What I would recommend you to do is reducing the number of the executions of your site. Here is how you can see how you can do that easily:
https://www.siteground.com/tutorials...executions.htm
2. The second thing I notices, and most probably the reason for the issue, was that there is a lot of bandwidth generated by:
Code:
Other logins (and/or anonymous users)
You can check that from your AwStats tool in your cPanel account.
In most cases the issue is caused by malware and for this reason I have made a thorough scan of your account. You can see the output below:
Code:
Scanning [/home] ...se wait...
[GEN]eval_base64decode [01/03/13] /home/xxx/tmp/awstats/awstats022013.religiousverse.com.txt
[HEX]eval_base64_mixed [02/08/16] /home/xxx/public_html/core/includes/adminfunctions_template.php
[STR]google_referer [03/08/16] /home/xxx/public_html/.htaccess
-----------------------------------------
Scanned Files: 52463
Scanner Hits: 3
Time Taken: 62 (sec)
Scan Report: report-040816-024140
As you can see there are 3 files marked as infected. They look like false positive, but just in case I would recommend to review and if possible delete them. Be careful with the .htaccess file as deleting may cause problems with the internal links of your site. Would recommend to ask your developer to review it.
Also I please review the links below which can give more details about such other logins and hints on how you can solve the problem:
https://forums.cpanel.net/threads/aw...d-users.25934/
https://forums.totalchoicehosting.co...howtopic=33739
https://sourceforge.net/p/awstats/di...read/acf12ba2/
Additionally I have gone through the guardian server logs and it seems that there are some reports related to the IDLE email processes:
Code:
Aug 04 00:44:33 Killed long proc(21662) owner(dovenull) :: dovecot/imap-login
Aug 04 00:44:33 Killed long proc(21656) owner(dovenull) :: dovecot/imap-login
What you could do is disable those from your email clients as it seems they contribute to the issue in question:
https://www.siteground.com/kb/disabl...-mail-clients/
Something else that you could optimize is your databases as there are slow database queries reported:
Code:
=== TOP 10 of 154 (total) Slow Queries for the past 24 hours ==========
1. Executed 11h 49m 45s ago for 145.200913 sec on Database --> xxx
Date: 2016-08-03 14:51:10 Query_time: 145.200913 Rows_examined: 1: Rows_sent 1 Lock_time: 5.599920
SELECT * FROM session WHERE `userid` = 0 AND `host` = '37.60.239.48' AND `idhash` = 'xxx' LIMIT 1;
--------------------------------------------------------------------------------------------------
2. Executed 22h 27m 56s ago for 139.601014 sec on Database --> xxx
Date: 2016-08-03 04:12:59 Query_time: 139.601014 Rows_examined: 1: Rows_sent 1 Lock_time: 132.401278
SELECT * FROM cache WHERE `cacheid` IN ('vB_UserPerms0');
----------------------------------------------------------------------------------------------------
3. Executed 22h 27m 56s ago for 139.600965 sec on Database --> xxx
Date: 2016-08-03 04:12:59 Query_time: 139.600965 Rows_examined: 1: Rows_sent 1 Lock_time: 116.499943
SELECT * FROM cache WHERE `cacheid` IN ('vB_UserPerms0');
----------------------------------------------------------------------------------------------------....
There can be many reasons for slow database queries, but the following 3 are the most common ones:
1. Large database
2. Not well written scripts
3. Large number of internal links that query the database directly.
What you should do is optimising it. Here are some hints which you can use to do that:
https://www.siteground.com/kb/how_to...ysql_database/
https://www.siteground.com/kb/how_to...ng_phpmyadmin/
Please be informed that the website/database optimization is a complex on-going activity which is best when performed by a professional developer.
Please do check it from your end and do let us know if you have any further comments or require any further assistance.
We are always here to help you.
Best Regards,
Tech Support
Comment