LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices



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

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


Hi,

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,

cooljai
-------
ek chota mota hindustani
-------
 
  


Reply

Tags
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 11:05 AM
Can dd restore the entire hard disk including partition table and MBR? depam Linux - General 17 01-01-2007 08: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 03:13 AM
directory size & QUOTA questions... hct224 Linux - Newbie 4 04-23-2004 07:41 PM
set user quota size juno Linux - General 2 10-25-2002 04:42 AM


All times are GMT -5. The time now is 03:17 AM.

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