Re: Altering database size to add more space

2010-06-25 Thread Carsten Pedersen
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

Re: Altering database size to add more space

2010-06-25 Thread Jim Lyons
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

Re: Altering database size to add more space

2010-06-25 Thread Johan De Meersman
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

Re: Altering database size to add more space

2010-06-24 Thread Prabhat Kumar
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-

Re: Altering database size to add more space

2010-06-24 Thread Jim Lyons
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

Re: Altering database size to add more space

2010-06-24 Thread Ananda Kumar
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

Altering database size to add more space

2010-06-24 Thread Sarkis Karayan
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

Public history of database size, throughput?

2010-06-04 Thread Mike Spreitzer
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

Re: database size

2006-06-08 Thread Chris W
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.

database size

2006-06-08 Thread Eko Budiharto
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

Re: INNODB database size

2006-04-25 Thread Gary Richardson
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

Re: INNODB database size

2006-04-25 Thread Pure Web Solution
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.

INNODB database size

2006-04-25 Thread Todd Smith
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

Re: Any limits on Database Size?

2006-04-10 Thread mysql
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 --

Any limits on Database Size?

2006-04-10 Thread 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

Re: max Mysql database size

2005-09-14 Thread 2wsxdr5
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

Re: max Mysql database size

2005-09-14 Thread Chenzhou Cui
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

max Mysql database size

2005-09-14 Thread Andrew stolarz
Hello Everyone, Hopefully easy question, What is the Max size of a MySQL server database?

Re: NULL and database size

2005-08-19 Thread Devananda
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

Re: NULL and database size

2005-08-19 Thread Keith Ivey
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

NULL and database size

2005-08-19 Thread Robert Crowell
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

RE: How to control database size in MySQL Windows?

2005-06-10 Thread mfatene
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

RE: How to control database size in MySQL Windows?

2005-06-10 Thread Gordon Bruce
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

How to control database size in MySQL Windows?

2005-06-10 Thread Salama hussein
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

Re: How to limit database size under Windows?

2005-02-06 Thread Salama hussein
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

Re: How to limit database size under Windows?

2005-02-06 Thread Yves Goergen
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

Re: How to limit database size under Windows?

2005-02-05 Thread Mark Webber
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

How to limit database size under Windows?

2005-02-05 Thread Salama hussein
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

Re: per user database size quota

2004-09-07 Thread Egor Egorov
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

per user database size quota

2004-09-06 Thread Balazs Miklos
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.

Re: database size

2004-06-21 Thread Alec . Cawley
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

database size

2004-06-21 Thread Ruslan Spivak
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

Re: urgent: how to increase the database size

2004-04-29 Thread kamlesh pandey
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

Re: urgent: how to increase the database size

2004-04-29 Thread Eric
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

Re: urgent: how to increase the database size

2004-04-29 Thread Paul DuBois
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

Re: urgent: how to increase the database size

2004-04-28 Thread Rhino
- 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

urgent: how to increase the database size

2004-04-28 Thread amahansaria
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

Re: Maximum Database size

2004-03-12 Thread Alex Greg
> 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

Re: Maximum Database size

2004-03-12 Thread Thomas Spahni
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

Re: Maximum Database size

2004-03-12 Thread Egor Egorov
"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

Maximum Database size

2004-03-12 Thread Baum, Stefan
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]

Re: practical MySQL database size limits

2003-11-10 Thread Eric Jain
> 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

Re: practical MySQL database size limits

2003-11-08 Thread Jeremy Zawodny
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

Re: practical MySQL database size limits

2003-11-06 Thread Jeff Mathis
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

practical MySQL database size limits

2003-11-06 Thread Ari Davidow
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

RE: Finding Table and database size

2003-07-31 Thread Dan Muey
> 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

RE: Finding Table and database size

2003-07-31 Thread Dan Muey
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

RE: Finding Table and database size

2003-07-31 Thread Terry Riley
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

RE: Finding Table and database size

2003-07-31 Thread Alec . Cawley
| To: <[EMAIL PROTECTED]> | | cc: | | Subje

RE: Finding Table and database size

