21 September 2017

too many connections

  1. steps

    1. list connections and kill it

       mysql> show  processlist;
       ...
       mysql> kill 111111;
      
    2. config

       $ nano /etc/my.cnf
       max_connections=1000
       wait_timeout=5
      


blog comments powered by Disqus