Bug #2000 'Statistc' status crashes queries
Submitted: 3 Dec 2003 1:08 Modified: 3 Jan 2004 6:46
Reporter: Bogomil Shopov Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server Severity:S1 (Critical)
Version:3.23.51-log OS:Linux (RedHat)
Assigned to: CPU Architecture:Any

[3 Dec 2003 1:08] Bogomil Shopov
When I execute a query stat of the connection become 'statistics' and after that all following queries are locked.
Please help

How to repeat:
Well I dont know. I am asking.
[3 Dec 2003 5:09] MySQL Verification Team

This usually happens with joins involving several tables with many indices.

The optimiser then spends lot's of time trying to find best index for each table. 

This is much optimised in 4.0 and even more in 4.1
[3 Dec 2003 6:46] Sergei Golubchik
could you please explain the behaviour in more details ? or provide a repeatable test case.
[14 Feb 2005 22:54] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".