2003-07-31 Thread Dan Muey
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 > >

RE: Finding Table and database size

2003-07-30 Thread Dan Muey
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: > > >

RE: Finding Table and database size

2003-07-30 Thread Dan Muey
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';?? >

Finding Table and database size

2003-07-30 Thread Dan Muey
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

Re: database size

2003-03-28 Thread sunil sharma
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

Re: database size

2003-03-27 Thread Zak Greant
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

Re: database size

2003-03-27 Thread Jeremy Zawodny
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

RE: database size

2003-03-27 Thread Dathan Vance Pattishall
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

Re: database size

2003-03-27 Thread Jeremy Zawodny
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

RE: database size

2003-03-27 Thread Jeff Kilpatrick
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

RE: database size

2003-03-27 Thread Dathan Vance Pattishall
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

Re: database size

2003-03-27 Thread Jeff Kilpatrick
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

database size

2003-03-27 Thread sunil sharma
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

Re: Limit the database size

2003-02-18 Thread KH Chiu
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

re: Limit the database size

2003-02-18 Thread KH Chiu
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

re: Limit the database size

2003-02-18 Thread Victoria Reznichenko
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

Limit the database size

2003-02-17 Thread KH Chiu
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

Re: Controlling a database size

2002-07-10 Thread Victoria Reznichenko
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

Controlling a database size

2002-07-09 Thread JvdW
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 ---

Re: How to limit database size?

2002-05-17 Thread mos
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?

Re: Re: Re: How to limit database size?

2002-05-17 Thread Egor Egorov
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

RE: How to limit database size?

2002-05-17 Thread Gurhan Ozen
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

Re: How to limit database size?

2002-05-17 Thread Alexander Newald
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 ...

Re: How to limit database size?

2002-05-17 Thread Egor Egorov
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,

How to limit database size?

2002-05-16 Thread Alexander Newald
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

Database size

2002-05-15 Thread Bennie Warren
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

How do you limit the maximun database size for a group of users?

2002-01-21 Thread Victoria Reznichenko
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

How do you limit the maximun database size for a group of users?

2002-01-20 Thread Jef Card
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...

Re: Database Size Limit

2002-01-17 Thread Jeremy Zawodny
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

Re: Database Size Limit

2002-01-14 Thread Aaron Brick
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

Re: Database Size Limit

2002-01-13 Thread Heikki Tuuri
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

Re: Database Size Limit

2002-01-12 Thread Benjamin Arai
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

Re: Database Size Limit

2002-01-12 Thread Benjamin Arai
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.

Re: Database Size Limit

2002-01-11 Thread James Montebello
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

Re: Database Size Limit

2002-01-11 Thread Aaron Brick
> 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

Re: Database Size Limit

2002-01-11 Thread James Montebello
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

Re: Database Size Limit

2002-01-11 Thread Demirchyan Oganes-AOD098
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

Re: Database Size Limit

2002-01-10 Thread Dan Nelson
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

Database Size Limit

2002-01-10 Thread Manish Mehta
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:/

Re: Control Database size

2001-10-20 Thread Barbara Ferrell
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

Re: Control Database size

2001-10-20 Thread Jeremy Zawodny
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-

Control Database size

2001-10-19 Thread mickalo
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 =-=-=-=-=-=-=-=-

Re: [MySQL] Database size

2001-08-07 Thread Heikki Tuuri
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

Re: [MySQL] Database size

2001-08-06 Thread Grigory Bakunov
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

Re: [MySQL] Database size

2001-08-03 Thread Gene Sanborn
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

[MySQL] Database size

2001-08-03 Thread TIGNAC BRUNO
--- 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.

Re: Database size limit

2001-06-19 Thread VVM Ravikumar Sarma Chengalvala
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

Re: Database size limit

2001-06-18 Thread Ali Kemal YURTSEVEN
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

Re: Database size limit

2001-06-18 Thread VVM Ravikumar Sarma Chengalvala
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

Database size limit

2001-06-18 Thread Ali Kemal YURTSEVEN
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

RE: Determining Database size via SQL

2001-05-28 Thread Chris Bolt
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   2   >