MySQL hitting 179% usage when publishing posts
By Rob on Monday, 02 November 2015
Posted in Technical Issues
Replies 5
Likes 0
Views 737
Votes 0
HEllo,

I noticed that MySQL is hitting 179% when EasyBlog publishes a post I created. I also have noticed a high count in my easyblog_acl_group (over 400 rows) as compared to my test server which has only 37 rows.

I truncated the table and was wondering if there is anything else I can do for the DB that will alleviate any high memory utilization on the CPU.

Thank you for your time with this issue.

Regards,
Rob
Hello Rob,

I'm sorry, where did you see the 179%? I remember the easyblog_acl_group issue last time is affecting one of our user when installing Easyblog because he has a very huge data (400K rows) and the only way to solve this is to truncate the table and resave the ACL. But in you case, I believe it is not the issue. 400 rows should be fine.
Nik Faris
·
Monday, 02 November 2015 11:15
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Nick,

Thanks for the reply. What is odd is that I see it on only the techlick.com site and not on my testing site. Which is on the same server.

See screenshot. Only on page loads and saving blogs. But on the other site everything is fine.

It is just techlick.com that is having an issue. I am rebuilding the site but I am trying to figure out why my DB gets the CPU up that high.

Regards,
Rob
Rob
·
Monday, 02 November 2015 12:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Rob,

It is weird. We have never seen this issue before. However, keep us updated.
Nik Faris
·
Monday, 02 November 2015 13:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Okay I am rebuilding the site since it appears in version 3.9 there was instances of high CPU usage. It appears all is good with a fresh install of both Joomla and Easyblog. Thanks again for your support Nick.
Rob
·
Thursday, 05 November 2015 08:17
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Rob,

You're welcome.
Nik Faris
·
Thursday, 05 November 2015 12:43
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post