Hi Maged,

if you got blank page. you must turn on the joomla error reporting from backend.
after that you will know what the problem is.
I already enabling Azrul plugin. that plugin is mandatory for jomsocial.
and your cache already turn off. seem you must setup modules again. many missing modules.

Regards,
Albert

I already uninstall the Azrul plugin when Upgraded the jomsocial
Also i uninstall some modules because slowed on the website
I hope from you find the problems and fix it
I would be glad to your assist .

hi Albertus
It seems the high CPU usage is all from this one query I am seeing constantly being run:

```
| 4305 | aodlesys_aodlloc | localhost | aodlesys_db | Query | 25 | Sending data | SELECT a.`userid` as _userid , a.`status` as _status , a.`points` as _points, a.`posted_on` as |
```

can you help me

Hi Maged,

what is the complete query?
and could you please install Akeeba Backup? I need to make your site copy at my local. that more safe if I debugging your site at local copy. Because deep debugging process can damaging your site.

Seem any 3rd party plugins or components causing this issue.

Regards,
Albert

Hi Albert
It seems difficult to make backup using Akeeba Backup due to size the site, could reach more than 140 GB
I have more than 125,000 members ,and the database size is too large,I have more than 400,000 activites

Do you want to create a backup through backup wizard ?

Hi Maged,

I just realized your site too big ... :)
if exclude images and videos still big size? please try to purge sent message at Mail Queue (jomsocial backend) and delete old activities.
it can be slow because too many users + they data.

Let me know the result.

Regards,
Albert

I have deleted all activities and this Fatal bug
I have Purge Sent all Mail Queue
and still there high load on mysql
awesomescreenshot.com/0ee38dodde
awesomescreenshot.com/09438dsi1a
awesomescreenshot.com/03c38dmnd8
awesomescreenshot.com/0b938dnd96
How I can optimization my site and make it more faster without deleting data users

Hi Maged,

about message counter issue. we will fix that at next release.
and about your main issue. it's too complicated, must try any possibility. Because the big load at MySQL, try to increase MySQL settings for.

key_buffer_size         
 sort_buffer_size       
 tmp_table_size       
 max_heap_table_size    
 read_buffer_size      
 read_rnd_buffer_size
 myisam_sort_buffer_size 

I can't wait until the next release, i will to lose all users on my site
When a user upload a avatar , Occurs Repeat for activite
awesomescreenshot.com/0cb38e4sec
I am using a dedicated server for my website
I using InnoDB for database
please research in this issue , and please provide me the Solution next few hours, i already Very worried
I apologize for the inconvenience , and wish to help me, so as not to lose users my website

Hi Maged,

here the patch for repeat activities.
www.jomsocial.com/forum/bugfixes-and-upg...and-group-covers-fix

your site slow don't it's not becuase jomsocial it self. many factors causing this problems. you can search at this forum about jomsocial slow down issue. it can be other components, modules, or plugins.

I suggest you to optimize the DB by using phpmyadmin. maybe many overhead tables. after that increase any memory limit at mysql config (my prev post). if you using dedicated server you must know how to do it.

Regards,
Albert

hi Albertus
These are the current values
key_buffer = 512M
sort_buffer_size (not listed)
tmp_table_size = 128M
max_heap_table_size = 64M
read_buffer = 2M
read_rnd_buffer_size (not listed)
[myisamchk]
sort_buffer_size = 128M

I don't own the site extensions " jomsocial only
And my site too slow, I'm attached to you data access to root
for take look about problem and fix
i will be glad for your assist .

hi Albert
i'm received Message from liquidweb support

Hi Maged,

that query for get or init users. and Jomsocial already optimized that query. if i refresh your site many times some times I got mysql lost connection. I think that because your mysql over loaded.

do you already check by using phpmyadmin for any overhead tables?

I dont want touch your server, because out off scope for support.

for mysql setting there is no definitive benchmark you can use this tools for Mysql settings tools.percona.com/wizard

Regards,
Albert

I just have Upgrade jomsocial and there have been all these problems
I'm attached to you data access to root
for take look about problem and fix
i will be glad for your assist .