Slow Web UI XI

[scottwilkerson]

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

Code: Select all

cat /etc/my.cnf

Looking for the max connections settings if any.

Were any changes made just before this started?

[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

[scottwilkerson]

it is possible that you are hitting a connection limit in mysql

Under [mysqld] add the following

Code: Select all

max-connections=500

Then restart mariadb

Code: Select all

systemctl restart mariadb

[blariv]

setting has been changed. ill give it a day and let you know.

[scottwilkerson]

sounds good