• Registered: 2010-08-14
  • Posts: 8

Topic: MySQL & user quotas

Hello!

I suggest to clean from a starting script mysqld the following:

chown mysql:mysql "$datadir"

Since it disturbs to correct calculation of a disk quota of users, that is because of it, databases do not enter into a disk quota of users.

Regards,
Viktor.

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,739

Re: MySQL & user quotas

Sorry, but I don't think if another user (that the process owner) own the datadir it could works properly... (including for quota).

I see various solutions

1/ 1 mysqld process per user

You must wrote a init script for each user, a datadir for each user, and a config file.

I sometime use this multi-instance mysql solution.
That's ok if you have only a small number of users.



2/ 1 database per user

Of course, each user must/could not have the "creata database" right.
and then you must set owner/right on datadir/user (with setgid bit and probably some others)

In this case, innodb table will not be taken in account for quota (only MyISAM one)

+

Desktop: Fedora 37 + rpmfusion + remi-test
Laptop:  Fedora 36 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website