for 3 gb database how much ram is required ? - GoFuckYourself.com

cooldude7 · 01-18-2012, 11:05 AM

around., 100k queries /day mysql databse

is 4 gb ram enough ?

thanks

Supz · 01-18-2012, 11:08 AM

is it just a DB server?

cooldude7 · 01-18-2012, 11:10 AM

Quote:

Originally Posted by pornopete

ECC or RDIF?

whats that ?

sorry but i am still learning.,
thanks

cooldude7 · 01-18-2012, 11:11 AM

Quote:

Originally Posted by Supz

is it just a DB server?

nope., the complete web server.,
httpd
sshd
mysqld

woj · 01-18-2012, 11:11 AM

depends on the site, 3GB of what? what kind of site is it?

cooldude7 · 01-18-2012, 11:12 AM

Quote:

Originally Posted by pornopete

Also what kernel version do you have installed?

i am asking this for new machine.,
nothing installed yet, choosing the hw conf.

cooldude7 · 01-18-2012, 11:14 AM

Quote:

Originally Posted by woj

depends on the site, 3GB of what? what kind of site is it?

3gb of database consist of words.,

in diff tables., 5 mil words in each table.,

total 26 tables.,

total 120 + mil. records., divided in difff., tables.,

Supz · 01-18-2012, 11:20 AM

i money is not an issue. put in 8GB or memory. This will also give you the opportunity to grow within the server, if the queries go up you wont have to change servers

cooldude7 · 01-18-2012, 11:23 AM

Quote:

Originally Posted by Supz

i money is not an issue. put in 8GB or memory. This will also give you the opportunity to grow within the server, if the queries go up you wont have to change servers

okie.,.,

BIGTYMER · 01-18-2012, 11:23 AM

Should be fine. If you have issues tweak your db, mysql, or add more memory.

cooldude7 · 01-18-2012, 11:29 AM

Quote:

Originally Posted by BIGTYMER

Should be fine. If you have issues tweak your db, mysql, or add more memory.

hmmmm. okie.

mafia_man · 01-18-2012, 11:32 AM

I'd care more about how fast my disks are and the memory taken up by Apache.

mikesouth · 01-18-2012, 12:01 PM

Im going to race motorcycles, what color should I paint my Truck

yer question makes as much sense...

Operator · 01-18-2012, 12:04 PM

Ham sandwichs

facialfreak · 01-18-2012, 01:53 PM

If you can use MySQL caching, 4GB should be plenty ...

We have VPS plans that have 4GB guaranteed RAM, with up to 8GB burst RAM for the times that you need that extra little "ummmph".

With 100K queries daily, your better off with a VPS setup, since you will get a much better disk I/O with a 6-10 disk RAID-10 configuration to balance the load.

VPS technology has come so far now, that many people are switching to a VPS for the redundancy and the better disk I/O rates over a dedicated server.

While we do offer shared hosting and fully-managed dedicated hosting, we specialize in managed VPS hosting. Please feel free to open a dialog with us (sales |AT| a1websolutions |DOT| com) to discuss your hosting requirements if you are looking for hosting. We would love the opportunity to earn your business.

raymor · 01-18-2012, 03:45 PM

It probably is, but you'll want to properly index your tables to avoids using more RAM, CPU, and especially IO than needed. Since you're dining the web server on the same box, the resources needed by the web server is another question. Crappy PHP, which is typical, can use far more resources than the whole system SHOULD use.

PowerCum · 01-18-2012, 04:50 PM

with INNODB tables... about 256 - 500 MB RAM and a fast HD.
with InnoDB tables, properly setup between 2 and 6 GB RAM depending on your data.

Rothstein · 01-18-2012, 04:53 PM

Do you realize that ram is nearly free in cost? Any hosts that rips you off with a monthly fee for additional ram are scammers.

mafia_man · 01-19-2012, 11:10 AM

Quote:

Originally Posted by Rothstein

Do you realize that ram is nearly free in cost? Any hosts that rips you off with a monthly fee for additional ram are scammers.

Most hosting companies charge monthly for hardware upgrades.

Rothstein · 01-19-2012, 11:17 AM

Quote:

Originally Posted by mafia_man

Most hosting companies charge monthly for hardware upgrades.

yeah and most of the time the hosting company pays off the price of the hardware within a couple of months yet will charge the fee for years if you let them.

