Need help with slow request speeds...
By Michael Twigg on Thursday, 04 May 2017
Posted in Technical Issues
Likes 0
Views 278
Votes 0
I received some issues from my server company that caused them to disable my blog (I updated to the latest easyblog):

It seems that the problem is not with the cron but with the blog. The blog pages take a great amount of time to load. Each request to a page of your blog requires over 30 seconds to complete. To reduce the load, we have disabled the access to your blog. Your home page works fine.

Please check your MySQL usage statistics under your hosting Control Panel > Resources > CPU/MySQL usage tab. Your account consumes 50 times more MySQL time than allowed. This usage caused a high load on the entire shared server, and this affects all other customers on the server.

The high MySQL usage is caused by really slow database queries. The problem started around April 17 - April 18, 2017. Attached is a text file with the slowest database queries. Please review them and let us know if you find the culprit. In any case, access to your blog cannot be enabled before the issue is resolved.

We appreciate your cooperation and understanding.

Best regards,
Emiliyan Tsanov
Abuse Department
Hi Michael Twigg,

Regarding your issue, it seems like the issue was caused by the invalid records in db table #__easyblog_post_tag. I noticed in your site, this table as more than 10 thousand records and for each records, the tag_id is 0 (zero). This caused sql performance issue when EasyBlog attempt to retrieve the related posts for a blog post.

To fix this issue, I've cleared these invalid records from your #__easyblog_post_tag table and, I've applied a fix on your site to add a checking so that the sql queries will ignore these invalid records incase it happen again. Below are the file I've modified.

JOOMLA/administrator/components/com_easyblog/models/blog.php

Now, the initial request time to a blog post took about 2s compare the previous initial request time of 11s Please see http://take.ms/c60FX

The same fix will be added into next release of EasyBlog as well. And for anyone that encountered the same issue, download the attached blog.php file and copy this file to folder 'JOOMLA/administrator/components/com_easyblog/models/' and overwrite the existing 'blog.php'.

You may now request your hosting to unlock your site to the public

Hope this help and have a nice day
Sam
·
Thursday, 04 May 2017 12:21
·
0 Likes
·
0 Votes
·
0 Comments
·
If you can give me an IP address they can unlock your IP address to be able to access the blog from the front of the site:

okaynext.com/blog

Currently they have it blocked...
Michael Twigg
·
Thursday, 04 May 2017 03:39
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Michael Twigg,

Regarding your issue, here is our office IP address: 175.139.128.108
We are on the dynamic IP so the IP address might changed from time to time.

Also, can you provide us the ftp account to your server as well so that we can debug this issue directly from your site.

Hope this help and have a nice day
Sam
·
Thursday, 04 May 2017 10:37
·
0 Likes
·
0 Votes
·
0 Comments
·
Sam,

I provided a file for you to ftp...ftp login and password is same as joomla...
Michael Twigg
·
Thursday, 04 May 2017 10:46
·
0 Likes
·
0 Votes
·
0 Comments
·
We enabled access to the 175.139.128.108 IP address.

To access the account over FTP, they need to use server270.com for FTP host and the Control Panel username and password pair.
Michael Twigg
·
Thursday, 04 May 2017 11:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Michael Twigg,

Thanks for whitelist our IP address. I am able to ftp to your site now. Currently I am checking this issue on your site. Will get back to you as soon as possible once I've figure out what causing the slow issue.
Sam
·
Thursday, 04 May 2017 11:27
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post