We help IT Professionals succeed at work.

How do I find/set the maximum size of a MYSQL database?

save9
save9 asked
on
1,358 Views
Last Modified: 2008-08-05
Hi,

I need to find the maximum size allowed for a MYSQL 5 database created using the SQL 'CREATE DATABASE' command.

Then I need to be able to set the maximum size of the database. The database engine is MyISAM.

The reason I need this is so that an end user cannot exceed the maximum size of their database (and thus compromise my server). I've created a database and a MYSQL user with restricted privileges (SELECT, INSERT, UPDATE, DELETE) who is only allowed to access that database.
Comment
Watch Question

try this command in your query browser

 SHOW VARIABLES  

and see what it returns
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
for MyISAM, you do not have a maximum database size apart from the file system limits.
that means, that the limit is per table, ie 1 table can only have the max size of what the file system allows for a single file.

so, check out the file system, and it's specs.
for MyISAM, you do not have a maximum database size apart from the file system limits.
that means, that the limit is per table, ie 1 table can only have the max size of what the file system allows for a single file.
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.