----------------------------------------------- 서버 시작시 mysql 세팅 ----------------------------------------------


Host is blocked because of many connection errors; unblock with \'mysqladmin flush-hosts\'


1. flush-hosts

    mysqladmin -u root -p flush-hosts


2. sudo mysql -u root -p

    set global max_connections=999999;

    set global max_connect_errors=999999;

    show variables like '%max_connect%';


3. 접속자수 조회


mysql> show status like '%CONNECT%';

+--------------------------+-------+

| Variable_name            | Value |

+--------------------------+-------+

| Aborted_connects         | 200   |

| Connections              | 300   |

| Max_used_connections     | 101   |   ==> 현재 연결된 접속수

| Ssl_client_connects      | 0     |

| Ssl_connect_renegotiates | 0     |

| Ssl_finished_connects    | 0     |

| Threads_connected        | 101   |   ==> 연결되었던 최대 접속수

+--------------------------+-------+

'mysql' 카테고리의 다른 글

blocked because of many connection errors  (0) 2018.06.12
mac mysql 삭제  (0) 2018.01.21
그룹내 시퀀스 생성  (0) 2017.03.09

+ Recent posts