Hi Maged,

I will do my best to resolving this issue. please install akeeba backup. I want try make backup files with exclude images and videos files. let see how big is it. too risky if debugging straight at live site.

Regards,
Albert

i have changed the data access to aodle.com
So you look at it
Or you can write a message for hosting my technical support and I will send them
i will be glad for your assist .

Well I will do I install akeeba backup

i have completed installed the Akeeba Backup
can you log in to aodle administrator
I'm attached to you data log in to administrator

Hi Maged,

I the backup still running. please give me time for this.
during the time could please try to disable eAccelerator at php configuration, and try increase the memory limit settings at mySQL config (because you not tell about this already did or not). Let me know the result.

FYI: Jomsocial support cannot touch customer server, because out of support scope.

Regards,
Albert

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

Please advise to a new values

Hi Maged,

please try to double it all values. Need restart the server maybe after changed (depend with your server)

let me know the result.

Regards,
Albert

Hi Maged,

akeeba backup failed to make backup files. could make Database backup file from WHM/Cpanel in compressed format?
put it at under /images/ folder so I can download it

Regards,
Albert

I can't do that, Internet speed do not allow me to do
can you login to Cpanel to take backup

Hi Meged,

its ok I already made DB backup only using akeeba (for 2nd times). I will back to you again after I investigating your site at my local.

Regards,
Albert

great news
I'm looking forward to hear from you the solution

hi Albert

any update

Hi Maged,

because the akeeba backup cannot download full site only can download the Dabatase. because your site is too big. so I download your site by using FTP. Since last night until now still downloading. already 80%. I will spend my time for today until weekend to debugging your site. Did you already try to increase mysql memory limit? any effect?

Regards,
Albert

hi Albert
I have completed the requested changes. I have disabled Eaccelerator in your php configuration. I have also doubled the memory in your mysql configuration. I have also completed the restart of apache and mysql. but the problem still there , and I see The problem is that there is a query , is caused this overload :-