How to limit folder size?

  • Thread starter Thread starter John Dalberg
  • Start date Start date
J

John Dalberg

It seems MySQL doesn't have the ability to limit database size so I wonder
if I can put each database in a folder, is there any way to limit folder
size in Windows 2003? Third party tools?
 
John Dalberg said:
It seems MySQL doesn't have the ability to limit database size so I wonder
if I can put each database in a folder, is there any way to limit folder
size in Windows 2003? Third party tools?
Click to expand...

Not with built-in tools -- Quotas are available but
they are PER VOLUME, not per directory.

You can of course just creat a new volume with the
limited or quota size.

You can even make it appear as if it is a subdirectly
on the original volume-drive with LinkD from the
Resource Kit (or maybe support tools.)
[/QUOTE]
 
John Dalberg said:
I have tens of databases so putting each one in a volume won't work.
Click to expand...

Why not?

Tens of volumes and you can do it easily. About as
easily as setting up the quota, with perhaps a small
amount of effort to move the databases or back them
up (should do that anyway) long enough to repartion
if your drives are all allocated.

These quota manager programs are quite expensive.
Click to expand...

Cost vs. benefit.
 
Why not?

Tens of volumes and you can do it easily. About as
easily as setting up the quota, with perhaps a small
amount of effort to move the databases or back them
up (should do that anyway) long enough to repartion
if your drives are all allocated.
Click to expand...

Isn't a volume the same thing as a partition?
How many volumes can you have? A-Z = 26?
 
Isn't a volume the same thing as a partition?

Yes.
How many volumes can you have? A-Z = 26?
Click to expand...

On a "Basic disk" you can only have 4 partitions
(but more drive letters by having one of them be
an extended partition with logical partitions within
it.)

But driver letters are not your issue. You need
separate volumes and volumes don't require letters,
especially for your purpose where you wish them
to appear as subdirectories.

Also, if you convert a drive to DYNAMIC and
you can have almost as many partitions as you
can imagine.

Then you just mount each partition into the parent
volume/directory of the desire filespace.

You can do this (with limitations) in Disk Management
(of Computer Management) or more flexibly with the
(dangerous tool) linkd.exe from the Reskit tools.

You can literally create and mount the 200 volumes
you need.

You 'quota' can be enforce by either using the size
of the volume (no one can exceed it, cumulative) or
by having different quotas (on each volume) for each
user separately.

That is, you may not need the actual quota setting but
be able to just use the volume size -- or your can
use both with 1 set of quotas per volume.
 
Back
Top