My databases were causing excessive load on the server

bhatti22

New member
Joined
May 23, 2016
Messages
4
Points
0
I have some issues in my databases were causing excessive load on the server.. so how i can solve then? i already know the placing but i am not familiar with it..Is there any one who can guide me step by step?
 

Harry P

New member
Joined
Feb 3, 2015
Messages
331
Points
0
I have some issues in my databases were causing excessive load on the server.. so how i can solve then? i already know the placing but i am not familiar with it..Is there any one who can guide me step by step?
Obviously you are having the problem with your hosting, not really on your website, when traffic of your site increased suddenly then your mysql server or your hosting (RAM) could not handle them.

Just curious what type of your hosting are you using? a shared or a VPS? if it was a VPS, how much RAM do you have?

we need to know more information so can help you know what the exact problem you are facing.
 

bhatti22

New member
Joined
May 23, 2016
Messages
4
Points
0
its shared hosting... and i said to my hosting company..they said to me " It appears to me that one of his application/module/plugin might have been compromised. Mysql Table Statistics:"

Also they said to me when you will upgrade from shared hosting to VPS so this issue will be solved? i don't know this issue that why this is?
 

Harry P

New member
Joined
Feb 3, 2015
Messages
331
Points
0
its shared hosting... and i said to my hosting company..they said to me " It appears to me that one of his application/module/plugin might have been compromised. Mysql Table Statistics:"
Also they said to me when you will upgrade from shared hosting to VPS so this issue will be solved? i don't know this issue that why this is?
Seem your traffic is increasing and its requiring more web hosting resource than usual. I would suggest you find in your log files to see what is happening to your sites.

Also you can put some questions with detailed info to ask hosting experts on this forum https://www.webmastersun.com/forums/95-Web-Hosting

They can help you find out the problems.
 

Developer

Active member
Joined
Dec 21, 2015
Messages
412
Points
43
To get a better idea, please tell us the following:

1. Who are you hosting with?
2. What are the server specs?
3. Is this site a blog? cms? basic html?

Also, do you have access to your log files? Most hosting
accounts do give you access to the log files and these
are extremely important to find the direct culprit(s). You
may not NEED a VPS, you could just need some tweaking
of some code somewhere.

Before switching to a VPS (which is possibly just want your
host wants you to do, not necessarily what you NEED to do),
please answer the questions above and we'd be more than
happy to try to help you out as much as we can.
 

bhatti22

New member
Joined
May 23, 2016
Messages
4
Points
0
I am using Bluehost shared hosting account.
it is wordpress website which provides online services.
what do you mean about log files... i have access of cpanel and then can access the mysql database but i don't know how to change the database file and when i talked with the hosting company they said to me that " Either you need to edit the changes in your database by referring the above details or you can upgrade the hosting" They also told me some places where i need to change but which kind of things i need to change i don't know. basically i am not familiar with mysql database that's why trying to solve this issue by putting my questions here in this form.
 

Ron Killian

New member
Joined
Dec 3, 2015
Messages
804
Points
0
Well, sorry to say, Bluehost is part of the EIG group. A huge company that has been buying up hosting companies. Sadly after they take over, hosting services and support severely degrade.

I'd find a new host all together, a good VPS host.
 

Developer

Active member
Joined
Dec 21, 2015
Messages
412
Points
43
Your link (above) leads to a suspended page. Did this JUST happen or what?
 

ElixantTechnology

New member
Joined
Nov 26, 2014
Messages
622
Points
0
BlueHost offers very minimal resources with their shared hosting accounts, for example 256MB of memory is the standard throughout EIG brands. This allows them means for quick upselling of their services, which is a valid tactic however can be quite a pain if you ask me. I recommend switching hosting companies as soon as possible, to one of the not so large companies that is capable of running malware scans on hosting accounts without worrying about the servers going offline ;)

With one of the smaller hosting companies your are typically granted more access to resources and the capability of handling more traffic driven to your website.
 

laceibanet

New member
Joined
Feb 23, 2016
Messages
43
Points
0
Sometimes an unoptimized database can cause some issues. And it is known that a theme or plugin that isn't updated to the latest version can be compromised so what they suggest isn't entirely outside the box. But just checking on your account and keeping everything updated and maybe hire a designer to just check the database to see if there are any changes you can make to make your site run better. Moving to a vps isn't really a great solution as you might still run into the same issue there, just a bit more room to grow.
A host usually says that to not solve the problem but only not have it affect others on the same shared server.
 
Newer threads
Replies
4
Views
5,297
Replies
3
Views
7,121
Replies
5
Views
7,504
Replies
5
Views
5,209
Recommended threads
Replies
12
Views
9,144
Replies
2
Views
3,140
Replies
20
Views
8,500
Replies
3
Views
5,664

Referral contests

Referral link for :

Sponsors

Popular tags

You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.

Top