save9
asked on
How do I find/set the maximum size of a MYSQL database?
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.
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.
ASKER CERTIFIED SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
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.
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.
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.
SHOW VARIABLES
and see what it returns