Ivan,
----- Original Message ----- From: "Latindeveloper" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Sunday, February 20, 2005 10:51 PM
Subject: InnoDB Files
Hi to all,
I'm working with mysql 4.1, the InnoDb files are ~1.5Gb.
The question is: How to compress a inndodb data file?
the only way to to release the space in ibdata files to the operating system is to recreate the whole InnoDB installation.
You should consider using the option:
innodb_file_per_table
if you want better disk space management. Upgrade to MySQL-4.1.10 since in <= 4.1.8 the option contained critical bugs.
My InnoDB free space is ~800Mb.
Thanks in advance. -- Ivan Cachicatari http://www.latindevelopers.com
Best regards,
Heikki Tuuri
Innobase Oy
Foreign keys, transactions, and row level locking for MySQL
InnoDB Hot Backup - a hot backup tool for InnoDB which also backs up MyISAM tables
http://www.innodb.com/order.php
Order MySQL Network from http://www.mysql.com/network/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
