Hi
It seems that your application is generating a large number of slow MySql queries running for excessive amount of time and utilize a large amount of CPU and RAM. You can find example queries detected by the time we open this case below:
# User@Host: amw_dolp991[amw_dolp991] @ localhost [] Id: 648868
# Query_time: 2.643397 Lock_time: 0.457616 Rows_sent: 0 Rows_examined: 0
use amw_dolp991;
SET timestamp=1488287110;
SELECT * FROM `RayMp3Files` WHERE `Status`='pending' ORDER BY `ID` LIMIT 2;
--
# User@Host: amw_tiny364[amw_tiny364] @ localhost [] Id: 753059
# Query_time: 2.177593 Lock_time: 0.000436 Rows_sent: 60 Rows_examined: 256
use amw_tiny364;
SET timestamp=1488297618;
SELECT DISTINCT
--
# User@Host: amw_tiny364[amw_tiny364] @ localhost [] Id: 753059
# Query_time: 2.299358 Lock_time: 0.012536 Rows_sent: 1 Rows_examined: 1
use amw_tiny364;
SET timestamp=1488297621;
SELECT tag_cache FROM ttrss_user_entries
This is why, unfortunately we were forced to temporary block the access to this site. In order to reactivate the site we will need you to address the issue above and optimize the site and database performance with an assistance of a certified web developer.
This is the mail what i have got from my Hoster.
What can i do?
