An idea: create ha_trace tracing storage engine

(Sergey Petrunia) Our exprience in solving query optimizer problems shows that a good chunk of optimization problems are incorrect choice of join order. The most frequent causes of the problems are –Table engine returns index statistics or records-in-range numbers that are very far from reality;

Read More - Register for Free Membership