Limit database weight in mysql?

Question

linux

Hello! This is probably a question of interest to everyone, but how to make restrictions on the weight of the database for the user? I searched, I did not find the answer, I decided to ask.

Answer 1

At the file system level, you can check the size, and upon reaching a certain threshold, issue a notification to the user and restrict certain operations.

Answer 2

SELECT SUM(DATA_LENGTH + INDEX_LENGTH) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_SCHEMA='users_db'

Answer 3

mysql does not limit the size of the user's database.
The way out is to limit the disk space allocated to a particular database.
For example, a database users_db will be created for a user . You need to create a directory in /var/lib/mysql/users_db and mount the file system of the required size there.
If the file system is xfs, then you can simply install quota directly on the directory with the user base.

Answer 4

file system of the required size is not necessary - you can simply set a quota.

Answer 5

Best to just check. For example, throughdu