Thanks to all,
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Specialist
On Fri, Aug 29, 2014 at 11:59 AM, Hartmut Holzgraefe
wrote:
> On 08/29/2014 08:15 AM, geetanjali mehra wrote:
> > But after doing *optimize table*, the value inside
> >
On 8/29/2014 5:51 AM, Johan De Meersman wrote:
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Am I the only one worried about that line, then?
yes.
I welcome help from anyone willing. Expertise and willingness
both are important.
--bill
--
MySQL General Mailing Li
> Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Am I the only one worried about that line, then?
--
Unhappiness is discouraged and will be corrected with kitten pictures.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
On 08/29/2014 08:15 AM, geetanjali mehra wrote:
> But after doing *optimize table*, the value inside
> data_free is still the same. If there is no change in the value of
> data_free, then what *optimize table* does here?
Without seeing actual values I can only give an educated
guess:
* If you ar
Could you please answer these questions also. What does data_free field
from SHOW TABLE STATUS shows?
When should we run optimize table for innodb tables?
I read various blogs. They said data_free shows free space inside the
innodb tables. But after doing *optimize table*, the value inside
data_f
Hello Geetanjali,
On 8/26/2014 1:11 AM, geetanjali mehra wrote:
Hello to all,
I want to know whether my innodb index is fragemented. Is it possible to
know?
Best Regards,
Geetanjali Mehra
Senior Oracle and MySQL DBA Corporate Trainer and Database Security
Specialist
Just like every other pi
