Peter Zaitsev writes:
> I do not really remember from which version I started to se this thing, put
> it's somethere around mysql 3.23.18.
>
> Now I often see some really old queries habged in "Reading from net", even
> trying to kill them does not help. Queries can spend a lot in killed state
> ether. It does not take any much resources but still this is a bit wrong :)
>
> I'm using mysql 3.23.21 on Suse linux 6.3 Kernel 2.2.14smp
>
>
> ------------------------------------------------------------------------+
> | 1357 | apollo | apollo.spylog.com | | Killed | 26777 |
> Reading from net |
> |
> | 1856 | apollo | apollo.spylog.com | | Killed | 26177 |
> Reading from net |
>
Hello Pjotr,
The only difference between old and new versionsa is that new versions
are reporting much more and with more detail then before.
Among other things, reading and writing messages have been added to
help diagnose network and application problems.
The aim was to help programmer / administrator deal better with
bottlenecks with a system or application.
Regards,
Sinisa
+----------------------------------------------------------------------+
| ____ __ _____ _____ ___ == MySQL AB |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+