Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: How to add Data file in mysql ?
Thread ID: 345106 Message ID: 345193 # Views: 27 # Ratings: 0
Version: Unknown Category: Databases, Tables and SQL Server
Date: Sunday, May 20, 2012 5:22:56 AM         
   


> >
> > Thanks Pete :) ,
> > This means it is regarding about physical hdd Option . I was in wrong impression that this option will create extra space for my Mysql data :-P . Where i was working before 31 march as Edp Inchage we have banking software which have d2k as front end and oracle as back end and Linux server the some time increase oracle table space . So i thought that its related with that .
> >
> > So still my query is , Can i increase the data table space of mysql ?
> >
> >
> > regards
> > Anand S. Kulkarni
> >
> > When it rains ... all Birds occupy shelter , but Eagle is the only bird with its capacity to fly over the sky to avoid rains !!!
>
> Hi Anand,
> Yes you can increase the data file size, but if you have to checked off as "Auto-extending" then why would you as mySQL server will pe4rform this automatically by itself.
>
> The easiest way to increase the size of the InnoDB tablespace is to configure it from the beginning to be auto-extending. Specify the autoextend attribute for the last data file in the tablespace definition. Then InnoDB increases the size of that file automatically in 8MB increments when it runs out of space. The increment size can be changed by setting the value of the innodb_autoextend_increment system variable, which is measured in MB.
>
> Alternatively, you can increase the size of your tablespace by adding another data file. To do this, you have to shut down the MySQL server, change the tablespace configuration to add a new data file to the end of innodb_data_file_path, and start the server again.
>
> If your last data file was defined with the keyword autoextend, the procedure for reconfiguring the tablespace must take into account the size to which the last data file has grown. Obtain the size of the data file, round it down to the closest multiple of 1024 × 1024 bytes (= 1MB), and specify the rounded size explicitly in innodb_data_file_path. Then you can add another data file. Remember that only the last data file in the innodb_data_file_path can be specified as auto-extending.
>
> Pete "the IceMan", from the Great White North of Canada.
> www.marathongriffincomputers.com

Pete , Exactly i want this information :) . thanks for shareing this with me and my ratings to you .

regards
Anand S. Kulkarni

When it rains ... all Birds occupy shelter , but Eagle is the only bird with its capacity to fly over the sky to avoid rains !!!

ENTIRE THREAD

How to add Data file in mysql ? Posted by anand kulkarni @ 5/18/2012 11:02:53 AM
RE: How to add Data file in mysql ? Posted by Pete Sass @ 5/18/2012 3:25:31 PM
RE: How to add Data file in mysql ? Posted by anand kulkarni @ 5/18/2012 3:59:15 PM
RE: How to add Data file in mysql ? Posted by Pete Sass @ 5/18/2012 5:15:55 PM
RE: How to add Data file in mysql ? Posted by anand kulkarni @ 5/19/2012 11:07:29 AM
RE: How to add Data file in mysql ? Posted by Pete Sass @ 5/19/2012 7:50:45 PM
RE: How to add Data file in mysql ? Posted by anand kulkarni @ 5/20/2012 5:22:56 AM