MySQL 5 problem

[nookie_pl]

Hello,

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 loooong time to execute:

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 LEFT JOIN (gra_gwiazdy) ON (gra_gwiazdy.id = gra_shoutbox.gid) LEFT JOIN (swiat_miasta) ON (swiat_miasta.CityId = gra_gwiazdy.miastoid) LEFT JOIN (swiat_panstwa) ON (swiat_panstwa.CountryId = gra_gwiazdy.countryid) LEFT JOIN (gra_gm) ON (gra_gm.gid = gra_gwiazdy.id) WHERE gra_gwiazdy.id != '1310' ORDER BY gra_shoutbox.id DESC LIMIT 0, 10;

On 4.1 everything was ok. It's caused by this query or probably it's something else? Any help?

[nookie_pl]

Strange thing is that, there is only one process spawned. (even if there's is more connections) It's normal?