My web host Lonex gives me a very small free PHP/MySQL allocation. I think it is 5 MB or something like that. Is this done for some technical reason, or just as a sales teaser for customers to pay for more space?
I am looking for a host that would suit a forum such as phpBB. If it gets busy I would find a beefier account, but for now, something more realistic than 5 MB would suit me. Suggestions welcome. It is a .com domain but the initial audience is Australia.
I have a 2.2Gb MySQL database that gets tens of thousands of hits (no visitors) every day and I can honestly say it doesn't seem to affect the performance of the server at all. Of course you have to have designed your database properly if it's going to be big!
Although most of the SQL queries are relatively simple and I have indexing on the important columns
Prior to 3.23, I think mysql had a 4gb limit for individual tables, but now there is virtually no limit (terabytes). Old Linux kernels might also limit individual file sizes to under 2gb, but there's no technical reason for a 5mb limit. That is probably simply to keep clients within their allocated disk space. Other possibilities are the server is very low spec or it maybe expected to serve several hundred mysql databases.
Any host can accomodate far more than 5mb. We allow up to the plan's entire disk space allocation if that's what the client needs and I imagine most other hosts will do the same.
If I remember correctly, I thought the largest 1 table could be was 4gb (4294967295) depending on the table type (longtext, & longblob).
I've seen many hosts have a size limit, but knowing my database seems to be larger than many of the limits its a decisive decision for a potential host (most seem to have 5mb limit). My DB is currently at only 7.11 Megabytes. Not the biggest, but certainly enough to be a decisive requirement with searching for a host.
I've also seen some hosts who say there is no limit on the DB size, but the the DB size goes against your disk quota.
In the end, I believe its a marketing tool with nothing really technical about it.
Glioblastoma Multiforme (GBM) Brain Cancer Awareness. May is Brain Cancer awareness month. Gray Matters!
Incurable, 6-18 months prognosis, survivors longer than 3 years less than 1% chance.
Don't like what I say? Ignore me.
MySQL writes to the file system, so if there is a limit, it is the limite imposed by the filesystem itself.
However, since your MySQL counts towards your quota, I would imaging the other limit you might consider is the limit to your account. If you exceed your account's limit your host might have something to say about it.