Hai ,
u cannot mount other partoition because they put on the same storage..
any idea to solve this problem or, i miss configuration anywhere ? Thanks
On Mon, Nov 29, 2010 at 5:13 PM, HoangNam <n...@lqhn.net> wrote:
> 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 <7cr...@gmail.com>:
> > 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 <n...@lqhn.net> 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
> >> DBmail@dbmail.org
> >> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> >
> >
> > _______________________________________________
> > DBmail mailing list
> > DBmail@dbmail.org
> > http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
> >
> >
>
>
>
> --
>
> Hoang Nam
> _______________________________________________
> DBmail mailing list
> DBmail@dbmail.org
> http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
>
_______________________________________________
DBmail mailing list
DBmail@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
