On Sun, Jul 29, 2001 at 03:42:41PM -0600, Chris Cameron wrote:
> I sent this before, but it never made it..
>
> Does anyone here have any advice on controlling the size of user
> databases?
There's not a lot you can do about it today, short of (1) symlinks
onto a filesystem with user quotas where the user owns the files, or
(2) some program that actively monitors the size of the files and
takes some action if/when it needs to.
> I've heard talk of symlinks before, anyone had any luck with that?
The problem is that when a user goes over quota, they also stand a
good chance of ending up with corrupt MySQL data or index files. The
best solution would be to get some support built right into MySQL for
doing it. But I don't think it's high on the priority list, and
nobody has tried to sponsor such development.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 <-- NEW
MySQL 3.23.29: up 43 days, processed 340,219,856 queries (89/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php