Re: Long query locking up MySQL Server

[Shawn Taylor]

I must be missing something.

I see a create table and table status for flights. I also see an explain for a query against the flights table.

However in the query above the explain output, I don't see the flights table used at all.

Are you sure you pasted the right things into the post??

Please issue a show table status and show create table for these two tables:

* NN_dostepnosci_obiektow
* kody_regionow

Shawn