ISSUE SUMMARY:
The servers overloads becouse of a large amount of request from users ips
This is the message from my hosting provider:
Your website, or a feature of your website, has caused an overload on the web server it resides on. To stop degradation of server performance, we have temporarily suspended cmgarmisch.com, but you still have FTP access to work on scripts or files that may be causing this issue. Your consumption of CPU resources are listed below:

2016-02-23 300.32
2016-02-22 301.94
2016-02-21 13.32
2016-02-20 51.28
2016-02-19 325.66
2016-02-18 254.00
2016-02-17 284.00
2016-02-16 352.67

Scripts that possibly perform a server overload:

/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/index.php (30524) cpu_min: 293.93, ram: 1137171.99 MB, disk_read: 19.51 MB, disk_write: 0.29 MB.


STEPS TO REPLICATE:
1
2
3
4
5
RESULT
EXPECTED RESULT
BROWSER

Hi Andre,

You are using old Jomsocial version, which actually some of query havent be improved yet, I suggest you upgrade to the latest version first.

I also need the detail page which make your server overload.

thank you

Hi Dimas, I will update to the last version we have 4.1.3

That is what my hosting reported, the main issue is in the index.php page:
Scripts that possibly perform a server overload:

/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/index.php (30524) cpu_min: 293.93, ram: 1137171.99 MB, disk_read: 19.51 MB, disk_write: 0.29 MB.
.

/usr/bin/perl | N/A (7) cpu_min: 0.20, ram: 89.26 MB, disk_read: 0.37 MB, disk_write: 0.24 MB.
/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/modules/mod_guru_courses/createthumbs.php (35) cpu_min: 0.12, ram: 560.78 MB, disk_read: 0.29 MB, disk_write: 0.0 MB.

/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/administrator/index.php (3) cpu_min: 0.02, ram: 104.05 MB, disk_read: 1.47 MB, disk_write: 0.0 MB.

/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/plugins/community/gurucoursesteach/gurucoursesteach/createthumbs.php (2) cpu_min: 0.00, ram: 32.04 MB, disk_read: 0.1 MB, disk_write: 0.0 MB.

/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/plugins/community/gurucoursestake/gurucoursestake/createthumbs.php (4) cpu_min: 0.00, ram: 64.07 MB, disk_read: 0.1 MB, disk_write: 0.0 MB.

/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/plugins/community/gurumycertificates/gurumycertificates/createthumbs.php (2) cpu_min: 0.00, ram: 32.04 MB, disk_read: 0.04 MB, disk_write: 0.0 MB.
/bin/bash | N/A (6) cpu_min: 0.00, ram: 6.46 MB, disk_read: 0.74 MB, disk_write: 1.29 MB.

HI Andre,

I will report his to Guru developer, this issue caused by guru plugin for jomsocial actually.

thank you

Hi,

I updated TimThumb script for images with latest version, please let me know if this is not ok.

Hi,

I installed ProFiles extension for these changes, but now I can't uninstall, on Extensions - Manage page I received a Joomla database error.

Hi Alin, I see the error, and I see it too when I go to Plugins,
Something happens when you installed the script, do you need access to phpmyadmin to check the database?
What do you need to uninstall?
Error
Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM x3wat_extensions WHERE state=0 AND a.id != 991 Unknown column 'a.id' in 'where clause' SQL=SELECT *,2*protected+(1-protected)*enabled as status FROM x3wat_extensions WHERE state=0 AND a.id != 991 Unknown column 'a.id' in 'where clause' SQL=SELECT COUNT(*) FROM x3wat_extensions WHERE state=0 AND a.id != 991

Please update your post and add FTP and phpmyadmin in the secure form there.
Thank you.

Hello,please see attached file
thank you



André

Hello, yesterday the site causes overload again, I recomend you to help me with this problem because the next time the site will be suspendedn
thank you

Hi Andre,
I changed that file with is latest release so maybe the file is no more the cause.
Can you please ask hosting to give you again a log with high overload sources? maybe is related with traffic or something else, because from what you said is not happen every time.
Also, the memory_limit 64M is a bit low, maybe you can increase it at least to 256M, this will help a lot.

Please advise.
Regards,
Alin

Hello, the Ips causing the overload are always the same, users of the companys website, there are no more than 30-50 users in the same day so and dont thing such a number is the cause.

Scripts that possibly perform a server overload:

/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/index.php (27253) cpu_min: 267.78, ram: 989063.14 MB, disk_read: 17.68 MB, disk_write: 2.37 MB.
/
/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/administrator/index.php (92) cpu_min: 0.77, ram: 2883.47 MB, disk_read: 10.19 MB, disk_write: 0.02 MB.
/usr/bin/perl | N/A (8) cpu_min: 0.25, ram: 91.96 MB, disk_read: 3.18 MB, disk_write: 0.29 MB.
/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/modules/mod_guru_courses/createthumbs.php (47) cpu_min: 0.15, ram: 762.05 MB, disk_read: 0.33 MB, disk_write: 0.34 MB.

/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/cfg.php (1) cpu_min: 0.00, ram: 15.26 MB, disk_read: 0.02 MB, disk_write: 0.0 MB.
/hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/plugins/community/gurucoursestake/gurucoursestake/createthumbs.php (2) cpu_min: 0.00, ram: 31.76 MB, disk_read: 0.09 MB, disk_write: 0.0 MB.
/bin/bash | N/A (6) cpu_min: 0.00, ram: 6.44 MB, disk_read: 1.05 MB, disk_write: 1.03 MB.
/bin/cat | N/A (2) cpu_min: 0.00, ram: 1.12 MB, disk_read: 1.36 MB, disk_write: 0.0 MB.

I have increased memory to 256 in php.ini file I hope this will help.

Did you check the database?, because I still get some database errors in Plugin and Global configuration in the joomla admin panel, please help me to fix this.

Hello Alin, did you read my last update?

Hi Andre,
I tried to log in to ixwebhosting.com account but doesn't work, please check them again and send me by email to This email address is being protected from spambots. You need JavaScript enabled to view it., please do not post them in thread.

Then, when I read again the overload scripts, look at the home one:
hsphere/shared/php53/bin/php-cgi | bbbm606/cmgarmisch.com/index.php (27253) cpu_min: 267.78, ram: 989063.14 MB, disk_read: 17.68 MB, disk_write: 2.37 MB.
this is quite big RAM consumption, what you have published in Home?

Please advise,
Alin