Ilya Obshadko wrote:
>
> I've noticed a strange loss in performance of Mysql (FreeBSD 3.2-STABLE,
> Dual P-II-333). Some SELECT queries take about 40 seconds, and processor
> load is about 98%! Maybe this is a known situation, please let me know if
> anybody had such problems...
>
> #-- Ilya Obshadko [IDO-RIPN] -------------------------------#
> #-- email: ilya@stripped, ilya24@stripped -----------------#
> #-- ICQ UIN: 10704338 --------------------------------------#
>
Is this reproducable?
When this happens again ( or when you reproduce it), run mysqladim
extented-status and post the results.
--
Sasha Pachev
http://www.sashanet.com/ (home)
http://www.direct1.com/ (work)
