List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:June 16 1999 4:25pm
Subject:Re: inadequate performance (3.22.20a)
View as plain text  
In the last episode (Jun 16), Ilya Obshadko said:
> 
> 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...

We need to see your query, table definitions, table sizes, and EXPLAIN
SELECT output before we can even guess at a solution.
 
	-Dan Nelson
	dnelson@stripped
Thread
inadequate performance (3.22.20a)Ilya Obshadko16 Jun
  • Re: inadequate performance (3.22.20a)Dan Nelson16 Jun
    • Re: inadequate performance (3.22.20a)Ilya Obshadko16 Jun
  • Re: inadequate performance (3.22.20a)Sasha Pachev16 Jun
    • Re: inadequate performance (3.22.20a)Ilya Obshadko16 Jun
  • Re: inadequate performance (3.22.20a)Ozemail)16 Jun