Hi there, I just created an InnoDB table mirroring the schema of the original table...
But, I am getting the following....... mysql> insert into NEW_TABLE select * from ORIG_TABLE; ERROR 1114: The table 'NEW_TABLE' is full I checked on the manual.... and I got the following..... #####Comments from http://www.mysql.com/doc/F/u/Full_table.html Comments: : This doesn't seem to work while using InnoDB table types... InnoDB seems to try and share memory equally between all tables and NOT want to use the hard disk or swap space... ::shrug:: ##### This size of the ORIG_TABLE (MYD +MYI) is ~ 150MB.... ----- Original Message ----- From: Heikki Tuuri <[EMAIL PROTECTED]> To: "ImpactNET - Edgar R Gutierrez" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, March 13, 2002 9:15 PM Subject: Re: Converting MyISAM to InnoDB > Hi! > > You should add a new data file as explained in section 5 of > http://www.innodb.com/ibman.html. > > Best regards, > > Heikki Tuuri > Innobase Oy > --- > Order technical MySQL/InnoDB support at https://order.mysql.com/ > Speed up adding of features to MySQL/InnoDB through support contracts > See http://www.innodb.com for the online manual and latest news on InnoDB > > > -----Original Message----- > From: "ImpactNET - Edgar R Gutierrez" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.mysql > Date: Wednesday, March 13, 2002 9:25 AM > Subject: Converting MyISAM to InnoDB > > > > > >Hello, > > > >We are currently in the process of converting our MyISAM tables to InnoDB > to > >make our tables > >transaction safe. Unfortunately, I am getting the following error on one > >of the tables... > > > >mysql> alter table SUBSCRIBERS type = InnoDB; > >ERROR 1114: The table '#sql-fcc_1' is full > >mysql> > > > >What value should I set the following..... > >Currently, I set it to 512M... > > > >set-variable = innodb_buffer_pool_size=512M > > > >My SYSTEM runs V4.0.1-alpha and my server has 1GB of RAM. > > > >Thanks > > > > > > > >--------------------------------------------------------------------- > >Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > >To request this thread, e-mail <[EMAIL PROTECTED]> > >To unsubscribe, e-mail > <[EMAIL PROTECTED]> > >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
