On Fri, 25 Jun 2010 06:31:11 -0500, Jim Lyons
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 lim
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 F
On Fri, Jun 25, 2010 at 7:11 AM, Prabhat Kumar wrote:
> 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 it several years a
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
here<http://adminlinux.blogspot.com/2009/12/mysql-tips-calculate-database-
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 a
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 wrote:
> I feel like I am missing something, because I am not able to find t
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( d
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
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 time.
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
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 ca
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:
http://dev.
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
m: Jim <[EMAIL 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
--
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:http://lists.mysql.com/[EMAIL
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 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 (Chi
Hello Everyone,
Hopefully easy question,
What is the Max size of a MySQL server database?
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 val
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 i
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
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 t
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.tabl
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 an
up, and if you have hundreds of databases, it will need to
run against all these databases. I am not sure if this check is cpu/time
consuming or fast. I also use MS SQL Server which can limit database size
and I am dissapointed that MySQL can't.
Salama
--
MySQL General Mailing List
For
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 s
Salama hussein wrote:
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 lackin
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 Gener
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 con
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?
Thanks.
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 adv
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 a
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 thi
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 4.0.1
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
- 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.
>
H
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 databa
> 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, n
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 re
"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 techn
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]
> 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 e
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
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 advan
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 data
> 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 M
e-
> From: 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
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 th
| To: <[EMAIL PROTECTED]>
|
| cc:
|
| Subje
nd 'Index_length' 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
> >
nesday, July 30, 2003 4:24 PM
> 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:
> >
>
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';??
>
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
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 possibl
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 Thu, Mar 27, 2003 at 12:54:49PM -0800, Dathan Vance Pattishall wrote:
> ISAM tables have a 4GB limit myISAM tables do not have a filesize limit.
> There is a big difference between ISAM and myISAM.
Ah, okay. I read ISAM as MyISAM. Sorry. :-(
Who's still using ISAM anyway? :-)
Jeremy
--
Jer
ot 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:
> ISA
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
emory table and specify the memory max
> 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
bject: 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 ad
your 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 dat
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
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
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 allo
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 e
Dear all,
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 up the disk space and make my server
unfu
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
Greetings all
I have a quick newbie question. How would I limit the size a database can grow
to in mysql? Let's say I want to limit my database to 20MB. How would I do
this? Would this be done on a user level or the actual database?
--
l8r
./JvdW
---
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?
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 rea
urhan
-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]>
S
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 ...
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,
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 c
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
g
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 o
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 soluti
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 restrict
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 problem
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.
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 settin
> 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
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 h
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 have
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 big
a file your OS can handle.
--
Dan
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:
http:/
t;[EMAIL PROTECTED]>
Sent: Saturday, 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??
&g
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-
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
=-=-=-=-=-=-=-=-
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/I
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 sec
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: [MyS
--- 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 17.
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
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 Ravikum
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
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 ch
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
sh
1 - 100 of 112 matches
Mail list logo