Author Topic: OG 1.5 final act very slow  (Read 3193 times)

quichot

  • Newbie
  • *
  • Posts: 3
    • View Profile
    • Email
OG 1.5 final act very slow
« on: July 30, 2009, 09:42:37 am »
Hi folks.

I Upgraded OG from 1.4.2 to 1.5. (on my testserver)
Upgrade was succesfull without errors

The application act very slow though. Far too slow for production purposes
My production enviroment  will not be upgraded before this performance issue is solved.

What is your experience considering performance?

Greetz

Q

chekka

  • Newbie
  • *
  • Posts: 25
    • View Profile
Re: OG 1.5 final act very slow
« Reply #1 on: August 11, 2009, 07:11:39 pm »
I’m not sure if it is a casual connection between upgrade to 1.5.1 and speed, but most scripts now take much more time than before.

Pet

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 638
  • Always mining for solutions!
    • View Profile
    • The Bet!
Re: OG 1.5 final act very slow
« Reply #2 on: August 11, 2009, 08:52:55 pm »
my 1.5.1 runs just as fast as 1.4.2 did
Support OpenGoo - Sponsor a Feature! | Follow me on Twitter | OG Support Chat | Did you turn debugging on?

chekka

  • Newbie
  • *
  • Posts: 25
    • View Profile
Re: OG 1.5 final act very slow
« Reply #3 on: August 12, 2009, 07:24:36 am »
I notice peformance leaks especially when moving things to trash and at email actions like deleting, moving to workspace ...

I also found out that there are some recurring errors written in cache/log.php (e.g. broken pipe, no such file or directory, invalid argument).
« Last Edit: August 12, 2009, 07:32:44 am by chekka »

chekka

  • Newbie
  • *
  • Posts: 25
    • View Profile
Re: OG 1.5 final act very slow
« Reply #4 on: August 13, 2009, 06:45:09 pm »
I have another 1.5.1 installation. This works perfectly!
Any clues what may cause these perfornance leaks?

chekka

  • Newbie
  • *
  • Posts: 25
    • View Profile
PROBLEM FOUND --- but no solution
« Reply #5 on: August 13, 2009, 07:56:14 pm »
I found the problem (for my installation): The »opengoo_application_logs« table growed up to 528,848 entries in a few days.

I exported that table an found out that any task was repeated more than 7,500 times(!!!).

e.g if i delete an email message there is one entry with action »trash« and 7,500+ entries with action »delete«. So OG makes more than 200 entries per minute or 3-4 entries per second.

I cleared that table and OG worked with normal performance. But after 30 minutes the table contained 37,000 entries again.


« Last Edit: August 13, 2009, 08:00:42 pm by chekka »

chekka

  • Newbie
  • *
  • Posts: 25
    • View Profile
NEW FINDINGS
« Reply #6 on: August 14, 2009, 04:59:51 am »
10:00 AM

I observed the »opengoo_application_logs« table and found a new, very interesting behavior:
I catched every 10 seconds the account and saw that entries amount doesn’t grow continuously but goes up and down.

See attached file

------

ADDITION: 17:30 PM

The table grewed up to 188,577 entries --- without any actions in OG today.
« Last Edit: August 14, 2009, 12:27:06 pm by chekka »

ignacio

  • Hero Member
  • *****
  • Posts: 1703
    • View Profile
Re: OG 1.5 final act very slow
« Reply #7 on: August 14, 2009, 12:34:53 pm »
Hi, The issue of mail deletion on application logs was solved on version 1.5.2. You should upgrade to 1.5.2 and execute this query to remove the unnecessary application logs:

Code: [Select]
DELETE FROM `og_application_logs` WHERE `rel_object_manager` = 'MailContents' AND `taken_by_id` = 0 and `action` = 'delete'
With this you'll loose all logs about emails being deleted. If you only want to remove duplicated logs you would have to use another query. You can also add a condition like (AND `created_on` > '2009-08-01') to delete logs from some date onwards.

chekka

  • Newbie
  • *
  • Posts: 25
    • View Profile
Re: OG 1.5 final act very slow
« Reply #8 on: August 14, 2009, 05:38:28 pm »
1.) Thanks for your fast reply
2.) Upgrade to 1.5.2 runs without any problems
3.) I miss the announcement for 1.5.2 at OG startpage and at the forum
4.) The upgrade did’nt solve the problem. My DB grows faster than ever.

The only difference I can see is that the table grows linear and not back and forth (if you know what I mean ;-)   ==>   see below
« Last Edit: August 14, 2009, 05:58:34 pm by chekka »

chekka

  • Newbie
  • *
  • Posts: 25
    • View Profile
Re: OG 1.5 final act very slow
« Reply #9 on: August 14, 2009, 07:14:15 pm »
OK, I think I got it.

I stopped my cronjobs and so the growing of »opengoo_application_logs« stops too. After restarting cronjobs everything looks normal. I hope this remains so.

 

anything