pasaisea
Beginner 2.0
Permisi saya mau tanya kenapa ya di server yang saya buat mendadak connectionnys bisa sampai belasan ribu. Padahal sebelumnya ga seperti ini. Kalau saya coba status:
mysql> show status like '%onn%';
+--------------------------------------------------------------------+-------+
| Variable_name | Value |
+-------------------------------------------------------------------+-------+
| Aborted_connects | 10 |
| Connection_errors_accept | 0 |
| Connection_errors_internal | 0 |
| Connection_errors_max_connections | 13 |
| Connection_errors_peer_address | 0 |
| Connection_errors_select | 0 |
| Connection_errors_tcpwrap | 0 |
| Connections | 14012 |
| Max_used_connections | 152 |
| Performance_schema_session_connect_attrs_lost | 0 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 12 |
+-----------------------------------------------------------------------+-------+
14 rows in set (0,05 sec)
Terus kalau saya coba netstat -s hasilnya:
Tcp:
23657 active connections openings
49210 passive connection openings
525 failed connection attempts
7395 connection resets received
163 connections established
2217790 segments received
2384811 segments send out
68800 segments retransmited
19 bad segments received.
9659 resets sent
Udp:
559532 packets received
12260 packets to unknown port received.
0 packet receive errors
849797 packets sent
SndbufErrors: 2
IgnoredMulti: 26182
Ini apakah normal untuk server yang menampung hanya 1 website dan mail perusahaan untuk active dan passive connectionnya sebanyak ini? Cara ngekill connectionsnya dan agar ga bikin2 koneksi baru lagi gimana ya?
Mohon saran dan pendapatnya
mysql> show status like '%onn%';
+--------------------------------------------------------------------+-------+
| Variable_name | Value |
+-------------------------------------------------------------------+-------+
| Aborted_connects | 10 |
| Connection_errors_accept | 0 |
| Connection_errors_internal | 0 |
| Connection_errors_max_connections | 13 |
| Connection_errors_peer_address | 0 |
| Connection_errors_select | 0 |
| Connection_errors_tcpwrap | 0 |
| Connections | 14012 |
| Max_used_connections | 152 |
| Performance_schema_session_connect_attrs_lost | 0 |
| Ssl_client_connects | 0 |
| Ssl_connect_renegotiates | 0 |
| Ssl_finished_connects | 0 |
| Threads_connected | 12 |
+-----------------------------------------------------------------------+-------+
14 rows in set (0,05 sec)
Terus kalau saya coba netstat -s hasilnya:
Tcp:
23657 active connections openings
49210 passive connection openings
525 failed connection attempts
7395 connection resets received
163 connections established
2217790 segments received
2384811 segments send out
68800 segments retransmited
19 bad segments received.
9659 resets sent
Udp:
559532 packets received
12260 packets to unknown port received.
0 packet receive errors
849797 packets sent
SndbufErrors: 2
IgnoredMulti: 26182
Ini apakah normal untuk server yang menampung hanya 1 website dan mail perusahaan untuk active dan passive connectionnya sebanyak ini? Cara ngekill connectionsnya dan agar ga bikin2 koneksi baru lagi gimana ya?
Mohon saran dan pendapatnya