Richard Ellerbrock wrote:
> I am not 100% sure I understand you but I presume you are talking about the 2Gig
>file size limit of some OS'es? If this is the case, just find out where MySQL stores
>its databases and have a look at the filesize - you are using the C API, so doing a
>call to get this info should be trivial.
Yes I am talking about the 2gig(solaris) or 4gig(linux) limit, and
I know how to check it myself if I am running on the same server
that mysql server is running on. My question is regarding running
from a client on an arbitrary machine, which may *not* be directly
accessible except through the mysql server.
>
>
> Databases are usually stored in /var/lib/mysql on Linux and each database is just a
>subdirectory in this directory. So check the filesize and just roll-over the database
>yourself when you reach a self imposed limit.
>
> Also, have you looked at LFS support for your OS. Redhat ships kernels with LFS
>support. You just need to know where to find them! Also what about RAID tables?
>
> --
> Richard Ellerbrock
> [EMAIL PROTECTED]
>
> >>> [EMAIL PROTECTED] 2001/01/19 02:22:18 >>>
> I need to test the relative "fullness" of a given table
> relative to its maximum size on the OS. I am doing
> everything through the C API. What I would like is
> to be able to ask is, how full is table "bletch?", and get back
> something like 87%.
>
> The reason I am doing this is that I am dealing with
> huge amounts of data whereby a given table, if used
> in the traditional way, could easily exceed the maximum
> on the filesystem. I understand that other database
> management systems spread the table across files
> so this is not a problem. I am more than willing to
> manage "concatenated" tables myself through the
> C API, but I want to be able to detect that I am getting
> near the limit without just "hitting the wall" on an
> INSERT.
>
> Is there some way to do this?
>
> Thanks.
>
> Dean Hoover
>
> PS. By the way, what errno is returned when I do "hit the
> wall" on an INSERT?
>
> ---------------------------------------------------------------------
> 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
---------------------------------------------------------------------
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
