Szymon Kosok (s...@mwg.pl)

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

It was problem with query. MySQL uses filesort, and that was cause. I've
deleted WHERE clause and now execution time is 100 times faster. (with
WHERE about 3 sec, without 0,03 sec. ;-)) In other way, strange is that
there wasn't any problem in 4.1.

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 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 INNER JOIN (gra_gwiazdy) ON (gra_gwiazdy.id =
gra_shoutbox.gid) INNER JOIN (swiat_miasta) ON (swiat_miasta.CityId =
gra_gwiazdy.miastoid) INNER JOIN (swiat_panstwa) ON
(swiat_panstwa.CountryId = gra_gwiazdy.countryid) INNER 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?