Neowin Forums > How big is the NW MySQL DB?

Bushrat

May 4 2005, 01:10

Hi,

Just out of curiosity.... How big is the neowin MySQL database?

It must have to be at least 1-10gb?

Thanks.

Tim Dorr

May 4 2005, 04:02

root@server [/var/lib/mysql/neowin_ibf]# du -h
4.8G .

bukowski

May 4 2005, 04:05

holy crap, for this site i had a long time ago i think mine was like 10mb TOPS

Josh

May 4 2005, 04:08

Well, remember... neowin deletes nothing. They are running up on Guiness for having the most extensive collection of useless posts on the planet LOL!!!

xxdesmus

May 4 2005, 04:11

wow, thanks for the info Tim

NienorGT

May 4 2005, 04:14

Oh god...
it's... BIG...

Tomi

May 4 2005, 04:21

Whoa, that's big. =\

djlegion

May 4 2005, 04:23

big epenis

Lare2

May 4 2005, 05:24

Neowin should install a bot that automatically answer that question, since it pops very often.

Bushrat

May 4 2005, 11:03

^ lmfao

Well, yeah 5Gb is big for a mysql database. But think about how much extra space they have left over.

There are bigger databases i have come across, but damn. 5 Gb for a forum. Thats a lot of text.

Thanks for that Tim

[a]

May 4 2005, 11:06

nice

semaja2.net

May 4 2005, 11:12

hey what if we have like a php script on the front page which displays the details on the server like sql size, cpu usage, space? and a link to the specs or someother cool stuff

KC

May 4 2005, 21:53

QUOTE(semaja2 @ May 4 2005, 05:12)

hey what if we have like a php script on the front page which displays the details on the server like sql size, cpu usage, space? and a link to the specs or someother cool stuff
[right][snapback]585870935[/snapback][/right]

Causing more cpu usages, more tables in the database and overall just more load.

Laptop™

May 4 2005, 21:55

How much disc space?

lylesback2

May 4 2005, 21:59

each letter = 1 byte right? and each space is also included into that.. thats a LOT of bites!

phedot

May 4 2005, 22:02

QUOTE(pTony @ May 4 2005, 05:23)

big epenis
[right][snapback]585869902[/snapback][/right]

Huge ePenis

....

May 4 2005, 22:03

QUOTE(MyServerGuy @ May 3 2005, 23:08)

Well, remember... neowin deletes nothing. They are running up on Guiness for having the most extensive collection of useless posts on the planet LOL!!!
[right][snapback]585869821[/snapback][/right]

And one more gets added.

.Atlantis

May 4 2005, 22:14

QUOTE(BOOGSoftball @ May 4 2005, 23:03)

And one more gets added.

[right][snapback]585873578[/snapback][/right]

And you too.

wait, and me.

Narlzac85

May 4 2005, 22:31

does a database like this include any kind of compression?

wired57

May 4 2005, 22:36

it could but that uses more ram and cpu time, so usually no

Jay R.

May 4 2005, 23:49

It would be cheaper not to use compression on a site this huge... Let's say CPU X costs $320/mo. and it has 6 80GB hdds (scuzzy/SCSI) and a 5GB db... compared to a $400 server with CPU Z and 6 80GB hdds and a 2gb db (compressed)...

And whilst we're on it -> what's average CPU load on Neowin servers?

Tim Dorr

May 5 2005, 01:26

QUOTE(AresXP @ May 4 2005, 18:49)

It would be cheaper not to use compression on a site this huge... Let's say CPU X costs $320/mo. and it has 6 80GB hdds (scuzzy/SCSI) and a 5GB db... compared to a $400 server with CPU Z and 6 80GB hdds and a 2gb db (compressed)...

No, why would we want to compress the data? We've got a RAID 5 machine running the DB right now, so that's more than enough space to hold the DB. Space isn't an issue, speed is. More indexes do cost more disk space, but we don't care when there's a faster query speed to be had.

QUOTE

And whilst we're on it -> what's average CPU load on Neowin servers?

DB server's hovering around 1 (with 2 CPUs). The web servers are more spikey and it depends on the time of day and other factors.

Steven

May 5 2005, 07:10

QUOTE(timdorr @ May 4 2005, 18:26)

No, why would we want to compress the data? We've got a RAID 5 machine running the DB right now, so that's more than enough space to hold the DB. Space isn't an issue, speed is. More indexes do cost more disk space, but we don't care when there's a faster query speed to be had.
DB server's hovering around 1 (with 2 CPUs). The web servers are more spikey and it depends on the time of day and other factors.
[right][snapback]585874335[/snapback][/right]

If speed is an issue why not change to RAID10? Using RAID5 is kinda of killing your performance.isn't it?.

Jay R.

May 5 2005, 19:13

Timdorr, you denied what I said but you pretty much said the same thing about you not wanting to use compression

1 load isnt bad on a busy MySQL server... Do you have CPU load problems sometimes?

ember™

May 7 2005, 04:56

5Gigs? that huuuuuuge!

pre

May 7 2005, 04:59

QUOTE(ember™ @ May 7 2005, 04:56)

5Gigs? that huuuuuuge!
[right][snapback]585884392[/snapback][/right]

Too true....