Locked out of site!

I’ve been locked out of my site https://athomewithrebecka.com. Error Forbidden 403. Hostgator says I need optimization or dedicated server. I need access to my admin panel so I can optimize my site. Issue, my site was hosted with HostGator then moved to Wildwestdomains. I have no way to access anything! The person that moved my site hosting is no longer in business and unable to supply records of my account. I need my site backup to transfer to another provider.

The script “/home/athomewi/public_html/” was found to be consuming an inordinate amount of mysql connections, to the point of degrading overall system performance. While we do limit each account to no more than 25% of a system’s resources in our terms of service, we do not actively disable accounts until they greatly exceed that number, which is what happened in this case.

Resolving this situation may be as simple as modifying the code to to use mysql_connect instead of mysql_pconnect, closing connections sooner, adding additional indexes to your database, optimizing the queries used, or something equally easy. If not, it may simply be a matter of moving this database to dedicated services, as it may have outgrown a shared environment.

If you believe you have a solution to this overuse, we are happy to discuss the situation with you and possibly reinstate the database on the server. Otherwise, we will be happy to assist you with the upgrade process if a dedicated server is the most appropriate solution. Thank you, and we look forward to hearing from you shortly.

~
Excessive MySQL activity is caused by (a) a long-running process that locks a table, causing other queries to back up, (b) a query that is not optimized ][example: select all from … and involving a large or complex query], (c) huge table copies/maintenance during peak hours.

NOTE:, the following are just possible fixes or suggestions, and are not endorsed or supported by HostGator. They are included in the hope that they may apply to your situation, and/or help you reduce the amount of resources your SQL queries consume. As always, it’s best to backup any data before making any changes or adjustments.

First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table..

Additionally, adding indexes to your table(s) may improve performance. If you’re not sure what you’re doing, it’s best not to modify any table; caution is recommended. There are various articles (https://www.developer.com/print.php/3667831). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.

If you reply back to this with your IP address (https://www.hostgator.com/ip.shtml) we will be more than happy to go ahead enable HTTP access for you, so that you can safely work on the script without it causing further issues. Please let us know how you would like to proceed.

Hostgator ticket info. *************************** 17. row ***************************
USER: athomewi_wrdp1
DB: athomewi_wrdp1
STATE:
TIME: 14
COMMAND: Sleep
INFO: NULL

Open connections:

Recent Site Requests:
199.16.156.124 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
199.59.148.210 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
23.22.233.83 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
24.101.155.131 athomewithrebecka.com /oven-roasted-buttercup-squash/
24.101.155.131 athomewithrebecka.com /oven-roasted-buttercup-squash/
37.59.16.157 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
37.59.16.157 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
50.18.133.178 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
54.246.135.228 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
67.215.230.19 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
72.14.179.62 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
81.17.28.185 athomewithrebecka.com /wp-login.php?registration=disabled
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
98.137.207.107 athomewithrebecka.com /handcrafted-coffee-creamers-dairy-gluten-free-or-the-whole
(8:19:25am)Kasie M.:The site is using too much cpu for a shared server.
(8:19:42am)Rebecka:How do we fix this?
(8:20:01am)Kasie M.:NOTE:, the following are just possible fixes or suggestions, and are not endorsed or supported by HostGator. They are included in the hope that they may apply to your situation, and/or help you reduce the amount of resources your SQL queries consume. As always, it’s best to backup any data before making any changes or adjustments.

First and foremost, you may need to optimize your tables. The frequency depends on the size and usage of the database, but most databases would benefit from doing something like this on a yearly basis: a) Enter your phpMyAdmin/MySQL control panel. Click on the database (not the table, the database name), and on the right hand column your tables should be listed. Scroll down till you see the .Check all. link. Click on that link, make sure all database tables are checked and then from the drop-down next to it, and carefully select .Optimize table..

Additionally, adding indexes to your table(s) may improve performance. If you’re not sure what you’re doing, it’s best not to modify any table; caution is recommended. There are various articles (https://www.developer.com/print.php/3667831). It may be best to Google for something like [Your Software Name] MySQL indexes for suggestions.