alter table and 'something wrong in indexes'?
- Date: Thu, 26 May 2016 10:45:31 +0200
- From: MAS! <urkapd@xxxxxxxxx>
- Subject: 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