Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: anand kulkarni
  Where is anand kulkarni?
 sholapur
 India
 anand kulkarni
 Tags
Subject: RE: How to add Data file in mysql ?
Thread ID: 345106 Message ID: 345181 # Views: 36 # Ratings: 1
Version: Unknown Category: Databases, Tables and SQL Server
Date: Saturday, May 19, 2012 7:50:45 PM         
   


> >
> >
> > Hi Anand,
> >
> > OK now I think I know what you are after. In mySQL server you can have your data split into more that one data file. Generally speaking let say you are running out of room in a hard drive partition and your mySQL Server database data file resides in this partition. You have three possible options to make more room if you are running out of hard drive disk space:
> >
> > 1. You use a partition manager such as "EASEUS Partition Master 8" or another partition manager and re-size the partition where your mySQL data file resides and make the partition bigger, shrinking another partition that has more free space.
> >
> > 2. You install a secondary hard drive in your server, format it and then go into the InnoDB Manager and create a second data file and target the new hard drive you just installed in the server. Set this new data file so it grows automatically. For full instructions on how to setup and configure this please review in full the following link: http://dev.mysql.com/doc/refman/4.1/en/innodb-configuration.html
> >
> > 3. You do have one other option if you are installing a second hard drive. Install the new hard drive and format it. Then shutddown mySQL and copy the database files into a folder on your new hard drive with lots of drive space. Now in the InnoDB Manager target the new drive and folder location for your mySQL server database files upon startup. In this scenario you still have only 1 mySQL server data file, but now relocated into a hard drive partition with lost of growth space.
> >
> > In looking at all the options above I would probably go with option 3 as hard drives are cheap.
> >
> > Note: Always perform a full database backup prior to performing these kinds of administrative tasks and of course perform these kinds of things off-line in non-working hours.
> >
> > Pete "the IceMan", from the Great White North of Canada.
> > www.marathongriffincomputers.com
>
> 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

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