Review your favorite Linux distribution.
Go Back > Forums > Linux Forums > Linux - Server
User Name
Linux - Server This forum is for the discussion of Linux Software used in a server related context.


  Search this Thread
Old 06-06-2007, 02:38 AM   #1
Registered: May 2007
Location: /dev/random
Distribution: CentOS, Fedora, RHEL, SuSE
Posts: 62

Rep: Reputation: 15
Question Disk quota that including database size


I've two centos 4.4 servers. On first, I've implemented disk quotas for users and its running fine. On other server, mysql is running.

I want to monitor the size of database also related to the user and if the size usage (disk quota+db size) reached certain limit, I can do some action (like mail).

for example, I've assigned 10MB disk quota to a user. So when the user has files totaling 8 MB and the database (having size 2 MB) then limit should be enforced or any action will be taken.

Currently, I've idea to create a script that will fetch disk usage by using "repquota" command, get size of database from other server using "show table status" command and then calculate total size and implement the action.

Is it correct way to do this thing. Plz advice and give hint if theres more better way to implement the same.

thanks & regards,

ek chota mota hindustani


database, disk, quota, size

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
User quota, block size calculation procfs Linux - General 8 09-24-2010 10:05 AM
Can dd restore the entire hard disk including partition table and MBR? depam Linux - General 17 01-01-2007 07:05 PM
Why should you give the size of the swap disk as twice the size of RAM vmniza Linux - Newbie 3 09-17-2004 02:13 AM
directory size & QUOTA questions... hct224 Linux - Newbie 4 04-23-2004 06:41 PM
set user quota size juno Linux - General 2 10-25-2002 03:42 AM > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 02:24 PM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration