-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Curtis Maurand schrieb: | You're running into my major complaint about innodb. It never gives | space back. the file continues to grow until it uses all available
That's not completely true. You`re right - giving back space is not done by innodb itselfes. But innodb needs a db administrator. He is responsible for the health of innodb. It is like DB2. IBM's database also requests to do "reorgs" for maintaining the used space. | resources. I have heard about altering the storage engine to MyISAM and | then changing it back to get your disk space back, but I've never tried In tha case, you'll need to put you emailsystem offline. MyISAM is not transaction safe! | it. running mysqloptimize will only make the file grow larger. Do you talk about the "optimize table" command? Did you read http://www.dbmail.org/dokuwiki/doku.php?id=mysql_notes ? Uwe -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.7 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iQEVAwUBSKHXYNs3frmum9swAQISlwf/YmJNh7S/lata7tCFG1wnfgL/25sgiGp7 uw6s3kcTQUzFTSH7GkE8ehpShKAmh8zBhiSlnkdWXy76xj5v19HGkMYpINpjwyIB QafwCvpOQhWLhTdfWn8reOMNviMJC0r+FndhLMrDMAg1GCsNnhJa6a2JHYILvWD4 nYkd18nciqB7ZOSLEMARWP4NPKAQf+Ru1MdqEPndEWbxtQyHdcz/aYVwZVWNZl2o NwvJYZlEiXay9uma6jxC+/H330Y/m0rkPIiaY9/yEA0KKn4GABa+HEamJT+gzKP/ sru895unGd2CWqJrkpE8gbQCpoY1xHcGsFgE6gp0RWw/6FOmtCCxrA== =mqAc -----END PGP SIGNATURE----- _______________________________________________ DBmail mailing list DBmail@dbmail.org https://mailman.fastxs.nl/mailman/listinfo/dbmail
