Re: urgent: how to increase the database size - Eric - com.mysql.lists.mysql

5 messages in com.mysql.lists.mysqlRe: urgent: how to increase the datab...

From	Sent On	Attachments
amah...@hss.hns.com	28 Apr 2004 11:01
Rhino	28 Apr 2004 13:38
Paul DuBois	29 Apr 2004 08:29
Eric	29 Apr 2004 08:57
kamlesh pandey	29 Apr 2004 09:50

Subject:	Re: urgent: how to increase the database size
From:	Eric (ef...@kwinternet.com)
Date:	04/29/2004 08:57:02 AM
List:	com.mysql.lists.mysql

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 or something like that. So in that case, if you don't have autoextend, you could have a db with a max
size.

Or maybe he is just running out of disk space :)

Thanks,

Eric

At 08:29 AM 4/29/2004, Paul DuBois wrote:

At 23:32 +0530 4/28/04, amah...@hss.hns.com 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 can provide me the maximum size of the database which is possible.

Databases don't have a maximum size.

You'll probably get a better answer if you provide information more specific than "it fails." For example, do you get an error message? If so, what is it?