How big is the NW MySQL DB?

[Bushrat]

Hi,

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

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

Thanks.

[Tim Dorr Veteran]

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

4.8G .

[bukowski]

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

[Josh]

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]

wow, thanks for the info Tim ;)

[NienorGT]

Oh god...

it's... BIG...

[Tomi]

Whoa, that's big. =\

[david]

big epenis

[Lare2]

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

[Bushrat]

^ 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]]

nice :ninja:

[semaja2.net]

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]

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

585870935[/snapback]

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

[Laptop]

How much disc space?

[Andrew Lyle Global Moderator]

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

[phedot]

big epenis

585869902[/snapback]

Huge ePenis :laugh:

[....]

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

585869821[/snapback]

And one more gets added. :rolleyes:

[.Atlantis]

And one more gets added.  :rolleyes:

585873578[/snapback]

And you too.

wait, and me. :no:

[Narlzac85]

does a database like this include any kind of compression?

[wired57]

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

[j.r.l.]

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 Veteran]

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.

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]

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.

585874335[/snapback]

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

[j.r.l.]

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

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

[ember]

5Gigs? that huuuuuuge!