Hi there,
As far as I know, MySQL does not have a CREATE TABLE command do that.
The only thing I can think of is if by "size" you mean "number of
rows". (Which is directly proportional to the size in bytes if you do
not use variable-length fields, anyway.)
If so, you can have an autoincrement f
Hi, there!
I would like to know whether mysql has built-in capabilities/config options in
order to limid a database size or a table size.
I want a table to grow up to a limit and, when reached, for a new row to be
inserted the oldest one be deleted. Has mysql got this
functionality built-in? If
Is it possible to limit the size of a dbase or table?
---
Keith Schuster
Schuster & Company LLC
ph:704-799-2438
fx:704-799-0779
iChat/AIM:FSHSales
WWW.FlagShipHosting.com
WWW.Schusterandcompany.com
WWW.Vsheet.net
--
MySQL General
On Mon, 14 Jan 2002, Benjamin Arai wrote:
> Raids don't really help Table performance because in almost all cases the
> bottlneck is caused by the drives access time. raiding drives doesn't
> increase the access time therefore, you are most likely not going to see
> and poerformance increases usi
Benjamin Arai <[EMAIL PROTECTED]> writes:
> Oh, I don't know how well that would work. But I do know you will still
> run into limitations of 2 GB, so if you had 2 drives raided then you now
> have a 4 GB limit which doesn't help to much. I would think the best
> solution would be to re-compile
_
>
>
>
> > -Original Message-
> > From: Benjamin Arai [mailto:[EMAIL PROTECTED]]
> > Sent: Tuesday, January 15, 2002 1:52 AM
> > To: Geoffrey Soh
> > Cc: [EMAIL PROTECTED]
> > Subject: RE: Redhat 7.2 Linux Maximum Database/Table Size
>
__
> -Original Message-
> From: Benjamin Arai [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, January 15, 2002 1:52 AM
> To: Geoffrey Soh
> Cc: [EMAIL PROTECTED]
> Subject: RE: Redhat 7.2 Linux Maximum Database/Table Size
>
>
>
You don't understand. You need to use a operating system which has a
filesystem which lifts the 2 GB limit. By default from every Linux
distrobtion I have used, if the OS has lifted the limit then they usually
fix all the programs to uses the new file size capabilities.
Raid doesn't help at all
> On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote:
> > Benjamin,
> > can you also grow MyISAM tables to such sizes?
>
> You can.
I understand that the RAID option can help break the 2GB/4GB barrier, esp.
on Linux machines.
But how do you surpass the Max_data_length restriction
On Mon, Jan 14, 2002 at 09:55:16AM +0100, Dr. Frank Ullrich wrote:
> Hi,
>
> Jeremy Zawodny wrote:
> >
> > On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote:
> > > Benjamin,
> > > can you also grow MyISAM tables to such sizes?
> >
> > You can.
>
> that implies that MySQL itself
Yes, all programs which don't have built in limits can go smoewhere in the
range of I think 8 TB but I have only tested it to 50 GB with MySQL. As
for Solaris this is also true.
Benjamin Arai
[EMAIL PROTECTED]
On Mon, 14 Jan 2002, Dr. Frank Ullrich wrote:
> Hi,
>
> Jeremy Zawodny wrote:
> >
>
Hi,
Jeremy Zawodny wrote:
>
> On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote:
> > Benjamin,
> > can you also grow MyISAM tables to such sizes?
>
> You can.
that implies that MySQL itself (and all its tools) is able to handle
files bigger than 2 GB?
Is that the case with MyS
On Fri, Jan 11, 2002 at 08:51:33AM +0100, Dr. Frank Ullrich wrote:
> Benjamin,
> can you also grow MyISAM tables to such sizes?
You can.
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936
MySQL 3.23.41-max:
Benjamin,
can you also grow MyISAM tables to such sizes?
Regards,
Frank.
Benjamin Arai wrote:
>
> I have been testing Redhat 7.2 Linux for about 3 month's. I few notes
> regarding the installation which might be helpful for MySQL Admins.
>
> - Maximum Table Size: Limited online by d
On Thu, Jan 10, 2002 at 07:22:10PM -0800, Benjamin Arai wrote:
> I have been testing Redhat 7.2 Linux for about 3 month's. I few notes
> regarding the installation which might be helpful for MySQL Admins.
>
> - Maximum Table Size: Limited online by disk space. (I have tested
> tables upto 50 g
All right How do you set ext3 to minimum journaling??
> -Original Message-
> From: Benjamin Arai [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, January 10, 2002 9:22 PM
> To: [EMAIL PROTECTED]
> Subject: Redhat 7.2 Linux Maximum Database/Table Size
>
>
> I
I have been testing Redhat 7.2 Linux for about 3 month's. I few notes
regarding the installation which might be helpful for MySQL Admins.
- Maximum Table Size: Limited online by disk space. (I have tested
tables upto 50 gigs)
- Maximum Records Per Table: Limited only by available disk space.
17 matches
Mail list logo
