 Quick Question, Is there a limit on the size of the MySQL database? |
|
|
|
|
  |
 Feb 18 2006, 11:12 PM
Post
#1
|
|
|
Advanced Member  Group: Members Posts: 126 Joined: 18-February 06 From: London, England Member No.: 18,837  |
Question's in the title!
|
 |
 
|
|
Feb 19 2006, 12:17 AM
Post
#2
|
|
|
Newbie Group: Members Posts: 0 Joined: 19-February 06 Member No.: 18,851 |
QUOTE(tt3 @ Feb 18 2006, 11:12 PM)  Question's in the title! how do i start to build my site? |
|
|
|
|
Feb 19 2006, 12:24 AM
Post
#3
|
|
|
Hidden Secrets can't be told threw just words. One must feel what the other feels to truely understand... Group: Members Posts: 1,523 Joined: 8-January 06 From: Sacramento California Member No.: 16,756 |
blueangel, this would not be the place to make such a post, you should post this on your own forum not the forum of someone elses problem, just a little tip from member to member..but you would start your site by getting 30 hosting credits...then putting in an application and waiting for it to be approved
i do not believe there is a limit on the size of the database, but you would have to wait for an admin or mod to tell you offically... |
|
|
|
|
Feb 19 2006, 02:13 AM
Post
#4
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing.  Group: [MODERATOR] Posts: 3,910 Joined: 24-July 05 From: In Trouble Again... still? Member No.: 9,787  |
According to the mysql Manual, on a Linus 2.4+ system, the mysql Tables can be as large as 4 Terrabytes.
Windows 32 with NTFS max 2 terrabytes Windows fat32 approx 2 Gigs, Linux 2.2 same. As you can see from above, the restriction is Operating System dependant. If the System allows for the mysql to operate at its maximum potential, then the limit for the mysql table is 64 Terrabytes, but, Operating System Maximum File Sizes pull the maximum down to force mysql to function within the constraints of the Operating System Max File Size. All this and more is to be found in the mysql Manual. This information is based on mysql 5. If you are using (cringe) mysql3, or 4, then the maximums are smaller, but still pretty big. |
|
|
|
|
Feb 19 2006, 04:18 AM
Post
#5
|
|
|
Premium Member Group: Members Posts: 183 Joined: 27-June 05 From: Minnesota Member No.: 8,734 |
lol, jlhaslip you get really technical and have all kinds of stats and facts
 But yea, basically you can have the mysql database as large as you want, as long as its smaller than like 2 gigs as jlhaslip said above.... but if you have hosting on trap or something like that, you will never be able to have a 2 gig mysql database because your hosting account isn't that big Mysql databases count towards your disk quota, so you can't have a database bigger than your disk quota.
|
|
|
|
|
Feb 19 2006, 04:32 AM
Post
#6
|
|
|
A computer once beat me at chess, but it was no match for me at kick boxing. Group: [MODERATOR] Posts: 3,910 Joined: 24-July 05 From: In Trouble Again... still? Member No.: 9,787 |
A matter of interpretation, I suppose. I thought the question was how large can a mysql d/b be? You interpreted it to ask how large a d/b will the trap17 Hosting account allow my d/b to be. I guess we are both right.
|
|
|
|
|
Feb 19 2006, 09:40 PM
Post
#7
|
|
|
-=Hybrid Bus=- Group: Members Posts: 744 Joined: 2-November 05 From: My hybrid bus (in NYC), a computer Member No.: 13,709 |
Yeah, I think that it can't be larger than your storage quota (50 or 150 MB). You could probably request more disk space, but you shouldn't need it unless you have a forum like this running.
|
|
|
|
|
Mar 7 2006, 06:07 AM
Post
#8
|
|
|
Newbie [Level 1] Group: Members Posts: 20 Joined: 7-March 06 Member No.: 19,635 |
I don't believe that there is a limit but database sure does add up.
|
|
|
|
|
Jan 19 2008, 07:22 PM
Post
#9
|
|
|
Newbie Group: Members Posts: 0 Joined: 19-January 08 Member No.: 56,506 |
QUOTE(michaelper22 @ Feb 19 2006, 03:40 PM) Yeah, I think that it can't be larger than your storage quota (50 or 150 MB). You could probably request more disk space, but you shouldn't need it unless you have a forum like this running. Before I choose Trap17 or any other host: I'm trying to figure out how much space I will need for my personal website. It will have a Xoops/Wordpress-based blog, a Coppermine-style photo gallery, a guestbook module, a large link database (web directory with thousands of web links), and down the road I will try a Xoops forum module (for the experience, if nothing else). To be more specific, I have almost 50 MB worth of photos to upload to a gallery (and need a little room for the future), but the forum requirements will be very small as membership will be invitation-only and limited to about 40 or 50 members at most. I'm guessing that I will probably need the 150 MB storage quota. However... 1) Question: Do you think it's likely I will run out of even this much quota space in the forseeable future? It is very encouraging to hear that Trap17 does not have a specific limit on the MySQL database. Most other free web hosts have a specific maximum file size limit, like either 8 MB or 10 MB. 2) Question: Does this mean that, even if they don't specifically state it, their MySQL database(s) are also limited to their maximum file size? This is not made very clear... I was told that Xoops stores almost everything in the MySQL database - except for uploaded files and the index. 3) Question: Does this mean that photos uploaded to an image gallery are not stored in its MySQL database? |
|
|
|