mos wrote:
At 01:24 PM 10/10/2007, Baron Schwartz wrote:
Hi,
Tiago Cruz wrote:
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?
You must dump your data to files,
Why not change the table type to MyISAM instead of dumping to a file?
If you have a bunch of indexes on the table, you're creating the indexes
on the MyISAM table too. It could be a lot more expensive than a dump
and restore.
Otherwise it sounds like a good idea.
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
