Feng Forum
Support => Older versions => : quichot 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
-
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.
-
my 1.5.1 runs just as fast as 1.4.2 did
-
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).
-
I have another 1.5.1 installation. This works perfectly!
Any clues what may cause these perfornance leaks?
-
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.
-
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.
-
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:
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.
-
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
-
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.