Web interface lagging/slow/not repsponding

[anthony.rabbito]

i've created a general dashboard to deploy to all of our clients by moving the dashlets around. that's it. i haven't modified any files within nagios to do this.

[anthony.rabbito]

here you go

[scottwilkerson]

This is quite odd, they should be loading quite quick..

when you say "at a snails pace" how long (in actual time measurement) is it taking to load a page? Are all pages like this?

[anthony.rabbito]

its sporadic. can take 1ms or 1min. it varies. i get the spinning wheels all the time.

[scottwilkerson]

Can you run the following, we may be hitting a mysql connection limit

Code: Select all

echo "show processlist;"|mysql -pnagiosxi|wc -l
cat /etc/my.cnf|grep max_connections

[anthony.rabbito]

[root@nagiosxi libexec]# echo "show processlist;"|mysql -pnagiosxi|wc -l
36
[root@nagiosxi libexec]# cat /etc/my.cnf|grep max_connections
[root@nagiosxi libexec]#

[lmiltchev]

Try the following - open the "my.cnf" file in a text editor:

vi /etc/my.cnf

and add the following line under "user=mysql":

user=mysql
set-variable=max_connections=500
interactive_timeout=60

Restart mysql:

Code: Select all

service mysqld restart

Let us know if this helped.

[anthony.rabbito]

i added the lines. i'll see how this works.

Code: Select all

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
set-variable=max_connections=500
interactive_timeout=60
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

[slansing]

Sounds good, we will wait for an update.

[lmiltchev]

Let us know if there is any improvement. Thanks!