01-18-2012, 11:05 AM	#1
cooldude7 Confirmed User Industry Role: Join Date: Nov 2009 Location: Heaven Posts: 4,306	for 3 gb database how much ram is required ? around., 100k queries /day mysql databse is 4 gb ram enough ? thanks Last edited by cooldude7; 01-18-2012 at 11:09 AM..

01-18-2012, 11:11 AM	#5
woj <&(©¿©)&> Industry Role: Join Date: Jul 2002 Location: Chicago Posts: 47,882	depends on the site, 3GB of what? what kind of site is it? __________________ Custom Software Development, email: woj#at#wojfun#.#com to discuss details or skype: wojl2000 or gchat: wojfun or telegram: wojl2000 Affiliate program tools: Hosted Galleries Manager Banner Manager Video Manager Wordpress Affiliate Plugin Pic/Movie of the Day Fansign Generator Zip Manager

01-18-2012, 11:32 AM	#12
mafia_man Confirmed User Industry Role: Join Date: Jul 2005 Location: icq#: 639544261 Posts: 1,965	I'd care more about how fast my disks are and the memory taken up by Apache. __________________ I'm out.

01-18-2012, 12:01 PM	#13
mikesouth Confirmed User Industry Role: Join Date: Jun 2003 Location: My High Horse Posts: 6,334	Im going to race motorcycles, what color should I paint my Truck yer question makes as much sense... __________________ Mike South It's No wonder I took up drugs and alcohol, it's the only way I could dumb myself down enough to cope with the morons in this biz.

01-18-2012, 01:53 PM	#15
facialfreak Confirmed User Join Date: Feb 2005 Location: Montreal Posts: 3,018	If you can use MySQL caching, 4GB should be plenty ... We have VPS plans that have 4GB guaranteed RAM, with up to 8GB burst RAM for the times that you need that extra little "ummmph". With 100K queries daily, your better off with a VPS setup, since you will get a much better disk I/O with a 6-10 disk RAID-10 configuration to balance the load. VPS technology has come so far now, that many people are switching to a VPS for the redundancy and the better disk I/O rates over a dedicated server. While we do offer shared hosting and fully-managed dedicated hosting, we specialize in managed VPS hosting. Please feel free to open a dialog with us (*sales \|AT\| a1websolutions \|DOT\| com*) to discuss your hosting requirements if you are looking for hosting. We would love the opportunity to earn your business. __________________ Managed Shared Hosting starting at $4.99/mo Managed VPS starting at $29.99/mo

01-18-2012, 11:08 AM	#2
Supz Arthur Flegenheimer Industry Role: Join Date: Jul 2006 Location: New York City Posts: 11,056	is it just a DB server?

01-18-2012, 11:20 AM	#8
Supz Arthur Flegenheimer Industry Role: Join Date: Jul 2006 Location: New York City Posts: 11,056	i money is not an issue. put in 8GB or memory. This will also give you the opportunity to grow within the server, if the queries go up you wont have to change servers

01-18-2012, 11:23 AM	#10
BIGTYMER Junior Achiever Industry Role: Join Date: Nov 2004 Location: Walled Garden Posts: 17,066	Should be fine. If you have issues tweak your db, mysql, or add more memory.

01-18-2012, 12:04 PM	#14
Operator So Fucking Banned Industry Role: Join Date: May 2009 Location: ΠπΠ Posts: 2,419	Ham sandwichs

01-18-2012, 03:45 PM	#16
raymor Confirmed User Join Date: Oct 2002 Posts: 3,745	It probably is, but you'll want to properly index your tables to avoids using more RAM, CPU, and especially IO than needed. Since you're dining the web server on the same box, the resources needed by the web server is another question. Crappy PHP, which is typical, can use far more resources than the whole system SHOULD use. __________________ For historical display only. This information is not current: support@bettercgi.com ICQ 7208627 Strongbox - The next generation in site security Throttlebox - The next generation in bandwidth control Clonebox - Backup and disaster recovery on steroids

01-18-2012, 04:50 PM	#17
PowerCum CjOverkill Industry Role: Join Date: Apr 2003 Location: Woldwide Posts: 1,328	with INNODB tables... about 256 - 500 MB RAM and a fast HD. with InnoDB tables, properly setup between 2 and 6 GB RAM depending on your data. __________________ CjOverkill Traffic Trading Script Free, secure and fast traffic trading script. Get your copy now

01-18-2012, 04:53 PM	#18
Rothstein So Fucking Banned Industry Role: Join Date: Jan 2012 Location: Frostburg, MD Posts: 682	Do you realize that ram is nearly free in cost? Any hosts that rips you off with a monthly fee for additional ram are scammers.