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
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?
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
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 MySQL on
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:
On
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 (and all its
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 of
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
__
-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
]]
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
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 your
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 using
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: up
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
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 have been testing Redhat 7.2 Linux
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 gigs)
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 disk
17 matches
Mail list logo