- Original Message -
From: Rick James rja...@yahoo-inc.com
Hey Rick,
Thanks for your thoughts.
* Smells like some huge LONGTEXTs were INSERTed, then DELETEd.
Perhaps just a single one of nearly 500M.
I considered that, too; but I can see the on-disk size grow over a period of a
.
* In InnoDB, the LONGTEXT will usually be stored separately, thereby making a
full table scan relatively efficient.
-Original Message-
From: Johan De Meersman [mailto:vegiv...@tuxera.be]
Sent: Friday, February 15, 2013 4:21 AM
To: mysql.
Subject: MyISAM table size vs actual data
Hey list,
I've got another peculiar thing going on :-) Let me give you a quick summary of
the situation first: we host a number of Drupal sites, each site and it's db on
separate VMs for reasons that are not important to this scenario. MySQL is
5.0.51a-24+lenny4-log (Debian); I don't have
On Nov 22, 2009, at 8:54 AM, Ryan Chan wrote:
Hello,
Is it common heard from people that if you have large table (assume
MyISAM in my case), you need large memory in order to have the
key/index in memory for performance, otherwise, table scan on disk is
slow.
But how to estimate how much
Hello,
Is it common heard from people that if you have large table (assume
MyISAM in my case), you need large memory in order to have the
key/index in memory for performance, otherwise, table scan on disk is
slow.
But how to estimate how much memory I need?
Consider a simple case, a MyISAM
In the last episode (Nov 22), Ryan Chan said:
Is it common heard from people that if you have large table (assume MyISAM
in my case), you need large memory in order to have the key/index in
memory for performance, otherwise, table scan on disk is slow.
But how to estimate how much memory I
At 10:47 PM -0400 3/18/08, Sookhyun Yang wrote:
Dear all,
I have a question about the limitatin of table size.
If I use the InnoDB engine, I don't have to worry that the total size of
table is greater than the single filesize?
You can create an InnoDB tablespace that spans multiple files, yes
Dear all,
I have a question about the limitatin of table size.
If I use the InnoDB engine, I don't have to worry that the total size of
table is greater than the single filesize?
Thanks a lot!
Best,
Sookhyun.
PROTECTED]
To: Dan Nelson [EMAIL PROTECTED]
Cc: Josh [EMAIL PROTECTED]; mysql@lists.mysql.com
Sent: Sunday, October 28, 2007 9:25:11 AM
Subject: Re: Table Size
Dan Nelson wrote:
In the last episode (Oct 27), Baron Schwartz said:
InnoDB has the following extra things, plus some things I might
: Sunday, October 28, 2007 9:25:11 AM
Subject: Re: Table Size
Dan Nelson wrote:
In the last episode (Oct 27), Baron Schwartz said:
InnoDB has the following extra things, plus some things I might forget:
a) the primary key B-Tree
b) row versioning information for every row
c) 16k page size; each
towards the table size. Actually, the primary
key B-Tree might not be; I'd need to look that up. But I think it
is. H. I just tested -- yes, the PK counts towards table size.
In fact, in InnoDB, all indexes count towards table size, since there
is a single .ibd file for the whole thing. So
Hello,
I have a database that is growing at a rate of 4-5 MB per day (that number is
getting larger as well). Not too bad but I'm trying to clean up the tables to
minimize the amount of space they take up.
I have one particular table that has 2 columns:
rolID int(10) unsigned
repID int(10)
Josh wrote:
Hello,
I have a database that is growing at a rate of 4-5 MB per day (that number is
getting larger as well). Not too bad but I'm trying to clean up the tables to
minimize the amount of space they take up.
I have one particular table that has 2 columns:
rolID int(10) unsigned
Message
From: Baron Schwartz [EMAIL PROTECTED]
To: Josh [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Saturday, October 27, 2007 10:17:32 AM
Subject: Re: Table Size
Josh wrote:
Hello,
I have a database that is growing at a rate of 4-5 MB per day (that number is
getting larger
Have you tried optimize table?
On 10/27/07, Josh [EMAIL PROTECTED] wrote:
Hello,
I have a database that is growing at a rate of 4-5 MB per day (that number is
getting larger as well). Not too bad but I'm trying to clean up the tables
to minimize the amount of space they take up.
I have
InnoDB has the following extra things, plus some things I might forget:
a) the primary key B-Tree
b) row versioning information for every row
c) 16k page size; each page might not be completely full
Those are all counted towards the table size. Actually, the primary key
B-Tree might
:32 AM
Subject: Re: Table Size
Josh wrote:
Hello,
I have a database that is growing at a rate of 4-5 MB per day (that number is
getting larger as well). Not too bad but I'm trying to clean up the tables
to minimize the amount of space they take up.
I have one particular table that has 2
size. Actually, the primary
key B-Tree might not be; I'd need to look that up. But I think it
is. H. I just tested -- yes, the PK counts towards table size.
In fact, in InnoDB, all indexes count towards table size, since there
is a single .ibd file for the whole thing. So you've got
of those tables, it doesn't
change table size.
If you have a table with a year column you could break it down into
months, so when you query a particular month, the whole table isn't
checked, only a particular partition.
So mysql can go to the right partition (month), then use appropriate
Helo all,
Just wanted to know when should a Table be considered for partitioning ( or
should it be archiving ).
Almost all of our tables are of Innodb type. I am looking for an estimate
rather than a Depends on situation kind of an answer.
We have few of our table swhich are very huge ( in
column8 datetime
which gives an approximate value of 630 bytes for a row in this table and
given that I can have 48000 such rows in this table taking the table size to
30MB. Note that I have not taken into account the indexes and foreign
keys... How much space do these take? I have 6 such innodb
Hi,
What command used to check table size and database size?
thanks
-
Blab-away for as little as 1¢/min. Make PC-to-Phone Calls using Yahoo!
Messenger with Voice.
At 2:15 pm -0700 5/4/06, Ravi Kumar wrote:
What command used to check table size and database size?
For table size:
http://dev.mysql.com/doc/refman/5.0/en/show-table-status.html
I imagine (though I don't know for sure) that you can get the same info from
the information_schema database
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 not, what other approaches could
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
As it looks like no one else has replied.
The default table size is 4GB - effectively if you do not modify the
table create statement this is the size you get.
To alter the table size you need to change the value of the MAX_ROWS
parameter. The table size is governed by MAX_ROWS multiplied
Hi,
I am using Mysql built-in defaults for starting the
server. It chokes when the table size grows to 4GB in
data directory.
What parameter needs to be tweaked for allowing larger
size tables ?
===
-rw-rw1 vagarwal dev 4294967284 Apr 29
22:33 crec.MYD
-rw-rw1
MyISAM tables files have MYI suffix. See:
http://dev.mysql.com/doc/mysql/en/full-table.html
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my
RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI.
Currently the table size
Many many thanks... I was in confusion. But how can I exten the table
size.
Regards
Naveen
- Original Message -
From: gerald_clark [EMAIL PROTECTED]
To: Naveen C Joshi [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Tuesday, March 15, 2005 7:52 PM
Subject: Re: To extend InnoDB table
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat
Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI.
Currently the table size is fixed 4GB and I want to extend it 10GB. Could you
please give me perfect command to extend my table size. The is my
Naveen C Joshi wrote:
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI.
These are MyIsam, not InnoDB.
Currently the table size is fixed 4GB and I want to extend it 10GB. Could you
please give me
I know there must be a command line query to show the size of the
database or of specific tables. What is it? I've been unable to find
anything in the online manual (of course that presupposes I've been
looking in the right place).
Thanks,
Susan
--
MySQL General Mailing List
For list archives:
[snip]
I know there must be a command line query to show the size of the
database or of specific tables. What is it? I've been unable to find
anything in the online manual (of course that presupposes I've been
looking in the right place).
[/snip]
SHOW TABLE STATUS [FROM `table`]
Hello,
after restoring from a mysqldump I use phpMyAdmin to view my database
but the size field is unknown ...
how could I get a size display ?
--
Dilipan Sebastiampillai
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Update phpMyAdmin.
Santino
At 12:33 + 12-11-2004, Dilipan Sebastiampillai wrote:
Hello,
after restoring from a mysqldump I use phpMyAdmin to view my
database but the size field is unknown ...
how could I get a size display ?
--
Dilipan Sebastiampillai
--
MySQL General Mailing List
For list
Razor Fish mailto:[EMAIL PROTECTED]
on Thursday, October 21, 2004 3:19 PM said:
i need consulting help for optimizing a database with
1.2 million records to handle 3-4 million hits a day.
this is going to be a 'duh' question on my part but i just had to ask
anyway.
my largest table
easily run into billions of records.
J.R.
-Original Message-
From: Chris W. Parker [mailto:[EMAIL PROTECTED]
Sent: Monday, October 25, 2004 3:41 PM
To: [EMAIL PROTECTED]
Subject: OT: table size WAS RE: optimizing database
Razor Fish mailto:[EMAIL PROTECTED]
on Thursday, October 21
and it will not be more than 1 G for sure. I am not sure if
I understood correct or not and would like to hear your suggestion. Is
there any relation between the table size (no of rows and file size)
and the system memory needed to get better performance? i read on web
that its better to have ram more
for sure. I am not sure if I understood correct or not and would like to
hear your suggestion. Is there any relation between the table size (no of
rows and file size) and the system memory needed to get better
performance? i read on web that its better to have ram more than the
largest table size
How do I figure out the physical disk storage size of a table and of the
containing database? I'm using InnoDB. When I look at the directory
through the OS, I see the Ibdata1 file is about 1GB and a
MyServer-bin.06 file that is about 900MB. There are also other -bin
and various log files
Hi,
i read the mysql manual and it's explained the maximum table size in many
operating system, but i can't find the maximum size for MS window (win32),
what's the maximum table size for win32?
My office want to migrate the database server to mysql, and it's contains a
millions record. Can
On Mon, 25 Aug 2003 15:17:25 +0700
Alf Koswara [EMAIL PROTECTED] wrote:
Hi,
i read the mysql manual and it's explained the maximum table size in many
operating system, but i can't find the maximum size for MS window (win32),
what's the maximum table size for win32?
My office want
.
|-Original Message-
|From: Roger Baklund [mailto:[EMAIL PROTECTED]
|Sent: Tuesday, August 05, 2003 6:25 PM
|To: [EMAIL PROTECTED]
|Cc: NEWMEDIAPLAN
|Subject: Re: table size in mysql
|
|
|* NEWMEDIAPLAN
| how many records can i put in a mysql table.
|
|As many as you like, pretty much. The total file
* nm
Is it possible to MERGE innodb tables?
No, MERGE is for MyIsam tables only. InnoDb tables are stored in
tablespaces, the problem with file size does not apply. You simply use
multiple tablespaces when the data outgrows the OS limits.
Can't find docs on mysql.com
hm... mysql.com seems to
* NEWMEDIAPLAN
what variable values /mysql tuning you suggest for more than 2000
potential concurrent users and big tables.
2000 concurrent users is much, at least if you mean 2000 concurrent requests
to the database, as opposed to 2000 concurrent users of a web site. It is
hard to give you a
* NEWMEDIAPLAN
how many records can i put in a mysql table.
As many as you like, pretty much. The total file size could be delimited by
your OS, but this can be dealt with using MERGE tables (splitting a single
table in multiple files) or InnoDB tables (with multiple table spaces).
i need a
hello.
how many records can i put in a mysql table. i need a table with more than
50,000,000 records (just 4 short fields, it's basically a log with
id,action,date,result). What do you think?
thanks in advance!!!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Hello
As i understand it mysql maintains a file for every table created. Does it
mean that the filesystem restricts the maximum size of a given table or do i
have the option to make table data spawn more than on file like in oracle?
Thanks in advance
Mark Vollmann
Mit freundlichen Grüßen,
And the manual says : .
http://www.mysql.com/doc/en/Table_size.html
Jerry
- Original Message -
From: Mark Vollmann [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 02, 2003 9:39 AM
Subject: Maximum table size
Hello
As i understand it mysql maintains a file for every
If your os permits, mysql can handle file sizes up to terabytes. You
don't need to spawn your tables. But you have to be careful when
creating your myisam tables. If you don't specify your table size limit
with the max_rows option when creating table mysql will create a table
with 4G file size
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,
Would anyone be able to confirm that mysqld-max-nt.exe does not have a 4 GB
limitation. I'd like the DB to go up to 40GB and 330 million rows. I am
flexible, I'll use the biggest DB I can create.
ISAM seems to be the obvious choice but would INODB perform better on
inserts for a large DB,
SHOW STATUS (after 24 hrs uptime):
created_tmp_disk_tables = 597
created_tmp_tables = 8893.
SHOW VARIABLES:
tmp_table_size = 33554432.
Does this mean that 597 queries have created a result set in excess of 33MB?
How can I find these rogue queries and optimise them? I could increase the
I have two tables containing a BLOB cloumn as;
-- supposed to be able to handle up to about 16MB
CRETAE TABLE gallery1 (
idINTEGER,
titleVARCHAR(255),
mediumimageMEDIUMBLOB
);
-- supposed to be able to handle up to about 4GB
CRETAE TABLE gallery2 (
idINTEGER,
On 26 Nov 2002, at 8:52, Pae Choi wrote:
Q: How come the size of table does not decrease
after deletion?
MySQL will reuse that space when you insert new records. To recover
the space, you need to optimize the table:
http://www.mysql.com/doc/en/OPTIMIZE_TABLE.html
P.S.: MySQL, SQL,
First of all, thanks for your reply as well as a pointer to the Doc.
I tried the OPTIMIZE command as follows:
mysql optimize table gallery;
mysql optimize table gallery2;
Both does not contain any entry since I deleted the BLOB data.
But the size of tables, gallery.db and gallery2.db does not
Pae,
Tuesday, November 26, 2002, 6:52:20 PM, you wrote:
PC I have two tables containing a BLOB cloumn as;
PC -- supposed to be able to handle up to about 16MB
PC CRETAE TABLE gallery1 (
PC idINTEGER,
PC titleVARCHAR(255),
PC mediumimageMEDIUMBLOB
PC );
PC -- supposed to
no database manager that i know of automatically
packs the database after every record deletion.
it would be too costly.
that is one of the reasons that most of us do not
store blobs in databases, but store them
externally.
I have two tables containing a BLOB cloumn as;
-- supposed to
At 10:36 -0800 11/26/02, Pae Choi wrote:
First of all, thanks for your reply as well as a pointer to the Doc.
I tried the OPTIMIZE command as follows:
mysql optimize table gallery;
mysql optimize table gallery2;
Both does not contain any entry since I deleted the BLOB data.
But the size of
Paul,
It really did the trick. Thanks.
Regards,
Pae
- Original Message -
From: Paul DuBois [EMAIL PROTECTED]
To: Pae Choi [EMAIL PROTECTED]; Keith C. Ivey [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, November 26, 2002 10:59 AM
Subject: Re: [MySQL v3.23.53a] BLOB Data and Table
Hi !
This is my first posting to this group so:
hello to everybody.
I`m using snort (IDS) with logging to MySQL DB. Snort is little bit noisy and it
inserts a lot of datas in DB - about 130MB/4h.
I`m confused about:
is it better to use fs with support more then 2GB files (ext3, ReiserFS (which
Hi !
i forgot to tell You (sorry !) that DB has to be run on linux.
ps. sql,query - included for filter.
greetz
boka
---
Tytus na Dzikim Zachodzie http://tytus.wp.pl/
Which Operating Systems limit MySQL to a 2GB table size?
-
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
work arounds, like the Innodb. I hope this will make you an idea. Leonardo
Javier Beln. AFIP-AR.
- Original Message -
From: Scott Pippin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 12:17 PM
Subject: MySQL Table size
Which Operating Systems limit MySQL to a 2GB
work arounds, like the Innodb. I hope this will make you an idea. Leonardo
Javier Beln. AFIP-AR.
- Original Message -
From: Scott Pippin [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, August 27, 2002 12:17 PM
Subject: MySQL Table size
Which Operating Systems limit MySQL
Scott Pippin wrote:
Which Operating Systems limit MySQL to a 2GB table size?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Tue, 27 Aug 2002, Scott Pippin wrote:
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
Hello,
There are basically two things you should consider:
1) Switch to InnoDB tables and create several data files just under
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Tuesday 27 August 2002 20:05, Scott Pippin wrote:
I found out my AIX box's maximum file size is 2GB. What can I do if I
will have MySQL tables that are possibly over 2GB?
You could either use MERGE tables:
When I create a temp table, If I put to much in it,
I get a Temp Table [Table name] is Full error.
I changed my tmp_table_size to a ver large number.
Still same error, Any Ideas?
This is windows 2000
MySQL 4.01
Config Loaded Form my.ini in winnt dir.
Show Variables for server shows new
Hi Mike,
Possibly out of available memory. (Or disk space assuming that's what
it's hitting)
Mike Grover wrote:
When I create a temp table, If I put to much in it,
I get a Temp Table [Table name] is Full error.
I changed my tmp_table_size to a ver large number.
Still same error, Any
Table size?
Hi Mike,
Possibly out of available memory. (Or disk space assuming that's what
it's hitting)
Mike Grover wrote:
When I create a temp table, If I put to much in it,
I get a Temp Table [Table name] is Full error.
I changed my tmp_table_size to a ver
As show table status doesn't appear to be supported in this older version
I'm using, how did you who used this version get max table size information?
I haven't been to find anything from the list archives/manual about this.
Brian
sql,query
Quoted from http://www.mysql.com/doc/T/a/Table_size.html is:
By default, MySQL tables have a maximum size of about 4G. You can check the
maximum table size for a table with the SHOW TABLE STATUS command or with
the myisamchk -dv table_name. See section 4.5.6 SHOW Syntax.
Gurhan
-Original
will give me the total diskspace occupied by the
table?
Brian
sql,query
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Friday, February 22, 2002 8:58 AM
To: Brian Warn; 'MySQL List'
Subject: RE: 3.22.32: max table size
Quoted from http://www.mysql.com/doc/T
You, like me, are using 3.22 which does not have the myisam table type
(or others for that matter). ISAM I believe, has a lower limit. They do
support sizes less that 4GB (up to the OS file size limits). The three
file extentions total do constitute the total table size, but I believe
PROTECTED],
'MySQL List' [EMAIL PROTECTED]
Subject: RE: 3.22.32: max table size
I did see that reference, but found that myisamchk wasn't an option
either. I did find isamchk is available and have been seeing what
information it is able to provide. I'm wondering now whether summing
Hi guys,
I am not able to insert into the MySQL database
anymore. I think it has reached the table size. How do
i check the size to see if it has reached the table
size? Also let me know how to increase the table size
in case it is reached the limit.
Thanks,
Satish
=
The only person
Satish:
You can see how much space is used (among other things) with a query
like:
show table status from database like 'Syslog';
Increasing the maximum table size is a little more complicated and
depends on what OS and table type you're using.
Eric
-Original Message-
From: Satish
Satish,
Saturday, February 09, 2002, 12:21:06 AM, you wrote:
SS Hi guys,
SS I am not able to insert into the MySQL database
SS anymore. I think it has reached the table size. How do
SS i check the size to see if it has reached the table
SS size? Also let me know how to increase the table
Satish,
Saturday, February 09, 2002, 12:21:06 AM, you wrote:
SS Hi guys,
SS I am not able to insert into the MySQL database
SS anymore. I think it has reached the table size. How do
SS i check the size to see if it has reached the table
SS size? Also let me know how to increase the table
Hi guys,
I am not able to insert into the MySQL database
anymore. I think it has reached the table size. How do
i check the size to see if it has reached the table
size? Also let me know how to increase the table size
in case it is reached the limit.
Thanks,
Satish
=
The only person
Satish:
You can see how much space is used (among other things) with a query
like:
show table status from database like 'Syslog';
Increasing the maximum table size is a little more complicated and
depends on what OS and table type you're using.
Eric
-Original Message-
From: Satish
Hello,
I am using HEAP tables and would like to see how much memory
they use. I found this snipped of instruction in the MySQL-documentation:
--
The memory needed for one row in a HEAP table is:
SUM_OVER_ALL_KEYS(max_length_of_key + sizeof(char*) * 2)
+ ALIGN(length_of_row+1, sizeof(char*))
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
of 4294967295 bytes
on a RAIDED table? do you increase max_rows on such a table? if so,
would this affect the performance of a large table e.g. above 50GB?
Without changing max_rows it seems that MySQL will still restrict the table
size to 4GB, even with raid_chunks and raid_chunksize set to e.g. 50
.
But how do you surpass the Max_data_length restriction of 4294967295 bytes
on a RAIDED table? do you increase max_rows on such a table? if so,
would this affect the performance of a large table e.g. above 50GB?
Without changing max_rows it seems that MySQL will still restrict the table
size to 4GB
__
-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
Hi,
is it right, that the max. size of a table is 4 GB on WindowsOS ?
I am using MySql from a Java - Program for a Log-Database and I get
the Message: The table 'LOG4_FFE' is full.
Is there another way to get around the Problem as using then to use
the MERGE - utility?
I am using My Sql
At 16:58 14/01/2002 +0100, Peter Arnold wrote:
Hi!
Hi,
is it right, that the max. size of a table is 4 GB on WindowsOS ?
I am using MySql from a Java - Program for a Log-Database and I get
the Message: The table 'LOG4_FFE' is full.
For this issue there are two options:
1- Use an OS of the
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
My question is two-fold, first regarding error handing of table size
limitations, and secondly performance and other implications of raid
striping.
I'm building a system with an integrated MySQL database and there is a
potential for filling up tables to the maximum file size for the OS I'm
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 space
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
1 - 100 of 117 matches
Mail list logo
