All of sudden for the past three weeks, our site that has the photopost installation has been experiencing CPU Maxed Out every day. And it is progressing worse and worse, to a point that a server reboot is needed for the past week every couple of days.
We tried to identify the cause with our server admin, and the only thing we can narrow it down is this photopost gallery application. The admin said something about the script does not close the mysql connection properly and caused the build up. I have posted something below hoping support team can give me some pointer on how to best solve this. I am considering upgrading the script. Current version is 6.23. Will upgrade solve the issue? Thank you!
Quote:
Please read the lines below. There are 2-3 DBs of "photozo" user in which you can see under "time" that from how much time the connection is idle & it is just wastage of memory & CPU of the server. The same value are mentioned in those links which were provided earlier.
This is the thing we would like you to notice & get in touch with the developer of this website to optimize the DBs.
If still the things are not clear then please let me know.
--------------------------------------------------
| Id | User | Host | db | Command | Time | State | |
+-------+--------------+-----------+--------------+----------------+-------+--------------------+------------------------------------------------------------------------------------------------------+
| 30800 | photozo_com2 | localhost | photozo_com2 | Sleep | 27495 | | |
| 30801 | photozo_peng | localhost | photozo_pp | Sleep | 27495 | | |
| 31317 | photozo_com2 | localhost | photozo_com2 | Sleep | 27083 | | |
| 31318 | photozo_peng | localhost | photozo_pp | Sleep | 27083 |
IMPORTANT: Do not ignore this email.
This is cPanel stats runner on host.photozo.com!
While processing the log files for user photozo, the cpu has been
maxed out for more than a 6 hour period. The current load/uptime line on the server at the time of
this email is
11:15:03 up 6 days, 1:47, 0 users, load average: 31.79, 32.69, 32.71
You should check the server to see why the load is so high and take
steps to lower the load. If you want stats to continue to run even with a high load; Edit
/var/cpanel/cpanel.config and change extracpus to a number larger then 0 (run
/usr/local/cpanel/startup afterwards to pickup the changes). -----------------------------------------
|
Linear Mode
