Hi Wagner,
Yes! Analyze solves the situation in a moment.
(14:21:09) [borrame] > alter table creditLine discard tablespace;
Query OK, 0 rows affected (0.41 sec)
(14:21:21) [borrame] > alter table creditLine import tablespace;
Query OK, 0 rows affected (23.48 sec)
(14:24:55) [borrame] > a
Did you check if an ANALYZE TABLE is enough in this case?
--
Wagner Bianchi
Mobile: +55.31.8654.9510
> Em 10/10/2014, às 09:06, Ruben Cardenal escreveu:
>
>
>
> Hi,
>
> I have this problem among several different instaces of 5.6.20. I take
> all the steps as stated in
> http://dev.mysql.com
Hi,
I have this problem among several different instaces of 5.6.20. I take
all the steps as stated in
http://dev.mysql.com/doc/refman/5.6/en/tablespace-copying.html and get
no errors neither warnings, neither in the cli or the mysql log.
(13:23:02) [borrame] > alter table creditLine discard