Shakeel, ----- Original Message ----- From: "Shakeel Sorathia" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Wednesday, November 13, 2002 9:39 PM Subject: InnoDB: Error: tablespace size stored in header
> Hi, we're using Innodb here and I just upped the number of datafiles > that innodb was using. When I did a show table status I noticed that I > didn't get all the space that I had added. When I looked at the error > log, I got recieved the following error. > > InnoDB: Error: tablespace size stored in header is 960000 pages, but > InnoDB: the sum of data file sizes is 1152000 pages > > > Can anyone help me out here? BTW, we recompiled innodb to use 64kb > pages rather then the default of 16kb. Here is the my.cnf we are using... the support for <> 16 kB pages is not tested. Big pages were used in 2001 to let InnoDB store BLOBs of size up to 30 kB. But when big BLOBs up to 4 GB were implemented, that was no longer needed. I recommend keeping the page size at the default 16 kB. The error message above can occur if mysqld crashes or fails when you add a new data file. Then it may be that the new data file already got created, but the tablespace size in the tablespace header in the first data file was not yet updated. In that case you normally can remove the extra data file and create a new. But in your case this might also be some bug which surfaces because of the 64 kB page size. 960000 pages = 60 000 MB 1152000 pages = 72 000 MB Did you add the last 3 data files manually, and did not let InnoDB to create them and write them full? If yes, that explains why the tablespace size in the tablespace header was not updated. > Thanks! > > --shak Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB sql query > innodb_data_file_path = ibdata1:4000M;ibdata2:4000M;ibdata3:4000M;ibdata4:4000M;ibdata5:4000M;ibdata 6:4000M;ibdata7:4000M;ibdata8:4000M;ibdata9:4000M;ibdata10:4000M;ibdata11:40 00M;ibdata12:4000M;ibdata13:4000M;ibdata14:4000M;ibdata15:4000M;ibdata16:400 0M;ibdata17:4000M;ibdata18:4000M > innodb_flush_log_at_trx_commit=0 > set-variable = innodb_buffer_pool_size=2048M > innodb_data_home_dir = /opt/mysql/data/ > innodb_log_group_home_dir = /opt/mysql/data/ > innodb_log_arch_dir = /opt/mysql/data/ > set-variable = innodb_log_files_in_group=3 > set-variable = innodb_log_file_size=128M > set-variable = innodb_log_buffer_size=192M > innodb_log_archive=0 > innodb_fast_shutdown=1 > innodb_flush_method=nosync > set-variable = innodb_additional_mem_pool_size=128M > set-variable = innodb_file_io_threads=4 > set-variable = innodb_lock_wait_timeout=50 > set-variable = innodb_thread_concurrency=12 > > > --------------------------------------------------------------------- > 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
