Can one restrict the maximum size of a user database in mysql? -


i cannot find in mysql documentation how restrict users filling disks entirely.

we small group of people , share mysql server. provide every user private db, rights create tables in private dbs, should prevented (accidentally) filling disk of machine entirely.

you can assign each user own tablespace, store tables of user database in it, , when create tablespace can give maximum size it.

see mysql manual: https://dev.mysql.com/doc/refman/5.1/en/create-tablespace.html


Comments

Popular posts from this blog

java - UnknownEntityTypeException: Unable to locate persister (Hibernate 5.0) -

python - ValueError: empty vocabulary; perhaps the documents only contain stop words -

ubuntu - collect2: fatal error: ld terminated with signal 9 [Killed] -