Hello, first things first, you cann't resize your datafiles without shutting down your database. if it's ok with you, have a look at http://www.mysql.com/doc/en/Adding_and_removing.html
you may want to have a look at you my.cnf file, stored in mysql data dir or in /etc dir, for the default options specified there fo the datafile with: innodb_data_file_path Yes, you can add data file, just add another entry to above option. option entry is self-explainatory. At last, ibdata1, ibdata2.... are actual data files used to store actual data. one or more of these files are attached to one tablespace and one file cant span across tablespaces. ib_logfile0, ib_logfile1 are log files, which are used to log sql statements applied to database. these files are used to restore data in case of any crash or mishap. for further info, have a look at: http://www.mysql.com/doc/en/InnoDB_start.html Enjoy Nitin ----- Original Message ----- From: "Leo Huang" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, November 04, 2003 6:28 PM Subject: InnoDB Questions > Hello, > > I have a few questions about InnoDB. > I am new to InnoDB, and just converted my MyISAM tables into InnoDB a > few days ago. > I notice that it generates these files > > -rw-rw---- 1 mysql mysql 2560 Nov 2 13:07 > ib_arch_log_0000000000 > -rw-rw---- 1 mysql mysql 790626304 Nov 4 20:44 ibdata1 > -rw-rw---- 1 mysql mysql 10485760 Nov 4 20:44 ib_logfile0 > -rw-rw---- 1 mysql mysql 10485760 Nov 4 20:44 ib_logfile1 > -rw-rw---- 1 mysql mysql 10485760 Nov 3 00:02 ib_logfile2 > > But how can those files work together? > > In InnoDB documentation, it suggests to add another file ibdata2 to > get higher performance. Can I do that now, after I have created the > ibdata1 and used it for a while? > > The most important thing is I deleted a 300M database, but the ibdata1 > remains the same size. MyPHPAdmin says 330,000KB free. How can I make > the data file smaller? > > I will be really appreciated if someone can briefly describe what's > happening to those files or point me to some articles. > > Thanks a lot, > Leo > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
