MAS! alter table and 'something wrong in indexes'?
May 26, 2016; 10:45
alter table and 'something wrong in indexes'?
I use mysql/innodb tables on aws services
in a small table (about 2M records) I changed some columns datatypes from unsigned int to decimal and from float to decimal
I didn't change anything about primary key or other indexes
after the change (done without troubles), all my queries where really slow and the "explain" was different; it was like the primary key index was corrupted or not used anymore (even if the 'check table' was fine)
I had to drop an create again the table with the new datatypes and all was fine again
any idea about what was wrong?
I guess is not an aws problem, even if that is the first time I have a similar error
thank you in advance
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!