On Fri, Jun 25, 2010 at 7:11 AM, Prabhat Kumar aim.prab...@gmail.comwrote:
In case MyISAM it will grow up to space on your data drive or the Max size
of file limited by OS..
Not entirely correct. There is some kind of limit to a MyISAM file that has
to do with pointer size - I've encountered
I think you're confusing table size with data base size. The original post
grouped by schema so it appears the question concerns database size. I
don't believe mysql imposes any limits on that. Is there a limit on the
number of tables you can have in a schema imposed by mysql?
On Fri, Jun 25
On Fri, 25 Jun 2010 06:31:11 -0500, Jim Lyons jlyons4...@gmail.com
wrote:
I think you're confusing table size with data base size. The original
post
grouped by schema so it appears the question concerns database size. I
don't believe mysql imposes any limits on that. Is there a limit
I feel like I am missing something, because I am not able to find the
answer to this simple question.
How can I increase the size of a database?
I am using the following query to check the available space and notice
that it is time to increase.
SELECT
table_schema AS 'Db Name',
Round( Sum(
what is the innodb file size that u have specified in my.cnf.
If the last file is autoextend, that this will grow to the size of the disk
space avaliable.
regards
anandkl
On Thu, Jun 24, 2010 at 7:43 PM, Sarkis Karayan skara...@gmail.com wrote:
I feel like I am missing something, because I am
What do you mean time to increase? What tells you that?
A database's size is determined by the amount of available diskspace. If
you need more than the filesystem that it is currently on has, then you can
either move the entire schema (which is synonymous to database) to another
filesystem and
There is 2 way to check databases size :
A. OS level, you can do *#du -hs *of data dir , it will show current usages
of you database size at File system level.
B. You can also check on Database level check details
herehttp://adminlinux.blogspot.com/2009/12/mysql-tips-calculate-database
Are there any publicly available data on how the size of some (or better
yet, many) particular real database(s) changed over time (for a longish
period of time)? How about data on how the throughput (in any interesting
terms) varied over time?
Thanks,
Mike Spreitzer
Hi,
I would like to ask about the size that can be handled by mysql. How big if I
use innoDB? How big with myISAM?
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Eko Budiharto wrote:
Hi,
I would like to ask about the size that can be handled by mysql. How big if I
use innoDB? How big with myISAM?
Quoting from the manual 65536 terabytes
http://dev.mysql.com/doc/refman/5.0/en/table-size.html
Try 5 minutes of searching the manual next
Hello
I have inherited an INNODB database. I am new to MySQL and may not be
describing my problem correctly so any suggestions or questions are welcome.
I have data files named ib_data_00 through ib_data_14 all of which are 2.0G.
I also have ib_data_15 which is 26G. I am receiving errors saying
Todd
you need to look at how InnoDB is configured and learn a bit about how Innodb
uses and manages its tablespace. if you look in the my.ini options file you
should see how innodb is set up for your installation. Take a look at the
link below that explains how InnoDB can be set up:
Look at your my.cnf for a configuration directive called
'innodb_data_file_path'. This is where you configure the files for the
innodb table space. The last one is probably an auto-grow. My guess is that
every time it complains, it's just added 8MB to the file. If you remove the
auto-grow (and I
Hi All,
We used to use Interbase which required a new file to be assigned for every
4 gig of data stored in a DB.
Is there any issues like this in mySQL?
Thanks,
Jim
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
PROTECTED]
Subject: Any limits on Database Size?
Hi All,
We used to use Interbase which required a new file to be
assigned for every 4 gig of data stored in a DB. Is there
any issues like this in mySQL?
Thanks, Jim
--
MySQL General Mailing List
For list archives: http
Hello Everyone,
Hopefully easy question,
What is the Max size of a MySQL server database?
I have a database, which is more than 120GB with about 500 million
records. MySQL works well.
Andrew stolarz wrote:
Hello Everyone,
Hopefully easy question,
What is the Max size of a MySQL server database?
--
Chenzhou Cui
Andrew stolarz wrote:
Hello Everyone,
Hopefully easy question,
What is the Max size of a MySQL server database?
The answer to that question depends more on your OS than mysql. A quick
search of the contents page of the documentation clearly list the
limitations of this kind.
--
Chris W
I have data from two different sources that I would like to store in a mysql
database. Dataset_1 has pieces of information A, B, and C (let's say first,
middle, and last name) and Dataset_2 has pieces of information A, B, C, and D
(first, middle, last names and a DOUBLE value).
Dataset_1 has 9.5
Robert Crowell wrote:
However, if the table was created with columns A, B, C, and D, most of the
entries in the D column will be NULL. Is this considered 'good form'? Even
though these entries are all NULL, they will still consume the disk space that
a DOUBLE will, correct?
I can't find it
Robert Crowell wrote:
I have data from two different sources that I would like to store in a mysql
database. Dataset_1 has pieces of information A, B, and C (let's say first,
middle, and last name) and Dataset_2 has pieces of information A, B, C, and D
(first, middle, last names and a DOUBLE
I think the answer to this is You can't. So I guess what I can do is run a
query once every while and get the sizes of all the databases and if any
exceeds a predetermined size, revoke insert and update privilages.
What's is the SQL query like to get a database size and the SQL to get
If you are on 5.0.n there is an INFORMATION_SCHEMA which you can query
like this. A casual scan of the mysql tables don't show any sizes and I
don't know of a way to get table/database size via SQL.
mysql select table_schema, sum(DATA_LENGTH) from
information_schema.tables group by 1
Selon Gordon Bruce [EMAIL PROTECTED]:
If you are on 5.0.n there is an INFORMATION_SCHEMA which you can query
like this. A casual scan of the mysql tables don't show any sizes and I
don't know of a way to get table/database size via SQL.
mysql select table_schema, sum(DATA_LENGTH) from
On 06.02.2005 05:26 (+0100), Mark Webber wrote:
What version of Windows? XP and Windows 2000, 2003 have built-in Quota
functions if you are using NTFS. Right click on the drive, choose
properties, click on the Quota tab.
That won't help him, and he know I think.
You can limit the folder
I need to limit my users' databases size. In Linux, you can control the
folder size but I can't do this under Windows unless I use expensive third
party quota manager programs.
Is there any way to limit the database size? I find this feature seriously
lacking.
Salama
--
MySQL General Mailing
Balazs Miklos [EMAIL PROTECTED] wrote:
I would like to limit database sizes on my server on a per user basis.
I haven't really found any information about this in the manual, neither
in the list archive or on the web.
Is there a way to do this?
No.
--
For technical support
Hello,
I would like to limit database sizes on my server on a per user basis.
I haven't really found any information about this in the manual, neither
in the list archive or on the web.
Is there a way to do this?
If mysql doesn't support this natively, is there maybe a third party
patch?
Hello.
I have quite big database - around 15Gb(~ 180 million of rows).
My problem is that after deleting 70million of rows(with 'delete from'
statement) database file size didn't decrease - it's still 15Gb.
Can anybody give me advice, what i'm doing wrong, why db size is the
same after deleting
Ruslan Spivak [EMAIL PROTECTED] wrote on 21/06/2004 12:22:04:
I have quite big database - around 15Gb(~ 180 million of rows).
My problem is that after deleting 70million of rows(with 'delete from'
statement) database file size didn't decrease - it's still 15Gb.
Can anybody give me advice,
At 23:32 +0530 4/28/04, [EMAIL PROTECTED] wrote:
Hi,
I am trying to insert the records in the database. After the insertion of
3millions records, it fails to insert the records further. Can someone help
me in this problem. How do I go and increase the capacity of the database.
Moreover if someone
Hi,
Unless he is having some weird nightmare that doesn't involve reality, then I am
pretty sure he is talking about this in the my.cnf:
innodb_data_file_path = ibdata1:400M:autoextend
A while back I remember that the autoextend was not in the sample my.cnf files. I
think this was around
If you are getting table full error,may be your table
size is exceeding the maximum default size allowed.
check the table size and default size.
You can change the maximum size of the table using
Alter table command.
Somthing like following,but it is better so back up
the database before doing
Hi,
I am trying to insert the records in the database. After the insertion of
3millions records, it fails to insert the records further. Can someone help
me in this problem. How do I go and increase the capacity of the database.
Moreover if someone can provide me the maximum size of the
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 28, 2004 2:02 PM
Subject: urgent: how to increase the database size
[snip]
Moreover if someone can provide me the maximum size of the database which
is possible.
Have you tried looking
Hi,
I'm planning to use MySQL for logging from an SMTP-Relay.
What is the maximum size of the database, that can be reached?
Stefan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Baum, Stefan [EMAIL PROTECTED] wrote:
Hi,
I'm planning to use MySQL for logging from an SMTP-Relay.
What is the maximum size of the database, that can be reached?
Table size (for MyISAM/ISAM tables) and number of tables per database is limited by
your filesystem.
--
For technical
Stefan,
it depends ...
For MyISAM tables max size is limited by the maximum filesize of your
OS/Filesystem.
Regards,
Thomas
On Fri, 12 Mar 2004, Baum, Stefan wrote:
Hi,
I'm planning to use MySQL for logging from an SMTP-Relay.
What is the maximum size of the database, that can be
Stefan,
it depends ...
For MyISAM tables max size is limited by the maximum filesize of your
OS/Filesystem.
Following on from that, the maximum file size you can have on 32-bit Linux is 2GB,
unless your distro has LFS (Large File Support),
in which case is is much larger (terabytes, not
our database is about 20 Gb and growing daily. so far, I still see
nearly constant time query performance on tables with ~10M rows. I
don't think mysql is limited by file size per se.
I guess performance depends a lot on what your tables look like, and
your hardware, obviously. From my own
On Thu, Nov 06, 2003 at 05:08:54PM -0700, Jeff Mathis wrote:
our database is about 20 Gb and growing daily. so far, I still see
nearly constant time query performance on tables with ~10M rows. I don't
think mysql is limited by file size per se.
It is limited to the extent that your operating
We're talking about storing binary files (images) inside a MySQL database
to take advantage of the granularity and control we get over file access
that way.
But we already have 1.5GB, and that could lead to a very large database
very quickly.
What are people's experiences with large MySQL
our database is about 20 Gb and growing daily. so far, I still see
nearly constant time query performance on tables with ~10M rows. I don't
think mysql is limited by file size per se.
Ari Davidow wrote:
We're talking about storing binary files (images) inside a MySQL database
to take
' are in bytes and
added together would make the disk size that that table
is using up?
Thanks a bunch
Dan
-Original Message-
From: Dan Muey
Sent: Wednesday, July 30, 2003 4:24 PM
To: [EMAIL PROTECTED]
Subject: RE: Finding Table and database size
Is this even
]
|
| cc:
|
| Subject: RE: Finding Table and database size
Dan
What you may be looking for (and I had to hunt around to find it myself!)
is
myisamchk -eis table_name
Hope that helps - just because you don't get an answer doesn't mean we
don't care - it probably means we don't know.
Terry
--Original Message-
Ok, if this is
: Terry Riley [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 31, 2003 10:16 AM
To: [EMAIL PROTECTED]
Subject: RE: Finding Table and database size
Dan
What you may be looking for (and I had to hunt around to find
it myself!)
is
myisamchk -eis table_name
Hope that helps - just
Hello Dan,
Probably the reason that no-one has replied to you is that
on-one feels that they have anything helpful to add to what
you already know. A quick check on my system shows that the
data and index sizes reported by SHOW TABLE STATUS are the
same as the byte sizes of the MYD and
Howdy List!
A couple questions about finding the disk space used by a table/database:
1) First how can I get the size a table is taking up on disk?
Is it the 'Data_length' field in: SHOW TABLE STATUS FROM db_name LIKE 'wild';??
If so how can I do a query like the one above
Is this even possible with mysql then?
Howdy List!
A couple questions about finding the disk space used by a
table/database:
1) First how can I get the size a table is taking up on disk?
Is it the 'Data_length' field in: SHOW TABLE STATUS
FROM db_name LIKE 'wild';??
To: [EMAIL PROTECTED]
Subject: RE: Finding Table and database size
Is this even possible with mysql then?
Howdy List!
A couple questions about finding the disk space used by a
table/database:
1) First how can I get the size a table is taking up on disk?
Is it the 'Data_length
Dear Friends
First thanx for all of to ans me but
I feel that i put the question in wrong way.
Actually i created 5 databases other than default one that is mysql and test
I created the 5 different database for my client and i want to resitrct them for
particulary size limt.
So is this
Hello friends
I am using mysql on Suse linux 7.1
my mysql data partition is of on reiserfs filesystem.
Can anybody tell me, How i can resitrict database
size?
Is their any possibility that i can specify the
maximum size of database.
Thanx in advance
mysql user, but that's out of my experience.
-jeff
On Thu, 2003-03-27 at 05:55, sunil sharma wrote:
Hello friends
I am using mysql on Suse linux 7.1
my mysql data partition is of on reiserfs filesystem.
Can anybody tell me, How i can resitrict database
size?
Is their any possibility
: database size
Hello friends
I am using mysql on Suse linux 7.1
my mysql data partition is of on reiserfs filesystem.
Can anybody tell me, How i can resitrict database
size?
Is their any possibility that i can specify the
maximum size of database.
Thanx in advance
footprint).
Check this document out
http://www.mysql.com/doc/en/Table_types.html
-Original Message-
From: sunil sharma [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 3:56 AM
To: [EMAIL PROTECTED]
Subject: database size
Hello friends
I am using mysql on Suse linux 7.1
On Thu, Mar 27, 2003 at 12:17:45PM -0800, Dathan Vance Pattishall wrote:
ISAM tables are cut off at 4gb of data
No, they aren't. I have a 9GB MyISAM table here. By using a MAX_ROWS
specifier, you can suggest that MySQL use larger row pointers (more
than 4 bytes).
MYISAM / INNODB /BDB have a
not an irrelevant consideration.
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 27, 2003 12:30 PM
To: Dathan Vance Pattishall
Cc: [EMAIL PROTECTED]
Subject: Re: database size
On Thu, Mar 27, 2003 at 12:17:45PM -0800, Dathan Vance Pattishall wrote:
ISAM tables
On Thu, Mar 27, 2003 at 02:35:18PM -0600, Jeff Kilpatrick wrote:
It's also interesting to note that it's possible to split innodb data
between multiple files to have databases larger than the OS's max file
size.
The theoritical maximum table size for the various storage engines is:
BDB
On Tuesday 18 February 2003 04:26, KH Chiu wrote:
I am planning to offer a free service that allow users to use my server to
learn php and MySQL. I am a bit worry about if one of users (either
intentionally or unintentionally) get into infinite loop with insert
statement. It will quickly eat
Thank you very much for your information. Can you tell me more how to limit
size of directory in Linux? I can only set quota for users or groups but not
for directory.
Thank you very much.
On Tuesday 18 February 2003 04:26, KH Chiu wrote:
I am planning to offer a free service that allow
Thank you very much for your information. I have encountered another problem
if I use this approach. The problem is I can change the database directory to
another group which has quota. However, whatever mysql create new table, it
will use its configrated group (namely 'mysql' in Redhat default
JvdW,
Tuesday, July 09, 2002, 3:03:17 PM, you wrote:
J I have a quick newbie question. How would I limit the size a database can grow
J to in mysql? Let's say I want to limit my database to 20MB. How would I do
J this? Would this be done on a user level or the actual database?
You can't do it
Alexander,
Friday, May 17, 2002, 12:37:36 AM, you wrote:
AN I like to limit the size of a database (or if possible all databases of a
AN mysql user) to some value. It should work like the disk quota for disk
AN space.
You can't do it with MySQL, use disk quotas ...
AN Thanks for any hints,
AN
Hello,
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 1:42 PM
Subject: Re: How to limit database size?
[how to limit database size?]
You can't do it with MySQL, use disk quotas ...
Thanks for your answer.
What happens
-Original Message-
From: Alexander Newald [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 17, 2002 11:29 AM
To: mySQL Mailing list
Subject: Re: How to limit database size?
Hello,
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 1:42 PM
Hello Alexander,
Friday, May 17, 2002, 6:13:15 PM, you wrote:
Alexander, send your questions in mail-list!
You can't do it with MySQL, use disk quotas ...
AN Thanks for your answer.
AN What happens if a user tries to add more data to a table after the files
AN containing his database reached
At 10:28 AM 5/17/2002, you wrote:
Hello,
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, May 17, 2002 1:42 PM
Subject: Re: How to limit database size?
[how to limit database size?]
You can't do it with MySQL, use disk quotas ...
Thanks
Hello,
I like to limit the size of a database (or if possible all databases of a
mysql user) to some value. It should work like the disk quota for disk
space.
Thanks for any hints,
Alexander Newald
-
Before posting, please
I am new to MySQL to begin with. I am running syslog messages to a DB. It
sends anywhere from 3500 to 5600 per minute. I then use PHP to look at the
data. The DB machine is a Dual 1Ghz processor with 1Gb Ram. The problem is
the speed of lookups. The DB has about 7 million rows and is continually
JC Pretty much as the subject states, I am not a member of this list yet, as I
JC am sure my mail server cant handle the amont of messeges that come through
JC so please reply directly at [EMAIL PROTECTED]
JC I need to limit the max size of a database in MySql that is created for a
JC user on a
Pretty much as the subject states, I am not a member of this list yet, as I
am sure my mail server cant handle the amont of messeges that come through
so please reply directly at [EMAIL PROTECTED]
I need to limit the max size of a database in MySql that is created for a
user on a
few levels...
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:
On Fri, Oct 19, 2001 at 07:22:20AM -0500, [EMAIL PROTECTED] wrote:
Is there away to control the max size of each database create by
user. I mean built into MySQL??
There is not.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454
, October 20, 2001 1:50 PM
Subject: Re: Control Database size
On Fri, Oct 19, 2001 at 07:22:20AM -0500, [EMAIL PROTECTED] wrote:
Is there away to control the max size of each database create by
user. I mean built into MySQL??
There is not.
--
Jeremy D. Zawodny, [EMAIL PROTECTED]
Technical
Is there away to control the max size of each database create by user. I mean
built into MySQL??
Mike(mickalo)Blezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Tel: 1(225)686-2002
Date |Fri, 3 Aug 2001 17:21 +0200
From |TIGNAC BRUNO [EMAIL PROTECTED]
Hello!
TB --- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21
TB Hello,
TB I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One
TB of the tables is over 5 GB, and a second
Hi!
At 02:59 PM 8/7/01 +0300, you wrote:
Grigory Bakunov writes:
Date |Fri, 3 Aug 2001 17:21 +0200
From |TIGNAC BRUNO [EMAIL PROTECTED]
Hello!
TB --- Reçu de CMB.TIGNABR 0298426574 03-08-01
17.21
TB Hello,
TB I plan to use MySQL/InnoDB to store about 13 GB
--- Reçu de CMB.TIGNABR 0298426574 03-08-01 17.21
Hello,
I plan to use MySQL/InnoDB to store about 13 GB of data, into 40 tables. One
of the tables is over 5 GB, and a second over 1,5 GB. Do you think I can use
MySQL/InnoDB ?
Thank you.
Bruno Tignac
03-08-01
I hate to ask this on the list, but I have tried everything to unsubscribe
and nothing works. Any suggestions?
Thanks.
-Original Message-
From: TIGNAC BRUNO [EMAIL PROTECTED]
To: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Friday, August 03, 2001 11:00 AM
Subject: [MySQL] Database size
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
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
I need a way to determine the size of a single database on mySQL via an SQL
command.
I am running an application on a service provider that gives me a limited
amount of database space for my application. I want to be able to gauge the
percentage of that space that I am using. The only access
If you are using only fixed-length (no VARCHARs, TEXTs or BLOBs) MyISAM
tables you can calculate it by finding the storage required for each row
(http://www.mysql.com/doc/S/t/Storage_requirements.html) and multiplying it
by the number of rows. If you are using variable-length MyISAM tables, you
Hi,
I have a problem, my database has reached Linux Redhat 7.1
max file size. (2147483647 Bytes). Does eny one know what i
can do to make a lager database. (lager
filesystem)
Thanks
Erik Dhiin
I myself run a 300Gb database on a Linux redhat 6.0 Machine.
And it works
Erik,
You mentioned 40Gig files on Intel platform -
what OS/DBMS did you use then? How about the performance?
Thanks,
Vadim.
Terry Katz wrote:
Erik,
If your running Linux on an Intel machine (which I assume it is), then
you've hit Linux's limit for IA32 and 2.2.x kernels .. If you want
Hi,
I have a problem, my database has reached Linux Redhat 7.1 max file
size. (2147483647 Bytes).
Does eny one know what i can do to make a lager database. (lager
filesystem)
Thanks
Erik Dhiin
-
Before posting, please
Erik,
If your running Linux on an Intel machine (which I assume it is), then
you've hit Linux's limit for IA32 and 2.2.x kernels .. If you want to go
with sizes higher then 2gig you need to upgrade to a 2.4 kernel (and the
latest GNU Libc) .. I've had (not mysql databases) 40gig files on Intel
Hi.
First, there is somewhere a chapter about disk usage in the manual
(too lazy to look it up).
On Fri, Feb 09, 2001 at 09:51:03AM -0500, [EMAIL PROTECTED] wrote:
I was wondering if someone could help advise me on calculating
database size estimations. Assume the following table:
Field
1 - 100 of 102 matches
Mail list logo