Page 1 of 2
Very slow loading
Posted: Wed Jul 12, 2017 2:21 pm
by 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?
Re: Very slow loading
Posted: Thu Jul 13, 2017 9:59 am
by admin
Did you check what process consumes CPU the most ?
Re: Very slow loading
Posted: Thu Jul 13, 2017 10:38 am
by filthlab
mysqld
Re: Very slow loading
Posted: Thu Jul 13, 2017 11:19 am
by admin
did you check slow log ?
queries that mysql runs
Re: Very slow loading
Posted: Thu Jul 27, 2017 10:32 am
by 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?
Re: Very slow loading
Posted: Sat Jul 29, 2017 6:42 pm
by 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 ?
Re: Very slow loading
Posted: Sun Jul 30, 2017 7:33 am
by 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.
Re: Very slow loading
Posted: Sun Jul 30, 2017 4:03 pm
by 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 ?
Re: Very slow loading
Posted: Mon Aug 21, 2017 2:14 pm
by admin
Did you check it?
Re: Very slow loading
Posted: Tue Aug 22, 2017 10:34 am
by filthlab
You can see the slow log here:
http://filthlab.com/mysql_slow.txt
There is no problem when the pages are cashed.