- Posts: 18
- Thank you received: 0
Kunena 6.3.0 released
The Kunena team has announce the arrival of Kunena 6.3.0 [K 6.3.0] in stable which is now available for download as a native Joomla extension for J! 4.4.x/5.0.x/5.1.x. This version addresses most of the issues that were discovered in K 6.2 and issues discovered during the last development stages of K 6.3
Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.
Question Kunena 1.5.9 performance
14 years 2 months ago #22
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re:Kunena 1.5.9 performance
What about the InnoDB tables? Have you converted all that are possible (you cannot convert those with full text indices)?
If your Joomla db is on InnoDB for all tables, please post a new snapshot of the two mysql tuning scripts, as well as a top. Need to see the server load (pls without running any benchmarking on it, as that will always max out the server) plus user. system and wait IO.
If your Joomla db is on InnoDB for all tables, please post a new snapshot of the two mysql tuning scripts, as well as a top. Need to see the server load (pls without running any benchmarking on it, as that will always max out the server) plus user. system and wait IO.
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
14 years 2 months ago - 14 years 2 months ago #23
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re:Kunena 1.5.9 performance
Ahhh - and disable JBolo for now - when you do make sure its plugin is disabled or removed.
It is a true server killer. Its ajax calls on every page load more than quadruples server load.
I tried it on starVmax.com and took it off for that very same reason.
It is a true server killer. Its ajax calls on every page load more than quadruples server load.
I tried it on starVmax.com and took it off for that very same reason.
We love stars on the Joomla Extension Directory .
Last edit: 14 years 2 months ago by fxstein.
Please Log in or Create an account to join the conversation.
14 years 2 months ago - 14 years 2 months ago #24
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re:Kunena 1.5.9 performance
Should have looked at this with FireBug much earlier.
Get FireFox, install Firebug, go to any page on your site and look at the console.
You will see fatAjax.js run in an infinite loop to make page requests over and over and over. Any user leaving a browser open will do a 'load test' against your site. Have a hundred concurrent users and your server will be maxed out. I bet for every real page load, JBolo gives you and extra 25-100 for normal browsing.
During the time it took me to write this message that ajax script made the following calls:
Definitely JBolo. Get rid of it ASAP and see your server fall asleep.
As you can see FireBug has stopped recording as the limit was reached well before I copy the messages in here. Not only is this a server killer by itself, the fact that it also makes illegal calls to the /forum?mode.... just puts crazy load on your server.
Get FireFox, install Firebug, go to any page on your site and look at the console.
You will see fatAjax.js run in an infinite loop to make page requests over and over and over. Any user leaving a browser open will do a 'load test' against your site. Have a hundred concurrent users and your server will be maxed out. I bet for every real page load, JBolo gives you and extra 25-100 for normal browsing.
During the time it took me to write this message that ajax script made the following calls:
Code:
....loading....
URL
Status
Domain
Size
Timeline
Firebug's log limit has been reached. 0 entries not shown. Preferences
Net panel activated. Any requests while the net panel is inactive are not shown.
-
0KB
(0KB from cache)
0ms
Firebug's log limit has been reached. 0 entries not shown. Preferences
GET http://www.romani-online.co.uk/index.php?option=com_jbolo&action=startchatsession&_=1266810070047
GET http://www.romani-online.co.uk/index.php?option=com_jbolo&action=startchatsession&_=1266810070047
200 OK
950ms
js.php...9.js.gz (line 120)
cycle126 is not defined
[Break on this error] Failed to load source for: http://demo...nts/com_community/assets/script-1.2.js
script-1.2.js (line 799)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=314726
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=314726
200 OK
1.32s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=854204
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=854204
200 OK
1.04s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=10520
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=10520
200 OK
1.09s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
527ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=456588
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=456588
200 OK
1.85s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=883767
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=883767
200 OK
1.05s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=927160
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=927160
200 OK
1.04s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=819846
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=819846
200 OK
1.06s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=364601
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=364601
200 OK
1.02s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
1.11s
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=819926
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=819926
200 OK
1.05s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=44685
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=44685
200 OK
1.06s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=659571
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=659571
200 OK
1.31s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
824ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=431691
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=431691
200 OK
1.09s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=52983
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=52983
200 OK
1.26s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
740ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=427689
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=427689
200 OK
1.09s
fatAjax.js (line 27)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=219215
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=219215
200 OK
1.24s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
726ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=92172
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=92172
200 OK
1.27s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
767ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
766ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=889988
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=889988
200 OK
1.07s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
720ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=956620
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=956620
200 OK
1.26s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
810ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
746ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=269009
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=269009
200 OK
1.29s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
724ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
726ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=313287
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=313287
200 OK
1.27s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
475ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
789ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
772ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=278243
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=278243
200 OK
1.21s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
741ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
730ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
718ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
752ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=948481
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=948481
200 OK
1.25s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
715ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
738ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
737ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
717ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=838867
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=838867
200 OK
1.28s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
769ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
762ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
799ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
734ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
790ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
690ms
forum (line 2437)
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=519558
GET http://www.romani-online.co.uk/forum?mode=getshouts&jal_lastID=21082&rand=519558
200 OK
1.41s
fatAjax.js (line 27)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
739ms
forum (line 2437)
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
POST http://www.romani-online.co.uk/radiostats/radiostats.php?1266810096395
200 OK
723ms
forum (line 2437)
Inline Code Finder for Firebug
Definitely JBolo. Get rid of it ASAP and see your server fall asleep.
As you can see FireBug has stopped recording as the limit was reached well before I copy the messages in here. Not only is this a server killer by itself, the fact that it also makes illegal calls to the /forum?mode.... just puts crazy load on your server.
We love stars on the Joomla Extension Directory .
Last edit: 14 years 2 months ago by fxstein.
Please Log in or Create an account to join the conversation.
14 years 2 months ago #25
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re:Kunena 1.5.9 performance
One last thing.
Turning off JBolo will not immediately lower the load. All browsers with open windows need to refresh their pages to stop executing their Ajax loop. If some of your users leave their computers running with a browser on your site, it will run as long as the user closes it or reloads the page without the ajax js being present. Local caching around the world might make this a 48h+ endeavor.
Again make sure the JBolo plugin is gone. Even when you uninstall JBolo - if the plugin is left on your system, it will still add the ajax script and make call after call, even though the component is gone.
Turning off JBolo will not immediately lower the load. All browsers with open windows need to refresh their pages to stop executing their Ajax loop. If some of your users leave their computers running with a browser on your site, it will run as long as the user closes it or reloads the page without the ajax js being present. Local caching around the world might make this a 48h+ endeavor.
Again make sure the JBolo plugin is gone. Even when you uninstall JBolo - if the plugin is left on your system, it will still add the ajax script and make call after call, even though the component is gone.
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
- LittleJohn
-
- Offline
- Kunena Contributor
14 years 2 months ago #28
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re:Kunena 1.5.9 performance
Looks like we are making progress. Server load has come down from 40 to 3.
I really don't think that there is any scaleable Joomla realtime chat or shoutbox. I would go with a different solution for that, which does not run on your server. The ones you are using don't scale architecturally and will bring your server down or slow it to a grinding halt.
As for the CSS optimizer - once we have fixed your root cause problem I will suggest to turn it back on but not a moment before and not without before and after testing. You need to be aware what some of these modules and components cost you, ultimately your call.
Your server load is still higher than needed and there are way too many slow queries.
Can you confirm that your jos_fb_xxx tables have all the indices a new install comes with? You can simply install Kunena 1.5.9 on a fresh test server (or locally), then use phpMyAdmin to export all jos_fb_xxx table definitions, export the same for your production site (NO data! just definitions) and compared the two. They should be identical, if not you could be missing indices.
I really don't think that there is any scaleable Joomla realtime chat or shoutbox. I would go with a different solution for that, which does not run on your server. The ones you are using don't scale architecturally and will bring your server down or slow it to a grinding halt.
As for the CSS optimizer - once we have fixed your root cause problem I will suggest to turn it back on but not a moment before and not without before and after testing. You need to be aware what some of these modules and components cost you, ultimately your call.
Your server load is still higher than needed and there are way too many slow queries.
Can you confirm that your jos_fb_xxx tables have all the indices a new install comes with? You can simply install Kunena 1.5.9 on a fresh test server (or locally), then use phpMyAdmin to export all jos_fb_xxx table definitions, export the same for your production site (NO data! just definitions) and compared the two. They should be identical, if not you could be missing indices.
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
14 years 2 months ago #29
by fxstein
We love stars on the Joomla Extension Directory .
Replied by fxstein on topic Re:Kunena 1.5.9 performance
Any more progress?
Certainly does not look like Kunena 1.5.x is the root cause of these performance problems at all.
Certainly does not look like Kunena 1.5.x is the root cause of these performance problems at all.
We love stars on the Joomla Extension Directory .
Please Log in or Create an account to join the conversation.
14 years 2 months ago #30
by octet
Replied by octet on topic Re:Kunena 1.5.9 performance
Yes, they are identical.
Load is under 1 now
Still tweaking mysql, it's been running for about 18 hours, will comeback with more details and screenshots later on today.
Thanks
fxstein wrote:
Load is under 1 now
Still tweaking mysql, it's been running for about 18 hours, will comeback with more details and screenshots later on today.
Thanks
fxstein wrote:
Can you confirm that your jos_fb_xxx tables have all the indices a new install comes with? You can simply install Kunena 1.5.9 on a fresh test server (or locally), then use phpMyAdmin to export all jos_fb_xxx table definitions, export the same for your production site (NO data! just definitions) and compared the two. They should be identical, if not you could be missing indices.
Please Log in or Create an account to join the conversation.
Time to create page: 0.553 seconds