Elm, >Hello again! > >I'm currently inserting all my records into the table and suddenly after >1909152 records I get the error on an INSERT query : > >The table <table_name> is full > >each record is 36 bytes * 1909152 records is 68729472bytes = 68.7mb > >I'm using innodb tables and innodb_data_file_path is set to >innodb_data_file_path = ibdata1:200M; > >So I'm really not even half away from the total size. > >From what I can read on http://www.mysql.com/doc/F/u/Full_table.html this >should only happen when I SELECT data and not when I INSERT data? > >Does anyone know whats going on here? > >Another question is if I can just increase tha value of >innodb_data_file_path = ibdata1 variable without losing my data?
You must add a new data file ibdata2 as explained in the manual. InnoDB tables use more space than MyISAM tables because of, trx ids, roll pointers (for multiversioning), clustered indexes, and no key compression. See the manual at http://www.innodb.com/ibman.html about physical record structure. >Thanks again!! > >Elm Regards, Heikki --------------------------------------------------------------------- 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
