Help - Search - Members - Calendar
Full Version: Manage Client MySQL Database Size
The Planet Forums > System Administration > Server Hardware > RaQ Support
jnyost
I wish to control the size of databases for my clients. I don't want them to take advantage of buying a small package for disk space but then using a 500mb database. Any help would be appreciated...

tx
jared
EOC_Jason
Well, if you have quota's on, and their directory is limited by the amount of space they can write to it, then I would move their mysql DB into their directory, use a symlink to it, and then it counts as their total space... However if they run out of room, it could potentially cause DB corruption or integrity problems...

I would just watch the directory now and then (or write an email script to send you nightly / weekly file size info on that dir) and if it gets out of hand contact the person...
instantnet
The question is: How to code it? Would shell_exec (PHP) work?
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2009 Invision Power Services, Inc.