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.
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
