0
Welcome Guest! Login
0 items Join Now

Site is slow and consumes a lot of cpu w mysql after upgrade

Last Post
Search Topic

  • Site is slow and consumes a lot of cpu w mysql after upgrade

    Posted 13 years 3 weeks ago
    • Hi All,

      I've been struggeling for a good 6 days now, after upgrading from Joomla 1.7.5 to Joomla 2.5.4.
      I used as suggested by the joomla team, the Update function within joomla as adviced by the Joomla Dev Team.

      Now, all went well, but after upgrading I've seen high spikes on my Turnkeylinux Joomla Virtual Appliance as mysql runs on average on 110% cpu. I have 2 CPUs(vcpus) assaign to the VM so it has more than enough cpu power. But, it actually is beginning to be critical as it all of a sudden just drops, and I need to reboot to get it up and running again.
      When I take a look at active connections in mysql i see a lot of this:

      SELECT b.rules FROM j17_assets AS a LEFT JOIN j17_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_content.article.1255' OR a.parent_id=0) GROUP BY b.id, b.rules, b.lft ORDER BY b.lft
      Sometimes I can see up to 40 entries on this with different com_content.article.xxxx numbers.
      What does this mean?
      Now, I'm not that a techy on mysql and core joomla, but this seems to be something that's slowing the website down.
      Please help out!!!! as the Joomla Forum on joomla.org is currently disabled!
    #800880
    • MrT's Avatar
    • MrT
    • Preeminent Rocketeer
    • Posts: 101084
    • Thanks: 13484
    • Web Designer/Developer

    Re: Site is slow and consumes a lot of cpu w mysql after upgrade

    Posted 13 years 3 weeks ago
    • 1. is joomla cache on
      2. is gantry cache on
      3. is gantry gzipper on OR joomla gzip on (NOT BOTH!).
      4. consider using Akeeba Admin Tools to optimise tables.

      I hope that helps.

      Regards, Mark.
    • Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
    #800882

  • Re: Site is slow and consumes a lot of cpu w mysql after upgrade

    Posted 13 years 3 weeks ago
    • 1. NO
      2. Yes
      3. Gantry Cahe ON - Joomla gzip NO
      4. Yes, and they are optimized

      So, I've tried basically those 4 things!
    #800890

  • Re: Site is slow and consumes a lot of cpu w mysql after upgrade

    Posted 13 years 3 weeks ago
    • Although I have RokGZipper installed and on... if that can cause some fuss?
    #800891

  • Re: Site is slow and consumes a lot of cpu w mysql after upgrade

    Posted 13 years 3 weeks ago
    • Sorry, just dobbel checked, I did indeed have Joomla gzip on.. turned it off now... will need to monitor in an hour or 2 to see if it helps!
    #800893
    • MrT's Avatar
    • MrT
    • Preeminent Rocketeer
    • Posts: 101084
    • Thanks: 13484
    • Web Designer/Developer

    Re: Site is slow and consumes a lot of cpu w mysql after upgrade

    Posted 13 years 3 weeks ago
    • Turn on joomla cache and turn on Gantry gzipper (now you have turned joomla gzip off) they will make a huge difference, also move your joomla cache time up to 45 mins.

      Regards, Mark.
    • Please search forums before posting. Please make sure your post includes the version of the CMS you are using and a link to the problem. Annotations on screenshots can also be helpful to explain problems/goals. Please use the "secure" tab for confidential information.
    #800895

Time to create page: 0.047 seconds