On Mon, Jan 14, 2002 at 11:52:35AM -0800, Aaron Brick wrote:
in specific reference to linux, you are speaking of the 2.4 kernel,
glibc 2.2, and ext{2,3} filesystem? is it the case that large files
are correctly addressed (ie, seamlessly) on such systems?
Yes.
--
Jeremy D. Zawodny, [EMAIL
in specific reference to linux, you are speaking of the 2.4 kernel, glibc
2.2, and ext{2,3} filesystem? is it the case that large files are correctly
addressed (ie, seamlessly) on such systems? this is the impression i have
got from the limited research i've done.
looking for a generalized
Oganes,
are your really using disk partitions as InnoDB data files? If you use raw
disk partitions, then the operating system may put a limit on the number of
them, for example, 16.
But usually InnoDB data files will be just ordinary files of the file
system. The number of data files is
The size limitation is becauseof the operating system parameters. In
order to use tables larger then 3 GB, use either Redhat 7.2 or Solaris 8.
These operating systems allow file sizes greater then 2 GB. For the most
part I achievedtables sizes using these operating system of greater the 50
GB.
I disagree. The 4GB slowdown is usualy caused by indexing problems
associated with the OS having increased overhead when looking up and
inserting data. I have eliminated this slowdown in Solaris and Linux be
re-indexing the entire database once it becomes larger then 4GB. This
fixes the
Hello everyone,
I guess I have the similar question, that has been brought up.
I have 36 InnoDB tables, and I have allocated two 2GB partitions for my data.
Provided I have very big hard drive, how many partitions at 2GB each could I allocate?
As many as my hard drive can handle?
I also
On Thu, 10 Jan 2002, Dan Nelson wrote:
In the last episode (Jan 11), Manish Mehta said:
As we know that MySql support maximum of 4 GB data per table.
Actually, http://www.mysql.com/doc/T/a/Table_size.html says that only
Mysql 3.22 had a 4gb table size. With 3.23, the real limit is how
Yes and no. With 3.23, the MyISAM format will, by default, have a 4GB
limit (32 bits). You can set flags on the table to allow a 64-bit table,
and you'll generally hit an OS or physical limitation long before you
run out of space. The downside of the 64-bit version is it's considerably
This is speculation:
They're slower because many operations have to be done using 64 bit
values rather than 32 bit values. You set the flag by setting the max
data size when creating the table. You can also alter this after the
table is created with ALTER TABLE. The doc suggests you're
Hi,
As we know that MySql support maximum of 4 GB data per table.
Now the question arise that what is the maximum limit of Database in MySQL.
Manish Mehta
E-mail: [EMAIL PROTECTED]
-
Before posting, please check:
Well, my server is running on Mandrake 8.0. We're trying to implement
database hosting at our site, therefore people should probably have
database spaces between 10-50 MB.
In Microsoft SQL server you can limit the size of a database when
creating it. Is it possible in MySQL ?
VVM
Hi,
For most of the platforms Mysql has reasonably enough
space for each table itself(in GB).Database wise, also
there should not be any problem for the database size
you are mentioning.For sure,I can say that I have not
worked on Mandrake.But, I feel the size you have
mentioned should not be a
Hi,
I'm new in this list and new to MySQL also. What I want to know is how
to limit the size of a database.
Thanks.
--
Ali Kemal YURTSEVEN
Is Net A.S.
Iletisim Uzmani
-
Before posting, please
No need to worry.On NT each table can have
upto4GB.Database there is predefined limit.It can go
even upro 20GB or more also.
--- Ali Kemal YURTSEVEN [EMAIL PROTECTED]
wrote: Hi,
I'm new in this list and new to MySQL also. What I
want to know is how
to limit the size of a
14 matches
Mail list logo