Maximum Mysql Database Size

[Brad]

I currently have a MySql database hosted on hostpc with about 170,000 records and whose size is about 17.5 MB. It is working without problem.

However, I am about to start another project which will require a database with about 2 million records and a size of about 300MB. Is this feasible to do in MySql? What is the maximum feasible MySql database size?

[Jeff]

Brad, I ran this by Joe for a reaction. He says a database of that size and number of records exacts a substantial toll on server resources. He would be willing to let you host it on a semi-dedicated account, but it would be too much for a standard, shared-server account.

If you'd like to get pricing on a semi-dedicated account, open a helpdesk ticket.

[Edi]

This post dates back to 2005...

What is the actual limit for a mysql database on a standard, shared-server account?

Edi

[dbmasters]

I would presume the database size is limited by the size of your account MB quota...

[Edi]

I would presume the database size is limited by the size of your account MB quota...

That would be more than enough for my needs! :)

Edi

[anjanesh]

Its not the size that matters here - its the number of concurrent connections you intend to have at a time.

[starfighter]

Its not the size that matters here - its the number of concurrent connections you intend to have at a time.
You are right, number of connections will get you in trouble long before your quotas will. If you do hit the limit for the server your on, we will let you know.

[dbmasters]

Its not the size that matters here

Boy, it's a testament to the strength of my will in my new years resolution to not say something there... :)

[tnas]

...number of connections will get you in trouble long before your quotas will......

"Boy, it's a testament to the strength of my will in my new years resolution to not say something there... :)"

Ditto
:thumbUP