Hosting Question - GoFuckYourself.com

tonyparra · 07-02-2013, 11:13 PM

Can a database not assigned to a domain affect ram used? Hypothetical situation: I move database from host A to host B with the intention of switching to host B. However I never change the nameservers so therefore the site remains hosted at host A. Is it possible still that the db itself, though not actually being used could affect the ram at host B?

freecartoonporn · 07-02-2013, 11:20 PM

if its using innodb then yes. else not much

tonyparra · 07-02-2013, 11:31 PM

Quote:

Originally Posted by freecartoonporn

if its using innodb then yes. else not much

Not sure about that have to look that up. Host is saying that the server crashed several times. I have 4 dbs 2 of them are unassigned because sites never moved over. All site wp. The 2 that are there, receive very little traffic have about 200 post each.

bean-aid · 07-02-2013, 11:35 PM

Quote:

Originally Posted by tonyparra

Not sure about that have to look that up. Host is saying that the server crashed several times. I have 4 dbs 2 of them are unassigned because sites never moved over. All site wp. The 2 that are there, receive very little traffic have about 200 post each.

Do you need a home for your sites? This is the second thread I have read in the last week about your server problems. Server don't need to be a problem, if you find the right one.

baddog · 07-02-2013, 11:36 PM

You should always delete dbs and plugins you are not using.

paffie · 07-03-2013, 12:41 AM

Alter table tablename engine = myisam. If your script Will work with myisam ofcourse

sandman! · 07-03-2013, 12:42 AM

if your asking questions like this you need to stop trying to skimp on hosting and just get what you need.

no there is no reason any real webmaster should be asking the question you are asking.

tonyparra · 07-03-2013, 05:59 AM

Um...this happened with a well know provider (highly recommended on gfy of course) and the service is a vps

I had 8 different hosting accounts im going to minimize it to 2 or 3 this month and only keep sites up with traffic/sales. This is crazy. How can i be crashing the server before I even put the sites there.

PornDiscounts-V · 07-03-2013, 06:06 AM

This happens when you use a server that is setup to run php in a jailed environment. Php_exec if I remember correctly. That is bad. It is wordpress, not the DB that is bringing you down, but only because the server is not setup correctly.

In this configuration a new php is opened for every include. In wordpress that is about 50 just to see index page. So memory is used up with 4 or 5 people on the site. You need a new host. That one won't work.

Aloisia · 07-03-2013, 06:18 AM

Defenitly you should look around for a new host!

freecartoonporn · 07-03-2013, 08:26 AM

get a dedicated box with support and focus on things you can do, trust me on this.
i have had issues like these previously and it takes time and money, then why not spend money and get a support already?...

tonyparra · 07-03-2013, 09:07 AM

Quote:

Originally Posted by freecartoonporn

get a dedicated box with support and focus on things you can do, trust me on this.
i have had issues like these previously and it takes time and money, then why not spend money and get a support already?...

it was a fully managed vps

but i see ur point

07-02-2013, 11:13 PM	#1
tonyparra Confirmed User Industry Role: Join Date: Jul 2008 Location: In your back seat with duck tape Posts: 4,568	Hosting Question Can a database not assigned to a domain affect ram used? Hypothetical situation: I move database from host A to host B with the intention of switching to host B. However I never change the nameservers so therefore the site remains hosted at host A. Is it possible still that the db itself, though not actually being used could affect the ram at host B? __________________ High Performance Vps $10 Linode Manage your Digital Ocean, Linode, or Favorite Cloud Server. Simple, fast, and secure Server Pilot

07-02-2013, 11:20 PM	#2
freecartoonporn Confirmed User Industry Role: Join Date: Jan 2012 Location: NC Posts: 7,683	if its using innodb then yes. else not much __________________ SSD Cloud Server, VPS Server, Simple Cloud Hosting \| DigitalOcean

07-03-2013, 12:41 AM	#6
paffie Confirmed User Industry Role: Join Date: Mar 2013 Posts: 116	Alter table tablename engine = myisam. If your script Will work with myisam ofcourse __________________ Need a VPS? I use Ramnode, great uptime, friendly support and only $62/year (after their lifelong coupon) for an openVZ VPS => [email protected], 512Mb ram, 512 Mb swap, 120 Gb SSD, 1Gbps port, 2 Tb bandwith, 1 IPv4, 16 IPv6, weekly backups

07-03-2013, 12:42 AM	#7
sandman! Icq: 14420613 Industry Role: Join Date: Mar 2001 Location: chicago Posts: 15,432	if your asking questions like this you need to stop trying to skimp on hosting and just get what you need. no there is no reason any real webmaster should be asking the question you are asking. __________________ Need WebHosting ? Email me for some great deals [email protected]

07-03-2013, 05:59 AM	#8
tonyparra Confirmed User Industry Role: Join Date: Jul 2008 Location: In your back seat with duck tape Posts: 4,568	Um...this happened with a well know provider (highly recommended on gfy of course) and the service is a vps I had 8 different hosting accounts im going to minimize it to 2 or 3 this month and only keep sites up with traffic/sales. This is crazy. How can i be crashing the server before I even put the sites there. __________________ High Performance Vps $10 Linode Manage your Digital Ocean, Linode, or Favorite Cloud Server. Simple, fast, and secure Server Pilot

07-02-2013, 11:36 PM	#5
baddog So Fucking Banned Industry Role: Join Date: Apr 2001 Location: the beach, SoCal Posts: 107,089	You should always delete dbs and plugins you are not using.

07-03-2013, 06:06 AM	#9
PornDiscounts-V Confirmed User Industry Role: Join Date: Oct 2003 Location: L.A. Posts: 5,744	This happens when you use a server that is setup to run php in a jailed environment. Php_exec if I remember correctly. That is bad. It is wordpress, not the DB that is bringing you down, but only because the server is not setup correctly. In this configuration a new php is opened for every include. In wordpress that is about 50 just to see index page. So memory is used up with 4 or 5 people on the site. You need a new host. That one won't work. __________________ Blog Posts - Contextual Links - Hardlinks on 600+ Blog Network * Handwritten * 180 C Class IPs * Permanent! * Many Niches! * Bulk Discounts! GFYPosts /at/ J2Media.net

07-03-2013, 06:18 AM	#10
Aloisia Registered User Industry Role: Join Date: Mar 2010 Location: Europe Posts: 19	Defenitly you should look around for a new host!

07-03-2013, 08:26 AM	#11
freecartoonporn Confirmed User Industry Role: Join Date: Jan 2012 Location: NC Posts: 7,683	get a dedicated box with support and focus on things you can do, trust me on this. i have had issues like these previously and it takes time and money, then why not spend money and get a support already?... __________________ SSD Cloud Server, VPS Server, Simple Cloud Hosting \| DigitalOcean