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
