We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Get started

Update to 1.7.2 occasional long loading site | Forum

Topic location: Forum home » Support » Bug reports and troubleshooting

Pages: 1 2 »

Jozef Dec 12 '14

After update i have this problem - occasional long loading of page (only for registred users).

Performance page after the update is the same as before, but sometimes i click and site is loading about 30 seconds and then it works again.

Site occasional "freeze" = is loading cca 30 seconds, but only for registered users, when this happens and i have site open in another browser and I not logged in, freezing does not occur.

I tried to gradually shut down plugins, but I did not come out if is to blame for some plugin.

It is difficult to test because most of the time page load correctly, and have no idea what causes.

Some ideas?

Team

ross Dec 15 '14

Can you please tell does this happen on a certain page of the website or any?

Jozef Dec 15 '14

Any, (all website, but only for logged in users)

Team

ross Dec 15 '14

Jozef, in this case you need to contact your hosting provider and ask them to provide you with statistics what causes that delay. They should have such data.

Jozef Dec 15 '14

I have VPS, please how and where can I find such statistics?

Team

ross Dec 15 '14

I don't know, I'm not a server expert. You need to google then to find this info.

Jozef Dec 15 '14

But I do not know what the statistics you mean,...

Team

ross Dec 16 '14

Jozef it's query tracking, it is used to find out what part of the software causes (if it does) the loading problem

Jozef Jan 27 '15

Thanks Rebecca :) but this is problem only logged users, when this is happend and run site whith out login, site works normally...

Leader

Kяuncн Jan 27 '15

I suspect the delay comes from per each click the Chat/IM has to load all the Users, so when selected to Show all usrs,, it has to load them, so If you have lets say 1000+ users then you can imagine the CPU/Load and Memory this takes to render the list per click.

The use of an upper package VPS or Dedicated server "for me anyhow" resolved the issue.

#10

Leader

Kяuncн Jan 27 '15

Quote from Jozef I have VPS, please how and where can I find such statistics?

For you using VPS, "if your provider allows root access" then you would have the ability to view resources like memory and cpu %'s, open your SSH client, sign in, type in to the terminal as follows: top -c and you will be able to view your Apache servers health, Shrink your browser down so you can view it and the terminal window side by side as you navigate your site.

Once you discover exactly what is using what then you can can further/Google "Apache load distribution" or "Apache Load Balancing" to adjust your scripts performance.

#11

Jozef Jan 27 '15

Thank you Kяuncн

my results when web go long loading :

The Forum post is edited by Jozef Jan 27 '15

#12

Jozef Jan 28 '15

this is my slow log queries files(in attachment)

Yes, it looks like messages plugin problem, I hope it will be resolved in the new update....

Attachments:

mysql-slow.log.txt (22Kb)

#13

Leader

Kяuncн Jan 28 '15

A few small adjustments to consider till Oxwall writes a proper fix:

How many members on your site?
How often do you optimize the Db Tables at phpMyAdmin?
Have you considered at the IM to "Show only online users"?
How often do you restart Apache server?
Not often enough I see, I do mine weekly, your last was 3months ago.

Terminal command:
apachectl restart

(Nothing to do with per user load but certainly helps to take some stress off your server)
Have you adjusted the FcgidMaxRequestLen and FcgidMaxRequestInMem and if not find out what your default values are...

For safe keeping per example I have mine set as,,,
at: /etc/httpd/conf with in the httpd.conf
FcgidMaxRequestLen 2147483648
FcgidMaxRequestInMem 2147483648

"In case your wondering those values indicate 2G"

At File Manager/ I have
php.ini:
output_buffering = 4096
memory_limit = 2G

Keeping in mind after changes to restart your Apache.

These will be the least you can do for the time being...

The Forum post is edited by Kяuncн Jan 28 '15

#14

Jozef Jan 30 '15

1. cca 3750 users

2. cca one per week

3. it is not possible in last plugin version, (or am I wrong?)

4. you have right, not often

(Fcgi apache module is disabled) and if i activate it, I get the following error messages:

* Starting web server apache2 apache2: Syntax error on line 210 of /etc/apache2/apache2.conf: Syntax error on line 1 of /etc/apache2/mods-enabled/fcgid.load: Cannot load /usr/lib/apache2/modules/mod_fcgid.so into server: /usr/lib/apache2/modules/mod_fcgid.so: cannot open shared object file: No such file or directory Action 'start' failed. The Apache error log may have more information. ...fail!

(I admit that I am not a specialist in VPS)I need professional assistance and with my.cnf (performance tuning) and php.ini too, but need funds :)

but I changed php.ini according to your advice thank you :)

The Forum post is edited by Jozef Jan 30 '15

#15

Leader

Kяuncн Jan 31 '15

In /etc/apache2/apache2.conf
replace
LockFile ${APACHE_LOCK_DIR}/accept.lock
with this one
Mutex file:${APACHE_LOCK_DIR} default

If that doesn't work I'm afraid you will need to contact your support for further information.

Taken from

The Forum post is edited by Kяuncн Jan 31 '15

#16

Jozef Feb 1 '15

Thanks Kяuncн, i try it...

Quote from ross Jozef it's query tracking, it is used to find out what part of the software causes (if it does) the loading problem

Hi Ross, tonight I had a lot of visitors
now is performance (compared to version 1.7) much worse, I think it's a problem with mysql (CPU) specifically messages plugin probably.
How it looks with the update?

#17

Team

ross Feb 2 '15

Jozef is this the domain you're referring to: KORAB.SK ?

#18

Jozef Feb 2 '15

Yes

#19

Team

ross Feb 2 '15

Jozef, we have your admin access details and I registered at your website as well. I don't see any freezing at all, the website is flying. No even delays in loading.

#20

Pages: 1 2 »

Oxwall Software

Please sign in

We build. You grow.

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Update to 1.7.2 occasional long loading site | Forum