Question 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.

Still having problem with your mod_security, but full response is here:


romani-online.co.uk/response2.txt

Thanks
octet

Hello

This is a bit above my level yet, but I think these values is worth noticing:

TEMP TABLES
Current max_heap_table_size = 128 M
Current tmp_table_size = 128 M
Of 278533 temp tables, 36% were created on disk
Perhaps you should increase your tmp_table_size and/or max_heap_table_size
to reduce the number of disk-based temporary tables

TABLE LOCKING
Current Lock Wait ratio = 1 : 419
You may benefit from selective use of InnoDB.

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.

Any more progress?

Certainly does not look like Kunena 1.5.x is the root cause of these performance problems at all.

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:

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.