Hello guys, I have one monster database running on MySQL 4.0.17, using InnoDB:
270GB Oct 10 14:35 ibdata1 I've deleted a lot of register of then, and I've expected that the size can be decreased if 50% (135 GB) but the ibdata was the same value than before "clean"... How can I force to save this space? set-variable = innodb_buffer_pool_size=500M set-variable = innodb_additional_mem_pool_size=100M set-variable = innodb_log_files_in_group=5 set-variable = innodb_log_file_size=150M set-variable = innodb_log_buffer_size=8M set-variable = innodb_flush_log_at_trx_commit=1 set-variable = innodb_lock_wait_timeout=5 set-variable = innodb_data_home_dir=/dbms/mysql/bin-4.0.17/var set-variable = innodb_data_file_path=ibdata1:1000M:autoextend set-variable = innodb_log_group_home_dir=/dbms/mysql/bin-4.0.17/var Thanks! -- Tiago Cruz http://everlinux.com Linux User #282636 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]