Max Size of Database(s) Setting

[Michael42]

Can anyone tell me what setting in the my.cnf controls the maximum size a database can grow too?

Does this setting(s) control it on a database by database level or the total size for ALL databases?

Thanks!

 

[sleipnir214]

Since MySQL organizes a database as a directory on the filesystem, there may be no configurable limit on the size of a database.

Also, the MySQL online documentation mentions maximum table sizes, and that those are limited by your filesystem. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[Michael42]

Thanks for confirming this sleipnir214.

I just wanted to make sure there were no internal mySQL commands that I had to set or stay on top of like Oracle.

mySQL Rocks!

 

[sleipnir214]

No.

I'm not that familiar with Oracle, but I have some experience with M$ SQL Server. In SQL Server 6.5, you had to define a database space on the filesystem, then put all your tables in it. If it filled up, you had to start allocating more space by hand.

When you create a database in MySQL, it creates a directory on the filesystem. All tables in that database become files in that directory (multiple files per table). So your database size is limited by how big your tables can become (

http://www.mysql.com/doc/en/Table_size.html)

and how many tables your entire filesystem has space for. Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!