[root@localhost sokj00]# /usr/local/mysql/bin/mysqladmin -u root -p processlist
Enter password:
+-----+------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+-----+------+-----------+----+---------+------+-------+------------------+
| 308 | root | localhost | | Query | 0 | | show processlist |
+-----+------+-----------+----+---------+------+-------+------------------+
[root@localhost sokj00]# /usr/local/mysql/bin/mysqladmin -u root -p variables | grep max_connections
Enter password:
| max_connections | 100
[root@localhost sokj00]# /usr/local/mysql/bin/mysqladmin -u root -p variables | grep table_cache
Enter password:
| table_cache | 64
[root@localhost sokj00]# /usr/local/mysql/bin/mysqladmin -u root -p variables | grep wait_timeout
Enter password:
| innodb_lock_wait_timeout | 50 |
| table_lock_wait_timeout | 50 |
| wait_timeout | 28800
mysql> show status like '%CONNECT%';
+--------------------------+-------+
| Variable_name | Value |
+--------------------------+-------+
| Aborted_connects | 217 |
| Connections | 330 |
| Max_used_connections | 101 | <====
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 101 | <====
+--------------------------+-------+
7 rows in set (0.00 sec)
threads_connected : 현재 연결된 접속수
Max_used_connection : 연결되었던 최대 접속수
ERROR 1040 (08004): Too many connections
====> SET GLOBAL max_connections = 500; ( mysql 리부팅안하고 max_connections을 늘림 )
or
====> vi /etc/my.cnf
[mysqld]
max_connections = 500
|
|
|
△