OPTIMIZE TABLE should reclaim that space, but be aware that it could take a while to run (locking your table all the while) since it just maps to an ALTER TABLE statement which creates a new copy of the table. Depends on how big your tables are.
Doc: http://dev.mysql.com/doc/refman/4.1/en/optimize-table.html -Dan -----Original Message----- From: Tiago Cruz [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 10, 2007 2:14 PM To: mysql@lists.mysql.com Subject: Saving space disk (innodb) 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
