I wrote a post here saying this is no longer the case ( Does MySQL still handle indexes in this way?) and that question references my original MySQL AB post. Someone asked in the DBA StackExchange if MySQL still did this. I actually wrote a post in the MySQL AB General Discussion Forum requesting this be changed ( Why does mysql drop index very very slow in a large table?). Would you believe MySQL used to do this transformation 3 times back in 2006 under MySQL 4.1 ? In other words, SCENARIO #2 would be handled like SCENARIO #1. In #SCENARIO #1, this would happen three times.
0 Comments
Leave a Reply. |