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
