./mysqladmin -u root -p processlist
./mysqladmin -u root -p variables | grep max_connections
max_connections | 100 <====
./mysqladmin -u root -p variables | grep table_cache
table_cache | 512
./mysqladmin -u root -p variables | grep wait_timeout
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
mysql> SET GLOBAL max_connections = 500; ( mysql ¸®ºÎÆþÈÇÏ°í max_connectionsÀ» ´Ã¸² )
or
[prompt] vi /etc/my.cnf [mysqld] max_connections = 500
ÆÛ¿È... ´ëÃæ ÀÌÇصÊ.
|
|
|
|
°Ô½ÃÆÇ ±Û ¸ñ·Ï |
|
No |
Subject |
Poster |
Hits |
Posted |
|
2037 |
|
helix |
8143 |
2009-07-09 10:08:15 |
|
2018 |
|
helix |
1759 |
2009-06-17 17:25:10 |
|
1998 |
|
helix |
1663 |
2009-06-08 15:56:44 |
|
1980 |
|
helix |
1495 |
2009-06-02 14:15:36 |
|
1975 |
|
helix |
3987 |
2009-06-01 15:23:40 |
|
|
|
helix |
2373 |
2009-05-22 11:11:10 |
|
1947 |
|
helix |
1295 |
2009-05-20 13:14:06 |
|
1940 |
|
helix |
1965 |
2009-05-19 20:14:27 |
|
1930 |
|
helix |
1412 |
2009-05-15 17:27:08 |
|
1902 |
|
helix |
1592 |
2009-05-08 16:03:32 |
|
1891 |
|
helix |
1799 |
2009-04-30 11:51:35 |
|
|
|
ÄÚ¸àÆ® |
|
|
|
|
|
|