Another server overload

[drownedgod]

I am using IXWebhosting and they contacted me again that the website is causing a server overload. I searched for threads like this but I didn't find what I need to do. Here's what they said.

       We are notifying you that your account, or a portion or feature of your account has caused an overload on one of our servers. We have a shared hosting environment that we must maintain at a certain level of performance. This performance is monitored and balanced by us, however there are times when accounts can cause the server’s load to increase degrading the performance for all other customers on this server.

       To protect your account from further action you must agree to our request for compliance. Please respond to this message stating your intent to do so. You may either log into your control panel with us, and access this ticket via the 24/7 help desk, or provide this ticket number to our Live Chat or phone representatives.

       Please contact us to resolve this matter.

Most common query [db***user]:

Time: 99% (5638 sec)
Amount: 99% (580 queries)
Rows Examined/Sent: 189529964 / 11253
Avg. Query Exec/Lock Time: 9 / 0 sec.
Used databases: [db***name]
Query example: use db***name; SELECT * FROM cpg14x_pictures WHERE approved = 'YES' AND aid IN (5,6,7,8,9,10,11,12,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,54,55,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,134,135,136,137,138,139,140,141,142,143,144,145,146,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172 ... [too long]

db***name db chmoded to 0

Please note that this is the second time this problem occurred. Unfortunately, I have to bring to your attention that as per our terms of service a third instance will result in immediate account termination without notice. No backups will be provided. If you have any questions about how to avoid this from happening again our support team will be glad to advise.

HELP! I don't know what to do!

[Fabricio Ferrero]

A link to your gallery please.

[drownedgod]

http://www.tvscreencaps.com

[drownedgod]

They disabled the database that's why we are getting the error. I am asking them to re enable the database as of the moment. I don't know how long it will take them to take action on that.

[Fabricio Ferrero]

Yes, I can't see anything.

[Nibbler]

The random files block should not be used on large galleries. To advise more I need to see the  complete query they posted.

[drownedgod]

Thanks. I will remove the random photos block once the site is back. I will also let you know when the site is up so you guys can take a look.

thanks in advance

[Phill Luckhurst]

Threatening to terminate you without notice and without backups is a bit of a worry. If possible and just in case you should make a backup of your entire site and database asap.

I don't like this attitude. Rather than acting like that a little help might be better or even limiting your resources to take the load off others on your shared hosting.

[Joachim Müller]

Seems to me like you have set up very complicated permissions settings. Once your site is back up, disable the random thumbs as suggested and then post here.

http://tvscreencaps.com/sql/update.sql shows that you're running an outdated version, so you should update immediately. Additionally, turn indexing off - it's not a bright idea that visitors are capable to browse the content of folders.

[drownedgod]

hey guys,

thanks for all the suggestions. the site is up again. i removed the random thumbs.

however, i think i got hacked. look http://tvscreencaps.com/albums/

how do i fix this?

[Joachim Müller]

That's possible, as you are running an outdated version that contains known security flaws. Read the thread that people always get refered to when they ask about having been hacked. Search the board first before asking and respect the "one issue per thread" policy in the future.
Actual link is http://tvscreencaps.com/