Database Size and Location

[GivenRandy]

How can I find where my MySQL database resides and how large it is (I presume by either File Manager and/or phpMyAdmin)?

[jason]

Your database files are stored in a central location on the server, not in your account. I don't know the exact datafile structure for MySQL, but with most DBMS systems, there usually isn't a single file per database or anything like that. They tend to group things together in ways that make accessing data as fast as possible.

As for the size of your databases, go into phpMyAdmin and select the database you're curious about. On the summary page, you'll see a list of all of the tables available. The last column is the size of the table, and at the bottom of the list is the total of all of the tables.

--Jason

[GivenRandy]

Is there a limit? Does it show in the site allocation? I imagine if there were abuses (e.g., someone making a 1G database), it would get stopped quickly. Still, I would like to know any limitations before I run into them (I currently have 400M storage for my very-low-traffic site).

[jason]

I don't believe that database storage is metered, but if your db starts to get too big, I'm sure support will let you know about it. I remember hearing this a long time ago, so it may have changed, but I don't remember hearing of any changes.

--Jason