I have a MySQL 5.5 instance running on a RedHat distro. I have edited
my.cnf with the following setting:
However, client connections are sleeping and never getting killed. The server has been restarted with the new setting in place.
What am I not understanding?
[mysqld] datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock user=mysql performance_schema=off innodb_buffer_pool_size=64M # Disabling symbolic-links is recommended to prevent assorted security risks symbolic-links=0 wait_timeout = 30 key_buffer = 16M max_allowed_packet = 16M thread_stack = 192K thread_cache_size = 8 # This replaces the startup script and checks MyISAM tables if needed # the first time they are touched myisam-recover = BACKUP #max_connections = 500 #table_cache = 64 #thread_concurrency = 10 # # * Query Cache Configuration # query_cache_limit = 1M query_cache_size = 16M expire_logs_days = 10 max_binlog_size = 100M bind-address=192.168.0.11 interactive_timeout = 60 max_connections = 500 [mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid [isamchk] key_buffer = 16M
Interestingly per @RolandMySQLDBA comments:
It appears none of the cnf file settings are being considered.
and the proof:
[root@localhost ~]# locate my.cnf /etc/my.cnf /opt/rh/mysql55/root/etc/my.cnf