It seems that mysql needs a temp table to optimize a table. so you need db's size + biggest table's size + some others of hdd space.
2010/11/29 7CREWZ <[email protected]>: > Hai to ALL, > > Please take alook at this report.. when o run this optimize table > dbmail_headervalue; u can see #sql-4560_2.frm and #sql-4560_2.ibd the file > increase.... > > mysql> optimize table dbmail_headervalue; > +---------------------------+----------+----------+----------+ > | Table | Op | Msg_type | Msg_text | > +---------------------------+----------+----------+----------+ > | dbmail.dbmail_headervalue | optimize | status | OK | > +---------------------------+----------+----------+----------+ > 1 row in set (49.28 sec) > > ls -al look the #sql-4560_2.ibd it bigger and bigger.... > > 37M dbmail_tofield.ibd > 12K dbmail_usermap.frm > 100K dbmail_usermap.ibd > 16K dbmail_users.frm > 9.1M dbmail_users.ibd > 4.0K db.opt > 12K #sql-4560_2.frm > 233M #sql-4560_2.ibd > > > On Mon, Nov 29, 2010 at 4:51 PM, HoangNam <[email protected]> wrote: >> >> Hi >> >> >> > I found that the database in dbmail was doube of my data. if i >> > use >> > innodb_per_table all the data will inside the table.when i read of some >> > documentation they said u must optimize the table to get real space.But >> > my >> > concern if my database is 500GB, i should have 1T for optimize the >> > database >> > because of temporary space why ? can it be done diffrent way ? >> >> What made you think that you need +500GB for space to use to optimize? >> DBMS wont need too much as that. >> It's DBMS (MySQL, PostgreSQL, ...) problem and dbmail doesnt double >> your DB size. >> Anyway, optimization will delete unused data (such as transactions >> log), check indexes, defragment the data file ... >> (it's called vacuum in PostgreSQL) >> It wont take your hdd spaces but time if your database size gets huge. >> >> -- >> >> Hoang Nam >> _______________________________________________ >> DBmail mailing list >> [email protected] >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > > _______________________________________________ > DBmail mailing list > [email protected] > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail > > -- Hoang Nam _______________________________________________ DBmail mailing list [email protected] http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
