Page 2 of 2
Re: Slow Web UI XI
Posted: Mon Apr 02, 2018 4:07 pm
by scottwilkerson
blariv wrote:I am not using an external URL, this is all internal to us. I also put the fqdn in the hosts file.
this is a pretty high end server on all flash storage not sure how a ramdisk would help me out in that case.
please send output of
Looking for the max connections settings if any.
Were any changes made just before this started?
Re: Slow Web UI XI
Posted: Mon Apr 02, 2018 4:11 pm
by blariv
there are no settings for the connection in there. I saw that in another post but didnt want to tweak that.
[root@nagiosxi ~]# cat /etc/my.cnf
[mysqld]
query_cache_size=16M
query_cache_limit=4M
tmp_table_size=64M
max_heap_table_size=64M
key_buffer_size=32M
table_open_cache=32
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in
http://fedoraproject.org/wiki/Systemd
[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid
#
# include all files from the config directory
#
!includedir /etc/my.cnf.d
Re: Slow Web UI XI
Posted: Tue Apr 03, 2018 8:43 am
by scottwilkerson
it is possible that you are hitting a connection limit in mysql
Under
[mysqld] add the following
Then restart mariadb
Re: Slow Web UI XI
Posted: Tue Apr 03, 2018 10:05 am
by blariv
setting has been changed. ill give it a day and let you know.
Re: Slow Web UI XI
Posted: Tue Apr 03, 2018 11:10 am
by scottwilkerson
sounds good