67.2xx.xx.96 VPS - High CPU usage
We regret that it has become necessary to issue this Policy Enforcement Notice for violation of our AUP or TOS available at
http://knownhost.com/company/aup.html and
http://knownhost.com/company/tos.html based on complaints and/or logs of abuse attached or included below. We will review the complaints and/or logs again if you believe this is an error. However, it is your responsibility to investigate your account and reply promptly to avoid disconnection. You are required to suspend or remove all domains, sites, users, and/or exploits causing this issue.
Pending your reply with your comments, questions, or actions to resolve this issue, the account is:
[ ] Monitored for Additional Violations
[x] Accessed for Investigation, Cleaning, Hardening, or Securing
[ ] Traffic filter applied
... [ ] Outgoing traffic: none
... [ ] Incoming traffic: none
[x] Suspended in:
... [ ] 48-Hours
... [ ] 24-Hours
... [x] 12-Hours
... [ ] 6-Hours
... [ ] 1-Hour
... [ ] 0-Hours
- CPU usage history for last 4 day period is attached. CPU usage must not exceed 25% of CPU time within any 90 second period.
- This high usage appears to be related to the MySQL database queries like the following examples:
| 224 | xxxx_xxxxxx | localhost | megusta_like | Query | 1 | Sorting result | SELECT c.* FROM clubs AS c
WHERE c.idioma='es'
ORDER BY RAND() DESC
|
| 228 | xxxx_xxxxxx | localhost | halfmusi_likesql | Query | 1 | Copying to tmp table | SELECT c.* FROM clubs AS c
WHERE c.idioma='es'
ORDER BY RAND() DESC
|
| 232 | xxxx_xxxxxx | localhost | halfmusi_likesql | Query | 1 | Locked | SELECT c.* FROM clubs AS c
WHERE c.idioma='es'
ORDER BY c.id DESC
|
| 234 | xxxx_xxxxxx | localhost | halfmusi_likesql | Query | 1 | Locked | SELECT c.* FROM clubs AS c
WHERE c.idioma='es'
ORDER BY RAND() DESC
|
| 235 | xxxx_xxxxxx | localhost | halfmusi_likesql | Query | 2 | Copying to tmp table | SELECT c.* FROM clubs AS c
WHERE c.idioma='es'
ORDER BY RAND() DESC
|
Regards,
Paul
KnownHost abuse