descent;249514 Wrote:
> On 10/1/2014 6:11 PM, al b wrote:
> >
> > descent;249489 Wrote:
> >> On 10/1/2014 10:07 AM, al b wrote:
> >>> After cleaning of Analyzer project/data MySQL database still have
> >> "same"
> >>> size.
> >>> When new data imported to Analyzer, MySQL didn't use "free" pages
> >> inside
> >>> DB and size of database continue grow.
> >>> In the end we have situation, when Analyzer have very limited

> amount
> >> of
> >>> data, application performance degradated and MySQL size bigger than

> 3
> >> GB
> >>> and continue grow...
> >>
> >> Specifically, run an optimize on the underlying tables using the

> MySQL
> >> Workbench. This should reclaim the free space.
> >>
> >> --
> >>

> -----------------------------------------------------------------------
> >> Will Schneider
> >> Knowledge Partner

> http://forums.netiq.com
> >>
> >> If you find this post helpful, please click on the star below.

> >
> > Thank you, Will.
> > I tried to run optimization...
> > I'm not MySQL expert (yet) and I'm not sure, if this optimization

> doing
> > anything
> >
> > For every table, that I tried to "optimize" I got similar message:

> Table
> > does not support optimize, doing recreate + analyze instead
> >
> > analyzer.enfkwkojzpl_master_table optimize note Table does not

> support
> > optimize, doing recreate + analyze instead
> >
> >

> I think that will do it too.
> Did it shrink at all after that?
>
> --
> -----------------------------------------------------------------------
> Will Schneider
> Knowledge Partner http://forums.netiq.com
>
> If you find this post helpful, please click on the star below.


I can't see that database size changed after "optimization".
It's looks exactly same, like before


--
al_b
------------------------------------------------------------------------
al_b's Profile: https://forums.netiq.com/member.php?userid=209
View this thread: https://forums.netiq.com/showthread.php?t=51866