Page 1 of 2
SQL High CPU usage error
Posted: Wed May 17, 2023 8:03 am
by radhavallabh
Hi;
I just started with a new domain and phoenix 1.0.8.20.
I just hit analyze button on my database... and The host suspended account says high CPU usage for my database due to process threads and unoptimized database.
I am not able to figure out the issue with it.
Can the Pro's please help me understand what shall be wrong with the database?
I am really stuck and unable to understand what may be causing the issue??
Please can you help me fix the issue.
Thank you in advance;
Warm Regds./
radhavallabh
Re: SQL High CPU usage error
Posted: Wed May 17, 2023 9:22 am
by burt
Ask your host what SQL is causing issues. If they do not know, or cannot answer...change host.
Re: SQL High CPU usage error
Posted: Wed May 17, 2023 9:37 am
by radhavallabh
burt wrote: ↑Wed May 17, 2023 9:22 am
Ask your host what SQL is causing issues. If they do not know, or cannot answer...change host.
I just received a log file from them, Have PM you the same dear..
Please can you check for me. If you think there is no issue I shall step forward in changing them...
Thank you in advance;
Very Warm Regds.,
radhavallabh
Re: SQL High CPU usage error
Posted: Wed May 17, 2023 10:52 am
by burt
radhavallabh wrote: ↑Wed May 17, 2023 9:37 am
I just received a log file from them, Have PM you the same dear..
Please can you check for me.
You need someone who is a host to look at this.
It's not something I can help with.
Ask your own host, they know their systems.
Re: SQL High CPU usage error
Posted: Wed May 17, 2023 11:03 am
by radhavallabh
burt wrote: ↑Wed May 17, 2023 10:52 am
radhavallabh wrote: ↑Wed May 17, 2023 9:37 am
I just received a log file from them, Have PM you the same dear..
Please can you check for me.
You need someone who is a host to look at this.
It's not something I can help with.
Ask your own host, they know their systems.
The sql log file of database i had PM dear... host will not help me with issues in that just say that too many processes connections caused high CPU load, hence i asked here that what is the problem as per the sql logs....
Re: SQL High CPU usage error
Posted: Wed May 17, 2023 9:48 pm
by ecartz
You can PM me the logs if you want.
However, I suspect that the upshot is going to be to switch to a different host, as Burt already suggested. It sounds to me like they're basically saying, "Your site seems busy--we don't do that here, that's how we stay so cheap." Unless it's one of the certified hosts, there's not much we can do to influence them.
Re: SQL High CPU usage error
Posted: Thu May 18, 2023 7:53 am
by radhavallabh
ecartz wrote: ↑Wed May 17, 2023 9:48 pm
You can PM me the logs if you want.
However, I suspect that the upshot is going to be to switch to a different host, as Burt already suggested. It sounds to me like they're basically saying, "Your site seems busy--we don't do that here, that's how we stay so cheap." Unless it's one of the certified hosts, there's not much we can do to influence them.
I just sent you PM dear... I shall surely also review the certified hosts and try to change to their server if possible....
Shall await your valuable help and reply dear;
Thank you in advance;
Regds./
radhavallabh
Re: SQL High CPU usage error
Posted: Thu May 18, 2023 4:46 pm
by 14Steve14
I had something similar with one of my hosts a few years ago, and they told me exactly what was causing the problem. They even gave me advice on how to cure it. I cant remember what we did though, so I cant be much more help. I had to create a support ticket, they looked further into the cause and rectified the problem. I did change hosts though as I couldn't have them shut everything off again.
Good luck and I hope you get it sorted. Nothing worse than a host that blames everyone else for a problem and wont give help.
Re: SQL High CPU usage error
Posted: Fri May 19, 2023 4:52 am
by radhavallabh
14Steve14 wrote: ↑Thu May 18, 2023 4:46 pm
I had something similar with one of my hosts a few years ago, and they told me exactly what was causing the problem. They even gave me advice on how to cure it. I cant remember what we did though, so I cant be much more help. I had to create a support ticket, they looked further into the cause and rectified the problem. I did change hosts though as I couldn't have them shut everything off again.
Good luck and I hope you get it sorted. Nothing worse than a host that blames everyone else for a problem and wont give help.
Still trying to sort it as they are really of no help in rectifying the issue, apart from the logs they gave.
Awaiting dear ecartz reply, so I can move forward in right direction of a fix if possible...
Hoping for the best;
Now will really be seeking a new host for sure, once am done with this.....
Regds./
radhavallabh
Re: SQL High CPU usage error
Posted: Fri May 19, 2023 5:31 am
by radhavallabh
ecartz wrote: ↑Wed May 17, 2023 9:48 pm
You can PM me the logs if you want.
However, I suspect that the upshot is going to be to switch to a different host, as Burt already suggested. It sounds to me like they're basically saying, "Your site seems busy--we don't do that here, that's how we stay so cheap." Unless it's one of the certified hosts, there's not much we can do to influence them.
Hi dear;
It seems the PM did not go through yesterday.. I checked my sent items and it was not there.
Have resent the log file. Please check..
Sorry for any inconvenience;
Thank you in advance;
Warm Regds./
radhavallabh