Very slow loading

[filthlab]

Hi,
When the gallery grabbing is running the loading of the site become very slow.
The CPU load is about %100, for a little while it even rise to %200-%300.
Now I have 17 sets with daily rss - 4 running every hour and the other running on 12 hours.
For "Grabber Speed, per minute" in the settings I have just 10.
Not sure if the problem is in the grabbing only.

Any idea what can be done to fix this?

[admin]

Did you check what process consumes CPU the most ?

[filthlab]

mysqld

[admin]

did you check slow log ?
queries that mysql runs

[filthlab]

Our server admin fixed this. But the problem (slow loading) still persist when you browse by tubes. Just visit http://filthlab.com/ and try to browse by tubes.

Also, how to list in Tube section just active sponsor/sites?

[admin]

I've tried urls like

/scj/tube/?force_lng=es&sponsor_slug=vporn&page=2
/scj/tube/?force_lng=es&sponsor_slug=vporn&page=3

loads pretty good

what url would you recommend to try ?

[filthlab]

From the main page just try different tubes. Sometimes it is fast, sometimes it isn't, and I can't find the reason for this.

[admin]

Ok
there are 3 main points

1. DB
2. template execution
3. network

let's start from the very beginning

turn on 'slow log ' for mysql
any queries ?

[admin]

Did you check it?

[filthlab]

You can see the slow log here:
http://filthlab.com/mysql_slow.txt

There is no problem when the pages are cashed.