Hi, Help!!! Can anyone kindly tell me why InnoDB will take up 10 times table space comparing with myISAM's table file? I only have one index built in this table and I don't think it took a lot of table space. The table has 543009 records and has a file size 256M in myISAM but it takes 2.3G table space in InnoDB.
When I try to drop the index from InnoDB, it gives me a error message: ERROR 1114: The table '#sql-258_4' is full The InnoDB is a very new concept to me, I am testing mysqld-max-nt 3.23.43 on Windows 2000(512M memory 833MHz CPU) with the following configuration: set-variable= key_buffer=32M set-variable= max_allowed_packet=1M set-variable= table_cache=256 set-variable= sort_buffer=1M set-variable= record_buffer=1M set-variable= myisam_sort_buffer_size=16M set-variable= thread_cache=8 innodb_data_home_dir = c:\ibdata innodb_data_file_path = ibdata1:1500M;ibdata2:1500M set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:\iblogs set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=50M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=0 innodb_log_arch_dir = c:\iblogs innodb_log_archive=0 set-variable = innodb_buffer_pool_size=300M set-variable = innodb_additional_mem_pool_size=20M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 set-variable=tmp_table_size=500M Wai Lee Zeborg --------------------------------------------------------------------- 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
