Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 6th June 2007, 09:42
cooljai cooljai is offline
Member
 
Join Date: May 2007
Location: /dev/random
Posts: 31
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via Yahoo to cooljai
Default Disk quota which include 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 give your advice/ hint if there is more better way to implement the same.

thanks & regards,

cooljai
-------
ek chota mota hindustani
-------
Reply With Quote
Sponsored Links
  #2  
Old 7th June 2007, 15:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
 
Default

Quote:
Originally Posted by cooljai
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.
That's how I'd do it, too.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail System doesnt work! crichton Installation/Configuration 3 17th September 2007 23:49
550 New Folder: Disk Quota exceeded Geoinline Installation/Configuration 5 6th March 2007 17:40
Problems with copy & paste dspuser Server Operation 3 23rd May 2006 17:21
Limit mysql database size ddelbia Feature Requests 14 25th April 2006 21:42


All times are GMT +2. The time now is 00:49.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.