06-24-2003, 11:07 AM
|
|
Junior Guru Wannabe
|
|
Join Date: May 2003
Posts: 64
|
|
Poll: What is the largest MySQL database you have?
Heh, just for fun, but also I'd like to know what MySQL is capable of...
What is the size of the largest functional MySQL database you have?
By "functional", I mean, it still runs okay speed-wise, etc..
Are these online or just on your local PC?
|
06-24-2003, 11:12 AM
|
|
Junior Guru Wannabe
|
|
Join Date: Mar 2003
Posts: 65
|
|
Are you referring to a database or a single table? There are lots of multi-gigabyte MySQL databases out there.
__________________
Sean Brunnock
http://server.com
|
06-24-2003, 11:15 AM
|
|
Aspiring Evangelist
|
|
Join Date: Jan 2003
Location: Suppot & Server Admin
Posts: 377
|
|
I wonder how big WHT database is?
|
06-24-2003, 01:41 PM
|
|
Web Hosting Master
|
|
Join Date: Apr 2002
Location: Southampton, UK
Posts: 1,023
|
|
Quote:
Originally posted by Pipson
I wonder how big WHT database is?
|
I think WebDev said it was 1-2GB
__________________
Regards,
Stephen Marsh ServerForce Ltd - AS39332
Linux Virtual Servers | Windows Virtual Servers | Managed Hosting | Web Hosting | Reseller Web Hosting | Dedicated Servers
|
06-24-2003, 01:46 PM
|
|
Web Hosting Master
|
|
Join Date: Jan 2003
Location: Lake Arrowhead, CA
Posts: 789
|
|
You need much larger options in the poll. Any reasonable size forum will hit a few hundred mb rather quick. The only reason most forum databases stay below a gig is they're usually purged frequently to save space or to allow faster offsite backups.
The largest db I manage is on a fairly small gaming site which is purged every few months to keep the db just over a gig.
|
06-24-2003, 01:51 PM
|
|
Disabled
|
|
Join Date: Jun 2003
Posts: 32
|
|
WHT = 1.8GB
My largest is 249MB
|
06-24-2003, 02:09 PM
|
|
Web Hosting Master
|
|
Join Date: Dec 2002
Posts: 4,304
|
|
I have one that is 324 MB and the next closest is 147 MB.
|
06-24-2003, 02:10 PM
|
|
Web Hosting Master
|
|
Join Date: Nov 2001
Location: Omaha
Posts: 2,131
|
|
Largest one is a 97 working vbulletin datbase
__________________
Sometimes life seems like a dream, especially when I look down and see that I forgot to put on my pants
|
06-24-2003, 02:48 PM
|
|
Web Hosting Master
|
|
Join Date: Jul 2002
Location: Missouri
Posts: 2,504
|
|
I deleted it a bit ago, but it was around 30 mb'sh... with 3 years of data.
__________________
What does one host say to the other? "(HostA) Want to go see a movie?" "(HostB) Sure, can your parents drive?"
I'm premium, and no, I did not have to pay $6 a month to figure that out.
|
06-24-2003, 03:00 PM
|
|
Account Suspended
|
|
Join Date: Mar 2003
Location: BC, Canada
Posts: 21
|
|
50MB db, around 150,000 search queries/day.
|
06-24-2003, 03:07 PM
|
|
Web Hosting Evangelist
|
|
Join Date: Jun 2003
Posts: 477
|
|
I didn't realize heavy usage MySQL databases were so small.
__________________
http://www.webhostingtalk.com/search.php?s=
Don't just ask point blank questions, search first.
|
06-24-2003, 05:12 PM
|
|
Web Hosting Master
|
|
Join Date: Jan 2002
Posts: 2,998
|
|
My largest is 16.7MB, but it is on my deveopment server. My next closest is 2.57MB and that is a little over a years worth of stuff.
__________________
Don't like what I say? Ignore me because it will be the only way you can shut me up.
|
06-24-2003, 05:58 PM
|
|
Web Hosting Master
|
|
Join Date: Jan 2003
Location: Montreal
Posts: 1,375
|
|
It depends if the forum is doing some maintenance, like deleting old subjects.
__________________
Charles Beliveau | NymixWeb.com
Proven success since 2001!
|
06-24-2003, 06:46 PM
|
|
Web Hosting Master
|
|
Join Date: May 2002
Location: UK
Posts: 2,994
|
|
Your poll doesn't even come close to what I'm running.
I have one running at 1.4Gb and another at 1.8Gb
and you know they are still fantastically fast at select statements.
They both have the same data (the ODP database) except one is running standard indexes and the latter is running a fulltext search on one field.
Test it if you like, just go to my site and click on the 'directory' link at the top. That's the 1.4Gb database.
|
06-24-2003, 07:40 PM
|
|
Web Hosting Master
|
|
Join Date: Jan 2003
Location: Montreal
Posts: 1,375
|
|
Pretty fast 
__________________
Charles Beliveau | NymixWeb.com
Proven success since 2001!
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
| Postbit Selector |
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
|
| Login: |
|
|
| Advertisement: |
|
|
| Web Hosting News: |
|
|
|
