how big can a mysql db get? - GoFuckYourself.com

TampaToker · 11-30-2006, 04:47 AM

Before it starts messin up 10mb 100mb 1000mb ?

bl4h · 11-30-2006, 04:48 AM

is it innodb or myisam

How are the tables structured

What type of machine does it run on

darksoul · 11-30-2006, 04:54 AM

it depends but its not that low
we have a few databases of 10-20GB running fine.

TampaToker · 11-30-2006, 05:05 AM

Quote:

Originally Posted by bl4h

is it innodb or myisam

How are the tables structured

What type of machine does it run on

good question i dont know lol i wil lhave to look into that

TampaToker · 11-30-2006, 05:06 AM

Quote:

Originally Posted by darksoul

it depends but its not that low
we have a few databases of 10-20GB running fine.

ok i feel better then mine is only at 10mb right now lol. Wanted to just check before i do what i am about to do......

polle54 · 11-30-2006, 05:14 AM

as darksoul said you can easily have large databases in mysql

but I would really consider reading up on db design if you wanna have such a big database.

it could affect your pageloadtime drastically if you make a bad design.

studiocritic · 11-30-2006, 06:05 AM

what polle says about optimization is definitely right..

assuming everything is kosher, the only real limits on the size of the database are ones imposed by the type of filesystem you're using. i.e. ext2, ext3, reiser, et al.

something you need to research and talk to your admin about

TampaToker · 11-30-2006, 06:31 AM

Cool cool thanks for the replays everyone

thebigstorm · 11-30-2006, 07:09 AM

my forum db is about 10 gigs

11-30-2006, 04:47 AM	#1
TampaToker Confirmed User Join Date: May 2006 Location: Tampa Posts: 5,827	how big can a mysql db get? Before it starts messin up 10mb 100mb 1000mb ? __________________ Icq 247-742-205

11-30-2006, 04:54 AM	#3
darksoul Confirmed User Join Date: Apr 2002 Location: /root/ Posts: 4,997	it depends but its not that low we have a few databases of 10-20GB running fine. __________________ 1337 5y54\|)m1n: 157717888 BM-2cUBw4B2fgiYAfjkE7JvWaJMiUXD96n9tN Cambooth

11-30-2006, 05:14 AM	#6
polle54 Confirmed User Join Date: Jul 2004 Location: The Beach Posts: 4,626	as darksoul said you can easily have large databases in mysql but I would really consider reading up on db design if you wanna have such a big database. it could affect your pageloadtime drastically if you make a bad design. __________________ ICQ# 143561781

11-30-2006, 06:05 AM	#7
studiocritic Confirmed User Join Date: Jun 2005 Location: Irvine, CA Posts: 2,442	what polle says about optimization is definitely right.. assuming everything is kosher, the only real limits on the size of the database are ones imposed by the type of filesystem you're using. i.e. ext2, ext3, reiser, et al. something you need to research and talk to your admin about __________________ 254342256

11-30-2006, 06:31 AM	#8
TampaToker Confirmed User Join Date: May 2006 Location: Tampa Posts: 5,827	Cool cool thanks for the replays everyone __________________ Icq 247-742-205

11-30-2006, 04:48 AM	#2
bl4h Confirmed User Join Date: Jul 2006 Location: Philadelphia Posts: 1,282	is it innodb or myisam How are the tables structured What type of machine does it run on

11-30-2006, 07:09 AM	#9
thebigstorm Confirmed User Join Date: Sep 2004 Posts: 164	my forum db is about 10 gigs