RE: MySQL 5 problem after upgrade

ct: Re: MySQL 5 problem after upgrade Hello again, > SELECT shout_avatar, shout_own, timestamp, tekst, imie, pseudo, wiek, > City, Country, plec, wlosy_kol, gra_gwiazdy.id, gra_gm.gid AS gm FROM > gra_shoutbox INNER JOIN (gra_gwiazdy) ON (gra_gwiazdy.id = > gra_shoutbox.gid) I

Re: MySQL 5 problem after upgrade

Hello again, SELECT shout_avatar, shout_own, timestamp, tekst, imie, pseudo, wiek, City, Country, plec, wlosy_kol, gra_gwiazdy.id, gra_gm.gid AS gm FROM gra_shoutbox INNER JOIN (gra_gwiazdy) ON (gra_gwiazdy.id = gra_shoutbox.gid) INNER JOIN (swiat_miasta) ON (swiat_miasta.CityId = gra_gwiazdy.mi

MySQL 5 problem after upgrade

Hello, I've posted this on Gentoo forums, but I'll try here too. :) I've made upgrade of MySQL to latest 5.0.x version. Now, when I access my site MySQL CPU usage is about 100%, and site is unaccessible. :( I've checked SHOW PROCESSLIST and this query take lng time to execute: SELECT shout_a